Question 1

Which of the following is true about inserting cells in a worksheet?

Accepted Answer

A)  Excel automatically adjusts cell references to reflect new formula locations. 
B)  You need to adjust cell references in all formulas that have moved. 
C)  You cannot insert cells in a worksheet. 
D)  Cells below the inserted cells are always moved downward. 
A)  Excel automatically adjusts cell references to reflect new formula locations. 
B)  You need to adjust cell references in all formulas that have moved. 
C)  You cannot insert cells in a worksheet. 
D)  Cells below the inserted cells are always moved downward.

Question 2

You receive a worksheet in which the row numbers are 1, 2, 3, 5, 6. This means that row 4 is _____.

Accepted Answer

A)  deleted 
B)  hidden 
C)  cut 
D)  conditionally formatted 
A)  deleted 
B)  hidden 
C)  cut 
D)  conditionally formatted

Question 3

To change the text fill color of WordArt, we need to select the WordArt text, click Text Color on the Drawing Tools Format tab and pick the outline color you want.

Accepted Answer

A) True 
 B)False

Question 4

If Solver finds a solution, you can generate a Solution PivotTable on a separate worksheet.

Accepted Answer

A) True 
 B)False

Question 5

Which of the following keys should you press to have Excel calculate all open workbooks manually?

Accepted Answer

A)  F5 
B)  F9 
C)  F10 
D)  F12 
A)  F5 
B)  F9 
C)  F10 
D)  F12

Question 6

What is the file extension of macro-enabled workbook?

Accepted Answer

A)  .xls 
B)  .xlx 
C)  .xlsx 
D)  .xlsm 
A)  .xls 
B)  .xlx 
C)  .xlsx 
D)  .xlsm

Question 7

Which of the following tabs should you add to the ribbon to enable and run macros in a workbook?

Accepted Answer

A)  Advance 
B)  Macro 
C)  Developer 
D)  Power Tools 
A)  Advance 
B)  Macro 
C)  Developer 
D)  Power Tools

Question 8

Hannah is preparing to take out a mortgage to buy a house. She wants to compare the monthly payments for the loans she is considering, which have interest rates ranging from 3.5% to 5.25%. She can quickly fill in the values from 3.5% to 5.25% using a sequential series.

Accepted Answer

A) True 
 B)False

Question 9

Which of the following functions can you use to locate information in a table?

Accepted Answer

A)  MATCH 
B)  TEXT 
C)  LOCATE 
D)  LOOKUP 
A)  MATCH 
B)  TEXT 
C)  LOCATE 
D)  LOOKUP

Question 10

Dante uses a worksheet to list sales data from five stores he manages. The worksheet includes a column named Product Type, and Dante wants to calculate subtotals for each product type. What must he do before using the Subtotal feature?

Accepted Answer

A)  Sort the data in the Product Type column., 
B)  Convert the range to a table. 
C)  Outline the data. 
D)  Remove calculated columns. 
A)  Sort the data in the Product Type column., 
B)  Convert the range to a table. 
C)  Outline the data. 
D)  Remove calculated columns.

Question 11

When you click a chart element such as a legend, it displays sizing handles to indicate it is selected.

Accepted Answer

A) True 
 B)False

Question 12

When you get and transform data from an external source, you must add it to a worksheet without any changes.

Accepted Answer

A) True 
 B)False

Question 13

Which of the following can be the target of a hyperlink in Excel?

Accepted Answer

A)  New blank workbook 
B)  Worksheet in the current workbook 
C)  Print setting in the current workbook, 
D)  New worksheet in the current workbook 
A)  New blank workbook 
B)  Worksheet in the current workbook 
C)  Print setting in the current workbook, 
D)  New worksheet in the current workbook

Question 14

You've copied a cell containing formula to the rows below it, and the results in the copied cells are all zeros. To find the problem, what should you check for in your original formula?

Accepted Answer

A)  If it needs an absolute cell reference. 
B)  If it needs a relative cell reference. 
C)  If it needs landscape orientation. 
D)  If it needs a function. 
A)  If it needs an absolute cell reference. 
B)  If it needs a relative cell reference. 
C)  If it needs landscape orientation. 
D)  If it needs a function.

Question 15

Tricia created a defined name for a range but no longer wants to use it. What dialog box can she use to delete the defined name?

Accepted Answer

A)  Define Names dialog box 
B)  Name Manager dialog box 
C)  Scope dialog box 
D)  New Name dialog box 
A)  Define Names dialog box 
B)  Name Manager dialog box 
C)  Scope dialog box 
D)  New Name dialog box

Question 16

To accept a suggested spelling for that instance only, which of the following would you click?

Accepted Answer

A)  Change 
B)  Change All 
C)  Ignore Once 
D)  Add to Dictionary 
A)  Change 
B)  Change All 
C)  Ignore Once 
D)  Add to Dictionary

Question 17

Ingrid wants to create a PivotChart based on a PivotTable she added to a worksheet. What should she do before creating the PivotChart?

Accepted Answer

