Question 1

You should press the SPACEBAR to clear a cell.

Accepted Answer

A) True 
 B)False

Question 2

You can apply the Bold font style by pressing the ____ keyboard shortcut keys.

Accepted Answer

A)   ALT+B
B)   CTRL+B
C)   SHIFT+B
D)   TAB+BE) All of the above
F) A) and B)

Question 3

A thin red border indicates the active cell.

Accepted Answer

A) True 
 B)False

Question 4

Clicking the ____ box completes an entry.

Accepted Answer

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

Question 5

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

Accepted Answer

A)   semi-colon (;) 
B)   colon (:) 
C)   period (. ) 
D)   none of the aboveE) C) and D)
F) A) and D)

Question 6

In Excel,a number can contain the characters ____.

Accepted Answer

A)   0 1 2 3 4 5 6 7 8 9
B)   + - ( ) ,/
C)   .$ % E e
D)   all of the aboveE) A) and C)
F) C) and D)

Question 7

Worksheet titles and subtitles should be as wordy as possible.

Accepted Answer

A) True 
 B)False

Question 8

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

Accepted Answer

A)  ALT+PAGE DOWN
B)  ARROW
C)  CTRL+HOME
D)  HOME
E)  CTRL+FF) ENDG) INSERTH) SHIFT+RIGHT ARROWI) BACKSPACEJ) SPACEBARK) All of the above
L) F) and J)

Question 9

How many chart types does Excel offer?

Accepted Answer

A)   5
B)   10
C)   29
D)   50E) A) and D)
F) A) and B)

Question 10

To add a pie chart,first select the data to be charted and then tap or click the Insert Pie or Doughnut Chart button (INSERT tab | Charts group).

Accepted Answer

A) True 
 B)False

Question 11

Excel remembers the last ____ actions you have completed.

Accepted Answer

A)   25
B)   50
C)   75
D)   100E) B) and D)
F) A) and B)

Question 12

By default,text is ____ in a cell.

Accepted Answer

A)   left-aligned
B)   centered
C)   justified
D)   right-alignedE) None of the above
F) C) and D)

Question 13

You can insert a function in a cell by ____.

Accepted Answer

A)   tapping or clicking the Sum button arrow (HOME tab | Editing group) 
B)   tapping or clicking the Insert Function button in the formula bar
C)   typing + and one or more letters and then selecting the function name from a list
D)   typing = and one or more letters and then selecting the function name from a listE) C) and D)
F) A) and B)

Question 14

Which of the following keys toggles between Insert mode and Overtype mode?

Accepted Answer

A)   INSERT
B)   ENTER
C)   TAB
D)   ALTE) B) and C)
F) A) and D)

Question 15

You can clear cell contents and formatting by tapping or clicking Clear Contents on the Clear button menu.

Accepted Answer

A) True 
 B)False

Question 16

Identify the letter of the choice that best matches the phrase or definition.
-Moves the insertion point to the end of data in a cell.

Accepted Answer

A)  ALT+PAGE DOWN
B)  ARROW
C)  CTRL+HOME
D)  HOME
E)  CTRL+FF) ENDG) INSERTH) SHIFT+RIGHT ARROWI) BACKSPACEJ) SPACEBARK) D) and H)
L) E) and H)

Question 17

The opposite of merging cells is splitting a merged cell._________________________

Accepted Answer

A) True 
 B)False

Question 18

Both the Cancel box and the Enter box appear on the formula bar when you begin typing in a cell.

Accepted Answer

A) True 
 B)False

Question 19

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

Accepted Answer

A)   HOME
B)   ENTER
C)   INSERT
D)   TABE) All of the above
F) B) and D)

Question 20

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

Accepted Answer

The answer of Excel's ____________________ function,which adds all of the...

Exam 12: Excel: Creating a Worksheet and a Chart

Worksheet titles and subtitles should be as wordy as possible.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

How many chart types does Excel offer?

Correct AnswerverifiedShow Answer

By default,text is ____ in a cell.

Correct AnswerverifiedShow Answer

Clicking the ____ box completes an entry.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Which of the following keys toggles between Insert mode and Overtype mode?

Correct AnswerverifiedShow Answer

You can clear cell contents and formatting by tapping or clicking Clear Contents on the Clear button menu.

Correct AnswerverifiedShow Answer

A thin red border indicates the active cell.

Correct AnswerverifiedShow Answer

Both the Cancel box and the Enter box appear on the formula bar when you begin typing in a cell.

Correct AnswerverifiedShow Answer

To add a pie chart,first select the data to be charted and then tap or click the Insert Pie or Doughnut Chart button (INSERT tab | Charts group).

Correct AnswerverifiedShow Answer

Excel remembers the last ____ actions you have completed.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

The opposite of merging cells is splitting a merged cell._________________________

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

You should press the SPACEBAR to clear a cell.

Correct AnswerverifiedShow Answer

Identify the letter of the choice that best matches the phrase or definition. -Moves the insertion point to the end of data in a cell.

Correct AnswerverifiedShow Answer

In Excel,a number can contain the characters ____.

Correct AnswerverifiedShow Answer

You can insert a function in a cell by ____.

Correct AnswerverifiedShow Answer

You can apply the Bold font style by pressing the ____ keyboard shortcut keys.

Correct AnswerverifiedShow Answer

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

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified