Question 1

Which of the following keyboard shortcuts allows you to select a range of cells with entries surrounded by blank cells?

Accepted Answer

A)  ALT+SHIFT+ASTERISK (*) 
B)  CTRL+SHIFT+ASTERISK (*) 
C)  TAB+SHIFT+ASTERISK (*) 
D)  SHIFT+HOME+ASTERISK (*) 
A)  ALT+SHIFT+ASTERISK (*) 
B)  CTRL+SHIFT+ASTERISK (*) 
C)  TAB+SHIFT+ASTERISK (*) 
D)  SHIFT+HOME+ASTERISK (*)

Question 2

When you use the SUM function,Excel assumes that all contiguous numbers should be summed.

Accepted Answer

A) True 
 B)False

Question 3

When a series of @@@@@@ signs or symbols appears in a cell that should contain a date,the formatted date does not fit in the width of the cell._________________________

Accepted Answer

A) True 
 B)False

Question 4

If multiple sheets are selected and you want to select a sheet that is selected,but not active,click the sheet tab you want to select.

Accepted Answer

A) True 
 B)False

Question 5

A circular reference is a formula that depends on its own value.​

Accepted Answer

A) True 
 B)False

Question 6

​The consolidated main workbook that contains links to the separate workbooks is called the dependent workbook.

Accepted Answer

A) True 
 B)False

Question 7

The code ____ instructs Excel to insert the page number in the header or footer section.

Accepted Answer

A)  > 
B)  &[Page] 
C)  [PageNum] 
D)  (LoadPageNum) 
A)  > 
B)  &[Page] 
C)  [PageNum] 
D)  (LoadPageNum)

Question 8

You must enter the first three numbers in a series so that Excel can determine the increment amount when using the fill handle to increment a series by two.

Accepted Answer

A) True 
 B)False

Question 9

The path to the Sum button is ____.

Accepted Answer

Question 10

Headers,footers,and margins are all ____ options.

Accepted Answer

A)  validation 
B)  calculation 
C)  page setup 
D)  control 
A)  validation 
B)  calculation 
C)  page setup 
D)  control

Question 11

You can reference an entire column or an entire row in a function argument by listing only the column or only the row.

Accepted Answer

A) True 
 B)False

Question 12

It is recommended that you use the ____ function on formulas that potentially can result in more decimal places than the applied format displays.

Accepted Answer

A)  DATE 
B)  ROUND 
C)  SUM 
D)  IF 
A)  DATE 
B)  ROUND 
C)  SUM 
D)  IF

Question 13

An organization may keep data from various departments or regions in different worksheets in the same workbook._________________________

Accepted Answer

A) True 
 B)False

Question 14

When you consider how to organize your data in a workbook,use multiple worksheets when the data is tightly related.

Accepted Answer

A) True 
 B)False

Question 15

The standard accounting format for a table or numbers contains floating dollar signs in the first row of numbers.

Accepted Answer

A) True 
 B)False

Question 16

The formula =sum(1:1)adds all the values in column A._________________________

Accepted Answer

A) True 
 B)False

Question 17

You can customize a format code in a cell entry to specify how ____ are displayed in a cell.

Accepted Answer

A)  positive numbers 
B)  negative numbers 
C)  zeros 
D)  text 
A)  positive numbers 
B)  negative numbers 
C)  zeros 
D)  text

Question 18

You can use the ENTER key to complete a paste operation.

Accepted Answer

A) True 
 B)False

Question 19

As you develop more sophisticated workbooks,it will become increasingly important that you create good test data to ensure your workbooks are free of errors.

Accepted Answer

A) True 
 B)False

Question 20

You can change headers or footers to increase or decrease the white space surrounding the printed worksheet or chart.

Accepted Answer

A) True 
 B)False

Which of the following keyboard shortcuts allows you to select a range of cells with entries surrounded by blank cells?

When you use the SUM function,Excel assumes that all contiguous numbers should be summed.

When a series of @@@@@@ signs or symbols appears in a cell that should contain a date,the formatted date does not fit in the width of the cell._________________________

If multiple sheets are selected and you want to select a sheet that is selected,but not active,click the sheet tab you want to select.

A circular reference is a formula that depends on its own value.

The consolidated main workbook that contains links to the separate workbooks is called the dependent workbook.

The code ____ instructs Excel to insert the page number in the header or footer section.

You must enter the first three numbers in a series so that Excel can determine the increment amount when using the fill handle to increment a series by two.

The path to the Sum button is ____.

Headers,footers,and margins are all ____ options.

You can reference an entire column or an entire row in a function argument by listing only the column or only the row.

It is recommended that you use the ____ function on formulas that potentially can result in more decimal places than the applied format displays.

An organization may keep data from various departments or regions in different worksheets in the same workbook._________________________

When you consider how to organize your data in a workbook,use multiple worksheets when the data is tightly related.

The standard accounting format for a table or numbers contains floating dollar signs in the first row of numbers.

The formula =sum(1:1)adds all the values in column A._________________________

You can customize a format code in a cell entry to specify how ____ are displayed in a cell.

You can use the ENTER key to complete a paste operation.

As you develop more sophisticated workbooks,it will become increasingly important that you create good test data to ensure your workbooks are free of errors.

You can change headers or footers to increase or decrease the white space surrounding the printed worksheet or chart.

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

Which of the following keyboard shortcuts allows you to select a range of cells with entries surrounded by blank cells?

When you use the SUM function,Excel assumes that all contiguous numbers should be summed.

When a series of @@@@@@ signs or symbols appears in a cell that should contain a date,the formatted date does not fit in the width of the cell._________________________

If multiple sheets are selected and you want to select a sheet that is selected,but not active,click the sheet tab you want to select.

A circular reference is a formula that depends on its own value.​

​The consolidated main workbook that contains links to the separate workbooks is called the dependent workbook.

The code ____ instructs Excel to insert the page number in the header or footer section.

You must enter the first three numbers in a series so that Excel can determine the increment amount when using the fill handle to increment a series by two.

The path to the Sum button is ____.

Headers,footers,and margins are all ____ options.

You can reference an entire column or an entire row in a function argument by listing only the column or only the row.

It is recommended that you use the ____ function on formulas that potentially can result in more decimal places than the applied format displays.

An organization may keep data from various departments or regions in different worksheets in the same workbook._________________________

When you consider how to organize your data in a workbook,use multiple worksheets when the data is tightly related.

The standard accounting format for a table or numbers contains floating dollar signs in the first row of numbers.

The formula =sum(1:1)adds all the values in column A._________________________

You can customize a format code in a cell entry to specify how ____ are displayed in a cell.

You can use the ENTER key to complete a paste operation.

As you develop more sophisticated workbooks,it will become increasingly important that you create good test data to ensure your workbooks are free of errors.

You can change headers or footers to increase or decrease the white space surrounding the printed worksheet or chart.

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

A circular reference is a formula that depends on its own value.

The consolidated main workbook that contains links to the separate workbooks is called the dependent workbook.