Question 1

To create a PivotTable layout, you can drag fields from the field list to an area box in the PivotTable Fields pane.

Accepted Answer

A) True 
 B)False

Question 2

Which of the following functions would you use to calculate the arithmetic mean of a price list?

Accepted Answer

A)  MAX 
B)  COUNT 
C)  SUM 
D)  AVERAGE 
A)  MAX 
B)  COUNT 
C)  SUM 
D)  AVERAGE

Question 3

To highlight track changes in a worksheet, go to the Highlight Changes dialog box and check the box for Highlight changes on screen, then click OK.

Accepted Answer

A) True 
 B)False

Question 4

In formulas, calculations in square brackets are calculated first.

Accepted Answer

A) True 
 B)False

Question 5

Which of the following is true about moving cell contents?

Accepted Answer

A)  You can move cells using the Copy command. 
B)  You cannot move cells from one worksheet to another. 
C)  When you move cell contents, they remain in their original location. 
D)  You can move cells using the drag-and-drop feature. 
A)  You can move cells using the Copy command. 
B)  You cannot move cells from one worksheet to another. 
C)  When you move cell contents, they remain in their original location. 
D)  You can move cells using the drag-and-drop feature.

Question 6

Dana added a report filter to a PivotTable, but the list of filter values is long and difficult to use. What can she do to reduce the filter values in the list?

Accepted Answer

A)  Use a slicer instead of a report filter. 
B)  Enter search text in the Search box above the list of field item values. 
C)  Sort the PivotTable first. 
D)  Use the Approximate Filter feature. 
A)  Use a slicer instead of a report filter. 
B)  Enter search text in the Search box above the list of field item values. 
C)  Sort the PivotTable first. 
D)  Use the Approximate Filter feature.

Question 7

How do you select a cell containing a hyperlink without activating the link?

Accepted Answer

A)  Double-click the cell. 
B)  Right-click the cell. 
C)  Click the cell and then click Do Not Activate. 
D)  Click the cell and then click Edit Hyperlink. 
A)  Double-click the cell. 
B)  Right-click the cell. 
C)  Click the cell and then click Do Not Activate. 
D)  Click the cell and then click Edit Hyperlink.

Question 8

Jason wants to average the sales in the range C3:C50, and then round the result to the nearest integer. Which of the following formulas should he use?

Accepted Answer

A)  =ROUND(AVERAGE(C3:C50),0) 
B)  =AVERAGE((C3:C50), ROUND, 0)) 
C)  =ROUND(C3:C50) 
D)  AVERAGE(ROUND(C3:C50),0) 
A)  =ROUND(AVERAGE(C3:C50),0) 
B)  =AVERAGE((C3:C50), ROUND, 0)) 
C)  =ROUND(C3:C50) 
D)  AVERAGE(ROUND(C3:C50),0)

Question 9

The value in cell B2 cell is 65. In cell C2, the value is 75. Which of the following formulas returns FALSE if any of the conditions are false for the values in cells B2 and C2?

Accepted Answer

A)  =IF(B2>=70, C2>=80) 
B)  =OR(B2>=70, C2>=80) 
C)  =AND(B2>=70, C2>=80) 
D)  =NOT(OR(B2>=70, C2>=80)) 
A)  =IF(B2>=70, C2>=80) 
B)  =OR(B2>=70, C2>=80) 
C)  =AND(B2>=70, C2>=80) 
D)  =NOT(OR(B2>=70, C2>=80))

Question 10

Which of the following inserts a function into a cell?

Accepted Answer

A)  mode indicator 
B)  AutoSum button 
C)  argument 
D)  formula prefix 
A)  mode indicator 
B)  AutoSum button 
C)  argument 
D)  formula prefix

Question 11

Dean wants to insert two blank rows above row 5. To do so, he can click the row 5 heading, and then click the Insert button in the Cells group two times.

Accepted Answer

A) True 
 B)False

Question 12

You can use the Find and Replace dialog box to find and replace _____.

Accepted Answer

A)  cell formatting 
B)  cell references 
C)  function names 
D)  worksheet names 
A)  cell formatting 
B)  cell references 
C)  function names 
D)  worksheet names

Question 13

Brian wants to filter a PivotTable by the Appointment Date field. To do so, he should create a calendar slicer.

Accepted Answer

A) True 
 B)False

Question 14

How can you reverse your most recent action in Excel?

Accepted Answer

A)  Click the Redo button. 
B)  Click the Reverse button. 
C)  Click the Escape button. 
D)  Click the Undo button. 
A)  Click the Redo button. 
B)  Click the Reverse button. 
C)  Click the Escape button. 
D)  Click the Undo button.

Question 15

To rename a worksheet, you change the text on the _____.

Accepted Answer

A)  sheet columns 
B)  sheet rows 
C)  sheet header 
D)  sheet tab 
A)  sheet columns 
B)  sheet rows 
C)  sheet header 
D)  sheet tab

