Question 1

If you want to combine data from multiple worksheets and display the results on another worksheet, you can summarize the data.

Accepted Answer

A) True 
 B)False

Question 2

When you move a chart to a new worksheet, you must also move the data source.

Accepted Answer

A) True 
 B)False

Question 3

Julio wants to analyze the best, most likely, and worst outcomes for changing expense values. He should create three scenarios.

Accepted Answer

A) True 
 B)False

Question 4

Which of the following chart elements identifies the purpose of a chart?

Accepted Answer

A)  Legend 
B)  Gridlines 
C)  Vertical axis 
D)  Chart title 
A)  Legend 
B)  Gridlines 
C)  Vertical axis 
D)  Chart title

Question 5

If cell A5 displays a time in hours, minutes, and seconds, which of the following functions can you use to display the time as a serial number?

Accepted Answer

A)  HOUR 
B)  TIME 
C)  SERIAL 
D)  NOW 
A)  HOUR 
B)  TIME 
C)  SERIAL 
D)  NOW

Question 6

The WORKDAY function calculates the day of the week starting from a specified date.

Accepted Answer

A) True 
 B)False

Question 7

Nathan wants a formula to return "Yes" if the value in cell A1 is less than the value in cell B1, and to return "No" otherwise. Which of the following functions should he use?

Accepted Answer

A)  AND 
B)  IF 
C)  NOT 
D)  ROUND 
A)  AND 
B)  IF 
C)  NOT 
D)  ROUND

Question 8

You can change a table back to a range by clicking the Change to Range button on the Table Tools Design tab.

Accepted Answer

A) True 
 B)False

Question 9

Cora inserted a Check Box control in a worksheet. She wants to display the text TRUE in cell B17 when the control contains a checkmark. What property should she set?

Accepted Answer

A)  Caption 
B)  Cell link 
C)  Macro name 
D)  Run action 
A)  Caption 
B)  Cell link 
C)  Macro name 
D)  Run action

Question 10

How can you create a single PivotTable to analyze data from two tables?

Accepted Answer

A)  Create the PivotTable using Power Pivot. 
B)  Use the same name for each table. 
C)  Create a measure to link the tables. 
D)  Group the tables. 
A)  Create the PivotTable using Power Pivot. 
B)  Use the same name for each table. 
C)  Create a measure to link the tables. 
D)  Group the tables.

Question 11

You can use the Auto Outline feature to group worksheet data into an outline.

Accepted Answer

A) True 
 B)False

Question 12

Text files you can import into Excel use a(n) _____, a separator such as a space or comma between columns of data.

Accepted Answer

A)  delimiter 
B)  outline 
C)  column break 
D)  specifier 
A)  delimiter 
B)  outline 
C)  column break 
D)  specifier

Question 13

What does the third argument (3) refer to in the following formula: VLOOKUP(10005, A1:C6, 3, FALSE)

Accepted Answer

A)  number of the column containing the return value 
B)  location of the lookup table 
C)  whether to return a value only when an exact match is found 
D)  cell with the lookup value 
A)  number of the column containing the return value 
B)  location of the lookup table 
C)  whether to return a value only when an exact match is found 
D)  cell with the lookup value

Question 14

The score of a student in two subjects are inserted in B2 and C2 cell and the passing score for each subject is 60. which of these functions will you insert in D2 cell to get FALSE as the result if the student has passed and TRUE as the result if the student has failed?

Accepted Answer

A)  =IF(B2>=60, C2>=60) 
B)  =NOT(OR(B2>=60, C2>=60)) 
C)  =OR(B2>=60, "Pass", "Fail") 
D)  =AND(B2>=60, "Pass", "Fail") 
A)  =IF(B2>=60, C2>=60) 
B)  =NOT(OR(B2>=60, C2>=60)) 
C)  =OR(B2>=60, "Pass", "Fail") 
D)  =AND(B2>=60, "Pass", "Fail")

Question 15

A _____ is a calculated named field in Power Pivot that uses data analysis expressions.

Accepted Answer

A)  3-D map 
B)  Power field 
C)  measure 
D)  layer 
A)  3-D map 
B)  Power field 
C)  measure 
D)  layer

Question 16

In the formula =SUM(A6:A9), which of the following best describes A6:A9?

Accepted Answer

A)  argument 
B)  function 
C)  label 
D)  active cell 
A)  argument 
B)  function 
C)  label 
D)  active cell

Question 17

Lydia entered row titles in the range A1:A10 and listed data next to it in the range B1:B10. Which Excel feature can she use to apply the text in the range A1:10 as defined names for the cells in the range B1:B10?

Accepted Answer