A)  Select the range where the PivotChart should be inserted. 
B)  Collapse the PivotTable fields to make room for the PivotChart. 
C)  Select a cell in the PivotTable. 
D)  Apply a PivotTable style so the PivotChart uses the same one. 
A)  Select the range where the PivotChart should be inserted. 
B)  Collapse the PivotTable fields to make room for the PivotChart. 
C)  Select a cell in the PivotTable. 
D)  Apply a PivotTable style so the PivotChart uses the same one.

Question 18

How can you remove the split panes from a worksheet?

Accepted Answer

A)  Click the View tab, and then click the Split button in the Windows group. 
B)  Click the Page Layout tab, and then click the Bring Forward button in the Arrange group. 
C)  Click the View tab, and then click the Hide button in the Windows group. 
D)  Click the Page layout tab, and then click the Remove Breaks button in the Page Setup group. 
A)  Click the View tab, and then click the Split button in the Windows group. 
B)  Click the Page Layout tab, and then click the Bring Forward button in the Arrange group. 
C)  Click the View tab, and then click the Hide button in the Windows group. 
D)  Click the Page layout tab, and then click the Remove Breaks button in the Page Setup group.

Question 19

In a two-input data table, you can vary the results in two cells and see the recalculated results.

Accepted Answer

A) True 
 B)False

Question 20

After you record a macro, you should _____ it to test the actions it contains.

Accepted Answer

A)  save 
B)  run 
C)  customize 
D)  rename 
A)  save 
B)  run 
C)  customize 
D)  rename

Which of the following is true about inserting cells in a worksheet?

You receive a worksheet in which the row numbers are 1, 2, 3, 5, 6. This means that row 4 is _____.

To change the text fill color of WordArt, we need to select the WordArt text, click Text Color on the Drawing Tools Format tab and pick the outline color you want.

If Solver finds a solution, you can generate a Solution PivotTable on a separate worksheet.

Which of the following keys should you press to have Excel calculate all open workbooks manually?

What is the file extension of macro-enabled workbook?

Which of the following tabs should you add to the ribbon to enable and run macros in a workbook?

Hannah is preparing to take out a mortgage to buy a house. She wants to compare the monthly payments for the loans she is considering, which have interest rates ranging from 3.5% to 5.25%. She can quickly fill in the values from 3.5% to 5.25% using a sequential series.

Which of the following functions can you use to locate information in a table?

Dante uses a worksheet to list sales data from five stores he manages. The worksheet includes a column named Product Type, and Dante wants to calculate subtotals for each product type. What must he do before using the Subtotal feature?

When you click a chart element such as a legend, it displays sizing handles to indicate it is selected.

When you get and transform data from an external source, you must add it to a worksheet without any changes.

Which of the following can be the target of a hyperlink in Excel?

You've copied a cell containing formula to the rows below it, and the results in the copied cells are all zeros. To find the problem, what should you check for in your original formula?

Tricia created a defined name for a range but no longer wants to use it. What dialog box can she use to delete the defined name?

To accept a suggested spelling for that instance only, which of the following would you click?

Ingrid wants to create a PivotChart based on a PivotTable she added to a worksheet. What should she do before creating the PivotChart?

How can you remove the split panes from a worksheet?

In a two-input data table, you can vary the results in two cells and see the recalculated results.

After you record a macro, you should _____ it to test the actions it contains.

Access-2019

Powerpoint-2019

Word-2019

Question Sets

Outlook-2019

Windows-10-2019

Filters

Exam 2: Excel-2019

Which of the following is true about inserting cells in a worksheet?

You receive a worksheet in which the row numbers are 1, 2, 3, 5, 6. This means that row 4 is _____.

To change the text fill color of WordArt, we need to select the WordArt text, click Text Color on the Drawing Tools Format tab and pick the outline color you want.

If Solver finds a solution, you can generate a Solution PivotTable on a separate worksheet.

Which of the following keys should you press to have Excel calculate all open workbooks manually?

What is the file extension of macro-enabled workbook?

Which of the following tabs should you add to the ribbon to enable and run macros in a workbook?

Hannah is preparing to take out a mortgage to buy a house. She wants to compare the monthly payments for the loans she is considering, which have interest rates ranging from 3.5% to 5.25%. She can quickly fill in the values from 3.5% to 5.25% using a sequential series.

Which of the following functions can you use to locate information in a table?

Dante uses a worksheet to list sales data from five stores he manages. The worksheet includes a column named Product Type, and Dante wants to calculate subtotals for each product type. What must he do before using the Subtotal feature?

When you click a chart element such as a legend, it displays sizing handles to indicate it is selected.

When you get and transform data from an external source, you must add it to a worksheet without any changes.

Which of the following can be the target of a hyperlink in Excel?

You've copied a cell containing formula to the rows below it, and the results in the copied cells are all zeros. To find the problem, what should you check for in your original formula?

Tricia created a defined name for a range but no longer wants to use it. What dialog box can she use to delete the defined name?

To accept a suggested spelling for that instance only, which of the following would you click?

Ingrid wants to create a PivotChart based on a PivotTable she added to a worksheet. What should she do before creating the PivotChart?

How can you remove the split panes from a worksheet?

In a two-input data table, you can vary the results in two cells and see the recalculated results.

After you record a macro, you should _____ it to test the actions it contains.

Access-2019

Powerpoint-2019

Word-2019

Question Sets

Outlook-2019

Windows-10-2019

Filters