Question 1

To copy the contents of a cell to the cell directly below it,click the target cell and press ____.

Accepted Answer

A)  CTRL+X 
B)  CTRL+D 
C)  CTRL+C 
D)  CTRL+V 
A)  CTRL+X 
B)  CTRL+D 
C)  CTRL+C 
D)  CTRL+V B

Question 2

You can enter formulas that reference cells on other worksheets in the workbook.

Accepted Answer

A) True 
 B)False  True

Question 3

To reference cells in other sheets in a workbook when creating a formula,include the worksheet name rather than the cell reference.

Accepted Answer

A) True 
 B)False  False

Question 4

The process of summarizing data included on multiple worksheets on one worksheet is called drilling an entry.​

Accepted Answer

A) True 
 B)False

Question 5

The process of summarizing data included on multiple worksheets on one worksheet is called ____.

Accepted Answer

A)  summarization 
B)  consolidation 
C)  encapsulation 
D)  recapitulation 
A)  summarization 
B)  consolidation 
C)  encapsulation 
D)  recapitulation

Question 6

You can display the Cell Styles gallery by clicking the Cell Styles button (HOME tab | Styles group).

Accepted Answer

A) True 
 B)False

Question 7

You should create good ____ to ensure your workbooks are free of errors.

Accepted Answer

A)  color contrast 
B)  range boundaries 
C)  test data 
D)  none of the above 
A)  color contrast 
B)  range boundaries 
C)  test data 
D)  none of the above

Question 8

The following sequence,1,2,3,etc.,is an example of a(n)____ series.

Accepted Answer

A)  auto fill 
B)  date 
C)  linear 
D)  growth 
A)  auto fill 
B)  date 
C)  linear 
D)  growth

Question 9

Which of the following format symbols displays text along with numbers entered in a cell?

Accepted Answer

A)  _ (underscore) 
B)  0 (zero) 
C)  " " (quotation marks) 
D)  # (number sign) 
A)  _ (underscore) 
B)  0 (zero) 
C)  " " (quotation marks) 
D)  # (number sign)

Question 10

Which of the following are true about the ROUND function?

Accepted Answer

A)  If the number of digits argument is equal to 0 (zero),then the number is rounded to the nearest integer. 
B)  If the number of digits argument is not included,then the number is rounded to 10 times the current value. 
A)  If the number of digits argument is equal to 0 (zero),then the number is rounded to the nearest integer. 
B)  If the number of digits argument is not included,then the number is rounded to 10 times the current value.

Question 11

If added,a footer appears at the bottom of every printed worksheet page.

Accepted Answer

A) True 
 B)False

Question 12

When you create a new custom format code,Excel adds it to the bottom of the Type list in the Number sheet in the Format Cells dialog box to make it available for future use.

Accepted Answer

A) True 
 B)False

Question 13

Which of the following is the path to the Fill button?

Accepted Answer

Question 14

Which of the following format codes shows percent values with two decimal places and shows negative percent values in blue with parentheses?

Accepted Answer

A)  #,##0.00;[Blue](#,##0.00) 
B)  0.00%[Blue];(0.00%) 
C)  0.00%;[Blue](0.00%) 
D)  $*#,##0_;[Blue]($*#,##0_) 
A)  #,##0.00;[Blue](#,##0.00) 
B)  0.00%[Blue];(0.00%) 
C)  0.00%;[Blue](0.00%) 
D)  $*#,##0_;[Blue]($*#,##0_)

Question 15

Excel's capability of drilling data through worksheets is an inefficient way to enter data that is common among worksheets.

Accepted Answer

A) True 
 B)False

Question 16

Which of the following fill actions can you perform by dragging the fill handle?

Accepted Answer

A)  Jan,Feb,March,etc. 
B)  1,1,1,etc. 
C)  2,4,6,etc. 
D)  1,2,3,etc. 
A)  Jan,Feb,March,etc. 
B)  1,1,1,etc. 
C)  2,4,6,etc. 
D)  1,2,3,etc.

Question 17

A workbook contains ____ worksheet(s)by default.

Accepted Answer

A)  one 
B)  two 
C)  three 
D)  four 
A)  one 
B)  two 
C)  three 
D)  four

Question 18

If you change the Normal style,Excel applies the new format specifications to all cells,including those assigned other styles.

Accepted Answer

A) True 
 B)False

Question 19

The path to the Comma Style button is ____.

Accepted Answer

Question 20

If multiple sheets are selected and you want to select the active sheet,if you are using a touch screen,press and hold and select ____ from the shortcut menu.

Accepted Answer

