Question 1

Which type of conditional formatting rule would you create to add a horizontal bar to a cell background, where the length of the bar reflects the value in the cell?

Accepted Answer

A)  Top Values 
B)  Data Bar 
C)  Icon Sets 
D)  Color Scales 
A)  Top Values 
B)  Data Bar 
C)  Icon Sets 
D)  Color Scales

Question 2

You import data from an external source into a worksheet using the _____.

Accepted Answer

A)  Data Model 
B)  default PivotTable 
C)  Import Wizard 
D)  Power Query Editor 
A)  Data Model 
B)  default PivotTable 
C)  Import Wizard 
D)  Power Query Editor

Question 3

A treemap chart is a type of waterfall chart.

Accepted Answer

A) True 
 B)False

Question 4

Antonio wants to calculate the sum of values in the Order Amt column in a table. What should he do?

Accepted Answer

A)  Add a total row and then choose Sum in the Order Amt column. 
B)  Add a calculated field to the table that uses the SUM function. 
C)  Use the SUBTOTAL function at the bottom of the Order Amt column. 
D)  Add a total column and then choose Total to calculate all totals for the table. 
A)  Add a total row and then choose Sum in the Order Amt column. 
B)  Add a calculated field to the table that uses the SUM function. 
C)  Use the SUBTOTAL function at the bottom of the Order Amt column. 
D)  Add a total column and then choose Total to calculate all totals for the table.

Question 5

A student types the formula '= YEAR( TODAY())-2005' to calculate the age of a person born in 2005. This formula will use the TODAY function as an argument for the YEAR function to obtain the current year, and then subtract 2005 returning the person's age.

Accepted Answer

A) True 
 B)False

Question 6

A single PivotTable can draw information from two tables if the tables are _____.

Accepted Answer

A)  related, 
B)  similar 
C)  from the same source 
D)  filtered 
A)  related, 
B)  similar 
C)  from the same source 
D)  filtered

Question 7

You should not move a PivotChart because it must be on the same worksheet as its PivotTable.

Accepted Answer

A) True 
 B)False

Question 8

Ernie wants to add a screenshot of an entire window into his file. To do so, he clicks on the document at the location where he wants to add the screenshot, then clicks Screenshot in the Illustrations group on the Insert tab. What will he do when the Available windows gallery appears next?

Accepted Answer

A)  Click the thumbnail image of the window whose screenshot he wants to insert. 
B)  Click Screen Clipping, then press and hold the left mouse button to drag and capture the window screen. 
C)  Select a thumbnail of the required window, then press and hold the left mouse button to drag and capture the window screen. 
D)  Click Screen Clipping, and when the pointer becomes a hand icon, capture the window screen. 
A)  Click the thumbnail image of the window whose screenshot he wants to insert. 
B)  Click Screen Clipping, then press and hold the left mouse button to drag and capture the window screen. 
C)  Select a thumbnail of the required window, then press and hold the left mouse button to drag and capture the window screen. 
D)  Click Screen Clipping, and when the pointer becomes a hand icon, capture the window screen.

Question 9

Sheila imported a Clients table and a Projects table and wants to create a PivotTable that uses fields from both tables. She can link the tables using their common ClientID field. Because one client can have many projects, she will create a one-to-many connection .

Accepted Answer

A) True 
 B)False

Question 10

Dmitri created a table of employee data and wants to list the records in order by most recent hire date. Which of the following should he do?

Accepted Answer

A)  Sort the records in descending order by hire date. 
B)  Sort the records in ascending order by hire date. 
C)  Sort the records first by name and then by hire date. 
D)  Filter the records by hire date. 
A)  Sort the records in descending order by hire date. 
B)  Sort the records in ascending order by hire date. 
C)  Sort the records first by name and then by hire date. 
D)  Filter the records by hire date.

Question 11

To use the SLN function to calculate the depreciation of an asset, you need to know the cost, salvage value, and life of the asset.

Accepted Answer

A) True 
 B)False

Question 12

A(n) trendline is a line that extends from the chart's horizontal or vertical axis into the plot area, making it easier to identify the values in the chart.

Accepted Answer

A) True 
 B)False

Question 13

If a worksheet contains data that is not of interest to the user and is better summarized in another part of the workbook, consider _____ the worksheet.

Accepted Answer

A)  deleting 
B)  hiding 
C)  renaming 
D)  moving 
A)  deleting 
B)  hiding 
C)  renaming 
D)  moving

Question 14

Darryl has a worksheet that displays a product's net profit in cell C20. He is using Solver to determine how he can achieve the most profit by changing the values in other cells. Where should he enter a reference to cell C20 in the Solver Parameters dialog box?

Accepted Answer

A)  Set Objective box 
B)  By Changing Variable Cells box 
C)  Subject to the Constraints box 
D)  Load/Save box 
A)  Set Objective box 
B)  By Changing Variable Cells box 
C)  Subject to the Constraints box 
D)  Load/Save box

Question 15

To evaluate a formula, click the following series: Cell you want to evaluate > Formulas tab > Formula Auditing group > Evaluate Formula > Evaluate (Continue until all the parts of the formula have been evaluated) > Close.

Accepted Answer

A) True 
 B)False

Question 16

Maddie entered customer first names in column A and last names in column B. What feature can she use to enter the full names in column C?

Accepted Answer

A)  Business Intelligence 
B)  Flash fill 
C)  Quick Analysis tools 
D)  What-if analysis 
A)  Business Intelligence 
B)  Flash fill 
C)  Quick Analysis tools 
D)  What-if analysis

Question 17

The buttons on the Design tab within the Switch Visualizations button group allows us to change the type of data visualization.

Accepted Answer

A) True 
 B)False

Question 18

