Dante Level 2 Final Exam Guide 2025: Certification Test Prep & Study Tips

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