Question 1

Ursula wants to freeze the header row so that it remains visible while she scrolls down the worksheet. To do so, she can click the View tab and then click Freeze Top Row.

Accepted Answer

A) True 
 B)False

Question 2

What are you doing when you have Excel automatically translate each of your keystrokes and commands into program code?

Accepted Answer

A)  Running a macro 
B)  Editing Visual Basic code 
C)  Recording a macro 
D)  Inspecting the workbook 
A)  Running a macro 
B)  Editing Visual Basic code 
C)  Recording a macro 
D)  Inspecting the workbook

Question 3

In the Scenario Manager dialog box, the changing values are the cells that change in the worksheet to show the effect of the scenario.

Accepted Answer

A) True 
 B)False

Question 4

Flash Fill enters text based on patterns it finds in the data.

Accepted Answer

A) True 
 B)False

Question 5

Which of the following can you insert in a SmartArt shape?

Accepted Answer

A)  Picture 
B)  Chart 
C)  Worksheet 
D)  Trendline 
A)  Picture 
B)  Chart 
C)  Worksheet 
D)  Trendline

Question 6

When you wrap and center a range, you combine the cells into one cell.

Accepted Answer

A) True 
 B)False

Question 7

To which of the following locations can you move a PivotChart?

Accepted Answer

A)  New workbook 
B)  Worksheet in the current workbook 
C)  Worksheet in a different workbook 
D)  You cannot move a PivotChart. 
A)  New workbook 
B)  Worksheet in the current workbook 
C)  Worksheet in a different workbook 
D)  You cannot move a PivotChart.

Question 8

Which tab and button do you use to edit document properties ?

Accepted Answer

A)  File tab, Info Button 
B)  View tab, Show button 
C)  Review tab, Changes button 
D)  Home tab, Alignment button 
A)  File tab, Info Button 
B)  View tab, Show button 
C)  Review tab, Changes button 
D)  Home tab, Alignment button

Question 9

Stephanie added data validation to a worksheet column after entering a few records of data. Which Excel feature can she use to locate data that doesn't satisfy the data validation criteria?

Accepted Answer

A)  Tracer Arrows 
B)  Error Check 
C)  Watch Window 
D)  Circle Invalid Data 
A)  Tracer Arrows 
B)  Error Check 
C)  Watch Window 
D)  Circle Invalid Data

Question 10

What can you do when you have two levels of data in PivotTable rows?

Accepted Answer

A)  Add a calculated row to the PivotTable. 
B)  Use the Collapse and Expand buttons to drill down and up in the data. 
C)  Filter the PivotTable on two columns. 
D)  Create a 3-D PivotChart. 
A)  Add a calculated row to the PivotTable. 
B)  Use the Collapse and Expand buttons to drill down and up in the data. 
C)  Filter the PivotTable on two columns. 
D)  Create a 3-D PivotChart.

Question 11

When you change cell contents to italics, you are changing the cell's alignment.

Accepted Answer

A) True 
 B)False

Question 12

Which of the following is true about adding cell borders?

Accepted Answer

A)  A cell border changes the background color of the cell. 
B)  A cell border underlines the cell content. 
C)  You can add a border to the left, top, right, or bottom edge of a cell. 
D)  Borders are always single black lines. 
A)  A cell border changes the background color of the cell. 
B)  A cell border underlines the cell content. 
C)  You can add a border to the left, top, right, or bottom edge of a cell. 
D)  Borders are always single black lines.

Question 13

To apply a cell style, you would use the Cell Styles command on the _____ tab.

Accepted Answer

A)  Layout 
B)  Insert 
C)  View 
D)  Home 
A)  Layout 
B)  Insert 
C)  View 
D)  Home

Question 14

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 15

A _____ is a calculated named field in Power Pivot.

Accepted Answer

A)  measure 
B)  relationship 
C)  group 
D)  3D map 
A)  measure 
B)  relationship 
C)  group 
D)  3D map

Question 16

