Question 1

What effect does the Comma Style format have on the selected cells?

Accepted Answer

A)  Converts decimals to commas within a cell
B)  Converts decimals to commas within merged cells
C)  Displays cell contents with two decimal places and commas as thousands separators
D)  Allows for substitution of selected characters

Question 2

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

Accepted Answer

A)  blank
B)  test issues
C)  requirements
D)  certified

Question 3

Match between columns
                        Premises: Selects the adjacent cell in the direction of the arrow on the key.

Accepted Answer

The Answer of HOME and SPACEBAR and SHIFT+RIGHT ARROW and is...

Question 4

To draw a Clustered Cylinder chart, first select the data to be charted and then click the Column button (Insert tab | Charts group).

Accepted Answer

A) True 
 B)False

Question 5

Match between columns
                        Premises: Selects cell A1.

Accepted Answer

The Answer of CTRL+HOME and HOME and INSERT and CTRL+F is...

Question 6

_________________________ indicates how text characters are emphasized.

Accepted Answer

Font style

Question 7

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

Accepted Answer

A)  INSERT
B)  ENTER
C)  TAB
D)  ALT

Question 8

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

Accepted Answer

A)  worksheet
B)  workbook
C)  document
D)  presentation

Question 9

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

Accepted Answer

The answer of The automatically adjusted cell reference in a...

Question 10

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 11

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

Accepted Answer

A) True 
 B)False

Question 12

You can insert a function in a cell by _____.

Accepted Answer

A)  clicking the Sum button arrow (Home tab | Editing group) 
B)  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 list A,B,D

Question 13

Combining two or more selected cells into one cell is called _____ cells.

Accepted Answer

A)  merging
B)  mixing
C)  combining
D)  spanning

Question 14

Match between columns
                        Premises: Not used to clear a cell.

Accepted Answer

The Answer of SHIFT+RIGHT ARROW and INSERT and CTRL+F and is...

Question 15

If each cell in a selected range is next to a row of numbers, Excel assigns the SUM function to each cell in the selected range when the Sum button is clicked.

Accepted Answer

A) True 
 B)False

Question 16

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

Accepted Answer

A) True 
 B)False  False

Question 17

_____ is/are used to add worksheet, column, and row titles on a worksheet.

Accepted Answer

A)  Color
B)  Text
C)  Links
D)  Tabs

Question 18

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

Accepted Answer

A) True 
 B)False

Question 19

The cell into which data is being entered is referred to as the _________________________ cell.

Accepted Answer

The answer of The cell into which data is being...

Question 20

Match between columns
                        Premises: Selects the cell at the beginning of the row that contains the active cell.

Accepted Answer

The Answer of END and ARROW and HOME and CTRL+HOME is...

Exam 10: Excel : Creating a Worksheet and an Embedded Chart

What effect does the Comma Style format have on the selected cells?

Correct Answer
verified

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

Correct Answer
verified

Identify the letter of the choice that best matches the phrase or definition.

To draw a Clustered Cylinder chart, first select the data to be charted and then click the Column button (Insert tab | Charts group).

Correct Answer
verified

Identify the letter of the choice that best matches the phrase or definition.

_________________________ indicates how text characters are emphasized.

Correct Answer
verified
Font style

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

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

You can insert a function in a cell by _____.

Correct Answer
verified
A,B,D

Combining two or more selected cells into one cell is called _____ cells.

Correct Answer
verified

Identify the letter of the choice that best matches the phrase or definition.

If each cell in a selected range is next to a row of numbers, Excel assigns the SUM function to each cell in the selected range when the Sum button is clicked.

Correct Answer
verified

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

Correct Answer
verified
False

_____ is/are used to add worksheet, column, and row titles on a worksheet.

Correct Answer
verified

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

Correct Answer
verified

The cell into which data is being entered is referred to as the _________________________ cell.

Correct Answer
verified

Identify the letter of the choice that best matches the phrase or definition.

Exam 10: Excel : Creating a Worksheet and an Embedded Chart

What effect does the Comma Style format have on the selected cells?

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Identify the letter of the choice that best matches the phrase or definition.

To draw a Clustered Cylinder chart, first select the data to be charted and then click the Column button (Insert tab | Charts group).

Correct AnswerverifiedShow Answer

Identify the letter of the choice that best matches the phrase or definition.

_________________________ indicates how text characters are emphasized.

Correct AnswerverifiedFont style

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

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

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

Correct AnswerverifiedShow Answer

You can insert a function in a cell by _____.

Correct AnswerverifiedA,B,D

Combining two or more selected cells into one cell is called _____ cells.

Correct AnswerverifiedShow Answer

Identify the letter of the choice that best matches the phrase or definition.

If each cell in a selected range is next to a row of numbers, Excel assigns the SUM function to each cell in the selected range when the Sum button is clicked.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedFalse

_____ is/are used to add worksheet, column, and row titles on a worksheet.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

The cell into which data is being entered is referred to as the _________________________ cell.

Correct AnswerverifiedShow Answer

Identify the letter of the choice that best matches the phrase or definition.

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
Font style

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
A,B,D

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
False

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified