MS Excel Module 7

What is the purpose of alt text in a document?

• To provide a description of a graphic element for screen readers

• To change the font style of text

• To add a hyperlink to a webpage

• To adjust the brightness of an image

What does a chart represent in MS Excel?

• A list of hyperlinks

• A visual representation of one or more data series

• A collection of text documents

• A set of audio files

What is a chart element?

• A feature that applies cell formatting based on the value of that cell

• A row or column of related values in a worksheet

• An individual element of a chart, such as a title or legend

• A type of graph used to display data

What does conditional formatting do?

• It creates a new worksheet

• It applies cell formatting based on the value of that cell

• It changes the font size of all text

• It deletes empty cells

What is a data series?

• A type of chart used to compare data

• A feature that applies cell formatting

• A row or column of related values in a worksheet

• A method to sort data alphabetically

What is the purpose of a rules manager?

• To create and manage conditional formatting rules

• To preview analysis and visualization tools

• To design and edit spreadsheets

• To calculate complex formulas

What does the quick analysis feature provide?

• Editing tools for conditional formatting

• Previews of analysis and visualization tools

• Options for creating charts

• Tools for data entry

What is a quick style?

• A predefined collection of settings used to configure a visual element, such as a chart or sparkline

• A method to quickly draw a chart

• A tool to edit text documents

• A way to organize files on a computer

What does a quick layout refer to?

• A method to quickly draw a chart

• A predefined arrangement of chart elements

• A tool to edit text documents

• A way to organize files on a computer

What is a sparkline?

• A miniature chart that occupies a single cell and provides a visual representation of data

• A large chart that spans multiple cells

• A type of data filter

• A tool for sorting data