Question 16

Which of the following chart types show how two numeric data series are related to each other?

Accepted Answer

A)  Pie 
B)  Bar 
C)  Line 
D)  Scatter 
A)  Pie 
B)  Bar 
C)  Line 
D)  Scatter

Question 17

To ungroup worksheets after grouping them and working on them simultaneously, right-click any worksheet tab in the group and click Ungroup Sheets.

Accepted Answer

A) True 
 B)False

Question 18

When you protect a worksheet, you prevent users from renaming or deleting the worksheet.

Accepted Answer

A) True 
 B)False

Question 19

Which of the following keys do you press to copy cells while dragging them?

Accepted Answer

A)  ALT 
B)  SHIFT 
C)  TAB 
D)  CTRL 
A)  ALT 
B)  SHIFT 
C)  TAB 
D)  CTRL

Question 20

Which of the following is not a way to move cell contents?

Accepted Answer

A)  clicking the Cut and Paste buttons on the Home tab 
B)  pressing the CTRL+X keys 
C)  holding the CTRL key while dragging the selected cells 
D)  using drag-and-drop 
A)  clicking the Cut and Paste buttons on the Home tab 
B)  pressing the CTRL+X keys 
C)  holding the CTRL key while dragging the selected cells 
D)  using drag-and-drop

To create a PivotTable layout, you can drag fields from the field list to an area box in the PivotTable Fields pane.

Which of the following functions would you use to calculate the arithmetic mean of a price list?

To highlight track changes in a worksheet, go to the Highlight Changes dialog box and check the box for Highlight changes on screen, then click OK.

In formulas, calculations in square brackets are calculated first.

Which of the following is true about moving cell contents?

Dana added a report filter to a PivotTable, but the list of filter values is long and difficult to use. What can she do to reduce the filter values in the list?

How do you select a cell containing a hyperlink without activating the link?

Jason wants to average the sales in the range C3:C50, and then round the result to the nearest integer. Which of the following formulas should he use?

The value in cell B2 cell is 65. In cell C2, the value is 75. Which of the following formulas returns FALSE if any of the conditions are false for the values in cells B2 and C2?

Which of the following inserts a function into a cell?

Dean wants to insert two blank rows above row 5. To do so, he can click the row 5 heading, and then click the Insert button in the Cells group two times.

You can use the Find and Replace dialog box to find and replace _____.

Brian wants to filter a PivotTable by the Appointment Date field. To do so, he should create a calendar slicer.

How can you reverse your most recent action in Excel?

To rename a worksheet, you change the text on the _____.

Which of the following chart types show how two numeric data series are related to each other?

To ungroup worksheets after grouping them and working on them simultaneously, right-click any worksheet tab in the group and click Ungroup Sheets.

When you protect a worksheet, you prevent users from renaming or deleting the worksheet.

Which of the following keys do you press to copy cells while dragging them?

Which of the following is not a way to move cell contents?

Access 2019

Outlook 2019

Powerpoint 2019

Windows 10 - 2019

Word 2019

Computer History and Components

Filters

Exam 2: Excel 2019

To create a PivotTable layout, you can drag fields from the field list to an area box in the PivotTable Fields pane.

Which of the following functions would you use to calculate the arithmetic mean of a price list?

To highlight track changes in a worksheet, go to the Highlight Changes dialog box and check the box for Highlight changes on screen, then click OK.

In formulas, calculations in square brackets are calculated first.

Which of the following is true about moving cell contents?

Dana added a report filter to a PivotTable, but the list of filter values is long and difficult to use. What can she do to reduce the filter values in the list?

How do you select a cell containing a hyperlink without activating the link?

Jason wants to average the sales in the range C3:C50, and then round the result to the nearest integer. Which of the following formulas should he use?

The value in cell B2 cell is 65. In cell C2, the value is 75. Which of the following formulas returns FALSE if any of the conditions are false for the values in cells B2 and C2?

Which of the following inserts a function into a cell?

Dean wants to insert two blank rows above row 5. To do so, he can click the row 5 heading, and then click the Insert button in the Cells group two times.

You can use the Find and Replace dialog box to find and replace _____.

Brian wants to filter a PivotTable by the Appointment Date field. To do so, he should create a calendar slicer.

How can you reverse your most recent action in Excel?

To rename a worksheet, you change the text on the _____.

Which of the following chart types show how two numeric data series are related to each other?

To ungroup worksheets after grouping them and working on them simultaneously, right-click any worksheet tab in the group and click Ungroup Sheets.

When you protect a worksheet, you prevent users from renaming or deleting the worksheet.

Which of the following keys do you press to copy cells while dragging them?

Which of the following is not a way to move cell contents?

Access 2019

Outlook 2019

Powerpoint 2019

Windows 10 - 2019

Word 2019

Computer History and Components

Filters