Question 1

What must you change to customize the background color of a Command Button (ActiveX Control)?

Accepted Answer

A)  Background property 
B)  Control property 
C)  Font property 
D)  BackColor property 
A)  Background property 
B)  Control property 
C)  Font property 
D)  BackColor property

Question 2

The Table Styles gallery includes an option for creating a custom table style.

Accepted Answer

A) True 
 B)False

Question 3

To open the Power Pivot window from the workbook, click the View tab, then click the Data Tools button.

Accepted Answer

A) True 
 B)False

Question 4

To paste a data range so that column data appears in rows and row data appears in columns, you can _____ the data using the Paste list arrow.

Accepted Answer

A)  reverse 
B)  transpose 
C)  fill 
D)  merge 
A)  reverse 
B)  transpose 
C)  fill 
D)  merge

Question 5

When you name a range, you can also define its _____, the location in a worksheet where the named range is recognized.

Accepted Answer

A)  extent 
B)  scope 
C)  limitations 
D)  properties 
A)  extent 
B)  scope 
C)  limitations 
D)  properties

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

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 8

Use the Application Checker feature to check for formats that could prevent people with disabilities from interacting with data or Excel.

Accepted Answer

A) True 
 B)False

Question 9

In cell B4, Marcia inserted the formula = (B1+B2)/B3. To display a message if the result of the formula is an error, she can add the SUMIFS function to the formula in cell B4.

Accepted Answer

A) True 
 B)False

Question 10

To clear all the comments from a workbook, you must delete them one at a time.

Accepted Answer

A) True 
 B)False

Question 11

What happens if you select the City and Product Type check boxes in the Insert Slicers dialog box?

Accepted Answer

A)  You add the City and Product Type buttons to a slicer. 
B)  You add the City and Product Type slicers to the worksheet. 
C)  You filter the PivotTable on the City and Product Type fields. 
D)  You add the City and Product Type fields to the PivotTable. 
A)  You add the City and Product Type buttons to a slicer. 
B)  You add the City and Product Type slicers to the worksheet. 
C)  You filter the PivotTable on the City and Product Type fields. 
D)  You add the City and Product Type fields to the PivotTable.

Question 12

Which of the following boxes will you check after clicking on a table and then selecting Table Tools > Design, to add a total row to a table?

Accepted Answer

A)  Total Row 
B)  Header Row 
C)  Footer Row 
D)  Footer Row. 
A)  Total Row 
B)  Header Row 
C)  Footer Row 
D)  Footer Row.

Question 13

To insert only the current date in cell B1, use the NOW function in cell B1 .

Accepted Answer

A) True 
 B)False

Question 14

Calista wants to provide additional information about a hyperlink she is creating. Which of the following can she do?

Accepted Answer

A)  Add a description. 
B)  Add a ScreenTip. 
C)  Change the Link to location. 
D)  Add a HyperTip. 
A)  Add a description. 
B)  Add a ScreenTip. 
C)  Change the Link to location. 
D)  Add a HyperTip.

Question 15

A sequence of VBA statements is called a procedure.

Accepted Answer

A) True 
 B)False

Question 16

Which of the following functions inserts the total of a range?

Accepted Answer

A)  ROUND 
B)  AUTOSUM 
C)  AVERAGE 
D)  SUM 
A)  ROUND 
B)  AUTOSUM 
C)  AVERAGE 
D)  SUM

Question 17

The _____ number format adds dollar signs and two decimal places to numeric data.

Accepted Answer

A)  Data 
B)  Accounting 
C)  Percentage 
D)  General 
A)  Data 
B)  Accounting 
C)  Percentage 
D)  General

Question 18

Amari formatted a picture using effects, styles, and a border. What tool can she use to copy the formatting from this picture to another one?

Accepted Answer

A)  Artistic Effects 
B)  Corrections 
C)  Format Painter 
D)  Format Duplicator 
A)  Artistic Effects 
B)  Corrections 
C)  Format Painter 
D)  Format Duplicator

Question 19

After you link a Word document to an Excel worksheet, the Word content becomes part of the workbook and you can no longer update it.

