Question 1

A student is given the task of counting the number of nonblank cells in the range of cells B1 to B20. Which of the following formulas should he use to do so?

Accepted Answer

A)  =COUNT(B1:B20) 
B)  =COUNTIF(B1:B20) 
C)  =COUNTA(B1:B20) 
D)  =DCOUNTA(B1:B20) 
A)  =COUNT(B1:B20) 
B)  =COUNTIF(B1:B20) 
C)  =COUNTA(B1:B20) 
D)  =DCOUNTA(B1:B20)

Question 2

Marco wants to estimate his annual expenses for the next five years. He thinks they will increase by 5 percent each year. He should use a growth trend to calculate the expenses.

Accepted Answer

A) True 
 B)False

Question 3

Which type of constraint should you use to limit the answer to a whole number, such as for employees needed?

Accepted Answer

A)  bin 
B)  dif 
C)  int 
D)  = (equals) 
A)  bin 
B)  dif 
C)  int 
D)  = (equals)

Question 4

What can you do to make data series easier to distinguish from one another?

Accepted Answer

A)  Change the chart type. 
B)  Change the color of the data series. 
C)  Apply additional text styles. 
D)  Increase the size of the data series. 
A)  Change the chart type. 
B)  Change the color of the data series. 
C)  Apply additional text styles. 
D)  Increase the size of the data series.

Question 5

Harry has a PivotTable listing Stores and the revenue they produce. He wants to calculate the difference between the revenue from one store and another. What should he create?

Accepted Answer

A)  calculated item 
B)  measure 
C)  hierarchy 
D)  custom list 
A)  calculated item 
B)  measure 
C)  hierarchy 
D)  custom list

Question 6

Kylie created 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)  Text filter 
B)  Top Values filter 
C)  Number filter 
D)  Form filter 
A)  Text filter 
B)  Top Values filter 
C)  Number filter 
D)  Form filter

Question 7

If you want to sort data first by department, and then by last name, the last name field is the _____ sort field.

Accepted Answer

A)  primary 
B)  limited 
C)  secondary 
D)  minor 
A)  primary 
B)  limited 
C)  secondary 
D)  minor

Question 8

Which of the following is true about deleting a worksheet row?

Accepted Answer

A)  After you delete a row, the rows below it shift down one row. 
B)  Deleting a row and clearing a row have the same results 
C)  To delete a row, you can select the row, and then click the Delete button in the Cells group. 
D)  You cannot delete a row if it contains data. 
A)  After you delete a row, the rows below it shift down one row. 
B)  Deleting a row and clearing a row have the same results 
C)  To delete a row, you can select the row, and then click the Delete button in the Cells group. 
D)  You cannot delete a row if it contains data.

Question 9

To insert information that appears at the bottom of every worksheet page, you can use a command on the Insert tab.

Accepted Answer

A) True 
 B)False

Question 10

Maya created a table with the totals in the last column on the right. Which of the following table style options should she apply to call attention to the totals?

Accepted Answer

A)  Total Row 
B)  Last Column 
C)  Banded Columns 
D)  Header Row 
A)  Total Row 
B)  Last Column 
C)  Banded Columns 
D)  Header Row

Question 11

To change the contents of a macro, you must use the Record Macro button to step into the macro.

Accepted Answer

A) True 
 B)False

Question 12

Edwin wants to insert a PivotChart to summarize sales data. On which of the following does he need to base the new PivotChart?

Accepted Answer

A)  an existing PivotTable 
B)  another PivotChart 
C)  a column or bar chart on another worksheet 
D)  a slicer on the same worksheet 
A)  an existing PivotTable 
B)  another PivotChart 
C)  a column or bar chart on another worksheet 
D)  a slicer on the same worksheet

Question 13

Cell B5 contains the formula =A5*10. Cell A5 is a dependent cell for cell B5.

Accepted Answer

A) True 
 B)False

Question 14

Tamara wants to count the number of values in the Rating column that are greater than 7. Which of the following functions should she use?

Accepted Answer

A)  DCOUNT 
B)  DCOUNTA 
C)  COUNTIF 
D)  COUNTAIF 
A)  DCOUNT 
B)  DCOUNTA 
C)  COUNTIF 
D)  COUNTAIF

Question 15

To create a relationship between two tables, the first step would be to click on Relationships in the Relationships group on the Database Tools tab.

Accepted Answer

A) True 
 B)False

Question 16

What does the IRR function calculate?

Accepted Answer

A)  The present value of an investment 
B)  The payback period for an investment 
C)  The interest rate for repayment of a loan 
D)  The internal rate of return for an investment 
A)  The present value of an investment 
B)  The payback period for an investment 
C)  The interest rate for repayment of a loan 
D)  The internal rate of return for an investment

Question 17

Which of the following is not true about setting column width?

Accepted Answer

