Question 1

A(n) _____ is a section of columns or rows that you can freeze and unfreeze.

Accepted Answer

A)  pan 
B)  window 
C)  view 
D)  outline 
A)  pan 
B)  window 
C)  view 
D)  outline

Question 2

Which of the following types of conditional formatting rules identifies a set of the highest or lowest values in a field or column?

Accepted Answer

A)  Icon Sets 
B)  Color Scales 
C)  Top/Bottom Rules 
D)  Highlight Cells Rules 
A)  Icon Sets 
B)  Color Scales 
C)  Top/Bottom Rules 
D)  Highlight Cells Rules

Question 3

After adding tables to the Data Model, where can you create a relationship between the tables?

Accepted Answer

A)  Power Pivot window 
B)  Connections pane 
C)  Query tab 
D)  Power View 
A)  Power Pivot window 
B)  Connections pane 
C)  Query tab 
D)  Power View

Question 4

When you copy cell contents, the data is removed from its original location and placed on the Clipboard.

Accepted Answer

A) True 
 B)False

Question 5

When you lock a cell, it is hidden in the worksheet.

Accepted Answer

A) True 
 B)False

Question 6

Which dialog box do you use to delete a macro?

Accepted Answer

A)  Macro dialog box 
B)  Visual Basic dialog box 
C)  Edit Macros dialog box 
D)  Manage Macros dialog box 
A)  Macro dialog box 
B)  Visual Basic dialog box 
C)  Edit Macros dialog box 
D)  Manage Macros dialog box

Question 7

Which of the following functions can you use to locate information in a table?

Accepted Answer

A)  MATCH 
B)  TEXT 
C)  LOCATE 
D)  LOOKUP 
A)  MATCH 
B)  TEXT 
C)  LOCATE 
D)  LOOKUP

Question 8

A sequence of VBA statements is called a procedure.

Accepted Answer

A) True 
 B)False

Question 9

If you change many formatting options such as theme colors, cell styles, and fonts, how can you preserve the settings for use in another workbook?

Accepted Answer

A)  Create a new cell style. 
B)  Create a custom theme color. 
C)  Create custom theme fonts. 
D)  Save the settings as a custom theme. 
A)  Create a new cell style. 
B)  Create a custom theme color. 
C)  Create custom theme fonts. 
D)  Save the settings as a custom theme.

Question 10

Charlie imported data that displays "Albany, NY" in cell A24. What formula can he use to display "NY" in cell D3?

Accepted Answer

A)  =LEFT(A24, 2) 
B)  =RIGHT(A24, 2) 
C)  =LOWER(A24) 
D)  =EXTRACT(A24, 2) 
A)  =LEFT(A24, 2) 
B)  =RIGHT(A24, 2) 
C)  =LOWER(A24) 
D)  =EXTRACT(A24, 2)

Question 11

To go to a previous comment, use the Previous Comment button in the Comments group on the Review tab.

Accepted Answer

A) True 
 B)False

Question 12

Han has four workbooks open, with one maximized on the desktop. Which button can he click on the View tab to display a different workbook?

Accepted Answer

A)  Synchronous Scrolling 
B)  Switch Windows 
C)  Open New 
D)  Unhide 
A)  Synchronous Scrolling 
B)  Switch Windows 
C)  Open New 
D)  Unhide

Question 13

After Solver finds a solution, you can generate a(n) _____ summarizing the target cells, adjustable cells, and constraints.

Accepted Answer

A)  Analysis ToolPak 
B)  Solver PivotTable 
C)  Answer Report 
D)  Scenario Summary report 
A)  Analysis ToolPak 
B)  Solver PivotTable 
C)  Answer Report 
D)  Scenario Summary report

Question 14

Chen has a worksheet with a City column listing five cities and an Order ID column listing unique IDs for product orders. He wants to count the number of orders from Charlotte. Which of the following functions should he use?

Accepted Answer

A)  SUMIF 
B)  AVERAGEIF 
C)  COUNTIF 
D)  IF 
A)  SUMIF 
B)  AVERAGEIF 
C)  COUNTIF 
D)  IF

Question 15

To change the background color of a cell, you use the Background color button.

Accepted Answer

A) True 
 B)False

Question 16

The column labels you add to a PivotTable appear as legend fields in the corresponding PivotChart.

Accepted Answer

A) True 
 B)False

Question 17

When you insert a worksheet row, a row is inserted above the cell pointer and the sheet contents move downward.

