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

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

Question 3

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

Question 4

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

Accepted Answer

A)   receiver cell
B)   final cell
C)   receiving range
D)   destination areaE) None of the above
F) A) and D)

Question 5

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

Accepted Answer

A)   HOME
B)   DELETE
C)   END
D)   BACKSPACEE) A) and B)
F) All of the above C

Question 6

____________________ corrects two initial capital letters by changing the second letter to lowercase.

Accepted Answer

The answer of ____________________ corrects two initial capital letters by...

Question 7

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

Question 8

Live preview is available on a touch screen.

Accepted Answer

A) True 
 B)False

Question 9

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

Accepted Answer

A) True 
 B)False

Question 10

The default font for a new workbook is ____________________ 11-point regular black.

Accepted Answer

The answer of The default font for a new workbook...

Question 11

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

Question 12

The ____ is a blinking vertical line that indicates where the next typed character will appear.

Accepted Answer

A)   scroll box
B)   sheet tab
C)   insertion point
D)   split barE) A) and B)
F) B) and C)

Question 13

____ is/are used to place worksheet, column, and row titles on a worksheet.

Accepted Answer

A)   Color
B)   Text
C)   Links
D)   TabsE) A) and B)
F) A) and C) B

Question 14

Discuss document properties.Include definitions of these terms: standard properties and automatically updated properties .Be sure to give at least two reasons why document properties are valuable.

Accepted Answer

Excel helps you organize and identify yo...

Question 15

Excel remembers the last ____ actions you have completed.

Accepted Answer

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

Question 16

Match between columns
                        Premises: Displays the Find dialog box.

Accepted Answer

The Answer of CTRL+F and END and SPACEBAR and ALT+PAGE is...

Question 17

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

Accepted Answer

A)   press ALT+F4
B)   press and hold the Excel app button on the taskbar and then tap 'Close all windows' on the shortcut menuC) A) and B)
D) undefined

Question 18

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 19

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

Accepted Answer

A)   worksheet
B)   workflow
C)   document
D)   presentationE) B) and D)
F) A) and C)

Question 20

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

Exam 9: Excel: Creating a Worksheet and a Chart

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

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

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

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified
C

____________________ corrects two initial capital letters by changing the second letter to lowercase.

Correct Answer
verified

In Excel, a number can contain the characters ____.

Correct Answer
verified

Live preview is available on a touch screen.

Correct Answer
verified

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

Correct Answer
verified

The default font for a new workbook is ____________________ 11-point regular black.

Correct Answer
verified

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

Correct Answer
verified

The ____ is a blinking vertical line that indicates where the next typed character will appear.

Correct Answer
verified

____ is/are used to place worksheet, column, and row titles on a worksheet.

Correct Answer
verified
B

Discuss document properties.Include definitions of these terms: standard properties and automatically updated properties .Be sure to give at least two reasons why document properties are valuable.

Correct Answer
verified
Excel helps you organize and identify yo...
View Answer

Excel remembers the last ____ actions you have completed.

Correct Answer
verified
D

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

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

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

Exam 9: Excel: Creating a Worksheet and a Chart

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

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

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedC

____________________ corrects two initial capital letters by changing the second letter to lowercase.

Correct AnswerverifiedShow Answer

In Excel, a number can contain the characters ____.

Correct AnswerverifiedShow Answer

Live preview is available on a touch screen.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

The default font for a new workbook is ____________________ 11-point regular black.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

The ____ is a blinking vertical line that indicates where the next typed character will appear.

Correct AnswerverifiedShow Answer

____ is/are used to place worksheet, column, and row titles on a worksheet.

Correct AnswerverifiedB

Discuss document properties.Include definitions of these terms: standard properties and automatically updated properties .Be sure to give at least two reasons why document properties are valuable.

Correct AnswerverifiedExcel helps you organize and identify yo...View AnswerShow Answer

Excel remembers the last ____ actions you have completed.

Correct AnswerverifiedD

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

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

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

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
C

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
B

Correct Answer
verified
Excel helps you organize and identify yo...
View Answer

Correct Answer
verified
D

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified