Question 1

A(n) Summary function calculates summary statistics including AVERAGE, COUNT, and SUM, using criteria specified in a range.

Accepted Answer

A) True 
 B)False

Question 2

When you insert a column in a worksheet, what happens to formulas you already entered?

Accepted Answer

A)  Excel updates their cell references to reflect the new layout. 
B)  The formulas remain in the same cells. 
C)  The cells with formulas display an error so you can correct them. 
D)  The formulas need to be updated manually. 
A)  Excel updates their cell references to reflect the new layout. 
B)  The formulas remain in the same cells. 
C)  The cells with formulas display an error so you can correct them. 
D)  The formulas need to be updated manually.

Question 3

Isabel has a PivotTable listing revenue from 100 campground rentals, with campgrounds listed by capacity. She wants to display campgrounds with capacity of 1-20, 21-40, and so on. How can she do so?

Accepted Answer

A)  Group the campgrounds by reservation date. 
B)  Group the campgrounds by capacity. 
C)  Sort the campgrounds by revenue. 
D)  Filter the campgrounds by capacity. 
A)  Group the campgrounds by reservation date. 
B)  Group the campgrounds by capacity. 
C)  Sort the campgrounds by revenue. 
D)  Filter the campgrounds by capacity.

Question 4

Your worksheet contains a price in cell A5, and many formulas refer to that price. How would you refer to that price in the formulas?

Accepted Answer

A)  A5 
B)  $A$5 
C)  $A5 
D)  A$5 
A)  A5 
B)  $A$5 
C)  $A5 
D)  A$5

Question 5

Miley can copy a worksheet instead of moving it by holding down SHIFT and dragging the sheet tab.

Accepted Answer

A) True 
 B)False

Question 6

Which of the following is the default name assigned to the first PivotTable in a workbook?

Accepted Answer

A)  Table1 
B)  New PivotTable 
C)  PivotTable1 
D)  Pivot1 
A)  Table1 
B)  New PivotTable 
C)  PivotTable1 
D)  Pivot1

Question 7

To print a worksheet, you begin by going to Backstage view.

Accepted Answer

A) True 
 B)False

Question 8

When you paste formula cells using the Paste button in the Clipboard group, which of the following is true?

Accepted Answer

A)  A button appears near the selected cells with options for pasting formulas and values. 
B)  The formula is copied with cell references you must adjust to avoid worksheet errors. 
C)  The Auto Fill Options button appears. 
D)  Pointing to the destination cell displays a preview of the cell contents. 
A)  A button appears near the selected cells with options for pasting formulas and values. 
B)  The formula is copied with cell references you must adjust to avoid worksheet errors. 
C)  The Auto Fill Options button appears. 
D)  Pointing to the destination cell displays a preview of the cell contents.

Question 9

One advantage of forecast sheets is that they can analyze seasonal data in which the values follow a periodic pattern during the calendar year.

Accepted Answer

A) True 
 B)False

Question 10

When you select a cell range, the cells must be adjacent to each other.

Accepted Answer

A) True 
 B)False

Question 11

To provide suggestions to other people using your document, select the text you want to comment on, then click New Comment on the Review tab and type your comment.

Accepted Answer

A) True 
 B)False

Question 12

How can you add a new picture to a SmartArt graphic?

Accepted Answer

A)  Click the SmartArt button on the Insert tab, then click Picture, click a layout, and then click OK. 
B)  Select a picture, click the Picture Layout button on the Format tab under Picture Tools, and then select a layout. 
C)  Select a picture, click the Insert tab under Picture Tools, click the Insert Picture, and then select a layout. 
D)  Under SmartArt Tools, click the Design tab, then click the Add Shape button arrow, and then select the picture you want to add. 
A)  Click the SmartArt button on the Insert tab, then click Picture, click a layout, and then click OK. 
B)  Select a picture, click the Picture Layout button on the Format tab under Picture Tools, and then select a layout. 
C)  Select a picture, click the Insert tab under Picture Tools, click the Insert Picture, and then select a layout. 
D)  Under SmartArt Tools, click the Design tab, then click the Add Shape button arrow, and then select the picture you want to add.

Question 13

Decreasing a cell's indent moves its contents to the right one space.

Accepted Answer

A) True 
 B)False

Question 14

A theme is a predefined coordinated set of colors, fonts, graphical effects, and other formats.

Accepted Answer

A) True 
 B)False

Question 15

When you align a range, you combine the cells into one cell.

Accepted Answer

A) True 
 B)False

Question 16

