Have an account?
Skip to Content
Build your own quiz
Suggestions for you
Computers, Business
8th -
12thgrade
AES Excel 2: Quiz Unit 1-Using Formulas & Functions
20 questions
Show Answers
See Preview
- 1. Multiple Choice
If you copied D3 to D7, what would be the resulting cell reference in D7?
=D10
=D6
=C10
=C6
- 2. Multiple Choice
Which type of cell references are automatically updated when copied?
Absolute
Formula
Worksheet
Relative
- 3. Multiple Choice
What formula would you enter in C4 that combines A4 and B4 to get a result like in C2?
“=A4&""&B4” “="A4"&"
"&"B4"”
“=A4& &B4”
“=A4&" "&B4”
- 4. Multiple Choice
If C4=15 and C7=14, what is the result of the logical expression C4>C7?
False
True
- 5. Multiple Choice
What formula should be entered to calculate the total budget?
=B3*B4*B5*B6
=3B+4B+5B+6B
=3B*4B*5B*6B
=B3+B4+B5+B6
- 6. Multiple Choice
In Excel, all functions must begin with what symbol?
$
!
#
=
- 7. Multiple Choice
If you copied C7 to D5, what would be the resulting cell reference in D5?
=D5
=D3
=C3
=C5
- 8. Multiple Choice
What function would you use to calculate the TOTAL cost?
=SUM(B3:B6)
=CALCULATE(B3:B6)
=TOTAL(B3:B6)
=AVERAGE(B3:B6)
- 9. Multiple Choice
Which of these formulas uses relative cell references?
=17+$D$1
=F18/2
=5*10
=$A$10/100
- 10. Multiple Choice
If C2=20 and D2=10, what is the result of the function =IF(C2=D2,"Full","Open")?
Full
Unknown
Open
10
- 11. Multiple Choice
What function would you use to find the most expensive item?
=SUM(B3:B7)
=MIN(B3:B7)
=MAX(B3:B7)
=AVERAGE(B3:B7)
- 12. Multiple Choice
What formula would you enter in C3 that combines A3 and B3 to get a result like in C2?
=CONCATENATE(A3,"",B3)
=CONCATENATE("A3","","B3")
=CONCATENATE(A3," ",B3)
=CONCATENATE(A3,,B3)
- 13. Multiple Choice
What symbol is used to designate an absolute cell reference?
!
%
$
#
- 14. Multiple Choice
Which of the following is a way to search for a function?
Browse in the Function Library group
Click Insert Function and enter a search phrase
All of the above
- 15. Multiple Choice
You want to copy a formula in a cell down the column into multiple other cells. What would be the best tool for the job?
Spelling Checker
Find and Replace
Cut and Paste
AutoFill
- 16. Multiple Choice
What term refers to mathematical equations used in Excel to perform calculations?
Summations
Format
Cell
Formulas
- 17. Multiple Choice
Which type of cell references are locked and NOT automatically updated when copied?
Formula
Absolute
Worksheet
Relative
- 18. Multiple Choice
What is the argument in this function? =AVERAGE(F3:F26)
F26
=AVERAGE
F3:F26
F3
- 19. Multiple Choice
Which formula would you enter into D3, and then AutoFill into D4 to D6, to calculate the winning percentage (Pct.) for the teams?
=$B$3/($B$3+$C$3)
=B3/($B$3+$C$3)
=B3/(B3+C3)
=$B$3/(B3+C3)
- 20. Multiple Choice
A function is a predefined formula.
True
False
- Answer choicesTagsAnswer choicesTags