Sarah spends a lot of time cutting and pasting titles and headings and adjusting the formatting each month to create a sales report for her boss; Sarah could save time by creating a template.

True

False

Correct!

Review the section “Starting with a Template."

Freezing panes allows you to view four different areas of your worksheet at once.

True

False

Correct!

Review the section “Freeze Panes."

The IF function is useful in situations in which there are two, three, or even four possible outcomes.

True

False

Correct!

Review the section “The IF Function."

Data validation sets criteria for a cell or range that limits the possible entries in that cell or range.

True

False

Correct!

Review the section "Controlling Data Entry with Data Validation."

If you have a large list of employees sorted by department, and you want each department to print on a separate page, you need to insert page breaks between the departments.

True

False

Correct!

Review the section “Printing Options for Large Worksheets."

After inserting a table based on a range of data, you will not be able to remove the table formatting and convert the table data back to a normal range of data.

True

False

Correct!

Review the section “Create Tables."

A filter was applied to the list in the first image to show only two guests in the second image. Which filter was applied to obtain the result?

Shows three columns of data under the headings Guest, Industry, and Attending. There are eight names in the Guest column; the Industry column contains the categories Auto, Finance, Marketing, and Retail; the Attending column shows either Yes or No.

Second image shows a filter applied to the data in the first image; the results show two guests: Jessica McInnis from the Auto Industry, who is attending, and John Aikens from the Retail Industry, who is not attending. Sarah Mullins from the Auto industry, who is included in the first image, is not included in the filtered list.

Guest names that end with S

Guests in the Auto or Retail industry

Guest names that begin with J

Guests who said Yes to attending

Correct!

Review the section “Filter Data."

What view allows you to view and edit margins, headers, and footers?

Page Layout view

Page Break Preview

Normal view

Print Preview

Correct!

Review the section “Change the Workbook View."

Jonah is managing the guest list for an upcoming event at his work. His boss asks to see the guest list filtered to show who is attending and sorted in alphabetical (A to Z) order by industry. Based on this guest list, which figure shows the correct result?

A portion of a workbook with the range A1:C9 showing in table format. Row 1 is the header row populated with cell A1: Guest, cell B1: Industry, cell C1: Attending. The data in the range A2:C9 is not sorted by any column, and there are no filters applied.

A table showing all of the rows from the previous guest list, sorted in alphabetical order by the Industry column (column B).

The Guest column is sorted in alphabetical order by first name, and the Attending column is filtered to show only the Yes data. Rows 4, 5, and 9 have been filtered from the table.

The Industry column is sorted in alphabetical order, and the Attending column is filtered to show only the Yes data. Rows 4, 5, and 9 have been filtered from the table.

The Guest column is sorted in alphabetical order by first name, and the Attending column is filtered to show only the No data. Rows 2, 3, 6, 7, and 8 have been filtered from the table.

Correct!

Review the section “Sort and Filter to Organize Data."

Cheyenne is determining raises for her employees. Those who have been with the company longer than ten years get a 4% raise; everyone else gets 2%. The formula for Sarah is written =IF(D3>10,B3*4%,B3*2%). Considering that, what is Felecia’s raise?

A portion of a workbook with the range A1:E10 showing in table format. Row 2 is the header row populated with cell A2: Employee, cell B2: Salary, cell C2: Department, cell D2: Years, cell E2: Raise. Ten employee names are showing (column A), and for each, the Salary, Department, and Years columns (columns B–D, respectively) are populated. In the Raise column, data is showing in the range E3:E5 only. Data for row 3: Employee: Sarah Mullins, Salary: $28,000, Department: Marketing, Years: 11, Raise: $1,120. Data for row 6: Employee: Felecia Murray, Salary: $30,000, Department: Retail, Years: 12, Raise: [empty cell]

$300

$3,000

$600

$1,200

Correct!

Review the section “The IF Function."

Under a data validation rule with these details, an entry of _____ would NOT be allowed.

Portion of the Data Validation dialog box with the Settings tab showing. Allow box: Decimal, Ignore Blank checkbox: Checked, Data box: between, Minimum: 1, Maximum: 10

3

7.5

0

10

Correct!

Review the section “Controlling Data Entry with Data Validation."

Samantha wants to print the headings in row 3 at the top of each page of her four-page workbook. Which feature should she use?

Print Titles

Print Area

Freeze Panes

Scale to Fit

Correct!

Review the section “Printing Options for Large Worksheets."