How can you correct an error such as the #NAME? error in a worksheet?

Accepted Answer

A)  Ignore the error. 
B)  Open the Watch Window. 
C)  Use absolute references in the formula. 
D)  Trace the cell precedents and dependents to find the source of the error. 
A)  Ignore the error. 
B)  Open the Watch Window. 
C)  Use absolute references in the formula. 
D)  Trace the cell precedents and dependents to find the source of the error.

Question 17

Add a numeric field to the Values area to sum values for each intersection of a row category and column category.

Accepted Answer

A) True 
 B)False

Question 18

Every PivotTable includes a Totals area as one of its four primary areas.

Accepted Answer

A) True 
 B)False

Question 19

Workbook styles are predesigned workbooks that contain formulas and design elements.

Accepted Answer

A) True 
 B)False

Question 20

What is the file extension of macro-enabled workbook?

Accepted Answer

A)  .xls 
B)  .xlx 
C)  .xlsx 
D)  .xlsm 
A)  .xls 
B)  .xlx 
C)  .xlsx 
D)  .xlsm

A(n) Summary function calculates summary statistics including AVERAGE, COUNT, and SUM, using criteria specified in a range.

When you insert a column in a worksheet, what happens to formulas you already entered?

Isabel has a PivotTable listing revenue from 100 campground rentals, with campgrounds listed by capacity. She wants to display campgrounds with capacity of 1-20, 21-40, and so on. How can she do so?

Your worksheet contains a price in cell A5, and many formulas refer to that price. How would you refer to that price in the formulas?

Miley can copy a worksheet instead of moving it by holding down SHIFT and dragging the sheet tab.

Which of the following is the default name assigned to the first PivotTable in a workbook?

To print a worksheet, you begin by going to Backstage view.

When you paste formula cells using the Paste button in the Clipboard group, which of the following is true?

One advantage of forecast sheets is that they can analyze seasonal data in which the values follow a periodic pattern during the calendar year.

When you select a cell range, the cells must be adjacent to each other.

To provide suggestions to other people using your document, select the text you want to comment on, then click New Comment on the Review tab and type your comment.

How can you add a new picture to a SmartArt graphic?

Decreasing a cell's indent moves its contents to the right one space.

A theme is a predefined coordinated set of colors, fonts, graphical effects, and other formats.

When you align a range, you combine the cells into one cell.

How can you correct an error such as the #NAME? error in a worksheet?

Add a numeric field to the Values area to sum values for each intersection of a row category and column category.

Every PivotTable includes a Totals area as one of its four primary areas.

Workbook styles are predesigned workbooks that contain formulas and design elements.

What is the file extension of macro-enabled workbook?

Access 2019

Outlook 2019

Powerpoint 2019

Windows 10 - 2019

Word 2019

Computer History and Components

Filters

Exam 2: Excel 2019

A(n) Summary function calculates summary statistics including AVERAGE, COUNT, and SUM, using criteria specified in a range.

When you insert a column in a worksheet, what happens to formulas you already entered?

Isabel has a PivotTable listing revenue from 100 campground rentals, with campgrounds listed by capacity. She wants to display campgrounds with capacity of 1-20, 21-40, and so on. How can she do so?

Your worksheet contains a price in cell A5, and many formulas refer to that price. How would you refer to that price in the formulas?

Miley can copy a worksheet instead of moving it by holding down SHIFT and dragging the sheet tab.

Which of the following is the default name assigned to the first PivotTable in a workbook?

To print a worksheet, you begin by going to Backstage view.

When you paste formula cells using the Paste button in the Clipboard group, which of the following is true?

One advantage of forecast sheets is that they can analyze seasonal data in which the values follow a periodic pattern during the calendar year.

When you select a cell range, the cells must be adjacent to each other.

To provide suggestions to other people using your document, select the text you want to comment on, then click New Comment on the Review tab and type your comment.

How can you add a new picture to a SmartArt graphic?

Decreasing a cell's indent moves its contents to the right one space.

A theme is a predefined coordinated set of colors, fonts, graphical effects, and other formats.

When you align a range, you combine the cells into one cell.

How can you correct an error such as the #NAME? error in a worksheet?

Add a numeric field to the Values area to sum values for each intersection of a row category and column category.

Every PivotTable includes a Totals area as one of its four primary areas.

Workbook styles are predesigned workbooks that contain formulas and design elements.

What is the file extension of macro-enabled workbook?

Access 2019

Outlook 2019

Powerpoint 2019

Windows 10 - 2019

Word 2019

Computer History and Components

Filters