Exam 2: Microsoft Excel Basics

To change the alignment of a cell, select the cell, and then click an alignment button in the Alignment group on the ____________________ tab of the Ribbon.

To remove a style from the selected cell, simply click Good in the Good, Bad and Neutral section of the Cell Styles gallery.

A ____ is a list that shows the colors and symbols used in a chart.

When the exact amounts that you want to enter in the Data Validation dialog box are in the worksheet, you can click the Collapse dialog box button and then select the cell with the amount.

The formula =C8-232 is an example of a division operation.

Case EX 17-2 Adam works at a textile company. The company stores information about its products in an Excel workbook. Adam needs to find an easy way to share some of the information with clients. Before sharing the worksheet data with anyone else, Adam should use the ____ to find out if the workbook has any hidden or personal data, and to delete that data.

A chart that shows data on two y-axes for the purpose of showing different data is called a ____ chart.

Case EX 5-1 Cheryl is planning to use Formula AutoComplete to help her enter some formulas in her new worksheet. What should Cheryl do to access Formula AutoComplete to help her write her formulas?

If the ____ style is selected in the Error Alert tab of the Data Validation dialog box, you will not be allowed to enter any value that does not meet the criteria.

You can use the ____ feature to have circles drawn around data that does not meet the data validation requirements.

Using the Error Alert tab in the Data Checking dialog box, you can create an error alert that appears when a value you enter does not fall within the range.

If you do not want the slicer to print, you can right-click it and choose ____ from the shortcut menu.

To hide more than one row, select how many rows you want to hide, and then ____ the selection to show the short-cut menu.

The Formula Bar appears to the right of the Name Box and displays a formula when the cell of a worksheet contains a calculated value.

When the Watch Window first appears, it only includes the workbook name and the worksheet name.

You can use the SUM function to total the values stored in up to 255 non-adjacent cells or ranges.

The Cell Styles library includes many predefined styles.

The PivotTable button is found on the ____ tab on the Ribbon.

You can press the ____ key to cycle a selected cell reference from a relative reference to an absolute reference to a mixed reference with an absolute row to a mixed reference with an absolute column and back to a relative reference.