Question 1

It is possible to go to the next comment using the Next Comment button in the Comments group on the Review tab.

Accepted Answer

A) True 
 B)False

Question 2

A worksheet named Income (2) is most likely which of the following?

Accepted Answer

A)  a deleted worksheet 
B)  a worksheet with no calculations 
C)  a repositioned worksheet 
D)  a copy of another worksheet named Income 
A)  a deleted worksheet 
B)  a worksheet with no calculations 
C)  a repositioned worksheet 
D)  a copy of another worksheet named Income

Question 3

Which of the following Shadow property values displays a shadow for Text Box (ActiveX Control)?

Accepted Answer

A)  Outer 
B)  Inner 
C)  True 
D)  False 
A)  Outer 
B)  Inner 
C)  True 
D)  False

Question 4

By default, Excel records which type of cell references in a macro?

Accepted Answer

A)  absolute 
B)  relative 
C)  mixed 
D)  hidden 
A)  absolute 
B)  relative 
C)  mixed 
D)  hidden

Question 5

If you change theme colors, you must restore the original colors before closing Excel.

Accepted Answer

A) True 
 B)False

Question 6

Sam wants to count the number of cells in the range B1: B20 that contain numbers.Which of the following formulas should he use?

Accepted Answer

A)  '=COUNT(B1:B20) 
B)  =COUNTA(B1:B20) 
C)  =SUM(B1:B20) 
D)  =CALCULATE(B1:B20) 
A)  '=COUNT(B1:B20) 
B)  =COUNTA(B1:B20) 
C)  =SUM(B1:B20) 
D)  =CALCULATE(B1:B20)

Question 7

Che has a Pie PivotChart that he wants to display with in a three-dimensional format.Which of the following should he do?

Accepted Answer

A)  Change the PivotChart type from Pie to 3-D Pie. 
B)  Apply shadows to the PivotChart., 
C)  Explode the slices in the PivotChart. 
D)  Replace the Pie PivotChart with a Doughnut PivotChart. 
A)  Change the PivotChart type from Pie to 3-D Pie. 
B)  Apply shadows to the PivotChart., 
C)  Explode the slices in the PivotChart. 
D)  Replace the Pie PivotChart with a Doughnut PivotChart.

Question 8

When you create a PivotChart directly from data, what does Excel do?

Accepted Answer

A)  Creates a corresponding PivotTable report 
B)  Recommends a chart type for the PivotChart 
C)  Freezes the data until you finish creating the PivotChart 
D)  Removes any existing PivotCharts from the worksheet 
A)  Creates a corresponding PivotTable report 
B)  Recommends a chart type for the PivotChart 
C)  Freezes the data until you finish creating the PivotChart 
D)  Removes any existing PivotCharts from the worksheet

Question 9

To ungroup a range of cells in a row in a worksheet, select the rows or columns you wish to ungroup, then click the Group command in the Outline group on the Data tab.In the Group dialog box, select Rows and click OK .

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

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

Accepted Answer

A) True 
 B)False

Question 12

Walter selected data on a worksheet to show in a chart.Which button on the Insert tab can he click to display charts appropriate for the selected data?

Accepted Answer

A)  PivotChart button 
B)  Illustrations button 
C)  Recommended Charts button 
D)  Appropriate Charts button 
A)  PivotChart button 
B)  Illustrations button 
C)  Recommended Charts button 
D)  Appropriate Charts button

Question 13

Your worksheet contains confidential information in column C; to prevent others who use your worksheet from seeing the data, you can _____ column C.

Accepted Answer

A)  delete 
B)  conditionally format 
C)  edit 
D)  hide 
A)  delete 
B)  conditionally format 
C)  edit 
D)  hide

Question 14

When you insert a worksheet row, a row is inserted above the cell pointer and the sheet contents move downward.

Accepted Answer

A) True 
 B)False

Question 15

After you define the scope for a named range, you can no longer edit the defined name.

Accepted Answer

A) True 
 B)False

Question 16

When you open a workbook, it contains one or more worksheets.

Accepted Answer

A) True 
 B)False

Question 17

