Question 1

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 2

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

Accepted Answer

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

Question 3

-A cell is selected,or ____________________,when a heavy border surrounds the cell,as shown in the accompanying figure.

Accepted Answer

The answer of 
-A cell is selected,or ____________________,when a heavy...

Question 4

The date you change a file is an example of a(n) ____ property.

Accepted Answer

A)   automatically updated
B)   baseline
C)   standard
D)   indexedE) A) and C)
F) A) and B)

Question 5

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

Question 6

The characters that Excel displays on the screen are a specific ____.

Accepted Answer

A)   font
B)   style
C)   size
D)   colorE) A) and B)
F) None of the above

Question 7

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

Accepted Answer

A)   worksheet
B)   workflow
C)   document
D)   presentationE) All of the above
F) B) and D)

Question 8

To use the AutoCalculate area,select the range of cells containing the numbers for a calculation you want to verify and then press and hold or double-click the AutoCalculate area to display the Customize Status Bar shortcut menu.

Accepted Answer

A) True 
 B)False

Question 9

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

Question 10

Identify the letter of the choice that best matches the phrase or definition.
-Displays the Find dialog box.

Accepted Answer

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

Question 11

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

Accepted Answer

A) True 
 B)False

Question 12

You can double-tap or double-click the ____________________ tab of the worksheet whose name you want to change.

Accepted Answer

The answer of You can double-tap or double-click the ____________________...

Exam 12: Excel: Creating a Worksheet and a Chart

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

Correct Answer
verified

You can double-tap or double-click the ____________________ tab of the worksheet whose name you want to change.

Correct Answer
verified

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

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

Correct Answer
verified

The date you change a file is an example of a(n) ____ property.

Correct Answer
verified

The characters that Excel displays on the screen are a specific ____.

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

Identify the letter of the choice that best matches the phrase or definition. -Displays the Find dialog box.

Correct Answer
verified

-A cell is selected,or ____________________,when a heavy border surrounds the cell,as shown in the accompanying figure.

Correct Answer
verified

To use the AutoCalculate area,select the range of cells containing the numbers for a calculation you want to verify and then press and hold or double-click the AutoCalculate area to display the Customize Status Bar shortcut menu.

Correct Answer
verified

Exam 12: Excel: Creating a Worksheet and a Chart

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

Correct AnswerverifiedShow Answer

You can double-tap or double-click the ____________________ tab of the worksheet whose name you want to change.

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

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

Correct AnswerverifiedShow Answer

The date you change a file is an example of a(n) ____ property.

Correct AnswerverifiedShow Answer

The characters that Excel displays on the screen are a specific ____.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Identify the letter of the choice that best matches the phrase or definition. -Displays the Find dialog box.

Correct AnswerverifiedShow Answer

-A cell is selected,or ____________________,when a heavy border surrounds the cell,as shown in the accompanying figure.

Correct AnswerverifiedShow Answer

To use the AutoCalculate area,select the range of cells containing the numbers for a calculation you want to verify and then press and hold or double-click the AutoCalculate area to display the Customize Status Bar shortcut menu.

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