Question 1

Which of the following Excel features applies a design using theme colors to a table?

Accepted Answer

A)  table style 
B)  cell style 
C)  font style 
D)  number format 
A)  table style 
B)  cell style 
C)  font style 
D)  number format

Question 2

Maria entered three option buttons in a column on a worksheet and linked them to cell B2.When a user clicks the second option button, Excel inserts "2" in cell B2.

Accepted Answer

A) True 
 B)False

Question 3

You've copied a cell containing formula to the rows below it, and the results in the copied cells are all zeros.To find the problem, what should you check for in your original formula?

Accepted Answer

A)  If it needs an absolute cell reference. 
B)  If it needs a relative cell reference. 
C)  If it needs landscape orientation. 
D)  If it needs a function. 
A)  If it needs an absolute cell reference. 
B)  If it needs a relative cell reference. 
C)  If it needs landscape orientation. 
D)  If it needs a function.

Question 4

Tricia created a defined name for a range but no longer wants to use it.What dialog box can she use to delete the defined name?

Accepted Answer

A)  Define Names dialog box 
B)  Name Manager dialog box 
C)  Scope dialog box 
D)  New Name dialog box 
A)  Define Names dialog box 
B)  Name Manager dialog box 
C)  Scope dialog box 
D)  New Name dialog box

Question 5

If you change data used in the data model, what should you do?

Accepted Answer

A)  Refresh the data. 
B)  Reset the relationships. 
C)  Add the new data to the data model. 
D)  Display the data in Table view. 
A)  Refresh the data. 
B)  Reset the relationships. 
C)  Add the new data to the data model. 
D)  Display the data in Table view.

Question 6

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 7

When you create a scenario summary report, it is linked to the data so that if you change the data values, the report updates automatically.

Accepted Answer

A) True 
 B)False

Question 8

After creating a table, you can add preset formatting combinations of fill color, borders, type style, and type color by apply a table format.

Accepted Answer

A) True 
 B)False

Question 9

Musa wants to customize the fonts he uses in a workbook.He can change the heading font and the _____ font.

Accepted Answer

A)  body 
B)  normal 
C)  title 
D)  total 
A)  body 
B)  normal 
C)  title 
D)  total

Question 10

To change the actions in a recorded macro, you can open the macro in the Visual Basic Editor.

Accepted Answer

A) True 
 B)False

Question 11

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 12

Changing a worksheet window to Normal view changes the contents of the worksheet.

Accepted Answer

A) True 
 B)False

Question 13

If you want to change all occurrences of "Radio" to "TV" in a worksheet, you can use the _____ command.

Accepted Answer

A)  Replace 
B)  Find 
C)  Select 
D)  Paste 
A)  Replace 
B)  Find 
C)  Select 
D)  Paste

Question 14

After creating a PivotTable, you can refresh its data, but you cannot change the data source.

Accepted Answer

A) True 
 B)False

Question 15

A student enters the names of months in cells A2 to A5 with the heading "Month" in cell A1.Then he enters the number of days in each moth in cells B2 to B5 with the heading "Days" in cell B2.In order to arrange the names of the months in cells A6 to E6 with heading "Month" in cell A6 and the number of days each month in cells A7 to E7 with heading "Days" in cell A7, he can use the formula =TRANSPOSE(A1:B5).

Accepted Answer

A) True 
 B)False

Question 16

To add a worksheet to a workbook, you would use the New formula tab below the worksheet.

Accepted Answer

A) True 
 B)False

Question 17

Rohan can display the current date in a cell using the TODAY() function.

Accepted Answer

A) True 
 B)False

Question 18

The formula =ROUNDUP(G5,0) can be used to round up 59.425, entered in cell G5, to 60

Accepted Answer

A) True 
 B)False

Question 19

Carol wants to redisplay a workbook window she had hidden earlier.Which button should she click on the View tab?

Accepted Answer

A)  Unhide 
B)  Arrange All 
C)  Reset 
D)  Redisplay Window 
A)  Unhide 
B)  Arrange All 
C)  Reset 
D)  Redisplay Window

Question 20

To change the number format of a Value field in a PivotTable from General to Currency, you change the number format in the data source.

Accepted Answer

A) True 
 B)False

Which of the following Excel features applies a design using theme colors to a table?

Maria entered three option buttons in a column on a worksheet and linked them to cell B2.When a user clicks the second option button, Excel inserts "2" in cell B2.

You've copied a cell containing formula to the rows below it, and the results in the copied cells are all zeros.To find the problem, what should you check for in your original formula?

Tricia created a defined name for a range but no longer wants to use it.What dialog box can she use to delete the defined name?

If you change data used in the data model, what should you do?

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?

When you create a scenario summary report, it is linked to the data so that if you change the data values, the report updates automatically.

After creating a table, you can add preset formatting combinations of fill color, borders, type style, and type color by apply a table format.

Musa wants to customize the fonts he uses in a workbook.He can change the heading font and the _____ font.

To change the actions in a recorded macro, you can open the macro in the Visual Basic Editor.

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

Changing a worksheet window to Normal view changes the contents of the worksheet.

If you want to change all occurrences of "Radio" to "TV" in a worksheet, you can use the _____ command.

After creating a PivotTable, you can refresh its data, but you cannot change the data source.

To add a worksheet to a workbook, you would use the New formula tab below the worksheet.

Rohan can display the current date in a cell using the TODAY() function.

The formula =ROUNDUP(G5,0) can be used to round up 59.425, entered in cell G5, to 60

Carol wants to redisplay a workbook window she had hidden earlier.Which button should she click on the View tab?

To change the number format of a Value field in a PivotTable from General to Currency, you change the number format in the data source.

Word

Windows

Assessment

Powerpoint

Assessment

Outlook

Access

Technology and Digital Ethics

Filters

Exam 7: Excel

Which of the following Excel features applies a design using theme colors to a table?

Maria entered three option buttons in a column on a worksheet and linked them to cell B2.When a user clicks the second option button, Excel inserts "2" in cell B2.

You've copied a cell containing formula to the rows below it, and the results in the copied cells are all zeros.To find the problem, what should you check for in your original formula?

Tricia created a defined name for a range but no longer wants to use it.What dialog box can she use to delete the defined name?

If you change data used in the data model, what should you do?

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?

When you create a scenario summary report, it is linked to the data so that if you change the data values, the report updates automatically.

After creating a table, you can add preset formatting combinations of fill color, borders, type style, and type color by apply a table format.

Musa wants to customize the fonts he uses in a workbook.He can change the heading font and the _____ font.

To change the actions in a recorded macro, you can open the macro in the Visual Basic Editor.

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

Changing a worksheet window to Normal view changes the contents of the worksheet.

If you want to change all occurrences of "Radio" to "TV" in a worksheet, you can use the _____ command.

After creating a PivotTable, you can refresh its data, but you cannot change the data source.

To add a worksheet to a workbook, you would use the New formula tab below the worksheet.

Rohan can display the current date in a cell using the TODAY() function.

The formula =ROUNDUP(G5,0) can be used to round up 59.425, entered in cell G5, to 60

Carol wants to redisplay a workbook window she had hidden earlier.Which button should she click on the View tab?

To change the number format of a Value field in a PivotTable from General to Currency, you change the number format in the data source.

Word

Windows

Assessment

Powerpoint

Assessment

Outlook

Access

Technology and Digital Ethics

Filters