Exam 11: Excel 2013 Getting Started With Excel 2013

Critical Thinking Questions Case 1-1 You have created a simple worksheet like the one in the accompanying figure to help you keep track of your available funds based on your monthly costs for rent, gas, food, and entertainment. In the accompanying figure, the formula in cell C7 can be copied to cells C8 and C9. What Excel feature would you use to accomplish this?

All text formatted with the ____ style is imported into PowerPoint as a Level 1 item in a bulleted list.

In the accompanying figure, item ____ represents the vertical axis.

In the accompanying figure, use the Paste Options button labeled ____  if you want the pasted chart not to be linked to the source document and you want the pasted chart to keep the formatting from the source document.

Which function key on the keyboard allows the Excel user to cycle through all possible combinations of relative, mixed, and absolute cell references for a formula?

In the accompanying figure, the item marked as 1 points to the ____ button.

Discuss the five guidelines for creating calculations in Excel.

The default file extension for an Excel 2013 workbook is ____.

The ____ of a cell determines how the labels and values look.

When you insert a new column, the contents of the worksheet shift to the left from the point of the new column.

You can use colors, patterns, and borders to enhance the overall appearance of a worksheet and to make it easier to read. One of the ways of adding these enhancements is to use the Borders, Font Colors, and Fill Color buttons in the Font group on the ____ tab of the Ribbon.

Which formula contains a mixed cell reference?

When you integrate data from multiple Office programs, you work with both a source file and a destination file.

Describe Excel's AutoRecover feature.

As shown in the accompanying figure, item 2 points to the ____.

You can use the ____ slider on the status bar to enlarge your view of specific areas of your worksheet.

In Excel, a worksheet is contained in a file called a ____.

A(n) ____________________ is an equation in a worksheet.

You can ____ the chart title text to select it.

In the accompanying figure, item 3 points to a ____.