Question 1

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 2

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

Accepted Answer

A) True 
 B)False

Question 3

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

Accepted Answer

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

Question 4

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 5

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

Accepted Answer

A) True 
 B)False

Question 6

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

Accepted Answer

planning

Question 7

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

Accepted Answer

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

Question 8

Clicking the ____ box completes an entry.

Accepted Answer

A)   Cancel
B)   Formula
C)   Enter
D)   TabE) B) and D)
F) B) and C)

Question 9

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

Accepted Answer

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

Question 10

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

Accepted Answer

relative reference

Question 11

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

Accepted Answer

A)   fill
B)   range
C)   location
D)   pasteE) B) and D)
F) None of the above

Question 12

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) A) and C)

Question 13

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) None of the above
F) C) and D)

Question 14

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) C) and D)
F) A) and B)

Question 15

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

Accepted Answer

A) True 
 B)False  False

Question 16

The ____ button allows you to erase recent cell entries.

Accepted Answer

A)   Undo
B)   Cell Style
C)   Bold
D)   Increase DecimalE) B) and D)
F) All of the above

Question 17

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 18

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 19

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) A) and B)
F) None of the above

Question 20

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

Accepted Answer

A)   Color
B)   Text
C)   Links
D)   TabsE) A) and D)
F) B) and C)

Exam 3: Excel 1 Creating a Worksheet and a Chart

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

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

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

Correct AnswerverifiedShow Answer

Clicking the ____ box completes an entry.

Correct AnswerverifiedShow Answer

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

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

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

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedFalse

The ____ button allows you to erase recent cell entries.

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

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

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
planning

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
relative reference

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
False

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified