Question 1

Joe wants to format several worksheets at the same time. What is the easiest way for him to perform this task?

Accepted Answer

A)  Create a custom view of the worksheets. 
B)  Group the worksheets. 
C)  View the worksheets side by side. 
D)  Link the worksheets. 
A)  Create a custom view of the worksheets. 
B)  Group the worksheets. 
C)  View the worksheets side by side. 
D)  Link the worksheets.

Question 2

Which of the following buttons on the Home tab can you use to insert a row in a table?

Accepted Answer

A)  Format as Table 
B)  Insert & Merge 
C)  Insert 
D)  Add Row 
A)  Format as Table 
B)  Insert & Merge 
C)  Insert 
D)  Add Row

Question 3

What can you change to coordinate sparklines with other charts and graphic objects on a worksheet?

Accepted Answer

A)  sparkline type 
B)  sparkline color 
C)  show or hide data markers 
D)  scale of the sparkline axis 
A)  sparkline type 
B)  sparkline color 
C)  show or hide data markers 
D)  scale of the sparkline axis

Question 4

A _____ chart tracks the addition and subtraction of values within a sum.

Accepted Answer

A)  waterfall 
B)  histogram 
C)  scatter 
D)  combo 
A)  waterfall 
B)  histogram 
C)  scatter 
D)  combo

Question 5

When you insert a defined name into a formula, Excel treats the defined name as a(n) _____.

Accepted Answer

A)  relative cell reference 
B)  mixed cell reference 
C)  static cell reference 
D)  absolute cell reference 
A)  relative cell reference 
B)  mixed cell reference 
C)  static cell reference 
D)  absolute cell reference

Question 6

To which of the following chart types can you not add axis titles?

Accepted Answer

A)  Pie chart 
B)  Line chart 
C)  Area chart 
D)  Column chart 
A)  Pie chart 
B)  Line chart 
C)  Area chart 
D)  Column chart

Question 7

You can add data markers to sparklines to indicate the high and low points in the chart.

Accepted Answer

A) True 
 B)False

Question 8

When you enter a number, date, or time in a cell, it is left-aligned by default.

Accepted Answer

A) True 
 B)False

Question 9

You use the CUMPRINC function to calculate the cumulative interest payments for a loan.

Accepted Answer

A) True 
 B)False

Question 10

To save a workbook for the first time, you use the Save As dialog box.

Accepted Answer

A) True 
 B)False

Question 11

A(n) _____ changes values by a constant amount.

Accepted Answer

A)  linear trend 
B)  growth trend 
C)  AutoFill trend 
D)  constant trend 
A)  linear trend 
B)  growth trend 
C)  AutoFill trend 
D)  constant trend

Question 12

You need to add another product to your inventory worksheet, which shows product names in row A. Which of the following should you add?

Accepted Answer

A)  a row 
B)  a column 
C)  a button 
D)  conditional formatting 
A)  a row 
B)  a column 
C)  a button 
D)  conditional formatting

Question 13

Nathan has a PivotTable listing income from promotional events. He wants to multiple the value of a Tickets Sold field by a Price per Ticket field to find the total income from each type of ticket. He should create a calculated item .

Accepted Answer

A) True 
 B)False

Question 14

Even if a validation error message with the Stop style appears next to a cell, users can still enter any value in the cell.

Accepted Answer

A) True 
 B)False

Question 15

Which of the following functions would you use to find the column location of specified text?

Accepted Answer

A)  MATCH 
B)  INDEX 
C)  VLOOKUP 
D)  HLOOKUP 
A)  MATCH 
B)  INDEX 
C)  VLOOKUP 
D)  HLOOKUP

Question 16

Evelyn wants to analyze data stored in a comma-separate values (CSV) file. To access that data for use in Excel, she can create a data report .

Accepted Answer

A) True 
 B)False

Question 17

Allison's small business earns $10,000 in January. She expects income to increase by 5 percent per month until the end of the year. To use Excel to calculate monthly income from February to December, Allison can fill a series with a trend.

Accepted Answer

A) True 
 B)False

Question 18

Jacquan wants to use a cell style similar to the default Title style, but with a larger font size and different font color. What can he do?

Accepted Answer

