Question 1

Use the Application Checker feature to check for formats that could prevent people with disabilities from interacting with data or Excel.

Accepted Answer

A) True 
 B)False

Question 2

You can insert an ActiveX text box in a worksheet to let users select from a set of possible options.

Accepted Answer

A) True 
 B)False

Question 3

If you link Excel data to a Word document and then decide not to maintain the connection between the files, you can break the link

Accepted Answer

A) True 
 B)False

Question 4

To format text so that it automatically appears in multiple lines within a cell, you can transpose it.

Accepted Answer

A) True 
 B)False

Question 5

You can move the PivotTable Fields pane, but you cannot hide it.

Accepted Answer

A) True 
 B)False

Question 6

Cell B1 contains the text "Manager: Vang." What is the result of the formula = SUBSTITUTE (B1, "Vang", "Garcia")?

Accepted Answer

A)  Manager: Vang 
B)  Vang: Manager 
C)  Garcia: Manager 
D)  Manager: Garcia 
A)  Manager: Vang 
B)  Vang: Manager 
C)  Garcia: Manager 
D)  Manager: Garcia

Question 7

A Sunburst chart is a type of scatter chart.

Accepted Answer

A) True 
 B)False

Question 8

To show formulas instead of values, click on the Formulas tab in the ribbon, then in the Formula Auditing group, click on the Show Formulas option.

Accepted Answer

A) True 
 B)False

Question 9

To move cell contents one space to the right, you can use the Increase Space button.

Accepted Answer

A) True 
 B)False

Question 10

How can you align all objects to the upper-left corner of a cell?

Accepted Answer

A)  Click the arrow next to Align on the Drawing Tools Format tab and then click Snap to Grid. 
B)  Click the arrow next to Align on the Drawing Tools Format tab and then click Snap to Shape. 
C)  Click the Drawing Tools Format tab, then click the arrow next to Align, and then click Align Top. 
D)  Click the Drawing Tools Format tab, then click the arrow next to Align, and then click Align Bottom. 
A)  Click the arrow next to Align on the Drawing Tools Format tab and then click Snap to Grid. 
B)  Click the arrow next to Align on the Drawing Tools Format tab and then click Snap to Shape. 
C)  Click the Drawing Tools Format tab, then click the arrow next to Align, and then click Align Top. 
D)  Click the Drawing Tools Format tab, then click the arrow next to Align, and then click Align Bottom.

Question 11

When you click a chart element such as a legend, it displays sizing handles to indicate it is selected.

Accepted Answer

A) True 
 B)False

Question 12

When you copy and paste a formula to a new location, the formula's relative references do not change.

Accepted Answer

A) True 
 B)False

Question 13

Ned has a table with an Expenses column listing monthly expenses.To total numbers in the Expenses column that are greater than 100, he can use the DSUM function.

Accepted Answer

A) True 
 B)False

Question 14

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 15

How are Excel tables and PivotTables similar?

Accepted Answer

A)  Both summarize data automatically. 
B)  Both have styles you can apply for quick formatting. 
C)  Both have Field Header buttons. 
D)  Both are based on data from another worksheet. 
A)  Both summarize data automatically. 
B)  Both have styles you can apply for quick formatting. 
C)  Both have Field Header buttons. 
D)  Both are based on data from another worksheet.

Question 16

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 17

Ursula wants to freeze the header row so that it remains visible while she scrolls down the worksheet.To do so, she can click the View tab and then click Freeze Top Row.

Accepted Answer

A) True 
 B)False

Question 18

After adding tables to the Data Model, where can you create a relationship between the tables?

Accepted Answer

A)  Power Pivot window 
B)  Connections pane 
C)  Query tab 
D)  Power View 
A)  Power Pivot window 
B)  Connections pane 
C)  Query tab 
D)  Power View

Question 19

Tracing dependents indicates which cells are affected by a formula error.

Accepted Answer

A) True 
 B)False

Question 20

When you remove duplicate records from a table, Excel can examine only one column for duplicate data.

Accepted Answer

A) True 
 B)False

Use the Application Checker feature to check for formats that could prevent people with disabilities from interacting with data or Excel.

You can insert an ActiveX text box in a worksheet to let users select from a set of possible options.

If you link Excel data to a Word document and then decide not to maintain the connection between the files, you can break the link

To format text so that it automatically appears in multiple lines within a cell, you can transpose it.

You can move the PivotTable Fields pane, but you cannot hide it.

Cell B1 contains the text "Manager: Vang." What is the result of the formula = SUBSTITUTE (B1, "Vang", "Garcia")?

A Sunburst chart is a type of scatter chart.

To show formulas instead of values, click on the Formulas tab in the ribbon, then in the Formula Auditing group, click on the Show Formulas option.

To move cell contents one space to the right, you can use the Increase Space button.

How can you align all objects to the upper-left corner of a cell?

When you click a chart element such as a legend, it displays sizing handles to indicate it is selected.

When you copy and paste a formula to a new location, the formula's relative references do not change.

Ned has a table with an Expenses column listing monthly expenses.To total numbers in the Expenses column that are greater than 100, he can use the DSUM function.

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

How are Excel tables and PivotTables similar?

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

Ursula wants to freeze the header row so that it remains visible while she scrolls down the worksheet.To do so, she can click the View tab and then click Freeze Top Row.

After adding tables to the Data Model, where can you create a relationship between the tables?

Tracing dependents indicates which cells are affected by a formula error.

When you remove duplicate records from a table, Excel can examine only one column for duplicate data.

Word

Windows

Assessment

Powerpoint

Assessment

Outlook

Access

Technology and Digital Ethics

Filters

Exam 7: Excel

Use the Application Checker feature to check for formats that could prevent people with disabilities from interacting with data or Excel.

You can insert an ActiveX text box in a worksheet to let users select from a set of possible options.

If you link Excel data to a Word document and then decide not to maintain the connection between the files, you can break the link

To format text so that it automatically appears in multiple lines within a cell, you can transpose it.

You can move the PivotTable Fields pane, but you cannot hide it.

Cell B1 contains the text "Manager: Vang." What is the result of the formula = SUBSTITUTE (B1, "Vang", "Garcia")?

A Sunburst chart is a type of scatter chart.

To show formulas instead of values, click on the Formulas tab in the ribbon, then in the Formula Auditing group, click on the Show Formulas option.

To move cell contents one space to the right, you can use the Increase Space button.

How can you align all objects to the upper-left corner of a cell?

When you click a chart element such as a legend, it displays sizing handles to indicate it is selected.

When you copy and paste a formula to a new location, the formula's relative references do not change.

Ned has a table with an Expenses column listing monthly expenses.To total numbers in the Expenses column that are greater than 100, he can use the DSUM function.

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

How are Excel tables and PivotTables similar?

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

Ursula wants to freeze the header row so that it remains visible while she scrolls down the worksheet.To do so, she can click the View tab and then click Freeze Top Row.

After adding tables to the Data Model, where can you create a relationship between the tables?

Tracing dependents indicates which cells are affected by a formula error.

When you remove duplicate records from a table, Excel can examine only one column for duplicate data.

Word

Windows

Assessment

Powerpoint

Assessment

Outlook

Access

Technology and Digital Ethics

Filters