age 1 of 60
DANTE LEVEL 2 FINAL EXAM PREP 2025/2026
ACCURATE QUESTIONS WITH CORRECT DETAILED
ANSWERS || 100% GUARANTEED PASS <RECENT
VERSION>
1 As a visual guide to see the variation of values in a range,
Excel provides each of the following except
Choose one answer.
a. two-color scales.
b. three-color scales.
c. data bars.
d. animated graphics.
,age 2 of 60
Page: Excel Level 2, page 14 .......Answer.........d. animated
graphics.
2 Can you create your own conditional formatting rules? If so,
how?
Choose one answer.
a. No; you must use Excel's predefined rules.
b. Yes; edit a predefined rule.
c. Yes; use the New Formatting Rule dialog box.
d. Yes; create a macro.
Page: Excel Level 2, page 8 .......Answer.........c. Yes; use the New
Formatting Rule dialog box.
,age 3 of 60
3 Changing the appearance of a cell based on a condition is
called
Choose one answer.
a. what-if formatting.
b. what-if cell analysis.
c. conditional formatting.
d. conditional analysis.
Page: Excel Level 2, page 6 .......Answer.........c. conditional
formatting.
4 Conditional formats can be based on any of the following
except
Choose one answer.
, age 4 of 60
a. dates.
b. values in a range.
c. duplicated values.
d. formatting.
Page: Excel Level 2, page 6 .......Answer.........d. formatting.
5 Excel can add text such as GX- to the values you type in cells
if the cells have been formatted using the _____ category.
Choose one answer.
a. Special
b. Text
c. Custom
DANTE LEVEL 2 FINAL EXAM PREP 2025/2026
ACCURATE QUESTIONS WITH CORRECT DETAILED
ANSWERS || 100% GUARANTEED PASS <RECENT
VERSION>
1 As a visual guide to see the variation of values in a range,
Excel provides each of the following except
Choose one answer.
a. two-color scales.
b. three-color scales.
c. data bars.
d. animated graphics.
,age 2 of 60
Page: Excel Level 2, page 14 .......Answer.........d. animated
graphics.
2 Can you create your own conditional formatting rules? If so,
how?
Choose one answer.
a. No; you must use Excel's predefined rules.
b. Yes; edit a predefined rule.
c. Yes; use the New Formatting Rule dialog box.
d. Yes; create a macro.
Page: Excel Level 2, page 8 .......Answer.........c. Yes; use the New
Formatting Rule dialog box.
,age 3 of 60
3 Changing the appearance of a cell based on a condition is
called
Choose one answer.
a. what-if formatting.
b. what-if cell analysis.
c. conditional formatting.
d. conditional analysis.
Page: Excel Level 2, page 6 .......Answer.........c. conditional
formatting.
4 Conditional formats can be based on any of the following
except
Choose one answer.
, age 4 of 60
a. dates.
b. values in a range.
c. duplicated values.
d. formatting.
Page: Excel Level 2, page 6 .......Answer.........d. formatting.
5 Excel can add text such as GX- to the values you type in cells
if the cells have been formatted using the _____ category.
Choose one answer.
a. Special
b. Text
c. Custom
