Question 1

To calculate the total interest paid on a loan over a full year, you use the CUMPRINC function.

Accepted Answer

A) True 
 B)False

Question 2

A two-variable data table lets you view the relationship between two input cells and one result cell.

Accepted Answer

A) True 
 B)False

Question 3

When you double-click the right border of a column heading, which of the following occurs?

Accepted Answer

A)  The column is deleted. 
B)  AutoFit resizes the column to 8.43 characters wide. 
C)  A column is added to the right of the current column. 
D)  AutoFit resizes the column to the widest cell entry. 
A)  The column is deleted. 
B)  AutoFit resizes the column to 8.43 characters wide. 
C)  A column is added to the right of the current column. 
D)  AutoFit resizes the column to the widest cell entry.

Question 4

Abby created a scatter chart showing her company's annual expenses for the past 15 years. She also wants to highlight the general pattern of expense amounts. What can she add to the scatter chart?

Accepted Answer

A)  data labels 
B)  gridlines 
C)  trendline 
D)  secondary axis 
A)  data labels 
B)  gridlines 
C)  trendline 
D)  secondary axis

Question 5

After beginning a formula, what can you do instead of typing the syntax of a 3-D reference?

Accepted Answer

A)  Click a sheet tab, click a cell range, and then press ENTER. 
B)  Copy a sheet tab and then press CTRL+V to paste it in the formula. 
C)  Use the fill handle to select the external range. 
D)  Click the Enter button on the formula bar, click a sheet tab, and then click a cell range. 
A)  Click a sheet tab, click a cell range, and then press ENTER. 
B)  Copy a sheet tab and then press CTRL+V to paste it in the formula. 
C)  Use the fill handle to select the external range. 
D)  Click the Enter button on the formula bar, click a sheet tab, and then click a cell range.

Question 6

A _____ chart displays each category of data in a rectangle and smaller rectangles within them for subcategories.

Accepted Answer

A)  funnel 
B)  treemap 
C)  bubble 
D)  statistic 
A)  funnel 
B)  treemap 
C)  bubble 
D)  statistic

Question 7

To align the upper-left corner of a chart with the upper-left corner of a cell, press and hold CTRL as you drag the chart.

Accepted Answer

A) True 
 B)False

Question 8

One way to run a macro is to click the Run button in the Macros dialog box. What is another way?

Accepted Answer

A)  Press the shortcut key assigned to the macro. 
B)  Click the Run Macros button on the Formulas tab. 
C)  Create a formula using the MACRO function. 
D)  Assign the macro to a hyperlink. 
A)  Press the shortcut key assigned to the macro. 
B)  Click the Run Macros button on the Formulas tab. 
C)  Create a formula using the MACRO function. 
D)  Assign the macro to a hyperlink.

Question 9

After you delete a worksheet column, _____.

Accepted Answer

A)  the columns to its right shift left 
B)  the columns to its left shift right 
C)  the row remains but its contents are deleted 
D)  only its formats are deleted 
A)  the columns to its right shift left 
B)  the columns to its left shift right 
C)  the row remains but its contents are deleted 
D)  only its formats are deleted

Question 10

You use the Values area to limit a PivotChart to values that satisfy a specified criteria.

Accepted Answer

A) True 
 B)False

Question 11

To move cell contents one space to the right, you can use the Increase Space button.

Accepted Answer

A) True 
 B)False

Question 12

To find the largest value in a cell range, use the MIN function.

Accepted Answer

A) True 
 B)False

Question 13

The only way to update a link to another workbook is to insert a new link.

Accepted Answer

A) True 
 B)False

Question 14

Roberta added a calculated field to the Values area of a PivotTable, where it appears as "Sum of ORDERS." Where can she change the text displayed for this field?

Accepted Answer

A)  Number Format dialog box 
B)  Calculated Field Format dialog box 
C)  Value Field Settings dialog box 
D)  PivotTable Options dialog box 
A)  Number Format dialog box 
B)  Calculated Field Format dialog box 
C)  Value Field Settings dialog box 
D)  PivotTable Options dialog box

Question 15

Which of the following lets you edit the contents of a cell?

Accepted Answer

A)  Click the cell, click the status bar, and press Enter. 
B)  Click the cell and click in the status bar. 
C)  Double-click the cell, click in the status bar, or just start typing. 
D)  Double-click the cell or click in the formula bar. 
A)  Click the cell, click the status bar, and press Enter. 
B)  Click the cell and click in the status bar. 
C)  Double-click the cell, click in the status bar, or just start typing. 
D)  Double-click the cell or click in the formula bar.

Question 16