Which of the following can you use to insert a formula using a function? Select all the options that apply.
A) Type the formula including the function.
B) Click the AutoSum button.
C) Click the AutoSum arrow.
D) Copy and paste a cell containing a function.

Accepted Answer

The answer of Which of the following can you use...

Question 18

A student types the formula '= YEAR( TODAY())-2005' to calculate the age of a person born in 2005.This formula will use the TODAY function as an argument for the YEAR function to obtain the current year, and then subtract 2005 returning the person's age.

Accepted Answer

A) True 
 B)False

Question 19

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 20

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))

It is possible to go to the next comment using the Next Comment button in the Comments group on the Review tab.

A worksheet named Income (2) is most likely which of the following?

Which of the following Shadow property values displays a shadow for Text Box (ActiveX Control)?

By default, Excel records which type of cell references in a macro?

If you change theme colors, you must restore the original colors before closing Excel.

Sam wants to count the number of cells in the range B1: B20 that contain numbers.Which of the following formulas should he use?

Che has a Pie PivotChart that he wants to display with in a three-dimensional format.Which of the following should he do?

When you create a PivotChart directly from data, what does Excel do?

To ungroup a range of cells in a row in a worksheet, select the rows or columns you wish to ungroup, then click the Group command in the Outline group on the Data tab.In the Group dialog box, select Rows and click OK .

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

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

Walter selected data on a worksheet to show in a chart.Which button on the Insert tab can he click to display charts appropriate for the selected data?

Your worksheet contains confidential information in column C; to prevent others who use your worksheet from seeing the data, you can _____ column C.

When you insert a worksheet row, a row is inserted above the cell pointer and the sheet contents move downward.

After you define the scope for a named range, you can no longer edit the defined name.

When you open a workbook, it contains one or more worksheets.

Which of the following can you use to insert a formula using a function? Select all the options that apply. A) Type the formula including the function. B) Click the AutoSum button. C) Click the AutoSum arrow. D) Copy and paste a cell containing a function.

A student types the formula '= YEAR( TODAY())-2005' to calculate the age of a person born in 2005.This formula will use the TODAY function as an argument for the YEAR function to obtain the current year, and then subtract 2005 returning the person's age.

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.

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?

Word

Windows

Assessment

Powerpoint

Assessment

Outlook

Access

Technology and Digital Ethics

Filters

Exam 7: Excel

It is possible to go to the next comment using the Next Comment button in the Comments group on the Review tab.

A worksheet named Income (2) is most likely which of the following?

Which of the following Shadow property values displays a shadow for Text Box (ActiveX Control)?

By default, Excel records which type of cell references in a macro?

If you change theme colors, you must restore the original colors before closing Excel.

Sam wants to count the number of cells in the range B1: B20 that contain numbers.Which of the following formulas should he use?

Che has a Pie PivotChart that he wants to display with in a three-dimensional format.Which of the following should he do?

When you create a PivotChart directly from data, what does Excel do?

To ungroup a range of cells in a row in a worksheet, select the rows or columns you wish to ungroup, then click the Group command in the Outline group on the Data tab.In the Group dialog box, select Rows and click OK .

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

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

Walter selected data on a worksheet to show in a chart.Which button on the Insert tab can he click to display charts appropriate for the selected data?

Your worksheet contains confidential information in column C; to prevent others who use your worksheet from seeing the data, you can _____ column C.

When you insert a worksheet row, a row is inserted above the cell pointer and the sheet contents move downward.

After you define the scope for a named range, you can no longer edit the defined name.

When you open a workbook, it contains one or more worksheets.

Which of the following can you use to insert a formula using a function? Select all the options that apply. A) Type the formula including the function. B) Click the AutoSum button. C) Click the AutoSum arrow. D) Copy and paste a cell containing a function.

A student types the formula '= YEAR( TODAY())-2005' to calculate the age of a person born in 2005.This formula will use the TODAY function as an argument for the YEAR function to obtain the current year, and then subtract 2005 returning the person's age.

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.

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?

Word

Windows

Assessment

Powerpoint

Assessment

Outlook

Access

Technology and Digital Ethics

Filters