Exam 1: Creating a Worksheet and a Chart

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 features helps Anita be more productive by automatically reducing the number of misspelled or mistyped words?

The active cell reference appears in the ____________________ on the left side of the formula bar.

A pie chart with one or more slices offset is referred to as a(n)____ pie chart.

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

You can click the ____________________ button arrow (HOME tab | Editing group)to view a list of often-used functions.

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

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?

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

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

If a major error is made when typing data into a cell,tap or 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.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Selects the cell one worksheet window to the right.

-A cell is selected,or ____________________,when a heavy border surrounds the cell,as shown in the accompanying figure.

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 ____.

____ is / are used to place worksheet,column,and row titles on a worksheet.

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

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Highlights one or more adjacent characters to the right.

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

The ____ preceding a formula alerts Excel that you are entering a formula or function and not text.

The ____ button allows you to erase recent cell entries.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Should not be used to clear a cell.