Accepted Answer

A) True 
 B)False

Question 18

What can you do to share a workbook with other Office 365 users only?

Accepted Answer

A)  Post the workbook on your website. 
B)  Email the name of the workbook to other users. 
C)  Encrypt the workbook. 
D)  Upload the workbook to OneDrive. 
A)  Post the workbook on your website. 
B)  Email the name of the workbook to other users. 
C)  Encrypt the workbook. 
D)  Upload the workbook to OneDrive.

Question 19

Haley needs to delete an out-of-date column in a table. How can she do so?

Accepted Answer

A)  Click the worksheet column heading and then press DEL 
B)  Right-click the table column and then click Delete. 
C)  lick the Delete arrow in the Cells group and then click Delete Field. 
D)  Click the Remove Old button in the Tools group. 
A)  Click the worksheet column heading and then press DEL 
B)  Right-click the table column and then click Delete. 
C)  lick the Delete arrow in the Cells group and then click Delete Field. 
D)  Click the Remove Old button in the Tools group.

Question 20

You can set a scaling option to resize a worksheet to fit within a single page.

Accepted Answer

A) True 
 B)False

A(n) _____ is a section of columns or rows that you can freeze and unfreeze.

Which of the following types of conditional formatting rules identifies a set of the highest or lowest values in a field or column?

After adding tables to the Data Model, where can you create a relationship between the tables?

When you copy cell contents, the data is removed from its original location and placed on the Clipboard.

When you lock a cell, it is hidden in the worksheet.

Which dialog box do you use to delete a macro?

Which of the following functions can you use to locate information in a table?

A sequence of VBA statements is called a procedure.

If you change many formatting options such as theme colors, cell styles, and fonts, how can you preserve the settings for use in another workbook?

Charlie imported data that displays "Albany, NY" in cell A24. What formula can he use to display "NY" in cell D3?

To go to a previous comment, use the Previous Comment button in the Comments group on the Review tab.

Han has four workbooks open, with one maximized on the desktop. Which button can he click on the View tab to display a different workbook?

After Solver finds a solution, you can generate a(n) _____ summarizing the target cells, adjustable cells, and constraints.

Chen has a worksheet with a City column listing five cities and an Order ID column listing unique IDs for product orders. He wants to count the number of orders from Charlotte. Which of the following functions should he use?

To change the background color of a cell, you use the Background color button.

The column labels you add to a PivotTable appear as legend fields in the corresponding PivotChart.

When you insert a worksheet row, a row is inserted above the cell pointer and the sheet contents move downward.

What can you do to share a workbook with other Office 365 users only?

Haley needs to delete an out-of-date column in a table. How can she do so?

You can set a scaling option to resize a worksheet to fit within a single page.

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

A(n) _____ is a section of columns or rows that you can freeze and unfreeze.

Which of the following types of conditional formatting rules identifies a set of the highest or lowest values in a field or column?

After adding tables to the Data Model, where can you create a relationship between the tables?

When you copy cell contents, the data is removed from its original location and placed on the Clipboard.

When you lock a cell, it is hidden in the worksheet.

Which dialog box do you use to delete a macro?

Which of the following functions can you use to locate information in a table?

A sequence of VBA statements is called a procedure.

If you change many formatting options such as theme colors, cell styles, and fonts, how can you preserve the settings for use in another workbook?

Charlie imported data that displays "Albany, NY" in cell A24. What formula can he use to display "NY" in cell D3?

To go to a previous comment, use the Previous Comment button in the Comments group on the Review tab.

Han has four workbooks open, with one maximized on the desktop. Which button can he click on the View tab to display a different workbook?

After Solver finds a solution, you can generate a(n) _____ summarizing the target cells, adjustable cells, and constraints.

Chen has a worksheet with a City column listing five cities and an Order ID column listing unique IDs for product orders. He wants to count the number of orders from Charlotte. Which of the following functions should he use?

To change the background color of a cell, you use the Background color button.

The column labels you add to a PivotTable appear as legend fields in the corresponding PivotChart.

When you insert a worksheet row, a row is inserted above the cell pointer and the sheet contents move downward.

What can you do to share a workbook with other Office 365 users only?

Haley needs to delete an out-of-date column in a table. How can she do so?

You can set a scaling option to resize a worksheet to fit within a single page.

Access 2019

Powerpoint 2019

Word 2019

Outlook 2019

Windows 10 2019

Technology and IT: From CAM to IoT and Digital Citizenship

Filters