WorksheetsUsing Formulas and Functions- Excel
Total questions: 20
Worksheet time: 10mins
If B3=30 and F5=10, what is the result of the function =IF(B3=F5,"Full","Open")?
Full
10
Open
Unknown
What function would you use to calculate the TOTAL cost?
=SUM(B3:B6)
=CALCULATE(B3:B6)
=TOTAL(B3:B6)
=AVERAGE(B3:B6)
If you copied C7 to D5, what would be the resulting cell reference in D5?
=C3
=C5
=D3
=D5
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
If D3=30 and E9=28, what is the result of the logical expression D3>E9?
True
False
If you copied D3 to D7, what would be the resulting cell reference in D7?
=C10
=D10
=C6
=D6
In Excel, all functions must begin with what symbol?
$
#
!
=
What term refers to mathematical equations used in Excel to perform calculations?
Formulas
Format
Cell
Summations
Which formula would you enter into D3, and then AutoFill into D4 to D6, to calculate the winning percentage (Pct.) for the teams?
=B3/(B3+C3)
=$B$3/(B3+C3)
=B3/($B$3+$C$3)
=$B$3/($B$3+$C$3)
What function would you use to find the most expensive item?
=MAX(B3:B7)
=SUM(B3:B7)
=AVERAGE(B3:B7)
=MIN(B3:B7)
What is the argument in this function? =AVERAGE(W3:W26)
W26
W3:W26
=Average
F3
What symbol is used to designate an absolute cell reference?
%
$
!
#
What formula should be entered to calculate the total budget?
=B3+B4+B5+B6
=B3*B4*B5*B6
=3B+4B+5B+6B
=3B*4B*5B*6B
Which of these formulas uses relative cell references?
=5*10
=F18/2
=$A$10/100
=17+$D$1
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)
Which type of cell references are locked and NOT automatically updated when copied?
Relative
Formula
Absolute
Worksheet
A function is a predefined formula.
True
False
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
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?
Find and Replace
Cut and Paste
Spelling Checker
AutoFill
Which type of cell references are automatically updated when copied?
Formula
Relative
Absolute
Worksheet