A)  Column widths are expressed as the number of characters a column can contain. 
B)  The default column width is 8.43. 
C)  You can change the width of only one column at a time. 
D)  You can use the Format button in the Cells group to set an exact column width. 
A)  Column widths are expressed as the number of characters a column can contain. 
B)  The default column width is 8.43. 
C)  You can change the width of only one column at a time. 
D)  You can use the Format button in the Cells group to set an exact column width.

Question 18

When you freeze the top row of a worksheet, what part of the worksheet can you scroll?

Accepted Answer

A)  all rows below the top row 
B)  columns starting with column C 
C)  rows starting with row 4 
D)  only the lower-right pane of the worksheet 
A)  all rows below the top row 
B)  columns starting with column C 
C)  rows starting with row 4 
D)  only the lower-right pane of the worksheet

Question 19

The VLOOKUP function returns the position of a value found within a row or column

Accepted Answer

A) True 
 B)False

Question 20

Edie has a worksheet listing lectures scheduled for the year. She wants to know how many cells in the Rating column contain "Excellent." Which of the following functions should she use?

Accepted Answer

A)  DCOUNTA 
B)  COUNT 
C)  COUNTIF 
D)  COUNTAIF 
A)  DCOUNTA 
B)  COUNT 
C)  COUNTIF 
D)  COUNTAIF

A student is given the task of counting the number of nonblank cells in the range of cells B1 to B20. Which of the following formulas should he use to do so?

Marco wants to estimate his annual expenses for the next five years. He thinks they will increase by 5 percent each year. He should use a growth trend to calculate the expenses.

Which type of constraint should you use to limit the answer to a whole number, such as for employees needed?

What can you do to make data series easier to distinguish from one another?

Harry has a PivotTable listing Stores and the revenue they produce. He wants to calculate the difference between the revenue from one store and another. What should he create?

Kylie created 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?

If you want to sort data first by department, and then by last name, the last name field is the _____ sort field.

Which of the following is true about deleting a worksheet row?

To insert information that appears at the bottom of every worksheet page, you can use a command on the Insert tab.

Maya created a table with the totals in the last column on the right. Which of the following table style options should she apply to call attention to the totals?

To change the contents of a macro, you must use the Record Macro button to step into the macro.

Edwin wants to insert a PivotChart to summarize sales data. On which of the following does he need to base the new PivotChart?

Cell B5 contains the formula =A5*10. Cell A5 is a dependent cell for cell B5.

Tamara wants to count the number of values in the Rating column that are greater than 7. Which of the following functions should she use?

To create a relationship between two tables, the first step would be to click on Relationships in the Relationships group on the Database Tools tab.

What does the IRR function calculate?

Which of the following is not true about setting column width?

When you freeze the top row of a worksheet, what part of the worksheet can you scroll?

The VLOOKUP function returns the position of a value found within a row or column

Edie has a worksheet listing lectures scheduled for the year. She wants to know how many cells in the Rating column contain "Excellent." Which of the following functions should she use?

Access 2019

Outlook 2019

Powerpoint 2019

Windows 10 - 2019

Word 2019

Computer History and Components

Filters

Exam 2: Excel 2019

A student is given the task of counting the number of nonblank cells in the range of cells B1 to B20. Which of the following formulas should he use to do so?

Marco wants to estimate his annual expenses for the next five years. He thinks they will increase by 5 percent each year. He should use a growth trend to calculate the expenses.

Which type of constraint should you use to limit the answer to a whole number, such as for employees needed?

What can you do to make data series easier to distinguish from one another?

Harry has a PivotTable listing Stores and the revenue they produce. He wants to calculate the difference between the revenue from one store and another. What should he create?

Kylie created 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?

If you want to sort data first by department, and then by last name, the last name field is the _____ sort field.

Which of the following is true about deleting a worksheet row?

To insert information that appears at the bottom of every worksheet page, you can use a command on the Insert tab.

Maya created a table with the totals in the last column on the right. Which of the following table style options should she apply to call attention to the totals?

To change the contents of a macro, you must use the Record Macro button to step into the macro.

Edwin wants to insert a PivotChart to summarize sales data. On which of the following does he need to base the new PivotChart?

Cell B5 contains the formula =A5*10. Cell A5 is a dependent cell for cell B5.

Tamara wants to count the number of values in the Rating column that are greater than 7. Which of the following functions should she use?

To create a relationship between two tables, the first step would be to click on Relationships in the Relationships group on the Database Tools tab.

What does the IRR function calculate?

Which of the following is not true about setting column width?

When you freeze the top row of a worksheet, what part of the worksheet can you scroll?

The VLOOKUP function returns the position of a value found within a row or column

Edie has a worksheet listing lectures scheduled for the year. She wants to know how many cells in the Rating column contain "Excellent." Which of the following functions should she use?

Access 2019

Outlook 2019

Powerpoint 2019

Windows 10 - 2019

Word 2019

Computer History and Components

Filters