Accepted Answer

A) True 
 B)False

Question 20

Cell A5 contains the number 24.7835. In another cell, Ariane wants to enter the number from cell A5 but rounded to two decimal places. Which of these formulas can she use to do so?

Accepted Answer

A)  =ROUND(A5,2) 
B)  =MROUND(A5,2) 
C)  =ROUND(A5,2.0) 
D)  =MROUND(A5,0.2) 
A)  =ROUND(A5,2) 
B)  =MROUND(A5,2) 
C)  =ROUND(A5,2.0) 
D)  =MROUND(A5,0.2)

What must you change to customize the background color of a Command Button (ActiveX Control)?

The Table Styles gallery includes an option for creating a custom table style.

To open the Power Pivot window from the workbook, click the View tab, then click the Data Tools button.

To paste a data range so that column data appears in rows and row data appears in columns, you can _____ the data using the Paste list arrow.

When you name a range, you can also define its _____, the location in a worksheet where the named range is recognized.

Which dialog box do you use to delete a macro?

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?

Use the Application Checker feature to check for formats that could prevent people with disabilities from interacting with data or Excel.

In cell B4, Marcia inserted the formula = (B1+B2)/B3. To display a message if the result of the formula is an error, she can add the SUMIFS function to the formula in cell B4.

To clear all the comments from a workbook, you must delete them one at a time.

What happens if you select the City and Product Type check boxes in the Insert Slicers dialog box?

Which of the following boxes will you check after clicking on a table and then selecting Table Tools > Design, to add a total row to a table?

To insert only the current date in cell B1, use the NOW function in cell B1 .

Calista wants to provide additional information about a hyperlink she is creating. Which of the following can she do?

A sequence of VBA statements is called a procedure.

Which of the following functions inserts the total of a range?

The _____ number format adds dollar signs and two decimal places to numeric data.

Amari formatted a picture using effects, styles, and a border. What tool can she use to copy the formatting from this picture to another one?

After you link a Word document to an Excel worksheet, the Word content becomes part of the workbook and you can no longer update it.

Cell A5 contains the number 24.7835. In another cell, Ariane wants to enter the number from cell A5 but rounded to two decimal places. Which of these formulas can she use to do so?

Access-2019

Powerpoint-2019

Word-2019

Question Sets

Outlook-2019

Windows-10-2019

Filters

Exam 2: Excel-2019

What must you change to customize the background color of a Command Button (ActiveX Control)?

The Table Styles gallery includes an option for creating a custom table style.

To open the Power Pivot window from the workbook, click the View tab, then click the Data Tools button.

To paste a data range so that column data appears in rows and row data appears in columns, you can _____ the data using the Paste list arrow.

When you name a range, you can also define its _____, the location in a worksheet where the named range is recognized.

Which dialog box do you use to delete a macro?

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?

Use the Application Checker feature to check for formats that could prevent people with disabilities from interacting with data or Excel.

In cell B4, Marcia inserted the formula = (B1+B2)/B3. To display a message if the result of the formula is an error, she can add the SUMIFS function to the formula in cell B4.

To clear all the comments from a workbook, you must delete them one at a time.

What happens if you select the City and Product Type check boxes in the Insert Slicers dialog box?

Which of the following boxes will you check after clicking on a table and then selecting Table Tools > Design, to add a total row to a table?

To insert only the current date in cell B1, use the NOW function in cell B1 .

Calista wants to provide additional information about a hyperlink she is creating. Which of the following can she do?

A sequence of VBA statements is called a procedure.

Which of the following functions inserts the total of a range?

The _____ number format adds dollar signs and two decimal places to numeric data.

Amari formatted a picture using effects, styles, and a border. What tool can she use to copy the formatting from this picture to another one?

After you link a Word document to an Excel worksheet, the Word content becomes part of the workbook and you can no longer update it.

Cell A5 contains the number 24.7835. In another cell, Ariane wants to enter the number from cell A5 but rounded to two decimal places. Which of these formulas can she use to do so?

Access-2019

Powerpoint-2019

Word-2019

Question Sets

Outlook-2019

Windows-10-2019

Filters