A)  Select Active Sheet 
B)  Ungroup Sheets 
C)  Quick Select 
D)  Disaggregate Sheets 
A)  Select Active Sheet 
B)  Ungroup Sheets 
C)  Quick Select 
D)  Disaggregate Sheets

To copy the contents of a cell to the cell directly below it,click the target cell and press ____.

You can enter formulas that reference cells on other worksheets in the workbook.

To reference cells in other sheets in a workbook when creating a formula,include the worksheet name rather than the cell reference.

The process of summarizing data included on multiple worksheets on one worksheet is called drilling an entry.

The process of summarizing data included on multiple worksheets on one worksheet is called ____.

You can display the Cell Styles gallery by clicking the Cell Styles button (HOME tab | Styles group).

You should create good ____ to ensure your workbooks are free of errors.

The following sequence,1,2,3,etc.,is an example of a(n)____ series.

Which of the following format symbols displays text along with numbers entered in a cell?

Which of the following are true about the ROUND function?

If added,a footer appears at the bottom of every printed worksheet page.

When you create a new custom format code,Excel adds it to the bottom of the Type list in the Number sheet in the Format Cells dialog box to make it available for future use.

Which of the following is the path to the Fill button?

Which of the following format codes shows percent values with two decimal places and shows negative percent values in blue with parentheses?

Excel's capability of drilling data through worksheets is an inefficient way to enter data that is common among worksheets.

Which of the following fill actions can you perform by dragging the fill handle?

A workbook contains ____ worksheet(s)by default.

If you change the Normal style,Excel applies the new format specifications to all cells,including those assigned other styles.

The path to the Comma Style button is ____.

If multiple sheets are selected and you want to select the active sheet,if you are using a touch screen,press and hold and select ____ from the shortcut menu.

Creating a Worksheet and a Chart

Formulas, Functions, and Formatting

Working With Large Worksheets, Charting, and What-If Analysis

Financial Functions, Data Tables, and Amortization Schedules

Creating, Sorting, and Querying a Table

Creating Templates, Importing Data, and Working With Smartart, Images, and Screenshots

Working With Trendlines, Pivot Table Reports, Pivotchart Reports, and Slicers

Formula Auditing, Data Validation, and Complex Problem Solving

Using Macros and Visual Basic for Applications Vba With Excel

Collaboration Features for Workbooks

Essential Concepts and Skills

Productivity App: Productivity Apps for School and Work

Filters

Exam 5: Working With Multiple Worksheets and Workbooks

To copy the contents of a cell to the cell directly below it,click the target cell and press ____.

You can enter formulas that reference cells on other worksheets in the workbook.

To reference cells in other sheets in a workbook when creating a formula,include the worksheet name rather than the cell reference.

The process of summarizing data included on multiple worksheets on one worksheet is called drilling an entry.​

The process of summarizing data included on multiple worksheets on one worksheet is called ____.

You can display the Cell Styles gallery by clicking the Cell Styles button (HOME tab | Styles group).

You should create good ____ to ensure your workbooks are free of errors.

The following sequence,1,2,3,etc.,is an example of a(n)____ series.

Which of the following format symbols displays text along with numbers entered in a cell?

Which of the following are true about the ROUND function?

If added,a footer appears at the bottom of every printed worksheet page.

When you create a new custom format code,Excel adds it to the bottom of the Type list in the Number sheet in the Format Cells dialog box to make it available for future use.

Which of the following is the path to the Fill button?

Which of the following format codes shows percent values with two decimal places and shows negative percent values in blue with parentheses?

Excel's capability of drilling data through worksheets is an inefficient way to enter data that is common among worksheets.

Which of the following fill actions can you perform by dragging the fill handle?

A workbook contains ____ worksheet(s)by default.

If you change the Normal style,Excel applies the new format specifications to all cells,including those assigned other styles.

The path to the Comma Style button is ____.

If multiple sheets are selected and you want to select the active sheet,if you are using a touch screen,press and hold and select ____ from the shortcut menu.

Creating a Worksheet and a Chart

Formulas, Functions, and Formatting

Working With Large Worksheets, Charting, and What-If Analysis

Financial Functions, Data Tables, and Amortization Schedules

Creating, Sorting, and Querying a Table

Creating Templates, Importing Data, and Working With Smartart, Images, and Screenshots

Working With Trendlines, Pivot Table Reports, Pivotchart Reports, and Slicers

Formula Auditing, Data Validation, and Complex Problem Solving

Using Macros and Visual Basic for Applications Vba With Excel

Collaboration Features for Workbooks

Essential Concepts and Skills

Productivity App: Productivity Apps for School and Work

Filters

The process of summarizing data included on multiple worksheets on one worksheet is called drilling an entry.