Question 1. If the destination file is closed when you make a change in the source file, you choose whether to update the link to display the current values when you open the destination file or continue to display the older values from the destination file.

• True false
• 2.When you add a field to the Filters area of a PivotTable, Excel displays a slicer near the top of the worksheet. True False
• Question 3

A ____ is a workbook that you can open with the text, formats, and formulas already built into it.

• range master boiler summary sheet template

Question 4

To change the order of operations, enclose part of the formula in ____.

• quotation marks parenthese italics brackets

Question 5

When you copy a formula that contains an absolute reference to a new location, the reference ____.

becomes bold

does not change is updated automatically

has a dotted outline in its cell

Question 6

The _____ command searches through the current worksheet or workbook for the content or formatting you want to locate.

Seek Find Search Locate

Question 7

Michelle finished a 5 kilometer run in 180th position. The organizers shared an Excel spreadsheet with names of all the participants and the time they took to complete the race. The top 15 finishers are listed in rows 2 to 16. Michelle wants to compare her time against theirs. How can she do so?

Select rows 2 to 16 and click View tab > Window group > New Window > Split.

Select row 17 and click View tab > Window group > Split.

Select rows 2 to 16 and click View tab > Window group > Split.

Select row 16 and click View tab > W

Question 8

Which of the following are ways to format the appearance of a slicer? Select all the options that apply.

Slicer style

Slicer size

Button size Number of columns

Question 9

To move or copy a range of cells, select the correct order:

1. Move the pointer over the border of the selection until the pointer changes shape.

2. Select the cell or range you want to move or copy.

3. To move the range, click the border and drag the selection to a new location, or to copy the range, hold down the Ctrl key and drag the selection to a new location.

1,2,3 2,1,3 1,3,2

3,2,1

Question 10

Which function counts how many cells in a range contain numbers, where value1, value2, and so forth are text, numbers, or cell references?

SUM COUNTA AUTOSUM COUNT