Where does Excel list the fields available for a PivotTable?

Accepted Answer

A)  in the PivotTable itself 
B)  in the PivotTable Fields pane 
C)  on the PivotTable Tools Analyze tab 
D)  in the PivotTable Styles gallery 
A)  in the PivotTable itself 
B)  in the PivotTable Fields pane 
C)  on the PivotTable Tools Analyze tab 
D)  in the PivotTable Styles gallery

Question 17

In a PivotTable, the Values area contains a filter button that limits the PivotTable to only those values matching a specified criteria.

Accepted Answer

A) True 
 B)False

Question 18

You receive a worksheet in which the rows are numbered 1, 2, 3, 5,6. This means that row 4 is _____.

Accepted Answer

A)  deleted 
B)  hidden 
C)  cut 
D)  conditionally formatted 
A)  deleted 
B)  hidden 
C)  cut 
D)  conditionally formatted

Question 19

A constant is a term in an equation whose value does not change.

Accepted Answer

A) True 
 B)False

Question 20

Which of the following is a built-in formula that helps you perform complex calculations?

Accepted Answer

A)  clipboard 
B)  mode indicator 
C)  named range 
D)  function 
A)  clipboard 
B)  mode indicator 
C)  named range 
D)  function

To calculate the total interest paid on a loan over a full year, you use the CUMPRINC function.

A two-variable data table lets you view the relationship between two input cells and one result cell.

When you double-click the right border of a column heading, which of the following occurs?

Abby created a scatter chart showing her company's annual expenses for the past 15 years. She also wants to highlight the general pattern of expense amounts. What can she add to the scatter chart?

After beginning a formula, what can you do instead of typing the syntax of a 3-D reference?

A _____ chart displays each category of data in a rectangle and smaller rectangles within them for subcategories.

To align the upper-left corner of a chart with the upper-left corner of a cell, press and hold CTRL as you drag the chart.

One way to run a macro is to click the Run button in the Macros dialog box. What is another way?

After you delete a worksheet column, _____.

You use the Values area to limit a PivotChart to values that satisfy a specified criteria.

To move cell contents one space to the right, you can use the Increase Space button.

To find the largest value in a cell range, use the MIN function.

The only way to update a link to another workbook is to insert a new link.

Roberta added a calculated field to the Values area of a PivotTable, where it appears as "Sum of ORDERS." Where can she change the text displayed for this field?

Which of the following lets you edit the contents of a cell?

Where does Excel list the fields available for a PivotTable?

In a PivotTable, the Values area contains a filter button that limits the PivotTable to only those values matching a specified criteria.

You receive a worksheet in which the rows are numbered 1, 2, 3, 5,6. This means that row 4 is _____.

A constant is a term in an equation whose value does not change.

Which of the following is a built-in formula that helps you perform complex calculations?

Access 2019

Outlook 2019

Powerpoint 2019

Windows 10 - 2019

Word 2019

Computer History and Components

Filters

Exam 2: Excel 2019

To calculate the total interest paid on a loan over a full year, you use the CUMPRINC function.

A two-variable data table lets you view the relationship between two input cells and one result cell.

When you double-click the right border of a column heading, which of the following occurs?

Abby created a scatter chart showing her company's annual expenses for the past 15 years. She also wants to highlight the general pattern of expense amounts. What can she add to the scatter chart?

After beginning a formula, what can you do instead of typing the syntax of a 3-D reference?

A _____ chart displays each category of data in a rectangle and smaller rectangles within them for subcategories.

To align the upper-left corner of a chart with the upper-left corner of a cell, press and hold CTRL as you drag the chart.

One way to run a macro is to click the Run button in the Macros dialog box. What is another way?

After you delete a worksheet column, _____.

You use the Values area to limit a PivotChart to values that satisfy a specified criteria.

To move cell contents one space to the right, you can use the Increase Space button.

To find the largest value in a cell range, use the MIN function.

The only way to update a link to another workbook is to insert a new link.

Roberta added a calculated field to the Values area of a PivotTable, where it appears as "Sum of ORDERS." Where can she change the text displayed for this field?

Which of the following lets you edit the contents of a cell?

Where does Excel list the fields available for a PivotTable?

In a PivotTable, the Values area contains a filter button that limits the PivotTable to only those values matching a specified criteria.

You receive a worksheet in which the rows are numbered 1, 2, 3, 5,6. This means that row 4 is _____.

A constant is a term in an equation whose value does not change.

Which of the following is a built-in formula that helps you perform complex calculations?

Access 2019

Outlook 2019

Powerpoint 2019

Windows 10 - 2019

Word 2019

Computer History and Components

Filters