Exam 3: Excel 1 Creating a Worksheet and a Chart

The first step in creating an effective worksheet is to make sure you ____.

You use ____ to view an XPS file.

____________________ cells involves creating a single cell by combining two or more selected cells.

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

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

Which of the following keys moves the insertion point to the beginning of data in a cell?

Worksheet titles and subtitles should be as wordy as possible.

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

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.

Excel can display characters in only three font colors: black, red, and blue.

The person or persons requesting the worksheet should supply their requirements in a ____ document.

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

Critical Thinking Questions Case 1-1 Perry has recently expanded his business and hired two employees. As a result of this expansion, he is considering carefully how to establish policies and procedures for creating workbooks. Perry decides that before either of his employees creates a new workbook he must give them a ____.

You can enter the correct range in a function by typing the beginning and ending cell references separated by a ____.

____________________ indicates how characters are emphasized.

The default font for a new workbook is ____________________ 11-point regular black.

Excel remembers the last ____ actions you have completed.

A given range contains the data that determines the size of slices in a corresponding pie chart; these entries are called the category names.

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