When creating a _____ in Power Pivot, you can combine fields from multiple tables in the data model.

Accepted Answer

A)  PivotTable 
B)  3D map 
C)  measure 
D)  PowerTable 
A)  PivotTable 
B)  3D map 
C)  measure 
D)  PowerTable

Question 17

Which of the following is a predefined procedure that returns a value?

Accepted Answer

A)  clipboard 
B)  mode indicator 
C)  named range 
D)  function 
A)  clipboard 
B)  mode indicator 
C)  named range 
D)  function

Question 18

After you define the scope for a named range, you can no longer edit the defined name.

Accepted Answer

A) True 
 B)False

Question 19

A(n) highlighting scale is a formatting scheme that uses colors to convey relative values of data, such as using red for cells with high values and green for cells with low values.

Accepted Answer

A) True 
 B)False

Question 20

Before you can unprotect a worksheet, you must enter the correct password.

Accepted Answer

A) True 
 B)False

Ursula wants to freeze the header row so that it remains visible while she scrolls down the worksheet. To do so, she can click the View tab and then click Freeze Top Row.

What are you doing when you have Excel automatically translate each of your keystrokes and commands into program code?

In the Scenario Manager dialog box, the changing values are the cells that change in the worksheet to show the effect of the scenario.

Flash Fill enters text based on patterns it finds in the data.

Which of the following can you insert in a SmartArt shape?

When you wrap and center a range, you combine the cells into one cell.

To which of the following locations can you move a PivotChart?

Which tab and button do you use to edit document properties ?

Stephanie added data validation to a worksheet column after entering a few records of data. Which Excel feature can she use to locate data that doesn't satisfy the data validation criteria?

What can you do when you have two levels of data in PivotTable rows?

When you change cell contents to italics, you are changing the cell's alignment.

Which of the following is true about adding cell borders?

To apply a cell style, you would use the Cell Styles command on the _____ tab.

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 _____ is a calculated named field in Power Pivot.

When creating a _____ in Power Pivot, you can combine fields from multiple tables in the data model.

Which of the following is a predefined procedure that returns a value?

After you define the scope for a named range, you can no longer edit the defined name.

A(n) highlighting scale is a formatting scheme that uses colors to convey relative values of data, such as using red for cells with high values and green for cells with low values.

Before you can unprotect a worksheet, you must enter the correct password.

Access-2019

Powerpoint-2019

Word-2019

Question Sets

Outlook-2019

Windows-10-2019

Filters

Exam 2: Excel-2019

Ursula wants to freeze the header row so that it remains visible while she scrolls down the worksheet. To do so, she can click the View tab and then click Freeze Top Row.

What are you doing when you have Excel automatically translate each of your keystrokes and commands into program code?

In the Scenario Manager dialog box, the changing values are the cells that change in the worksheet to show the effect of the scenario.

Flash Fill enters text based on patterns it finds in the data.

Which of the following can you insert in a SmartArt shape?

When you wrap and center a range, you combine the cells into one cell.

To which of the following locations can you move a PivotChart?

Which tab and button do you use to edit document properties ?

Stephanie added data validation to a worksheet column after entering a few records of data. Which Excel feature can she use to locate data that doesn't satisfy the data validation criteria?

What can you do when you have two levels of data in PivotTable rows?

When you change cell contents to italics, you are changing the cell's alignment.

Which of the following is true about adding cell borders?

To apply a cell style, you would use the Cell Styles command on the _____ tab.

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 _____ is a calculated named field in Power Pivot.

When creating a _____ in Power Pivot, you can combine fields from multiple tables in the data model.

Which of the following is a predefined procedure that returns a value?

After you define the scope for a named range, you can no longer edit the defined name.

A(n) highlighting scale is a formatting scheme that uses colors to convey relative values of data, such as using red for cells with high values and green for cells with low values.

Before you can unprotect a worksheet, you must enter the correct password.

Access-2019

Powerpoint-2019

Word-2019

Question Sets

Outlook-2019

Windows-10-2019

Filters