Question 1

How can you align all objects to the upper-left corner of a cell?

Accepted Answer

A)  Click the arrow next to Align on the Drawing Tools Format tab and then click Snap to Grid. 
B)  Click the arrow next to Align on the Drawing Tools Format tab and then click Snap to Shape. 
C)  Click the Drawing Tools Format tab, then click the arrow next to Align, and then click Align Top. 
D)  Click the Drawing Tools Format tab, then click the arrow next to Align, and then click Align Bottom. 
A)  Click the arrow next to Align on the Drawing Tools Format tab and then click Snap to Grid. 
B)  Click the arrow next to Align on the Drawing Tools Format tab and then click Snap to Shape. 
C)  Click the Drawing Tools Format tab, then click the arrow next to Align, and then click Align Top. 
D)  Click the Drawing Tools Format tab, then click the arrow next to Align, and then click Align Bottom. A

Question 2

Horatio wants to hide field headers in a PivotTable. He clicks the PivotTable, then clicks the PivotTable Tools Analyze tab on the ribbon. What should he do next to complete the procedure?

Accepted Answer

A)  Click Clear in the Actions group. 
B)  Click +/- Buttons in the Show group. 
C)  Click Field Headers in the Show group. 
D)  Click Fields, Items & Sets in the Calculations group. 
A)  Click Clear in the Actions group. 
B)  Click +/- Buttons in the Show group. 
C)  Click Field Headers in the Show group. 
D)  Click Fields, Items & Sets in the Calculations group. C

Question 3

Warren has a table that applies fill formatting to every other column, which he finds distracting. How can he remove this formatting?

Accepted Answer

A)  Turn off banded columns. 
B)  Turn on banded rows. 
C)  Remove the filter buttons. 
D)  Add a Total column. 
A)  Turn off banded columns. 
B)  Turn on banded rows. 
C)  Remove the filter buttons. 
D)  Add a Total column. A

Question 4

Esperanza wants to save a series of commands she performs often. Which of the following should she do?

Accepted Answer

A)  Create a protected commands worksheet. 
B)  Turn on automatic calculations. 
C)  Run a procedure. 
D)  Record a macro. 
A)  Create a protected commands worksheet. 
B)  Turn on automatic calculations. 
C)  Run a procedure. 
D)  Record a macro.

Question 5

When you enter a value in a worksheet cell, it is automatically left-aligned.

Accepted Answer

A) True 
 B)False

Question 6

Jason wants to display the text "Poor" if the value in cell A3 is less than 25. If the value in cell A3 is less than 50, Jason wants to display "Average"; otherwise, he wants to display "Good". Which of the following formulas should he use?

Accepted Answer

A)  '=IF(A3 
B)  =IF(A3 
C)  IF(A3 > 50, "Good", =IF(A3 
A)  '=IF(A3 
B)  =IF(A3 
C)  IF(A3 > 50, "Good", =IF(A3

Question 7

You can set only one language as the editing language in Excel.

Accepted Answer

A) True 
 B)False

Question 8

You can import text data into Excel and save the imported data in Excel format.

Accepted Answer

A) True 
 B)False

Question 9

Nathan has recorded a few macros in a workbook and now wants to run one of them. Which dialog box should he open to select a macro and then run it?

Accepted Answer

A)  Macro dialog box 
B)  Run dialog box 
C)  This Workbook dialog box 
D)  Macro Security dialog box 
A)  Macro dialog box 
B)  Run dialog box 
C)  This Workbook dialog box 
D)  Macro Security dialog box

Question 10

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 11

When you click the Show Comments button to display all comments, they appear in the Comments pane.

Accepted Answer

A) True 
 B)False

Question 12

Which of the following Excel features applies a design using theme colors to a table?

Accepted Answer

A)  table style 
B)  cell style 
C)  font style 
D)  number format 
A)  table style 
B)  cell style 
C)  font style 
D)  number format

Question 13

Arlo creates a rectangle on a worksheet, right-clicks the shape, and then clicks _____ on the shortcut menu so he can use the shape to run a macro.

Accepted Answer

A)  Assign Macro 
B)  Run Macro 
C)  Set as Macro 
D)  View Macros 
A)  Assign Macro 
B)  Run Macro 
C)  Set as Macro 
D)  View Macros

Question 14

To analyze the results of scenarios, you can create a(n) _____.

Accepted Answer

A)  Scenario Management chart 
B)  Scenario Overview 
C)  Scenario PivotTable 
D)  Answer report 
A)  Scenario Management chart 
B)  Scenario Overview 
C)  Scenario PivotTable 
D)  Answer report

Question 15

