Question 1

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

Accepted Answer

A)   row
B)   worksheet
C)   column
D)   cellE) C) and D)
F) All of the above

Question 2

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

Accepted Answer

A)   Color
B)   Text
C)   Links
D)   TabsE) None of the above
F) A) and C)

Question 3

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

Accepted Answer

planning

Question 4

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

Accepted Answer

The answer of The ____________________ button allows you to choose...

Question 5

The ____ area on the status bar includes six commands as well as the result of the associated calculation on the right side of the menu.

Accepted Answer

A)   AutoFormat
B)   AutoComplete
C)   AutoFunction
D)   AutoCalculateE) A) and B)
F) B) and C)

Question 6

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

Accepted Answer

A) True 
 B)False

Question 7

Clicking the ____ box completes an entry.

Accepted Answer

A)   Cancel
B)   Formula
C)   Enter
D)   TabE) B) and C)
F) None of the above

Question 8

An Excel ____ allows data to be summarized and charted easily.

Accepted Answer

A)   worksheet
B)   workflow
C)   document
D)   presentationE) B) and D)
F) A) and D)

Question 9

The ____ button allows you to erase recent cell entries.

Accepted Answer

A)   Undo
B)   Cell Style
C)   Bold
D)   Increase DecimalE) B) and C)
F) A) and D)

Question 10

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

Accepted Answer

The answer of A(n) ____________________ conveys a visual representation of...

Question 11

The range of cells receiving the content of copied cells is called the ____.

Accepted Answer

A)   receiver cell
B)   final cell
C)   receiving range
D)   destination areaE) B) and D)
F) B) and C)

Question 12

While typing in a cell, you can press the ____________________ key to erase all the characters back to and including the incorrect character you just typed.

Accepted Answer

The answer of While typing in a cell, you can...

Question 13

A character with a point size of 10 is about 10/72 of one inch in height.

Accepted Answer

A) True 
 B)False

Question 14

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

Accepted Answer

A)   Converts alphabetic characters to numbers
B)   Displays cell contents with two decimal places that align vertically
C)   Performs tax calculations
D)   Copies the numbers of one cell to anotherE) B) and C)
F) B) and D)

Question 15

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

Accepted Answer

A) True 
 B)False

Question 16

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

Accepted Answer

The answer of The active cell reference appears in the...

Question 17

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

Accepted Answer

A) True 
 B)False  False

Question 18

Which of the following is the Ribbon path to the Cell Styles button?

Accepted Answer

A)   (HOME tab | Styles group) 
B)   (STYLES tab | Home group) 
C)   (HOME tab | Format group) 
D)   (FORMAT tab | Styles group) E) None of the above
F) B) and D)

Question 19

The automatically adjusted cell reference in a pasted formula is called a(n) ____________________.

Accepted Answer

relative reference

Question 20

The range of cells receiving copied content is called the ____ area.

Accepted Answer

A)   fill
B)   range
C)   location
D)   pasteE) A) and D)
F) B) and C)

Exam 3: Excel 1 Creating a Worksheet and a Chart

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct Answerverifiedplanning

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

Correct AnswerverifiedShow Answer

The ____ area on the status bar includes six commands as well as the result of the associated calculation on the right side of the menu.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Clicking the ____ box completes an entry.

Correct AnswerverifiedShow Answer

An Excel ____ allows data to be summarized and charted easily.

Correct AnswerverifiedShow Answer

The ____ button allows you to erase recent cell entries.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

The range of cells receiving the content of copied cells is called the ____.

Correct AnswerverifiedShow Answer

While typing in a cell, you can press the ____________________ key to erase all the characters back to and including the incorrect character you just typed.

Correct AnswerverifiedShow Answer

A character with a point size of 10 is about 10/72 of one inch in height.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedFalse

Which of the following is the Ribbon path to the Cell Styles button?

Correct AnswerverifiedShow Answer

The automatically adjusted cell reference in a pasted formula is called a(n) ____________________.

Correct Answerverifiedrelative reference

The range of cells receiving copied content is called the ____ area.

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
planning

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
False

Correct Answer
verified

Correct Answer
verified
relative reference

Correct Answer
verified