Exam 2: Microsoft Excel Basics

You can add ____ protection to an entire workbook.

A(n) ____________________ chart uses bars of varying heights to illustrate values in a worksheet.

You can use the Format Painter to copy formatting only to adjacent cells or ranges.

Macro settings can be viewed by clicking the ____ tab on the Ribbon, and then clicking the Macro Security button in the Code group.

The Calculations tab on the Ribbon contains all the buttons you need when working with manual calculations.

Some mathematical operations, such as addition, subtraction, multiplication, and division, do not require functions.

The ____________________ Rules format cells based on comparison operators such as greater than, less than, between, and equal to.

To add subtotals, you select the Subtotal button to display the available options you can select in the ____________________ dialog box.

PivotChart filters are located ____.

FIGURE EX 11-1 Figure EX 11-1 above shows the ____ feature applied to the worksheet.

To add conditional formatting, select the range you want to analyze. In the ____ group on the Home tab, and click the Conditional Formatting button.

Case EX 6-2 Harry has inserted a picture into his Excel worksheet and wants to make some adjustments. Harry also wants to change the picture's shape and border. He accesses the Format contextual tab and uses the tools in the ____ group to change the shape and color.

To select multiple worksheets in a workbook, hold down the ____ key as you click the sheet tab of each worksheet you want to include in the group.

When you want to see all the data in a worksheet again, you can restore all the rows by clearing the filter. Click the filter arrow, and then click the ____ command.

The Themes group is found on the ____ tab of the Ribbon.

Occasionally you may need to apply a number format that is not already predefined in the existing number formats.

Selecting a macro from the Macro dialog box and clicking the ____________________ button will open the macro code in the Microsoft Visual Basic for Applications window.

In Excel, you need to sort one column of data at a time.

If you try to save a workbook with a signature line with a different name, the signature line will show the words ____________________ above the signature line.

When you look at a function in Excel to see if it is correct, you are doing a(n) ____ of that function.