Question 1

Which of the following are ways to display comments attached to worksheet cells? Select all the options that apply.

Accepted Answer

A)  Click the Show Comments button on the Review tab. 
B)  Move the pointer over a cell containing a comment indicator. 
C)  Click the New Comment button on the Review tab. 
D)  Click the Notes button on the Review tab. 
A)  Click the Show Comments button on the Review tab. 
B)  Move the pointer over a cell containing a comment indicator. 
C)  Click the New Comment button on the Review tab. 
D)  Click the Notes button on the Review tab.

Question 2

Which property do you use to change the text displayed on a form control?

Accepted Answer

A)  Caption 
B)  Tag 
C)  Display Name 
D)  Label 
A)  Caption 
B)  Tag 
C)  Display Name 
D)  Label

Question 3

As you edit a worksheet, you can use the _____ to see how changes to cells affect selected worksheet formulas.

Accepted Answer

A)  Trace Error dialog box 
B)  IFERROR function 
C)  Auditing window 
D)  Watch Window 
A)  Trace Error dialog box 
B)  IFERROR function 
C)  Auditing window 
D)  Watch Window

Question 4

Excel Solver is a(n) _____, which means it must be installed before you can use it for the first time.

Accepted Answer

A)  constraint 
B)  hidden feature 
C)  macro 
D)  add-in 
A)  constraint 
B)  hidden feature 
C)  macro 
D)  add-in

Question 5

To extract the seconds from the time entered in cell B1 as 12:00:52 PM, type =SECOND(B1) in cell C1 and press ENTER.

Accepted Answer

A) True 
 B)False

Question 6

What must you change to customize the background color of a Command Button (ActiveX Control)?

Accepted Answer

A)  Background property 
B)  Control property 
C)  Font property 
D)  BackColor property 
A)  Background property 
B)  Control property 
C)  Font property 
D)  BackColor property

Question 7

The _____ describes the structure of data tables and how they interact.

Accepted Answer

A)  data model 
B)  Solver 
C)  Scenario Manager 
D)  Goal Seek 
A)  data model 
B)  Solver 
C)  Scenario Manager 
D)  Goal Seek

Question 8

When you wrap and center a range, you combine the cells into one cell.

Accepted Answer

A) True 
 B)False

Question 9

Which of the following can you do to decrease the level of a SmartArt shape?

Accepted Answer

A)  Make the shape smaller. 
B)  Promote the shape. 
C)  Demote the shape. 
D)  Move the shape. 
A)  Make the shape smaller. 
B)  Promote the shape. 
C)  Demote the shape. 
D)  Move the shape.

Question 10

What is the correct formula to insert the date January 12, 1998 into a cell?

Accepted Answer

A)  =DATE(1998,1,12) 
B)  =DATE(1998,12,1) 
C)  =DATE(12-1-1998) 
D)  =DATE(1/12/1998) 
A)  =DATE(1998,1,12) 
B)  =DATE(1998,12,1) 
C)  =DATE(12-1-1998) 
D)  =DATE(1/12/1998)

Question 11

You can use the Excel equation tools to insert an equation for calculating the area of a circle.

Accepted Answer

A) True 
 B)False

Question 12

When you click the Add to Data Model button on the Power Pivot tab, you are adding a query to the data model.

Accepted Answer

A) True 
 B)False

Question 13

Henry imported text data, which appeared in all lowercase.To convert text such as "order date" to "Order Date," he can use the TEXTJOIN function.

Accepted Answer

A) True 
 B)False

Question 14

Rukha has created two custom views of a worksheet.In one view, all rows and columns can be seen whereas in the other, specific rows and columns are hidden.What can she do to be able to see the view that she needs to at a given point in time?

Accepted Answer

A)  Click Custom Views and double-click on the display settings she wants to see. 
B)  Under Windows group on the View tab, click on View Side by Side. 
C)  Under Windows group on the View tab, click on Switch Windows and select the View she wants. 
D)  Click Custom View and check the box beside Hidden rows, column and filter settings to see Custom view of all rows and columns shown while uncheck the box to see the Custom view of specific rows and columns hidden. 
A)  Click Custom Views and double-click on the display settings she wants to see. 
B)  Under Windows group on the View tab, click on View Side by Side. 
C)  Under Windows group on the View tab, click on Switch Windows and select the View she wants. 
D)  Click Custom View and check the box beside Hidden rows, column and filter settings to see Custom view of all rows and columns shown while uncheck the box to see the Custom view of specific rows and columns hidden.

Question 15

Cell A5 contains the number 24.7835.In another cell, Ariane wants to enter the number from cell A5 but rounded to two decimal places.Which of these formulas can she use to do so?

Accepted Answer

A)  =ROUND(A5,2) 
B)  =MROUND(A5,2) 
C)  =ROUND(A5,2.0) 
D)  =MROUND(A5,0.2) 
A)  =ROUND(A5,2) 
B)  =MROUND(A5,2) 
C)  =ROUND(A5,2.0) 
D)  =MROUND(A5,0.2)

Question 16

The Clipboard task pane shows the contents of the _____.