Which type of chart would show increases in the value of a stock fund in green, decreases in gray, and the initial and final values in red?

Accepted Answer

A)  sunburst 
B)  waterfall 
C)  area 
D)  doughnut 
A)  sunburst 
B)  waterfall 
C)  area 
D)  doughnut

Question 19

Which of the following formulas adds 25 and 10, and then multiplies the result by 50?

Accepted Answer

A)  =25+10*50 
B)  25/(10*50) 
C)  50*25+10 
D)  (25+10)*50 
A)  =25+10*50 
B)  25/(10*50) 
C)  50*25+10 
D)  (25+10)*50

Question 20

To retrieve a return value from a vertical lookup table, you use the VTABLE function.

Accepted Answer

A) True 
 B)False

Which type of conditional formatting rule would you create to add a horizontal bar to a cell background, where the length of the bar reflects the value in the cell?

You import data from an external source into a worksheet using the _____.

A treemap chart is a type of waterfall chart.

Antonio wants to calculate the sum of values in the Order Amt column in a table. What should he do?

A student types the formula '= YEAR( TODAY())-2005' to calculate the age of a person born in 2005. This formula will use the TODAY function as an argument for the YEAR function to obtain the current year, and then subtract 2005 returning the person's age.

A single PivotTable can draw information from two tables if the tables are _____.

You should not move a PivotChart because it must be on the same worksheet as its PivotTable.

Ernie wants to add a screenshot of an entire window into his file. To do so, he clicks on the document at the location where he wants to add the screenshot, then clicks Screenshot in the Illustrations group on the Insert tab. What will he do when the Available windows gallery appears next?

Sheila imported a Clients table and a Projects table and wants to create a PivotTable that uses fields from both tables. She can link the tables using their common ClientID field. Because one client can have many projects, she will create a one-to-many connection .

Dmitri created a table of employee data and wants to list the records in order by most recent hire date. Which of the following should he do?

To use the SLN function to calculate the depreciation of an asset, you need to know the cost, salvage value, and life of the asset.

A(n) trendline is a line that extends from the chart's horizontal or vertical axis into the plot area, making it easier to identify the values in the chart.

If a worksheet contains data that is not of interest to the user and is better summarized in another part of the workbook, consider _____ the worksheet.

Darryl has a worksheet that displays a product's net profit in cell C20. He is using Solver to determine how he can achieve the most profit by changing the values in other cells. Where should he enter a reference to cell C20 in the Solver Parameters dialog box?

To evaluate a formula, click the following series: Cell you want to evaluate > Formulas tab > Formula Auditing group > Evaluate Formula > Evaluate (Continue until all the parts of the formula have been evaluated) > Close.

Maddie entered customer first names in column A and last names in column B. What feature can she use to enter the full names in column C?

The buttons on the Design tab within the Switch Visualizations button group allows us to change the type of data visualization.

Which type of chart would show increases in the value of a stock fund in green, decreases in gray, and the initial and final values in red?

Which of the following formulas adds 25 and 10, and then multiplies the result by 50?

To retrieve a return value from a vertical lookup table, you use the VTABLE function.

Access 2019

Outlook 2019

Powerpoint 2019

Windows 10 - 2019

Word 2019

Computer History and Components

Filters

Exam 2: Excel 2019

Which type of conditional formatting rule would you create to add a horizontal bar to a cell background, where the length of the bar reflects the value in the cell?

You import data from an external source into a worksheet using the _____.

A treemap chart is a type of waterfall chart.

Antonio wants to calculate the sum of values in the Order Amt column in a table. What should he do?

A student types the formula '= YEAR( TODAY())-2005' to calculate the age of a person born in 2005. This formula will use the TODAY function as an argument for the YEAR function to obtain the current year, and then subtract 2005 returning the person's age.

A single PivotTable can draw information from two tables if the tables are _____.

You should not move a PivotChart because it must be on the same worksheet as its PivotTable.

Ernie wants to add a screenshot of an entire window into his file. To do so, he clicks on the document at the location where he wants to add the screenshot, then clicks Screenshot in the Illustrations group on the Insert tab. What will he do when the Available windows gallery appears next?

Sheila imported a Clients table and a Projects table and wants to create a PivotTable that uses fields from both tables. She can link the tables using their common ClientID field. Because one client can have many projects, she will create a one-to-many connection .

Dmitri created a table of employee data and wants to list the records in order by most recent hire date. Which of the following should he do?

To use the SLN function to calculate the depreciation of an asset, you need to know the cost, salvage value, and life of the asset.

A(n) trendline is a line that extends from the chart's horizontal or vertical axis into the plot area, making it easier to identify the values in the chart.

If a worksheet contains data that is not of interest to the user and is better summarized in another part of the workbook, consider _____ the worksheet.

Darryl has a worksheet that displays a product's net profit in cell C20. He is using Solver to determine how he can achieve the most profit by changing the values in other cells. Where should he enter a reference to cell C20 in the Solver Parameters dialog box?

To evaluate a formula, click the following series: Cell you want to evaluate > Formulas tab > Formula Auditing group > Evaluate Formula > Evaluate (Continue until all the parts of the formula have been evaluated) > Close.

Maddie entered customer first names in column A and last names in column B. What feature can she use to enter the full names in column C?

The buttons on the Design tab within the Switch Visualizations button group allows us to change the type of data visualization.

Which type of chart would show increases in the value of a stock fund in green, decreases in gray, and the initial and final values in red?

Which of the following formulas adds 25 and 10, and then multiplies the result by 50?

To retrieve a return value from a vertical lookup table, you use the VTABLE function.

Access 2019

Outlook 2019

Powerpoint 2019

Windows 10 - 2019

Word 2019

Computer History and Components

Filters