Exam 2: Microsoft Excel Basics

To ____ a macro means to have the macro perform the automated task.

Changes can be made to a worksheet that is password protected.

The ____ function can count cells if they contain text or a combination of text and numbers.

You can close a workbook by clicking the ____ tab on the Ribbon, and then clicking Close in the navigation bar.

What is the relationship, in terms of the data, between a PivotTable and a PivotChart created from the PivotTable?

To move cell contents, select the cell or range whose contents you want to move. Then, click the Cut button in the ____ group on the Home tab of the Ribbon.

Once you create a chart, it cannot be changed to another type of chart.

Please briefly describe these three summary calculation options and provide an example of when it would be used: Average, Minimum, and Maximum.

Excel does not accept spaces in named ranges.

When formulas with mixed cell references are copied or moved, the row or column references preceded by a question mark do not change.

The Show/Hide Comment button is found on the Data tab.

____ represent where the actual data would be in the chart.

____ are used for seconds in a format code.

FIGURE EX 7-1 The area indicated by #2 in Figure EX 7-1 above is ____.

Case EX 11-1 Venecia is using a worksheet to track her spending each month. So far the worksheet has the information for January up to August. Venecia wants to quickly view the totals for the worksheet but does not want to store that information permanently in the worksheet. She needs to use the ____ feature.

Case EX 6-1 Mariana is working at a computer that was passed on to her by another employee. She wants to add comments to several cells of a worksheet. To change the username, click the ____ tab, and then click Options in the navigation bar.

To insert a SmartArt graphic, click the SmartArt button in the ____ group on the Insert tab. The Choose a SmartArt Graphic dialog box appears.