FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 1: Creating a Worksheet and a Chart

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 31

Short Answer

Review LaterAdd Note

Review Later

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

Correct Answer

verified

Show Answer

Question 32

Multiple Choice

Review LaterAdd Note

Review Later

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

A) requirements document
B) USB flash drive
C) file name
D) table of keyboard shortcuts

E) C) and D)
F) B) and C)

Correct Answer

verified

Show Answer

Question 33

Multiple Choice

Review LaterAdd Note

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?

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

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

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?

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

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

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.

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

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

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.

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

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

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

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

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

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