NEW
Font size
WorksheetsExcel: Applications Unit 1 Quiz Review
Total questions: 16
Worksheet time: 5mins
Which function adds a range of cells?
Sum
Average
=Max
Min
What does the concatenate function do in Excel?
Links text together
Adds sums
Create averages
Creates formulas
What is the name for an expression that results in either true or false?
Delta expression
Average expression
Sum expression
Logical expression
What are the three parts of an Excel formula?
Sigma sign, operators, and numbers
Equal sign, operands, and operators
Operands, operators, and hashtag
Equal sign, Sigma sign, and letters
If C4=15 and C7=14, what is the result of the logical expression C4>C7?
True
False
Which of these formulas uses relative cell references?
=5*10
=F18/2
=$A$10/100
=17+$D$1
In Excel, all functions must begin with what symbol?
!
$
=
#
What symbol is used to designate an absolute cell reference?
$
%
!
#
Which type of cell references are locked and NOT automatically updated when copied?
Absolute
Formula
Worksheet
Relative
If C2=20 and D2=10, what is the result of the function =IF(C2=D2,"Full","Open")?
Full
10
Open
Unknown
A function is a predefined formula.
True
False
Which type of cell references are automatically updated when copied?
Worksheet
Absolute
Formula
Relative
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
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
What term refers to mathematical equations used in Excel to perform calculations?
Summations
Cell
Formulas
Format
What is the argument in this function? =AVERAGE(F3:F26)
F3
F26
F3:F26
=AVERAGE
