Question 1

When you copy and paste a formula to a new location, the formula's relative references do not change.

Accepted Answer

A) True 
 B)False

Question 2

When you enter a formula such as =SUM('Chicago:San Francisco'!A6), which references cell A6 on four worksheets from the Chicago worksheet to the San Francisco worksheet, what type of reference are you using?

Accepted Answer

A)  structured reference 
B)  absolute reference 
C)  3-D reference 
D)  mixed reference 
A)  structured reference 
B)  absolute reference 
C)  3-D reference 
D)  mixed reference

Question 3

Which of the following is not true about setting column width?

Accepted Answer

A)  The column width measurement is based on characters. 
B)  The default column width is 8.43. 
C)  You can change the width of only one column at a time. 
D)  You can use the Format button in the Cells group to set an exact column width. 
A)  The column width measurement is based on characters. 
B)  The default column width is 8.43. 
C)  You can change the width of only one column at a time. 
D)  You can use the Format button in the Cells group to set an exact column width.

Question 4

You can create conditional cell formats using either the Home tab or the _____.

Accepted Answer

A)  Quick Analysis tool 
B)  Cell Styles dialog box 
C)  Font formatting buttons on the Home tab 
D)  Number formatting buttons on the Home tab 
A)  Quick Analysis tool 
B)  Cell Styles dialog box 
C)  Font formatting buttons on the Home tab 
D)  Number formatting buttons on the Home tab

Question 5

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 6

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 7

To customize the status bar, right-click the status bar, then click the options you want to show or hide .

Accepted Answer

A) True 
 B)False

Question 8

Which of the following properties can you change for a Command Button (ActiveX Control)?

Accepted Answer

A)  Code 
B)  Shape 
C)  Font 
D)  Layout 
A)  Code 
B)  Shape 
C)  Font 
D)  Layout

Question 9

To rotate cell contents, you use the Orientation button in the Alignment group on the Home tab.

Accepted Answer

A) True 
 B)False

Question 10

The default worksheet text is _____-point Calibri.

Accepted Answer

A)  10 
B)  11 
C)  12 
D)  14 
A)  10 
B)  11 
C)  12 
D)  14

Question 11

When you want to know the position of an item in a range, you can use the LOOKUP function.

Accepted Answer

A) True 
 B)False

Question 12

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

Accepted Answer

A) True 
 B)False

Question 13

You can import a text file that uses a divider such as a space, comma, or semicolon between columns of data.

Accepted Answer

A) True 
 B)False

Question 14

You can click the Collapse button to drill up into a PivotTable.

Accepted Answer

A) True 
 B)False

Question 15

To perform an action based on whether an option button control is selected, you assign a macro to the form control.

Accepted Answer

A) True 
 B)False

Question 16

In one workbook, Tim wants to include a link to another workbook. Which of the following dialog boxes should he use to add the link?

Accepted Answer

A)  Style dialog box 
B)  Insert Text dialog box 
C)  ScreenTip Text box 
D)  Insert Hyperlink dialog box 
A)  Style dialog box 
B)  Insert Text dialog box 
C)  ScreenTip Text box 
D)  Insert Hyperlink dialog box

Question 17

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 18

When you want to know the position of an item in a range, you can use the _____ function.

Accepted Answer

A)  HLOOKUP 
B)  MATCH 
C)  ROW 
D)  TABLE 
A)  HLOOKUP 
B)  MATCH 
C)  ROW 
D)  TABLE

Question 19

The formula =ROUNDUP(G5,0) can be used to round up 59.425, entered in cell G5, to 60

Accepted Answer

A) True 
 B)False

Question 20

Cell D1 contains the text "Office Locations." Min wants to convert the text to "OFFICE LOCATIONS." Which of the following formulas should he use?

Accepted Answer

A)  =LOWER(D1) 
B)  =PROPER(D1) 
C)  =UPPER(D1) 
D)  =CONCAT(D1) 
A)  =LOWER(D1) 
B)  =PROPER(D1) 
C)  =UPPER(D1) 
D)  =CONCAT(D1)

When you copy and paste a formula to a new location, the formula's relative references do not change.

When you enter a formula such as =SUM('Chicago:San Francisco'!A6), which references cell A6 on four worksheets from the Chicago worksheet to the San Francisco worksheet, what type of reference are you using?

Which of the following is not true about setting column width?

You can create conditional cell formats using either the Home tab or the _____.

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?

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 customize the status bar, right-click the status bar, then click the options you want to show or hide .

Which of the following properties can you change for a Command Button (ActiveX Control)?

To rotate cell contents, you use the Orientation button in the Alignment group on the Home tab.

The default worksheet text is _____-point Calibri.

When you want to know the position of an item in a range, you can use the LOOKUP function.

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

You can import a text file that uses a divider such as a space, comma, or semicolon between columns of data.

You can click the Collapse button to drill up into a PivotTable.

To perform an action based on whether an option button control is selected, you assign a macro to the form control.

In one workbook, Tim wants to include a link to another workbook. Which of the following dialog boxes should he use to add the link?

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

When you want to know the position of an item in a range, you can use the _____ function.

The formula =ROUNDUP(G5,0) can be used to round up 59.425, entered in cell G5, to 60

Cell D1 contains the text "Office Locations." Min wants to convert the text to "OFFICE LOCATIONS." Which of the following formulas should he use?

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

When you copy and paste a formula to a new location, the formula's relative references do not change.

When you enter a formula such as =SUM('Chicago:San Francisco'!A6), which references cell A6 on four worksheets from the Chicago worksheet to the San Francisco worksheet, what type of reference are you using?

Which of the following is not true about setting column width?

You can create conditional cell formats using either the Home tab or the _____.

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?

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 customize the status bar, right-click the status bar, then click the options you want to show or hide .

Which of the following properties can you change for a Command Button (ActiveX Control)?

To rotate cell contents, you use the Orientation button in the Alignment group on the Home tab.

The default worksheet text is _____-point Calibri.

When you want to know the position of an item in a range, you can use the LOOKUP function.

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

You can import a text file that uses a divider such as a space, comma, or semicolon between columns of data.

You can click the Collapse button to drill up into a PivotTable.

To perform an action based on whether an option button control is selected, you assign a macro to the form control.

In one workbook, Tim wants to include a link to another workbook. Which of the following dialog boxes should he use to add the link?

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

When you want to know the position of an item in a range, you can use the _____ function.

The formula =ROUNDUP(G5,0) can be used to round up 59.425, entered in cell G5, to 60

Cell D1 contains the text "Office Locations." Min wants to convert the text to "OFFICE LOCATIONS." Which of the following formulas should he use?

Access 2019

Powerpoint 2019

Word 2019

Outlook 2019

Windows 10 2019

Technology and IT: From CAM to IoT and Digital Citizenship

Filters