WorksheetsExcel 2016 - The Comeback
Total questions: 10
Worksheet time: 11mins
What must a formula always begin with?
a quotation mark
an equal sign
a parentheses
a function
Excel uses all the following references, except:
absolute
relative
multiple
relational
What is the last step when applying an array formula?
Press enter
Press Ctrl, Shift, Enter
insert an equal sign
add the { }
Which item below is an example of a Nested IF formula
=IF(AND(C4>4,D4>3),"Counseling","")
=IF(D2>89,"A",IF(D2>79,"B","F"))
=IF(OR(C3>2<4,D3<3),"Verbal Warning","")
=IF(A1=10,"Correct","Wrong")
The IF_AND function indicates that a logical test can meet either one of two criterias.
True
False
What will be the result of the below formula, using the table shown?
=VLOOKUP("Kidgets",B5:E10,3,FALSE)
9
$10
$90
False
Which of the following cell references has assigned absolute reference to rows only?
$A$1:$F$6
A1:$F$6
A$1:F$6
A1:F6
What feature is being used in the image?
Error Checking
Spell Check
Data Consolidation
Named Ranges
In the IF function, which arguments are required in order for it to work?
(logical_test, value_if_true,value_if_false)
(lookup_value, value_if_true,_value_if_false)
(lookup_value, table_array, column_index, range_lookup)
(Rate, Pv)
Named ranges use relative or absolute cell referencing?
Relative
Absolute
