Exam 9: Excel: Creating a Worksheet and a Chart

____________________ indicates how characters are emphasized.

Clicking the ____ box completes an entry.

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 make the adjacent cell the active cell.

Like an area chart, a(n) ____________________ chart often is used to illustrate changes in data over time.

Excel recognizes the following as text: 401AX21, 921-231, 619 321, 883XTY.

The ____ button allows you to choose whether you want to copy the values from the source area to the destination area with formatting.

____ properties are associated with all Microsoft Office files and include author, title, and subject.

If you wish to sign out of your Microsoft account, tap or click ____ on the ribbon to open the Backstage view and then tap or click the Account tab to display the Account gallery, and tap or click the Sign out link.

You can press the RIGHT ARROW or LEFT ARROW keys to position the insertion point during in-cell editing.

The opposite of merging cells is splitting a merged cell.

____________________ involves reducing the electricity consumed and environmental waste generated when using computers, mobile devices, and related technologies.

Worksheet titles and subtitles should be as wordy as possible.

To use the AutoCalculate area, select the range of cells containing the numbers for a calculation you want to verify and then press and hold or double-click the AutoCalculate area to display the Customize Status Bar shortcut menu.

To enter data in a cell, you must first select the ____.

Critical Thinking Questions Case 1-2 Anita is new to Microsoft Excel 2013.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?

What effect does the Accounting Number Format have on the selected cells?

Pressing the ____ keyboard shortcut key(s) selects cell A1.

A(n) ____________________ conveys a visual representation of data.

To clear the entire worksheet, tap or click the Clear All button on the worksheet.

A requirements document includes a needs statement, source of data, summary of calculations, and any other special requirements for a worksheet.