Accepted Answer

A)  Office Clipboard 
B)  Table Styles gallery 
C)  Quick Analysis tool 
D)  Recently-Used Add-Ins 
A)  Office Clipboard 
B)  Table Styles gallery 
C)  Quick Analysis tool 
D)  Recently-Used Add-Ins

Question 17

The results of formula =TIMEVALUE("10:30 AM") is the value 10:30.

Accepted Answer

A) True 
 B)False

Question 18

To which of the following locations can you move a PivotChart?

Accepted Answer

A)  New workbook 
B)  Worksheet in the current workbook 
C)  Worksheet in a different workbook 
D)  You cannot move a PivotChart. 
A)  New workbook 
B)  Worksheet in the current workbook 
C)  Worksheet in a different workbook 
D)  You cannot move a PivotChart.

Question 19

To copy a cell's formatting to another cell, which of the following can you use?

Accepted Answer

A)  Format Cells dialog box 
B)  Format Painter 
C)  Quick Analysis Tool 
D)  Format as Table 
A)  Format Cells dialog box 
B)  Format Painter 
C)  Quick Analysis Tool 
D)  Format as Table

Question 20

Cell A4 contains the time 10:27 pm.To round that time to the nearest 30-minute interval, use the formula =MROUND(A4,0:30).

Accepted Answer

A) True 
 B)False

Which of the following are ways to display comments attached to worksheet cells? Select all the options that apply.

Which property do you use to change the text displayed on a form control?

As you edit a worksheet, you can use the _____ to see how changes to cells affect selected worksheet formulas.

Excel Solver is a(n) _____, which means it must be installed before you can use it for the first time.

To extract the seconds from the time entered in cell B1 as 12:00:52 PM, type =SECOND(B1) in cell C1 and press ENTER.

What must you change to customize the background color of a Command Button (ActiveX Control)?

The _____ describes the structure of data tables and how they interact.

When you wrap and center a range, you combine the cells into one cell.

Which of the following can you do to decrease the level of a SmartArt shape?

What is the correct formula to insert the date January 12, 1998 into a cell?

You can use the Excel equation tools to insert an equation for calculating the area of a circle.

When you click the Add to Data Model button on the Power Pivot tab, you are adding a query to the data model.

Henry imported text data, which appeared in all lowercase.To convert text such as "order date" to "Order Date," he can use the TEXTJOIN function.

Rukha has created two custom views of a worksheet.In one view, all rows and columns can be seen whereas in the other, specific rows and columns are hidden.What can she do to be able to see the view that she needs to at a given point in time?

Cell A5 contains the number 24.7835.In another cell, Ariane wants to enter the number from cell A5 but rounded to two decimal places.Which of these formulas can she use to do so?

The Clipboard task pane shows the contents of the _____.

The results of formula =TIMEVALUE("10:30 AM") is the value 10:30.

To which of the following locations can you move a PivotChart?

To copy a cell's formatting to another cell, which of the following can you use?

Cell A4 contains the time 10:27 pm.To round that time to the nearest 30-minute interval, use the formula =MROUND(A4,0:30).

Word

Windows

Assessment

Powerpoint

Assessment

Outlook

Access

Technology and Digital Ethics

Filters

Exam 7: Excel

Which of the following are ways to display comments attached to worksheet cells? Select all the options that apply.

Which property do you use to change the text displayed on a form control?

As you edit a worksheet, you can use the _____ to see how changes to cells affect selected worksheet formulas.

Excel Solver is a(n) _____, which means it must be installed before you can use it for the first time.

To extract the seconds from the time entered in cell B1 as 12:00:52 PM, type =SECOND(B1) in cell C1 and press ENTER.

What must you change to customize the background color of a Command Button (ActiveX Control)?

The _____ describes the structure of data tables and how they interact.

When you wrap and center a range, you combine the cells into one cell.

Which of the following can you do to decrease the level of a SmartArt shape?

What is the correct formula to insert the date January 12, 1998 into a cell?

You can use the Excel equation tools to insert an equation for calculating the area of a circle.

When you click the Add to Data Model button on the Power Pivot tab, you are adding a query to the data model.

Henry imported text data, which appeared in all lowercase.To convert text such as "order date" to "Order Date," he can use the TEXTJOIN function.

Rukha has created two custom views of a worksheet.In one view, all rows and columns can be seen whereas in the other, specific rows and columns are hidden.What can she do to be able to see the view that she needs to at a given point in time?

Cell A5 contains the number 24.7835.In another cell, Ariane wants to enter the number from cell A5 but rounded to two decimal places.Which of these formulas can she use to do so?

The Clipboard task pane shows the contents of the _____.

The results of formula =TIMEVALUE("10:30 AM") is the value 10:30.

To which of the following locations can you move a PivotChart?

To copy a cell's formatting to another cell, which of the following can you use?

Cell A4 contains the time 10:27 pm.To round that time to the nearest 30-minute interval, use the formula =MROUND(A4,0:30).

Word

Windows

Assessment

Powerpoint

Assessment

Outlook

Access

Technology and Digital Ethics

Filters