Question 1

After creating a PivotTable, you can refresh its data, but you cannot change the data source.

Accepted Answer

A) True 
 B)False

Question 2

Which of the following Shadow property values displays a shadow for Text Box (ActiveX Control)?

Accepted Answer

A)  Outer 
B)  Inner 
C)  True 
D)  False 
A)  Outer 
B)  Inner 
C)  True 
D)  False

Question 3

Use the DLOOKUP function to extract a single record from a table that matches criteria you specify.

Accepted Answer

A) True 
 B)False

Question 4

If you change data used in the data model, what should you do?

Accepted Answer

A)  Refresh the data. 
B)  Reset the relationships. 
C)  Add the new data to the data model. 
D)  Display the data in Table view. 
A)  Refresh the data. 
B)  Reset the relationships. 
C)  Add the new data to the data model. 
D)  Display the data in Table view.

Question 5

To change the starting and ending values on a chart axis, use the _____ pane.

Accepted Answer

A)  Chart 
B)  Format Axis 
C)  Format Shape 
D)  Labels 
A)  Chart 
B)  Format Axis 
C)  Format Shape 
D)  Labels

Question 6

Which of the following is true about deleting a worksheet row?

Accepted Answer

A)  After you delete a row, the rows below it shift down one row. 
B)  To delete a row, you can select the row, then press the DELETE key on the keyboard. 
C)  To delete a row, you can select the row, then use the Delete button in the Cells group. 
D)  If you select a row and click the Delete list arrow, you can select Delete Sheet to delete the row. 
A)  After you delete a row, the rows below it shift down one row. 
B)  To delete a row, you can select the row, then press the DELETE key on the keyboard. 
C)  To delete a row, you can select the row, then use the Delete button in the Cells group. 
D)  If you select a row and click the Delete list arrow, you can select Delete Sheet to delete the row.

Question 7

To add a worksheet to a workbook, you would use the New formula tab below the worksheet.

Accepted Answer

A) True 
 B)False

Question 8

Which of the following functions can you use to display the middle characters in specified text?

Accepted Answer

A)  MIDDLE 
B)  MID 
C)  TEXT 
D)  CENTER 
A)  MIDDLE 
B)  MID 
C)  TEXT 
D)  CENTER

Question 9

Which of the following inserts a function into a cell?

Accepted Answer

A)  mode indicator 
B)  AutoSum button 
C)  argument 
D)  formula prefix 
A)  mode indicator 
B)  AutoSum button 
C)  argument 
D)  formula prefix

Question 10

Which property do you use to change the text displayed on a form control?

Accepted Answer

A)  Caption 
B)  Tag 
C)  Display Name 
D)  Label 
A)  Caption 
B)  Tag 
C)  Display Name 
D)  Label

Question 11

Currency is an example of a number format.

Accepted Answer

A) True 
 B)False

Question 12

A trendline is a small, simple chart in a worksheet cell that shows trends of data in nearby cells.

Accepted Answer

A) True 
 B)False

Question 13

Which of the following conditional formats can you apply to display small graphics in a cell that vary based on the cell's value?

Accepted Answer

A)  icon sets 
B)  data bars 
C)  Highlight Cells Rules 
D)  color scales 
A)  icon sets 
B)  data bars 
C)  Highlight Cells Rules 
D)  color scales

Question 14

A _____ between tables in the data model lets you access data from both tables.

Accepted Answer

A)  relationship 
B)  measure 
C)  query 
D)  diagram 
A)  relationship 
B)  measure 
C)  query 
D)  diagram

Question 15

Your worksheet contains a price in cell A5, and many formulas refer to that price. How would you refer to that price in the formulas?

Accepted Answer

A)  A5 
B)  $A$5 
C)  $A5 
D)  A$5 
A)  A5 
B)  $A$5 
C)  $A5 
D)  A$5

Question 16

When you open a workbook, it contains one or more worksheets.

Accepted Answer

A) True 
 B)False

Question 17

Tracing dependents indicates which cells are affected by a formula error.

Accepted Answer

