Excel Quiz
Which of the following is an absolute cell reference?
$B$2
What symbol do you use for multiplication in Excel?
*
Which of the formulas below are valid? Select all that apply.
=A+B+C =1-M2 =J5+C21/D21
What formula would you use to find the average of the values in cell range A1 to A10?
=AVERAGE(A1:A10)
In this image, which formula could you use to subtract the inventory costs from the monthly budget?
=B3-B2
In this image, which formula would we use to display the text Waffles: bunny?
=CONCATENATE(A2, ": ", B2)
What is the formula to add up a column of numbers in Excel?
=SUM(A1:A10)
Which of the following VLOOKUP functions is using the correct arguments?
=VLOOKUP(G5, Products!$A$2:$C$20, 3, FALSE)
What is a number format in Excel?
A format that tells Excel how to display data in a cell
What is a "Custom" number format in Excel?
A number format that you create to fit your specific needs
Suppose you want to copy a formula while keeping one of the cell references locked on the same cell. Which of the following would you use?
Absolute reference
What can you do with data validation? Select all that apply.
Add a drop-down list to a cell Control what values a user can enter into a cell Prevent inconsistent data from being entered
A group of cells is called a ________.
Cell range
What does the formula =A1&" "&A2 do in Excel?
Combines the values in cells A1 and A2 into a single cell with a space between them
True or False: Excel will always tell you if there is a problem with a formula you've created.
False
True or False: In Excel, the values 75 and 75% are equivalent.
False
Which function can display a different value depending on a condition?
IF
What does the "General" number format do in Excel?
It applies the default number format to a cell.
What does the "Evaluate Formula" tool in Excel do?
It shows the formula and its results step-by-step.
Which function can find the highest value in a cell range?
MAX
In the order of operations, which of the following comes first?
Operations enclosed in parentheses
Which function would you use to add several numeric values?
SUM
What is the purpose of the parentheses in a formula like =(A1+A2)*B1 in Excel?
They indicate the order in which operations should be performed.
What is the default type of cell reference in Excel?
relative
