Exam 2: Microsoft Excel Basics

A ____ is called a control because it controls the actions that are assigned to it.

____________________ divides the worksheet window into two or four panes that you can scroll independently.

When you add subtotals to a worksheet, the worksheet is displayed in an outline format.

You can also center cell contents across several columns. Select the cells, and then click the ____ button in the Alignment group on the Home tab of the Ribbon.

A(n) ____________________ chart shows the amount of progress accomplished toward a goal.

The sequence used to calculate the value of a formula is called the ____.

When you save a worksheet file, the tracer arrows are saved with the worksheet.

The IFERROR function is written as ____.

Choosing the ____ style in the Error Alert tab of the Data Validation dialog box displays a warning dialog box but allows the data to be entered.

You can reposition a worksheet by dragging its ____ to a new location.

The ____ tab has options that let you make changes to buttons.

The XPS format is accessible to more people than the PDF format.

You can use the Insert Function dialog box to find a specific function. In the ____ box, type a brief description of what you want to do. Then, click Go.

A(n) ____________________ sort arranges data with letters from Z to A, data with numbers from highest to lowest, and data with dates from oldest to newest.

To join the values of cells together, you use the ____ function.

Case EX 4-1 Kayden wants to preview calculations in the status bar so she can quickly glance at them and know some of the basics about a particular range of numbers. Kayden wants to customize which calculations appear on the status bar. What should she do next?

The Error Checking button is found on the ____ tab.

When you have a worksheet that several people have access to, you run the risk of unwanted changes.