Question 1

A histogram chart displays each category as a rectangle and each subcategory nested within a rectangle.

Accepted Answer

A) True 
 B)False

Question 2

Soledad is working with a worksheet that groups data by quarter.The Quarter 4 details are hidden.She can click the Auto Outline button to display the hidden data.

Accepted Answer

A) True 
 B)False

Question 3

You can copy and paste only the cell validation by copying a cell with data validation, right-clicking the destination cell, clicking Paste Special, then clicking the Rules button in the Paste Special dialog box.

Accepted Answer

A) True 
 B)False

Question 4

Which worksheet view shows headers, footers, and rulers?

Accepted Answer

A)  Normal view 
B)  Page Break Preview 
C)  Page Layout view 
D)  Formula view 
A)  Normal view 
B)  Page Break Preview 
C)  Page Layout view 
D)  Formula view

Question 5

Horatio wants to hide field headers in a PivotTable.He clicks the PivotTable, then clicks the PivotTable Tools Analyze tab on the ribbon.What should he do next to complete the procedure?

Accepted Answer

A)  Click Clear in the Actions group. 
B)  Click +/- Buttons in the Show group. 
C)  Click Field Headers in the Show group. 
D)  Click Fields, Items & Sets in the Calculations group. 
A)  Click Clear in the Actions group. 
B)  Click +/- Buttons in the Show group. 
C)  Click Field Headers in the Show group. 
D)  Click Fields, Items & Sets in the Calculations group.

Question 6

A teacher creates a table for Sports Day events.The table includes columns for Event, Rank, First Name, and Last Name.To find the top-ranking participants for each event, the teacher can sort the table first by Event and then by Rank.

Accepted Answer

A) True 
 B)False

Question 7

After adding data validation criteria to a worksheet, which of the following features can you use to locate data that doesn't satisfy the criteria?

Accepted Answer

A)  What-If Analysis 
B)  Circle Invalid Data 
C)  Remove Duplicates 
D)  Trace Precedents 
A)  What-If Analysis 
B)  Circle Invalid Data 
C)  Remove Duplicates 
D)  Trace Precedents

Question 8

Which of the following is an effect you can apply to a picture?

Accepted Answer

A)  Slicer 
B)  Glow 
C)  Style Set 
D)  Transformation 
A)  Slicer 
B)  Glow 
C)  Style Set 
D)  Transformation

Question 9

What information do you need to provide to Solver so it can find the best solution to a problem? Select all the options that apply.

Accepted Answer

A)  break-even cell 
B)  target cell 
C)  changing cells 
D)  constraints 
A)  break-even cell 
B)  target cell 
C)  changing cells 
D)  constraints

Question 10

The COUNTIF function counts blank cells.

Accepted Answer

A) True 
 B)False

Question 11

Helen wants to resize slicer buttons to exact dimensions.She selects the slicer, then clicks the Slicer Tools under Options tab.What should she select next to reset the slicer buttons to exact dimensions?

Accepted Answer

A)  Height and Width under Size group 
B)  Height and Width under Buttons group 
C)  Format cells under Format in Cells group 
D)  Filter under Sort & Filter in Editing group 
A)  Height and Width under Size group 
B)  Height and Width under Buttons group 
C)  Format cells under Format in Cells group 
D)  Filter under Sort & Filter in Editing group

Question 12

The score of a student is inserted in cell B2.The passing score for the subject is 60.Which of the following functions should you insert in cell C2 to check whether the student has passed or failed?

Accepted Answer

A)  '=IF(B2>=60, "Pass", "Fail") 
B)  =IF(B2 = 60, "Pass", "Fail")) 
A)  '=IF(B2>=60, "Pass", "Fail") 
B)  =IF(B2 = 60, "Pass", "Fail"))

Question 13

Angie created a PivotTable that includes two levels of data in each row, but now shows only the first level of data.She can click the Expand button in one row to display both levels of data.

Accepted Answer

