Exam 2: Microsoft Excel Basics

In the Show Error dialog box, you can choose to show the calculation steps to help identify where the problem occurs.

You can make a perfect square or circle by pressing and holding the F5 key as you drag in the worksheet to draw the shape.

If the Developer tab is not displayed on the Ribbon, you can add it to the Ribbon.

If a function contains more than one argument, semicolons separate the arguments.

FIGURE EX 8-1 In Figure EX 8-1 above, under Education Pays, the red and blue boxes labeled Men and Women is the ____.

A(n) ____________________ workbook lets you save the macro in the workbook and then run the macro.

____ allows you to access and share files online with friends, family members, or co-workers.

To insert a picture from a file, click the ____ button in the Illustrations group on the Insert tab of the Ribbon.

All chart types are interchangeable. For example, data suitable for a pie chart will also always work as a scatter chart.

FIGURE EX 5-1 In Figure EX 5-1 above, the Pmt figure is -250. The negative number means ____.

The Sum button is located in the ____ group on the Home tab of the Ribbon.

Data that is used to create a PivotTable can contain some blank columns or blank rows.

You use the HLOOKUP function when the lookup table is listed vertically in columns.

Passwords for a workbook are case sensitive.

The drag-and-drop method is the slowest way to copy or move data short distances in a worksheet.

When you use the VLOOKUP function, you will need to enter information into the ____ dialog box.

Modifying code is similar to modifying text in a Microsoft Word document.

The quickest way to select a chart element is to ____.