A)  Apply a different theme. 
B)  Create a custom cell style. 
C)  Transpose the Title style. 
D)  Apply conditional formats. 
A)  Apply a different theme. 
B)  Create a custom cell style. 
C)  Transpose the Title style. 
D)  Apply conditional formats.

Question 19

You can insert a formula by selecting a range of values, clicking the Quick Analysis button, and then clicking Tables .

Accepted Answer

A) True 
 B)False

Question 20

To edit a macro, you open the Macro editor, which is a separate application that works with Excel.

Accepted Answer

A) True 
 B)False

Joe wants to format several worksheets at the same time. What is the easiest way for him to perform this task?

Which of the following buttons on the Home tab can you use to insert a row in a table?

What can you change to coordinate sparklines with other charts and graphic objects on a worksheet?

A _____ chart tracks the addition and subtraction of values within a sum.

When you insert a defined name into a formula, Excel treats the defined name as a(n) _____.

To which of the following chart types can you not add axis titles?

You can add data markers to sparklines to indicate the high and low points in the chart.

When you enter a number, date, or time in a cell, it is left-aligned by default.

You use the CUMPRINC function to calculate the cumulative interest payments for a loan.

To save a workbook for the first time, you use the Save As dialog box.

A(n) _____ changes values by a constant amount.

You need to add another product to your inventory worksheet, which shows product names in row A. Which of the following should you add?

Nathan has a PivotTable listing income from promotional events. He wants to multiple the value of a Tickets Sold field by a Price per Ticket field to find the total income from each type of ticket. He should create a calculated item .

Even if a validation error message with the Stop style appears next to a cell, users can still enter any value in the cell.

Which of the following functions would you use to find the column location of specified text?

Evelyn wants to analyze data stored in a comma-separate values (CSV) file. To access that data for use in Excel, she can create a data report .

Allison's small business earns $10,000 in January. She expects income to increase by 5 percent per month until the end of the year. To use Excel to calculate monthly income from February to December, Allison can fill a series with a trend.

Jacquan wants to use a cell style similar to the default Title style, but with a larger font size and different font color. What can he do?

You can insert a formula by selecting a range of values, clicking the Quick Analysis button, and then clicking Tables .

To edit a macro, you open the Macro editor, which is a separate application that works with Excel.

Access 2019

Outlook 2019

Powerpoint 2019

Windows 10 - 2019

Word 2019

Computer History and Components

Filters

Exam 2: Excel 2019

Joe wants to format several worksheets at the same time. What is the easiest way for him to perform this task?

Which of the following buttons on the Home tab can you use to insert a row in a table?

What can you change to coordinate sparklines with other charts and graphic objects on a worksheet?

A _____ chart tracks the addition and subtraction of values within a sum.

When you insert a defined name into a formula, Excel treats the defined name as a(n) _____.

To which of the following chart types can you not add axis titles?

You can add data markers to sparklines to indicate the high and low points in the chart.

When you enter a number, date, or time in a cell, it is left-aligned by default.

You use the CUMPRINC function to calculate the cumulative interest payments for a loan.

To save a workbook for the first time, you use the Save As dialog box.

A(n) _____ changes values by a constant amount.

You need to add another product to your inventory worksheet, which shows product names in row A. Which of the following should you add?

Nathan has a PivotTable listing income from promotional events. He wants to multiple the value of a Tickets Sold field by a Price per Ticket field to find the total income from each type of ticket. He should create a calculated item .

Even if a validation error message with the Stop style appears next to a cell, users can still enter any value in the cell.

Which of the following functions would you use to find the column location of specified text?

Evelyn wants to analyze data stored in a comma-separate values (CSV) file. To access that data for use in Excel, she can create a data report .

Allison's small business earns $10,000 in January. She expects income to increase by 5 percent per month until the end of the year. To use Excel to calculate monthly income from February to December, Allison can fill a series with a trend.

Jacquan wants to use a cell style similar to the default Title style, but with a larger font size and different font color. What can he do?

You can insert a formula by selecting a range of values, clicking the Quick Analysis button, and then clicking Tables .

To edit a macro, you open the Macro editor, which is a separate application that works with Excel.

Access 2019

Outlook 2019

Powerpoint 2019

Windows 10 - 2019

Word 2019

Computer History and Components

Filters