Question 1

Kylie has a table with a Skill Number column that contains values from 400 to 500. What type of filter can she use to select records with skill numbers less than 450?

Accepted Answer

A)  Advanced filter 
B)  Text filter 
C)  Number filter 
D)  AutoText Filter 
A)  Advanced filter 
B)  Text filter 
C)  Number filter 
D)  AutoText Filter

Question 2

To delete a worksheet column, you can first select it by _____.

Accepted Answer

A)  clicking the column heading 
B)  double-clicking the column heading 
C)  clicking anywhere in the column 
D)  double-clicking anywhere in the column 
A)  clicking the column heading 
B)  double-clicking the column heading 
C)  clicking anywhere in the column 
D)  double-clicking anywhere in the column

Question 3

Igor needs a wider left margin in his worksheet. Which of the following can he do to change the margin?

Accepted Answer

A)  On the Margins tab of the Page Setup dialog box, change the number in the Left box. 
B)  On the Page Layout tab, click the Margins button and then click Normal. 
C)  On the Page tab of the Page Setup dialog box, change the Orientation setting. 
D)  On the Margins tab of the Page Setup dialog box, click the Preset button. 
A)  On the Margins tab of the Page Setup dialog box, change the number in the Left box. 
B)  On the Page Layout tab, click the Margins button and then click Normal. 
C)  On the Page tab of the Page Setup dialog box, change the Orientation setting. 
D)  On the Margins tab of the Page Setup dialog box, click the Preset button.

Question 4

To select a single worksheet cell so you can work with it, which of the following would you do?

Accepted Answer

A)  Click the cell. 
B)  Move the cell pointer over the cell. 
C)  Click the status bar. 
D)  Click the Name box. 
A)  Click the cell. 
B)  Move the cell pointer over the cell. 
C)  Click the status bar. 
D)  Click the Name box.

Question 5

Use the DGET function to count the numeric values in a column for cells that match the criteria.

Accepted Answer

A) True 
 B)False

Question 6

Willa created three scenarios to perform a what-if analysis. To apply the values in the first scenario to the worksheet, she can select the first scenario and then click the Load button.

Accepted Answer

A) True 
 B)False

Question 7

Arlo wants to use Goal Seek to answer a what-if question in a worksheet. Which button should he click on the Data tab to access the Goal Seek command?

Accepted Answer

A)  What-if Analysis 
B)  Data Validation 
C)  Consolidate 
D)  Relationships 
A)  What-if Analysis 
B)  Data Validation 
C)  Consolidate 
D)  Relationships

Question 8

To make the appearance of sparklines consistent with other parts of a worksheet, you can change their layout.

Accepted Answer

A) True 
 B)False

Question 9

In a complex formula, how does Excel determine which calculation to perform first?

Accepted Answer

A)  It calculates the leftmost formulas first. 
B)  It calculates operations outside parentheses first. 
C)  It follows the order of operations. 
D)  It calculates functions first. 
A)  It calculates the leftmost formulas first. 
B)  It calculates operations outside parentheses first. 
C)  It follows the order of operations. 
D)  It calculates functions first.

Question 10

Boris is displaying two instances of the same workbook and wants to remove one. Which button should he click on the View tab?

Accepted Answer

A)  Hide 
B)  Split 
C)  View Side by Side 
D)  Switch Windows 
A)  Hide 
B)  Split 
C)  View Side by Side 
D)  Switch Windows

Question 11

You can use Goal Seek to determine how many products to sell to earn a targeted profit amount.

Accepted Answer

A) True 
 B)False

Question 12

After adding data to a table where a filter is applied, what should you do to filter the new data?

Accepted Answer

A)  Sort the table. 
B)  Reapply the filter. 
C)  Refresh the data in the table. 
D)  Clear the filter. 
A)  Sort the table. 
B)  Reapply the filter. 
C)  Refresh the data in the table. 
D)  Clear the filter.

Question 13

You open the Visual Basic Editor by clicking the Macros button in the Code group on the Developer tab.

Accepted Answer

A) True 
 B)False

Question 14

Jamal inserted a comment in a worksheet, but the comment displays "User" instead of "Jamal." He needs to change the entry in the User name box of the Excel General dialog box.

Accepted Answer

A) True 
 B)False

Question 15

A table formula can use a table reference to refer to column names instead of cell addresses.

Accepted Answer

A) True 
 B)False

Question 16

When should you use relative cell references?

Accepted Answer

A)  When you want to preserve the exact cell address in a formula. 
B)  When you want to preserve the relationship to the formula location. 
C)  When you want to insert a function. 
D)  When you want to enter sequential values in a range of cells. 
A)  When you want to preserve the exact cell address in a formula. 
B)  When you want to preserve the relationship to the formula location. 
C)  When you want to insert a function. 
D)  When you want to enter sequential values in a range of cells.

Question 17

