Final Estimates Level 2| Exam Questions Solved
100% Correct | Verified Solutions
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.
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.
3 Changing the appearance of a cell based on a condition is called
Choose one answer.
a. what-if formatting.
1|Page
,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.
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
d. General
Page: Excel Level 2, page 20 - ANSWER-c. Custom
6 Excel provides special number formats that are specific to which of the following?
Choose one answer.
a. country and language
b. language and dialect
c. region and language
2|Page
, d. country and alphabet
Page: Excel Level 2, page 18 - ANSWER-a. country and language
7 How are numbers displayed when the format code is [Red];[Blue]?
Choose one answer.
a. Positive numbers are displayed in red; negative numbers in blue.
b. Positive numbers are displayed in blue; negative numbers in red.
c. Numbers to the left of the decimal point are displayed in red; numbers to the right in blue.
d. Numbers to the left of the decimal point are displayed in blue; numbers to the right in red.
Page: Excel Level 2, page 20 - ANSWER-a. Positive numbers are displayed in red; negative
numbers in blue.
8 How can you format a cell based on the value in a different cell?
Choose one answer.
a. Use a formula.
b. Apply two conditional formatting rules.
c. Apply conditional formatting rules to both cells.
d. You cannot format a cell in this way.
Page: Excel Level 2, page 15 - ANSWER-a. Use a formula.
9 Icon sets allow you to
Choose one answer.
a. classify data into three to five categories.
b. create your own symbols.
c. modify the shapes of threshold symbols.
d. change the images that appear on Excel buttons.
Page: Excel Level 2, pages 12 and 13 - ANSWER-a. classify data into three to five categories.
3|Page
100% Correct | Verified Solutions
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.
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.
3 Changing the appearance of a cell based on a condition is called
Choose one answer.
a. what-if formatting.
1|Page
,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.
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
d. General
Page: Excel Level 2, page 20 - ANSWER-c. Custom
6 Excel provides special number formats that are specific to which of the following?
Choose one answer.
a. country and language
b. language and dialect
c. region and language
2|Page
, d. country and alphabet
Page: Excel Level 2, page 18 - ANSWER-a. country and language
7 How are numbers displayed when the format code is [Red];[Blue]?
Choose one answer.
a. Positive numbers are displayed in red; negative numbers in blue.
b. Positive numbers are displayed in blue; negative numbers in red.
c. Numbers to the left of the decimal point are displayed in red; numbers to the right in blue.
d. Numbers to the left of the decimal point are displayed in blue; numbers to the right in red.
Page: Excel Level 2, page 20 - ANSWER-a. Positive numbers are displayed in red; negative
numbers in blue.
8 How can you format a cell based on the value in a different cell?
Choose one answer.
a. Use a formula.
b. Apply two conditional formatting rules.
c. Apply conditional formatting rules to both cells.
d. You cannot format a cell in this way.
Page: Excel Level 2, page 15 - ANSWER-a. Use a formula.
9 Icon sets allow you to
Choose one answer.
a. classify data into three to five categories.
b. create your own symbols.
c. modify the shapes of threshold symbols.
d. change the images that appear on Excel buttons.
Page: Excel Level 2, pages 12 and 13 - ANSWER-a. classify data into three to five categories.
3|Page