What happens when you drag a corner handle on SmartArt?

Accepted Answer

A)  You move the SmartArt. 
B)  You resize the SmartArt proportionally. 
C)  You resize the SmartArt nonproportionally. 
D)  You open the Text pane. 
A)  You move the SmartArt. 
B)  You resize the SmartArt proportionally. 
C)  You resize the SmartArt nonproportionally. 
D)  You open the Text pane.

Question 16

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

Accepted Answer

A) True 
 B)False

Question 17

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 18

Cell A4 contains the time 10:27 pm. To round that time to the nearest 30-minute interval, use the formula =MROUND(A4,0:30).

Accepted Answer

A) True 
 B)False

Question 19

As you edit a worksheet, you can open the Watch window to watch the effect that cell changes have on selected worksheet formulas.

Accepted Answer

A) True 
 B)False

Question 20

Where can you create a relationship between two Excel tables?

Accepted Answer

A)  Power Pivot 
B)  Power View 
C)  Get & Transform window 
D)  Solver 
A)  Power Pivot 
B)  Power View 
C)  Get & Transform window 
D)  Solver

How can you align all objects to the upper-left corner of a cell?

Horatio wants to hide field headers in a PivotTable. He clicks the PivotTable, then clicks the PivotTable Tools Analyze tab on the ribbon. What should he do next to complete the procedure?

Warren has a table that applies fill formatting to every other column, which he finds distracting. How can he remove this formatting?

Esperanza wants to save a series of commands she performs often. Which of the following should she do?

When you enter a value in a worksheet cell, it is automatically left-aligned.

Jason wants to display the text "Poor" if the value in cell A3 is less than 25. If the value in cell A3 is less than 50, Jason wants to display "Average"; otherwise, he wants to display "Good". Which of the following formulas should he use?

You can set only one language as the editing language in Excel.

You can import text data into Excel and save the imported data in Excel format.

Nathan has recorded a few macros in a workbook and now wants to run one of them. Which dialog box should he open to select a macro and then run it?

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?

When you click the Show Comments button to display all comments, they appear in the Comments pane.

Which of the following Excel features applies a design using theme colors to a table?

Arlo creates a rectangle on a worksheet, right-clicks the shape, and then clicks _____ on the shortcut menu so he can use the shape to run a macro.

To analyze the results of scenarios, you can create a(n) _____.

What happens when you drag a corner handle on SmartArt?

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.

Cell A4 contains the time 10:27 pm. To round that time to the nearest 30-minute interval, use the formula =MROUND(A4,0:30).

As you edit a worksheet, you can open the Watch window to watch the effect that cell changes have on selected worksheet formulas.

Where can you create a relationship between two Excel tables?

Access 2019

Powerpoint 2019

Word 2019

Outlook 2019

Windows 10 2019

Technology and IT: From CAM to IoT and Digital Citizenship

Filters

Exam 2: Excel 2019

How can you align all objects to the upper-left corner of a cell?

Horatio wants to hide field headers in a PivotTable. He clicks the PivotTable, then clicks the PivotTable Tools Analyze tab on the ribbon. What should he do next to complete the procedure?

Warren has a table that applies fill formatting to every other column, which he finds distracting. How can he remove this formatting?

Esperanza wants to save a series of commands she performs often. Which of the following should she do?

When you enter a value in a worksheet cell, it is automatically left-aligned.

Jason wants to display the text "Poor" if the value in cell A3 is less than 25. If the value in cell A3 is less than 50, Jason wants to display "Average"; otherwise, he wants to display "Good". Which of the following formulas should he use?

You can set only one language as the editing language in Excel.

You can import text data into Excel and save the imported data in Excel format.

Nathan has recorded a few macros in a workbook and now wants to run one of them. Which dialog box should he open to select a macro and then run it?

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?

When you click the Show Comments button to display all comments, they appear in the Comments pane.

Which of the following Excel features applies a design using theme colors to a table?

Arlo creates a rectangle on a worksheet, right-clicks the shape, and then clicks _____ on the shortcut menu so he can use the shape to run a macro.

To analyze the results of scenarios, you can create a(n) _____.

What happens when you drag a corner handle on SmartArt?

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.

Cell A4 contains the time 10:27 pm. To round that time to the nearest 30-minute interval, use the formula =MROUND(A4,0:30).

As you edit a worksheet, you can open the Watch window to watch the effect that cell changes have on selected worksheet formulas.

Where can you create a relationship between two Excel tables?

Access 2019

Powerpoint 2019

Word 2019

Outlook 2019

Windows 10 2019

Technology and IT: From CAM to IoT and Digital Citizenship

Filters