A) True 
 B)False

Question 14

When you right-click a cell containing a hyperlink, which of the following commands should you select to remove cell contents along with the hyperlink?

Accepted Answer

A)  Remove Hyperlink 
B)  Clear Contents 
C)  Edit Hyperlink 
D)  Clear Formats 
A)  Remove Hyperlink 
B)  Clear Contents 
C)  Edit Hyperlink 
D)  Clear Formats

Question 15

Charlie imported data that displays "Albany, NY" in cell A24.What formula can he use to display "NY" in cell D3?

Accepted Answer

A)  =LEFT(A24, 2) 
B)  =RIGHT(A24, 2) 
C)  =LOWER(A24) 
D)  =EXTRACT(A24, 2) 
A)  =LEFT(A24, 2) 
B)  =RIGHT(A24, 2) 
C)  =LOWER(A24) 
D)  =EXTRACT(A24, 2)

Question 16

To display a duplicate of a chart on another worksheet, select the chart and then click the Move button in the Clipboard group.

Accepted Answer

A) True 
 B)False

Question 17

Which of the following is not a way to move cell contents?

Accepted Answer

A)  clicking the Cut and Paste buttons on the Home tab 
B)  pressing the CTRL+X keys 
C)  holding the CTRL key while dragging the selected cells 
D)  using drag-and-drop 
A)  clicking the Cut and Paste buttons on the Home tab 
B)  pressing the CTRL+X keys 
C)  holding the CTRL key while dragging the selected cells 
D)  using drag-and-drop

Question 18

Which of the following formulas totals the cells B6, B7, B8, B9, and B10 most efficiently?

Accepted Answer

A)  The formula =B6+B7+B8+B9+B10. 
B)  The formula =TOTAL(B6-B10) 
C)  The formula =SUM(B6:B10) 
D)  The formula +SUM(B6-B10) 
A)  The formula =B6+B7+B8+B9+B10. 
B)  The formula =TOTAL(B6-B10) 
C)  The formula =SUM(B6:B10) 
D)  The formula +SUM(B6-B10)

Question 19

Jonathan wants to filter a table, but it does not display filter arrows.With the table selected, how can he display the filter arrows? Select all the options that apply.

Accepted Answer

A)  Click the Sort & Filter button on the Home tab, then click Filter., 
B)  Click the Filter button on the Data tab. 
C)  Click the Filter Button check box on the Table Tools Design tab. 
D)  Right-click a table column heading, then click Filter Arrows. 
A)  Click the Sort & Filter button on the Home tab, then click Filter., 
B)  Click the Filter button on the Data tab. 
C)  Click the Filter Button check box on the Table Tools Design tab. 
D)  Right-click a table column heading, then click Filter Arrows.

Question 20

Martha created a table where employees can enter customer data.She wants to display a reminder when an employee clicks a cell in the Contact Type column Which of the following should she use?

Accepted Answer

A)  Header row 
B)  Table alert 
C)  Input message 
D)  Insert message 
A)  Header row 
B)  Table alert 
C)  Input message 
D)  Insert message

A histogram chart displays each category as a rectangle and each subcategory nested within a rectangle.

Soledad is working with a worksheet that groups data by quarter.The Quarter 4 details are hidden.She can click the Auto Outline button to display the hidden data.

You can copy and paste only the cell validation by copying a cell with data validation, right-clicking the destination cell, clicking Paste Special, then clicking the Rules button in the Paste Special dialog box.

Which worksheet view shows headers, footers, and rulers?

Horatio wants to hide field headers in a PivotTable.He clicks the PivotTable, then clicks the PivotTable Tools Analyze tab on the ribbon.What should he do next to complete the procedure?

A teacher creates a table for Sports Day events.The table includes columns for Event, Rank, First Name, and Last Name.To find the top-ranking participants for each event, the teacher can sort the table first by Event and then by Rank.

After adding data validation criteria to a worksheet, which of the following features can you use to locate data that doesn't satisfy the criteria?