Kyla has a Clustered Column PivotChart that compares sales in four locations. How can she add columns that show a 10 percent increase in sales in each location?

Accepted Answer

A)  Add a calculated field. 
B)  Switch columns and rows. 
C)  Filter the PivotChart. 
D)  Refresh the data. 
A)  Add a calculated field. 
B)  Switch columns and rows. 
C)  Filter the PivotChart. 
D)  Refresh the data.

Question 18

Ian needs to extract the day of the month from the date entered as a serial number in cell A1. Which formula can he use to do this?

Accepted Answer

A)  =DAY(A1) 
B)  =DAY("A1'') 
C)  =DATE(DAY(A1)) 
D)  =DATE("DAY"(A1)) 
A)  =DAY(A1) 
B)  =DAY("A1'') 
C)  =DATE(DAY(A1)) 
D)  =DATE("DAY"(A1))

Question 19

You can use named ranges in formulas to make the formulas easier to build and to reduce formula errors.

Accepted Answer

A) True 
 B)False

Question 20

How many actions does the Undo button let you reverse?

Accepted Answer

A)  24 
B)  50 
C)  75 
D)  100 
A)  24 
B)  50 
C)  75 
D)  100

Kylie has a table with a Skill Number column that contains values from 400 to 500. What type of filter can she use to select records with skill numbers less than 450?

To delete a worksheet column, you can first select it by _____.

Igor needs a wider left margin in his worksheet. Which of the following can he do to change the margin?

To select a single worksheet cell so you can work with it, which of the following would you do?

Use the DGET function to count the numeric values in a column for cells that match the criteria.

Willa created three scenarios to perform a what-if analysis. To apply the values in the first scenario to the worksheet, she can select the first scenario and then click the Load button.

Arlo wants to use Goal Seek to answer a what-if question in a worksheet. Which button should he click on the Data tab to access the Goal Seek command?

To make the appearance of sparklines consistent with other parts of a worksheet, you can change their layout.

In a complex formula, how does Excel determine which calculation to perform first?

Boris is displaying two instances of the same workbook and wants to remove one. Which button should he click on the View tab?

You can use Goal Seek to determine how many products to sell to earn a targeted profit amount.

After adding data to a table where a filter is applied, what should you do to filter the new data?

You open the Visual Basic Editor by clicking the Macros button in the Code group on the Developer tab.

Jamal inserted a comment in a worksheet, but the comment displays "User" instead of "Jamal." He needs to change the entry in the User name box of the Excel General dialog box.

A table formula can use a table reference to refer to column names instead of cell addresses.

When should you use relative cell references?

Kyla has a Clustered Column PivotChart that compares sales in four locations. How can she add columns that show a 10 percent increase in sales in each location?

Ian needs to extract the day of the month from the date entered as a serial number in cell A1. Which formula can he use to do this?

You can use named ranges in formulas to make the formulas easier to build and to reduce formula errors.

How many actions does the Undo button let you reverse?

Access-2019

Powerpoint-2019

Word-2019

Question Sets

Outlook-2019

Windows-10-2019

Filters

Exam 2: Excel-2019

Kylie has a table with a Skill Number column that contains values from 400 to 500. What type of filter can she use to select records with skill numbers less than 450?

To delete a worksheet column, you can first select it by _____.

Igor needs a wider left margin in his worksheet. Which of the following can he do to change the margin?

To select a single worksheet cell so you can work with it, which of the following would you do?

Use the DGET function to count the numeric values in a column for cells that match the criteria.

Willa created three scenarios to perform a what-if analysis. To apply the values in the first scenario to the worksheet, she can select the first scenario and then click the Load button.

Arlo wants to use Goal Seek to answer a what-if question in a worksheet. Which button should he click on the Data tab to access the Goal Seek command?

To make the appearance of sparklines consistent with other parts of a worksheet, you can change their layout.

In a complex formula, how does Excel determine which calculation to perform first?

Boris is displaying two instances of the same workbook and wants to remove one. Which button should he click on the View tab?

You can use Goal Seek to determine how many products to sell to earn a targeted profit amount.

After adding data to a table where a filter is applied, what should you do to filter the new data?

You open the Visual Basic Editor by clicking the Macros button in the Code group on the Developer tab.

Jamal inserted a comment in a worksheet, but the comment displays "User" instead of "Jamal." He needs to change the entry in the User name box of the Excel General dialog box.

A table formula can use a table reference to refer to column names instead of cell addresses.

When should you use relative cell references?

Kyla has a Clustered Column PivotChart that compares sales in four locations. How can she add columns that show a 10 percent increase in sales in each location?

Ian needs to extract the day of the month from the date entered as a serial number in cell A1. Which formula can he use to do this?

You can use named ranges in formulas to make the formulas easier to build and to reduce formula errors.

How many actions does the Undo button let you reverse?

Access-2019

Powerpoint-2019

Word-2019

Question Sets

Outlook-2019

Windows-10-2019

Filters