Broward College Computer Literacy Practice Test

Unlock all questions

This demo includes only 20 questions. Upgrade to access hundreds of questions, flashcards, exam simulations, and disable ads.

Full question bankExam simulationsFlashcards

From $12.50Unlock all

Session length

1 / 20

Name a common Excel function used to calculate the average of a range.

AVERAGE (e.g., =AVERAGE(B2:B10)).

Calculating the average in Excel uses the AVERAGE function. This function takes a range of cells, adds all numeric values, and divides by how many numeric values exist, returning the arithmetic mean. For example, =AVERAGE(B2:B10) computes the mean of the numbers in that range. AVERAGE is the best choice when you want the typical value of a dataset. It ignores non-numeric cells, which helps when the range has blanks or text; if there are no numbers at all, Excel will return an error. Other common functions perform different tasks: SUM adds numbers, MAX finds the largest value, and CONCATENATE joins text strings.

SUM

MAX

CONCATENATE