Which of the following is an effect you can apply to a picture?

What information do you need to provide to Solver so it can find the best solution to a problem? Select all the options that apply.

The COUNTIF function counts blank cells.

Helen wants to resize slicer buttons to exact dimensions.She selects the slicer, then clicks the Slicer Tools under Options tab.What should she select next to reset the slicer buttons to exact dimensions?

The score of a student is inserted in cell B2.The passing score for the subject is 60.Which of the following functions should you insert in cell C2 to check whether the student has passed or failed?

Angie created a PivotTable that includes two levels of data in each row, but now shows only the first level of data.She can click the Expand button in one row to display both levels of data.

When you right-click a cell containing a hyperlink, which of the following commands should you select to remove cell contents along with the hyperlink?

Charlie imported data that displays "Albany, NY" in cell A24.What formula can he use to display "NY" in cell D3?

To display a duplicate of a chart on another worksheet, select the chart and then click the Move button in the Clipboard group.

Which of the following is not a way to move cell contents?

Which of the following formulas totals the cells B6, B7, B8, B9, and B10 most efficiently?

Jonathan wants to filter a table, but it does not display filter arrows.With the table selected, how can he display the filter arrows? Select all the options that apply.

Martha created a table where employees can enter customer data.She wants to display a reminder when an employee clicks a cell in the Contact Type column Which of the following should she use?

Word

Windows

Assessment

Powerpoint

Assessment

Outlook

Access

Technology and Digital Ethics

Filters

Exam 7: Excel

A histogram chart displays each category as a rectangle and each subcategory nested within a rectangle.

Soledad is working with a worksheet that groups data by quarter.The Quarter 4 details are hidden.She can click the Auto Outline button to display the hidden data.

You can copy and paste only the cell validation by copying a cell with data validation, right-clicking the destination cell, clicking Paste Special, then clicking the Rules button in the Paste Special dialog box.

Which worksheet view shows headers, footers, and rulers?

Horatio wants to hide field headers in a PivotTable.He clicks the PivotTable, then clicks the PivotTable Tools Analyze tab on the ribbon.What should he do next to complete the procedure?

A teacher creates a table for Sports Day events.The table includes columns for Event, Rank, First Name, and Last Name.To find the top-ranking participants for each event, the teacher can sort the table first by Event and then by Rank.

After adding data validation criteria to a worksheet, which of the following features can you use to locate data that doesn't satisfy the criteria?

Which of the following is an effect you can apply to a picture?

What information do you need to provide to Solver so it can find the best solution to a problem? Select all the options that apply.

The COUNTIF function counts blank cells.

Helen wants to resize slicer buttons to exact dimensions.She selects the slicer, then clicks the Slicer Tools under Options tab.What should she select next to reset the slicer buttons to exact dimensions?

The score of a student is inserted in cell B2.The passing score for the subject is 60.Which of the following functions should you insert in cell C2 to check whether the student has passed or failed?

Angie created a PivotTable that includes two levels of data in each row, but now shows only the first level of data.She can click the Expand button in one row to display both levels of data.

When you right-click a cell containing a hyperlink, which of the following commands should you select to remove cell contents along with the hyperlink?

Charlie imported data that displays "Albany, NY" in cell A24.What formula can he use to display "NY" in cell D3?

To display a duplicate of a chart on another worksheet, select the chart and then click the Move button in the Clipboard group.

Which of the following is not a way to move cell contents?

Which of the following formulas totals the cells B6, B7, B8, B9, and B10 most efficiently?

Jonathan wants to filter a table, but it does not display filter arrows.With the table selected, how can he display the filter arrows? Select all the options that apply.

Martha created a table where employees can enter customer data.She wants to display a reminder when an employee clicks a cell in the Contact Type column Which of the following should she use?

Word

Windows

Assessment

Powerpoint

Assessment

Outlook

Access

Technology and Digital Ethics

Filters