age 1 of 52
DANTE LEVEL 1 FINAL EXAM PREP 2025/2026
ACCURATE QUESTIONS WITH CORRECT DETAILED
ANSWERS || 100% GUARANTEED PASS <RECENT
VERSION>
1 A _____ is a built-in formula.
Choose one answer.
a. style
b. template
c. format
d. function
Page: Excel Level 2, page 39 .......Answer.........d. function
2 A function includes two parts: the name of the function and the
,age 2 of 52
Choose one answer.
a. argument.
b. format.
c. size.
d. location.
Page: Excel Level 2, page 39 .......Answer.........a. argument.
3 By default, what happens when the VLOOKUP function does
not find an exact match in the first column of the VLOOKUP
table?
Choose one answer.
a. It looks in the second column of the table for a value that
matches the lookup_value.
,age 3 of 52
b. An error occurs.
c. It looks in the first column of the table for the next closest
value (higher or lower).
d. It looks in the first column of the table for the largest value
that is less than the lookup_value.
Page: Excel Level 2, page 53 .......Answer.........d. It looks in the
first column of the table for the largest value that is less than the
lookup_value.
4 Excel stops evaluation of an IF formula
Choose one answer.
a. once the logical_test has been answered as false.
b. once the value_if_true has been answered as false.
, age 4 of 52
c. once the logical_test has been answered as true.
d. once the value_if_true has been answered as true.
Page: Excel Level 2, page 58 .......Answer.........c. once the
logical_test has been answered as true.
5 Excel will add the required syntax automatically when you
create a COUNTIF formula if you
Choose one answer.
a. use copy and paste.
b. create the formula manually.
c. use the Insert Function dialog box.
d. press F1 before typing the function.
DANTE LEVEL 1 FINAL EXAM PREP 2025/2026
ACCURATE QUESTIONS WITH CORRECT DETAILED
ANSWERS || 100% GUARANTEED PASS <RECENT
VERSION>
1 A _____ is a built-in formula.
Choose one answer.
a. style
b. template
c. format
d. function
Page: Excel Level 2, page 39 .......Answer.........d. function
2 A function includes two parts: the name of the function and the
,age 2 of 52
Choose one answer.
a. argument.
b. format.
c. size.
d. location.
Page: Excel Level 2, page 39 .......Answer.........a. argument.
3 By default, what happens when the VLOOKUP function does
not find an exact match in the first column of the VLOOKUP
table?
Choose one answer.
a. It looks in the second column of the table for a value that
matches the lookup_value.
,age 3 of 52
b. An error occurs.
c. It looks in the first column of the table for the next closest
value (higher or lower).
d. It looks in the first column of the table for the largest value
that is less than the lookup_value.
Page: Excel Level 2, page 53 .......Answer.........d. It looks in the
first column of the table for the largest value that is less than the
lookup_value.
4 Excel stops evaluation of an IF formula
Choose one answer.
a. once the logical_test has been answered as false.
b. once the value_if_true has been answered as false.
, age 4 of 52
c. once the logical_test has been answered as true.
d. once the value_if_true has been answered as true.
Page: Excel Level 2, page 58 .......Answer.........c. once the
logical_test has been answered as true.
5 Excel will add the required syntax automatically when you
create a COUNTIF formula if you
Choose one answer.
a. use copy and paste.
b. create the formula manually.
c. use the Insert Function dialog box.
d. press F1 before typing the function.
