Font size
WorksheetsAutoSum and Average Functions
Total questions: 53
Worksheet time: 52mins
Which Excel tabs commonly include the AutoSum button for quick calculations?
View and Developer tabs
Data and Review tabs
Insert and Page Layout
Home and Formulas tabs
What does the AVERAGE function calculate in a range of numbers?
Sum of all text entries
Largest value in range
Total count of cells
Arithmetic mean of values
Fill in the blank: The arithmetic mean is found by (a) the values and dividing by the number of values.
Where can you access more functions beyond SUM using the AutoSum dropdown?
Arrow to the right of AutoSum
Right-click the worksheet
Format Cells dialog
Status bar quick menu
You have numbers 2, 3, 3, 5, 7, and 10. Using AVERAGE, what result should Excel return?
6
4
5
7
Which function would you choose to find the smallest number in a list using the AutoSum menu?
AVERAGE
COUNT
MAX
MIN
A class has six grades: 70, 80, 85, 90, 95, and 0 (absent). If zeros are not counted, what is the class average using AVERAGE?
Which Excel function counts only cells containing numbers within a range?
COUNTBLANK counts empty cells only
MAX counts the highest numeric value
COUNT counts cells with numbers only
COUNTA counts all non-empty cells
What does the Count field on the status bar show when you select cells?
Total including empty cells
Number of selected numeric cells
Number of selected non-empty cells
Number of selected empty cells
Write the basic syntax to count numeric cells in range A1:A7 using Excel.
(a)
Which statement describes COUNTA correctly?
Counts only numbers and dates
Counts blanks and errors together
Counts any non-empty cell content
Counts only text values in ranges
If you need to count blank cells in two separate ranges, what approach should you use?
COUNTA(range1)+COUNTA(range2)
COUNT(range1)+COUNT(range2)
MAX(range1)+MIN(range2)
COUNTBLANK(range1)+COUNTBLANK(range2)
Which cells are ignored by the COUNT function?
Numbers, dates, errors
Text, logical values, blanks
Only blank cells in tables
All cells with content
You have numbers 10, 86, 87, 15, 1, 16, 54, 68, 90, 62 in A1:A10. Which formula returns the largest number?
=COUNTBLANK(A1:A10)
=COUNTA(A1:A10)
=MAX(A1:A10)
=MIN(A1:A10)
What is the purpose of the MIN function in Excel?
Returns the total of values
Returns the smallest value
Returns the largest value
Returns the average value
Provide the general syntax for the MIN function using two arguments.
(a)
Explain how MIN handles different types of values and arguments. Include limits and special cases.
Which argument in the IF function holds what Excel returns when the condition is true?
value_if_false argument
criteria argument
logical_test argument
value_if_true argument
Fill in the exact IF syntax placeholders: IF(logical_test, (a) , value_if_false).
What are the only two possible outcomes of an IF function’s logical test?
Positive and negative
Equal and not equal
True and False
Greater and lesser
Write an IF formula that returns "Pass" if B2 is greater than or equal to 70, otherwise returns "Fail".
In the example IF(A2="RED",TRUE,FALSE), what will Excel display if A2 contains the text RED?
It leaves the cell blank
It returns TRUE value
It shows the number 0
It displays FALSE value
Which statement correctly describes value_if_false in the IF function?
Must be a text string only
Returned when logical_test is true
Optional and returns FALSE if omitted
Always returns zero by default
What does the SUMAR.SI (SUMIF) function compute?
Maximum value in a range
Average of values matching criteria
Sum of values meeting a condition
Count of cells with any number
Provide a SUMIF formula to add values in A1:A20 that are strictly greater than 20.
Which two arguments are required by SUMAR.SI (SUMIF)?
Range and criteria
Criteria and sum_range
Logical_test and result
Column and row
If the data in A1:A3 are 22, 0, and 20, what will =SUMAR.SI(A1:A3,">20") return?
20 only
22 only
42 total
0 total
Fill the blank: To sum values equal to 20 in A1:A3, use (a) .
Explain when you would use SUM instead of SUMAR.SI.
In PROMEDIO.SI, which argument is optional and lets you average values from a different set of cells?
Criteria argument
Range argument
Delimiter argument
Average_range argument
Fill in the blank with the correct criterion symbol: To average values greater than sixty thousand, use (a) in the criteria.
Given the formula =PROMEDIO.SI(D2:D13, "<40000", C2:C13), which column provides the values being averaged?
Neither column is averaged
Both columns C and D are averaged
Column D provides the averaged values
Column C provides the averaged values
If no cells satisfy the condition in PROMEDIO.SI, what result should you expect?
A blank cell is displayed
The average of the entire range
Zero is returned
#DIV/0! error appears
Why might you use the Average_range argument instead of omitting it?
Excel can evaluate math expressions inside function arguments. What is the order of operations when using expressions as arguments?
Randomly chooses an order each time
Evaluate left to right without rules
Run the function first, then solve expressions
Solve expressions first, then run the function
Using A1=1, A2=5, A3=2, A4=4, what is the result of =SUM((A1+A3),(A2-A4))?
Result equals five
Result equals nine
Result equals three
Result equals seven
Which Excel function joins two or more text strings into one cell outcome?
MID merges characters from positions
EXACT combines compared cell contents
CONCATENATE joins multiple text strings
AVERAGE appends numbers as text
In CONCATENATE, what is the only required argument to start the function?
Cell format, the style type
Text1, the first text string
Text2, the optional string
Delimiter, a joining symbol
What does the EXACT function return when A1 contains "Monday" and B1 contains "MONDAY"?
FALSE because case is different
Error because cells are text
TRUE because spaces are ignored
TRUE because letters match
Fill in the blank: The EXACT function is (a) -sensitive.
Which pair best describes the MID function parameters?
start_position and num_characters
start_position and delimiter
text and cell format
row number and column label
If you use =MID("TK-2022",2,2), what result do you get?
K-
T-
TK
-2
Why might MID return the error value #VALUE!?
num_characters is negative
text argument is uppercase
cells are formatted as numbers
start_position equals 1
Explain how EXACT differs from comparing two cells with =A1=B1.
A code is in cell A2: "FT-2022". Write the formula to extract the first two characters only.
Which Excel function splits a text string into multiple parts using a specified delimiter?
LEN
SPLITTEXT
SUM
CONCAT
In cell B2, to separate "Lucas, Martinez" into last and first names by the comma, which formula is most appropriate?
=SPLITTEXT(A2, ",")
=CONCAT(A2:B2)
=LEN(A2)
=SPLITTEXT(B2, " ")
What improvement does CONCAT have compared to CONCATENATE for joining text?
Supports joining ranges
Ignores empty cells
Splits by delimiters
Counts characters in text
Fill in the blank: The LEN function returns the total number of (a) in a cell, including spaces and symbols.
Which formula correctly joins the values from A2 through B2 into one text string?
=SUM(A2:B2)
=CONCAT(A2:B2)
=LEN(A2:B2)
=SPLITTEXT(A2:B2, " ")
A student wants to count all letters, numbers, spaces, and symbols in cell A2. Which function should they use?
LEN
CONCAT
SPLITTEXT
AVERAGE
Explain when using SPLITTEXT is helpful and provide a short example scenario.
You have a list of codes in C2:C5 and need one combined code string without typing each cell. Which approach is best and why?
