Module 7 Questions

Conditional formatting uses a condition to determine a cell's _________________________________. Select the correct option.

• a. Value
• b. Appearance
• c. Size
• d. Location

Which of the following values can be indicated using conditional formatting? Select all that apply

• a. High or low values
• a. Average values
• b. Projected values based on the data
• c. Duplicate values

Which of the following options are types of conditional formatting? Select all that apply.

• a. Color scales
• c. Data bars
• d. Highlight cells rules
• a. Tables
• b. Pie charts

Which of the following conditional formatting rules is the best option for emphasizing the variance between values in a data range? Select the correct option.

• a. Top 10%
• a. Bottom 10 items
• b. Duplicate values
• c. Color scales

Which features can be used to remove conditional formatting? Select all that apply.

• a. New Rule
• a. Manage Rules
• b. Clear Rules
• c. Data Bars
• d. Color Scales

3 Signs is an option for the _______________________________ conditional formatting rule. Select all that apply.

• a. Color scales
• a. Icon sets
• b. Highlight between
• c. Data bars

What happens if multiple conditional formatting rules are applied to the same cell? Select the correct option.

• a. None of the rules are evaluated, and the cell is left unformatted.
• a. Only the first rule is applied, and the cell is formatted accordingly.
• b. All rules are applied in order, formatting the cell with every rule.
• c. Only the last rule is applied, and the cell is formatted accordingly.

Which of the following best describes the role of Alt Text? Select the correct option.

• a. Allow data to be translated into different languages.
• b. Assists users with a screen reader who are accessing the workbook.
• c. Provides additional information for a chart’s legend.
• d. Enables users to input text quickly.

Which of the following can be done with the Move Chart dialog box? Select all that apply.

• a. Make a duplicate copy of a chart.
• a. Move a chart to a new worksheet.
• b. Move a chart to an existing worksheet.
• c. Move a chart to a PowerPoint presentation.

How does Excel determine what data to use when creating a chart? Select the correct option.

• a. It uses all data on the current worksheet.
• a. It uses all data in the current workbook.
• b. It uses the selected cell and all adjacent cells.
• c. It uses only the selected cells.