Exam 3: Excel: Creating a Worksheet and an Embedded Chart

If a major error is made when typing data into a cell, click the Cancel box in the formula bar or press the ESC key to erase the entire entry, and then reenter the data from the beginning.

If the next entry you want to make is in an adjacent cell, use the ____________________ keys to complete the entry in the current cell and activate the adjacent cell.

When you click the Enter button to complete an entry in a cell, the active cell moves down to the next cell in the same column.

Careful ____________________ can reduce your effort significantly and result in a worksheet that is accurate, easy to read, flexible, and useful.

The recommended methodology for creating worksheets includes _____.

Both the Cancel button and the Enter button appear on the formula bar when you begin typing in a cell.

You can apply the Bold font style by pressing the ____ keyboard shortcut keys.

A ____ reference is an adjusted cell reference in a copied and pasted formula.

What effect does the Comma Style format have on the selected cells?

Choose a type of chart that relays the message that you want to convey.

Discuss document properties.Include definitions of these terms: metadata , keywords , standard properties , and automatically updated properties .Be sure to give at least two reasons why document properties are valuable.

When entering dollar values in cells, you also must type the dollar sign ($), commas, and any trailing zeros.

The ____ area on the status bar displays common calculations, such as SUM or AVERAGE, for selected numbers in the worksheet.

In the accompanying figure, the ____ identifies the colors assigned to each bar in the chart on a worksheet.

In general, use no more than ____ font types in a worksheet.

Excel's ____________________, which adds all of the numbers in a range of cells, provides a convenient means to calculate a total.

Anita is new to Microsoft Office Excel 2011.As she uses the application, she is beginning to see that Excel offers many features to help her save time and be more productive.Which of the following features helps Anita be more productive by automatically reducing the number of misspelled or mistyped words?

In a worksheet, columns typically contain information that is similar to a list.

The group of adjacent cells beginning with B4 and ending with B8, written as B4:B8, is called a(n)range .

Anita is new to Microsoft Office Excel 2011.As she uses the application, she is beginning to see that Excel offers many features to help her save time and be more productive.Which of the following Excel features helps Anita be more productive by helping her more easily organize and identify her workbook files?