A)  CONCAT function 
B)  Create from Selection 
C)  custom AutoFill list 
D)  Name Manager 
A)  CONCAT function 
B)  Create from Selection 
C)  custom AutoFill list 
D)  Name Manager

Question 18

To move cell contents one space to the right, you can use the Increase Space button.

Accepted Answer

A) True 
 B)False

Question 19

Jack wants to show sparklines with symbols for positive and negative values in a range. He should insert Win/Loss sparklines.

Accepted Answer

A) True 
 B)False

Question 20

The SUMIF function totals only the cells in a range that meet given criteria.

Accepted Answer

A) True 
 B)False

If you want to combine data from multiple worksheets and display the results on another worksheet, you can summarize the data.

When you move a chart to a new worksheet, you must also move the data source.

Julio wants to analyze the best, most likely, and worst outcomes for changing expense values. He should create three scenarios.

Which of the following chart elements identifies the purpose of a chart?

If cell A5 displays a time in hours, minutes, and seconds, which of the following functions can you use to display the time as a serial number?

The WORKDAY function calculates the day of the week starting from a specified date.

Nathan wants a formula to return "Yes" if the value in cell A1 is less than the value in cell B1, and to return "No" otherwise. Which of the following functions should he use?

You can change a table back to a range by clicking the Change to Range button on the Table Tools Design tab.

Cora inserted a Check Box control in a worksheet. She wants to display the text TRUE in cell B17 when the control contains a checkmark. What property should she set?

How can you create a single PivotTable to analyze data from two tables?

You can use the Auto Outline feature to group worksheet data into an outline.

Text files you can import into Excel use a(n) _____, a separator such as a space or comma between columns of data.

What does the third argument (3) refer to in the following formula: VLOOKUP(10005, A1:C6, 3, FALSE)

The score of a student in two subjects are inserted in B2 and C2 cell and the passing score for each subject is 60. which of these functions will you insert in D2 cell to get FALSE as the result if the student has passed and TRUE as the result if the student has failed?

A _____ is a calculated named field in Power Pivot that uses data analysis expressions.

In the formula =SUM(A6:A9), which of the following best describes A6:A9?

Lydia entered row titles in the range A1:A10 and listed data next to it in the range B1:B10. Which Excel feature can she use to apply the text in the range A1:10 as defined names for the cells in the range B1:B10?

To move cell contents one space to the right, you can use the Increase Space button.

Jack wants to show sparklines with symbols for positive and negative values in a range. He should insert Win/Loss sparklines.

The SUMIF function totals only the cells in a range that meet given criteria.

Access-2019

Powerpoint-2019

Word-2019

Question Sets

Outlook-2019

Windows-10-2019

Filters

Exam 2: Excel-2019

If you want to combine data from multiple worksheets and display the results on another worksheet, you can summarize the data.

When you move a chart to a new worksheet, you must also move the data source.

Julio wants to analyze the best, most likely, and worst outcomes for changing expense values. He should create three scenarios.

Which of the following chart elements identifies the purpose of a chart?

If cell A5 displays a time in hours, minutes, and seconds, which of the following functions can you use to display the time as a serial number?

The WORKDAY function calculates the day of the week starting from a specified date.

Nathan wants a formula to return "Yes" if the value in cell A1 is less than the value in cell B1, and to return "No" otherwise. Which of the following functions should he use?

You can change a table back to a range by clicking the Change to Range button on the Table Tools Design tab.

Cora inserted a Check Box control in a worksheet. She wants to display the text TRUE in cell B17 when the control contains a checkmark. What property should she set?

How can you create a single PivotTable to analyze data from two tables?

You can use the Auto Outline feature to group worksheet data into an outline.

Text files you can import into Excel use a(n) _____, a separator such as a space or comma between columns of data.

What does the third argument (3) refer to in the following formula: VLOOKUP(10005, A1:C6, 3, FALSE)

The score of a student in two subjects are inserted in B2 and C2 cell and the passing score for each subject is 60. which of these functions will you insert in D2 cell to get FALSE as the result if the student has passed and TRUE as the result if the student has failed?

A _____ is a calculated named field in Power Pivot that uses data analysis expressions.

In the formula =SUM(A6:A9), which of the following best describes A6:A9?

Lydia entered row titles in the range A1:A10 and listed data next to it in the range B1:B10. Which Excel feature can she use to apply the text in the range A1:10 as defined names for the cells in the range B1:B10?

To move cell contents one space to the right, you can use the Increase Space button.

Jack wants to show sparklines with symbols for positive and negative values in a range. He should insert Win/Loss sparklines.

The SUMIF function totals only the cells in a range that meet given criteria.

Access-2019

Powerpoint-2019

Word-2019

Question Sets

Outlook-2019

Windows-10-2019

Filters