Question 1

-A ____ is a series of two or more adjacent cells in a column or row or a rectangular group of cells,as shown in the accompanying figure.

Accepted Answer

A)   range
B)   bunch
C)   nearby cell
D)   neighborE) A) and C)
F) C) and D)

Question 2

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 3

The person or persons requesting the worksheet should supply their requirements in a ____ document.

Accepted Answer

A)   blank
B)   test issues
C)   requirements
D)   certifiedE) All of the above
F) A) and D)

Question 4

Excel can display characters in only three font colors: black,red,and blue.

Accepted Answer

A) True 
 B)False  False

Question 5

Press ____ to select the entire worksheet.

Accepted Answer

A)   F1
B)   CTRL+A
C)   ALT+A
D)   F4E) B) and C)
F) A) and C) B

Question 6

When entering dollar values in cells,you also must type the dollar sign ($),commas,and any trailing zeros.

Accepted Answer

A) True 
 B)False

Question 7

How many chart types does Excel offer?

Accepted Answer

A)   5
B)   10
C)   29
D)   50E) A) and B)
F) None of the above

Question 8

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

Question 9

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

Question 10

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 11

Excel remembers the last ____ actions you have completed.

Accepted Answer

A)   25
B)   50
C)   75
D)   100E) A) and C)
F) None of the above

Question 12

The AutoCorrect feature can automatically capitalize the first letter in the names of days.

Accepted Answer

A) True 
 B)False

Question 13

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Selects cell A1.

Accepted Answer

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

Question 14

A given range contains the data that determines the size of slices in a corresponding pie chart; these entries are called the category names.

Accepted Answer

A) True 
 B)False

Question 15

A single point is about 1 / 32 of one inch in height.

Accepted Answer

A) True 
 B)False

Question 16

If you have multiple Excel workbooks open,to close all open workbooks and exit Excel,____.

Accepted Answer

A)  press F4
B)  press ALT+F4
C)  press and hold the Excel app button on the taskbar and then tap 'Close all windows' on the shortcut menu
D)  right-click the Excel app button on the taskbar and then click 'Close all windows' on the shortcut menuE) B) and D)
F) A) and C)

Question 17

By default,text is ____ in a cell.

Accepted Answer

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

Question 18

A requirements document includes a needs statement,source of data,summary of calculations,and any other special requirements for a worksheet.

Accepted Answer

A) True 
 B)False

Question 19

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

Accepted Answer

A)   INSERT
B)   ENTER
C)   TAB
D)   ALTE) C) and D)
F) All of the above

Question 20

When you tap or click the Enter box to complete an entry in a cell,the active cell moves down to the next cell in the same column.

Accepted Answer

A) True 
 B)False  False

Exam 1: Creating a Worksheet and a Chart

-A ____ is a series of two or more adjacent cells in a column or row or a rectangular group of cells,as shown in the accompanying figure.

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 person or persons requesting the worksheet should supply their requirements in a ____ document.

Correct AnswerverifiedShow Answer

Excel can display characters in only three font colors: black,red,and blue.

Correct AnswerverifiedFalse

Press ____ to select the entire worksheet.

Correct AnswerverifiedB

When entering dollar values in cells,you also must type the dollar sign ($),commas,and any trailing zeros.

Correct AnswerverifiedShow Answer

How many chart types does Excel offer?

Correct AnswerverifiedShow Answer

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

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

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

Correct AnswerverifiedShow Answer

Excel remembers the last ____ actions you have completed.

Correct AnswerverifiedShow Answer

The AutoCorrect feature can automatically capitalize the first letter in the names of days.

Correct AnswerverifiedShow Answer

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Selects cell A1.

Correct AnswerverifiedShow Answer

A given range contains the data that determines the size of slices in a corresponding pie chart; these entries are called the category names.

Correct AnswerverifiedShow Answer

A single point is about 1 / 32 of one inch in height.

Correct AnswerverifiedShow Answer

If you have multiple Excel workbooks open,to close all open workbooks and exit Excel,____.

Correct AnswerverifiedShow Answer

By default,text is ____ in a cell.

Correct AnswerverifiedShow Answer

A requirements document includes a needs statement,source of data,summary of calculations,and any other special requirements for a worksheet.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

When you tap or click the Enter box to complete an entry in a cell,the active cell moves down to the next cell in the same column.

Correct AnswerverifiedFalse

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
False

Correct Answer
verified
B

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
False