CIS120 Exam Study Guide –
Practice Questions with Verified
Answers. GRADED A+. Latest
2026/2027 Update
You _____ create your own conditional formatting rules. - answer✔✔ - a.
cannot
b. can, but should not
c. can ******
d. must
As a visual guide to see the variation of values in a range, Excel provides each of
the following except - answer✔✔ - a. three-color scales.
b. data bars.
c. two-color scales.
d. animated graphics. ******
Changing the appearance of a cell based on a condition is called - answer✔✔ - a.
conditional formatting. ******
b. what-if formatting.
c. what-if cell analysis.
d. conditional analysis.
,The Edit the Rule Description section of the New Rule dialog box varies depending
on - answer✔✔ - a. whether any other cells in the worksheet have conditional
formatting applied. b. the formatting of the selected cells.
c. the active option in the Select a Rule Type section. ******
d. the type of formula in the selected cells.
To remove conditional formatting, select the range, click the Conditional
Formatting button, point to Clear Rules, and then choose - answer✔✔ - a. Clear
Conditional Formatting. b. Clear Rules from Selected Cells. ******
c. Clear Rules from Selected Range.
d. Clear Rules from Workbook.
Values in rows that do not meet the criteria in the Custom AutoFilter feature are -
answer✔✔ - a. temporarily hidden from view. ******
b. formatted with a bold font.
c. dimmed.
d. deleted from the worksheet.
When setting up a range for filtering, what step must you take just before you
click the filter arrow button? - answer✔✔ - a. Deselect the range. ****** b.
Point to Filter by Icon Set.
c. Point to Filter by Color.
d. Click the Sort & Filter button.
,You can filter values by more than one criterion at a time by using - answer✔✔ - a.
comparison operators. ******
b. conditional formatting.
c. wildcards.
d. dual filters.
Which number is represented by the format 2.60E+05? - answer✔✔ - a.
2,600,000.00
b. 2.65
c. 260,000.00 ******
d. 0.00026
Can you create your own conditional formatting rules? If so, how? - answer✔✔ -
a. Yes; use the New Formatting Rule dialog box. ******
b. Yes; edit a predefined rule.
c. No; you must use Excel's predefined rules.
d. Yes; create a macro.
The first step in creating a custom number format is to - answer✔✔ - a. select the
desired range. ******
b. click the Number group dialog box launcher.
c. click Custom in the Category list box.
d. right-click the Number Format option box.
Which of these custom number format codes will round values to fit the number
of decimals and fill in leading zeros? - answer✔✔ - a. ???.??
, b. "Number"###
c. ###.##
d. 000.00 ******
Conditional formats can be based on any of the following except - correct answer
<<<<<💕💕💕✔✔a. dates.
b. values in a range.
c. duplicated values.
d. formatting. ******
Excel provides special number formats that are specific to which of the following?
- answer✔✔ - a. country and alphabet
b. region and language
c. country and language ******
d. language and dialect
How can you tell that a filter has been defined for a column? - answer✔✔ - a. The
Sort & Filter button flashes when you select that column.
b. The word Filtered appears when you hover the mouse pointer over the column.
c. A down-pointing filter arrow appears in the column heading. ******
d. The column heading appears as bold text.
A _____ is a built-in formula. - answer✔✔ - a. function ****** b.
template
c. style
d. format
Practice Questions with Verified
Answers. GRADED A+. Latest
2026/2027 Update
You _____ create your own conditional formatting rules. - answer✔✔ - a.
cannot
b. can, but should not
c. can ******
d. must
As a visual guide to see the variation of values in a range, Excel provides each of
the following except - answer✔✔ - a. three-color scales.
b. data bars.
c. two-color scales.
d. animated graphics. ******
Changing the appearance of a cell based on a condition is called - answer✔✔ - a.
conditional formatting. ******
b. what-if formatting.
c. what-if cell analysis.
d. conditional analysis.
,The Edit the Rule Description section of the New Rule dialog box varies depending
on - answer✔✔ - a. whether any other cells in the worksheet have conditional
formatting applied. b. the formatting of the selected cells.
c. the active option in the Select a Rule Type section. ******
d. the type of formula in the selected cells.
To remove conditional formatting, select the range, click the Conditional
Formatting button, point to Clear Rules, and then choose - answer✔✔ - a. Clear
Conditional Formatting. b. Clear Rules from Selected Cells. ******
c. Clear Rules from Selected Range.
d. Clear Rules from Workbook.
Values in rows that do not meet the criteria in the Custom AutoFilter feature are -
answer✔✔ - a. temporarily hidden from view. ******
b. formatted with a bold font.
c. dimmed.
d. deleted from the worksheet.
When setting up a range for filtering, what step must you take just before you
click the filter arrow button? - answer✔✔ - a. Deselect the range. ****** b.
Point to Filter by Icon Set.
c. Point to Filter by Color.
d. Click the Sort & Filter button.
,You can filter values by more than one criterion at a time by using - answer✔✔ - a.
comparison operators. ******
b. conditional formatting.
c. wildcards.
d. dual filters.
Which number is represented by the format 2.60E+05? - answer✔✔ - a.
2,600,000.00
b. 2.65
c. 260,000.00 ******
d. 0.00026
Can you create your own conditional formatting rules? If so, how? - answer✔✔ -
a. Yes; use the New Formatting Rule dialog box. ******
b. Yes; edit a predefined rule.
c. No; you must use Excel's predefined rules.
d. Yes; create a macro.
The first step in creating a custom number format is to - answer✔✔ - a. select the
desired range. ******
b. click the Number group dialog box launcher.
c. click Custom in the Category list box.
d. right-click the Number Format option box.
Which of these custom number format codes will round values to fit the number
of decimals and fill in leading zeros? - answer✔✔ - a. ???.??
, b. "Number"###
c. ###.##
d. 000.00 ******
Conditional formats can be based on any of the following except - correct answer
<<<<<💕💕💕✔✔a. dates.
b. values in a range.
c. duplicated values.
d. formatting. ******
Excel provides special number formats that are specific to which of the following?
- answer✔✔ - a. country and alphabet
b. region and language
c. country and language ******
d. language and dialect
How can you tell that a filter has been defined for a column? - answer✔✔ - a. The
Sort & Filter button flashes when you select that column.
b. The word Filtered appears when you hover the mouse pointer over the column.
c. A down-pointing filter arrow appears in the column heading. ******
d. The column heading appears as bold text.
A _____ is a built-in formula. - answer✔✔ - a. function ****** b.
template
c. style
d. format