A) True 
 B)False

Question 18

In the formula =SUM('San Francisco'!A6:D6), the exclamation point is a(n) linked reference indicator.

Accepted Answer

A) True 
 B)False

Question 19

Che has a Pie PivotChart that he wants to display with in a three-dimensional format. Which of the following should he do?

Accepted Answer

A)  Change the PivotChart type from Pie to 3-D Pie. 
B)  Apply shadows to the PivotChart., 
C)  Explode the slices in the PivotChart. 
D)  Replace the Pie PivotChart with a Doughnut PivotChart. 
A)  Change the PivotChart type from Pie to 3-D Pie. 
B)  Apply shadows to the PivotChart., 
C)  Explode the slices in the PivotChart. 
D)  Replace the Pie PivotChart with a Doughnut PivotChart.

Question 20

To print more than one copy of your worksheet, which tab would you go to?

Accepted Answer

A)  View 
B)  Page Layout 
C)  Insert 
D)  File 
A)  View 
B)  Page Layout 
C)  Insert 
D)  File

After creating a PivotTable, you can refresh its data, but you cannot change the data source.

Which of the following Shadow property values displays a shadow for Text Box (ActiveX Control)?

Use the DLOOKUP function to extract a single record from a table that matches criteria you specify.

If you change data used in the data model, what should you do?

To change the starting and ending values on a chart axis, use the _____ pane.

Which of the following is true about deleting a worksheet row?

To add a worksheet to a workbook, you would use the New formula tab below the worksheet.

Which of the following functions can you use to display the middle characters in specified text?

Which of the following inserts a function into a cell?

Which property do you use to change the text displayed on a form control?

Currency is an example of a number format.

A trendline is a small, simple chart in a worksheet cell that shows trends of data in nearby cells.

Which of the following conditional formats can you apply to display small graphics in a cell that vary based on the cell's value?

A _____ between tables in the data model lets you access data from both tables.

Your worksheet contains a price in cell A5, and many formulas refer to that price. How would you refer to that price in the formulas?

When you open a workbook, it contains one or more worksheets.

Tracing dependents indicates which cells are affected by a formula error.

In the formula =SUM('San Francisco'!A6:D6), the exclamation point is a(n) linked reference indicator.

Che has a Pie PivotChart that he wants to display with in a three-dimensional format. Which of the following should he do?

To print more than one copy of your worksheet, which tab would you go to?

Access-2019

Powerpoint-2019

Word-2019

Question Sets

Outlook-2019

Windows-10-2019

Filters

Exam 2: Excel-2019

After creating a PivotTable, you can refresh its data, but you cannot change the data source.

Which of the following Shadow property values displays a shadow for Text Box (ActiveX Control)?

Use the DLOOKUP function to extract a single record from a table that matches criteria you specify.

If you change data used in the data model, what should you do?

To change the starting and ending values on a chart axis, use the _____ pane.

Which of the following is true about deleting a worksheet row?

To add a worksheet to a workbook, you would use the New formula tab below the worksheet.

Which of the following functions can you use to display the middle characters in specified text?

Which of the following inserts a function into a cell?

Which property do you use to change the text displayed on a form control?

Currency is an example of a number format.

A trendline is a small, simple chart in a worksheet cell that shows trends of data in nearby cells.

Which of the following conditional formats can you apply to display small graphics in a cell that vary based on the cell's value?

A _____ between tables in the data model lets you access data from both tables.

Your worksheet contains a price in cell A5, and many formulas refer to that price. How would you refer to that price in the formulas?

When you open a workbook, it contains one or more worksheets.

Tracing dependents indicates which cells are affected by a formula error.

In the formula =SUM('San Francisco'!A6:D6), the exclamation point is a(n) linked reference indicator.

Che has a Pie PivotChart that he wants to display with in a three-dimensional format. Which of the following should he do?

To print more than one copy of your worksheet, which tab would you go to?

Access-2019

Powerpoint-2019

Word-2019

Question Sets

Outlook-2019

Windows-10-2019

Filters