Question 1

Match between columns
                        Premises: Moves the insertion point to the end of data in a cell.

Accepted Answer

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

Question 2

The ____ preceding a formula alerts Excel that you are entering a formula or function and not text.

Accepted Answer

A)   quotation mark (") 
B)   colon (:) 
C)   plus (+) 
D)   equal sign (=)

Question 3

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 above

Question 4

You can click the ____________________ button arrow (HOME tab | Editing group) to view a list of often-used functions.

Accepted Answer

The answer of You can click the ____________________ button arrow...

Question 5

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)   TAB

Question 6

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

Question 7

How many chart types does Excel offer?

Accepted Answer

A)   5
B)   10
C)   29
D)   50

Question 8

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 9

To erase an entire entry in a cell and then reenter the data from the beginning, press the ____ key.

Accepted Answer

A)   ALT
B)   ESC
C)   CTRL
D)   TAB

Question 10

If you accidentally undo an action, you can use the Redo button to redo it.

Accepted Answer

A) True 
 B)False

Question 11

____________________ cells involves creating a single cell by combining two or more selected cells.

Accepted Answer

The answer of ____________________ cells involves creating a single cell...

Question 12

The ____ is the small black square located in the lower-right corner of the heavy border around the active cell.

Accepted Answer

A)   selection handle
B)   sizing handle
C)   fill handle
D)   copy handle

Exam 9: Excel: Creating a Worksheet and a Chart

The ____ is the small black square located in the lower-right corner of the heavy border around the active cell.

Correct Answer
verified

You can click the ____________________ button arrow (HOME tab | Editing group) to view a list of often-used functions.

Correct Answer
verified

____________________ cells involves creating a single cell by combining two or more selected cells.

Correct Answer
verified

The ____ preceding a formula alerts Excel that you are entering a formula or function and not text.

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

How many chart types does Excel offer?

Correct Answer
verified

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 Answer
verified

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

Correct Answer
verified

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

If you accidentally undo an action, you can use the Redo button to redo it.

Correct Answer
verified

To erase an entire entry in a cell and then reenter the data from the beginning, press the ____ key.

Correct Answer
verified

Exam 9: Excel: Creating a Worksheet and a Chart

The ____ is the small black square located in the lower-right corner of the heavy border around the active cell.

Correct AnswerverifiedShow Answer

You can click the ____________________ button arrow (HOME tab | Editing group) to view a list of often-used functions.

Correct AnswerverifiedShow Answer

____________________ cells involves creating a single cell by combining two or more selected cells.

Correct AnswerverifiedShow Answer

The ____ preceding a formula alerts Excel that you are entering a formula or function and not text.

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

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

Correct AnswerverifiedShow Answer

How many chart types does Excel offer?

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 AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

If you accidentally undo an action, you can use the Redo button to redo it.

Correct AnswerverifiedShow Answer

To erase an entire entry in a cell and then reenter the data from the beginning, press the ____ key.

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