A CSV file is a common file type in which each item of data is separated by a comma.

True

False

Correct!

Review the section "Importing and Exporting Data."

Your coworker sent you an Access database, and you want to analyze the information in Excel. To do this, you should first save the Access file as a CSV file.

True

False

Correct!

Review the section "Importing and Exporting Data."

You save transactions for your restaurant in a CSV file. To compare how many transactions were between $0–$50, $50–$100, and $100–$150, import the data into Excel and create a Histogram chart.

True

False

Correct!

Review the section "Additional Charts and Chart Tools."

To create a series of values that increase by 3% each time, you need to create a set of formulas.

True

False

Correct!

Review the section "Advanced Options for Filling a Data Series."

Using the XLOOKUP function allows you to lookup data that is either to the right or the left of the lookup column.

True

False

Correct!

Review the section "Additional Lookup and Logical Functions."

When you have data on multiple worksheets that have similar labels, such as months and categories, you should find the average of the values:

by copying and pasting the data into one sheet

by using the Consolidate tool

by using the MATCH function nested inside the INDEX function

by creating a data cube

Correct!

Review the section "Data Consolidation."

Amanda wants to save $20,000 in five years and is tracking her monthly progress against the goal. Column A shows the month and column C will be her actual savings. To show the goal in column B, she should:

Divide $20,000 by 60 and then type the values into column B.

Use the PMT function.

Enter 0 for the first value and $20,000 for the last value, and then use Fill Series to complete the rest.

Import the CSV file of her bank statement.

Correct!

Review the section "Advanced Options for Filling a Data Series."

Harnoor has asked you to help her create a function that will look up a transaction ID from column C and return its date from column A. You should:

tell her this is not possible in Excel

use the VLOOKUP function

use the AND function nested inside the VLOOKUP function

use the XLOOKUP function

Correct!

Review the section "Additional Lookup and Logical Functions."

You created a chart with specific settings you know you’ll want to use again and again. You should:

write down the settings so you can apply them later

use Format Painter to apply the same settings to other charts

save the chart as a template

save the file as a template

Correct!

Review the section "Saving a Chart as a Template."

You own a bike shop and track your inventory in an Access database. The item number would be one of the fields and each item would be a:

delimiter

table

query

record

Correct!

Review the section "Importing and Exporting Data."

You are tracking the price for several stocks you have invested in. To see how the overall price is moving, one option is to:

create a line chart and add a trendline

use a goal seek

fill a series based on the trend

create a histogram chart

Correct!

Review the section "Adding Trendlines."

To create a mail merge in Word, first you _____ the list of names from Excel by saving as a CSV; to use data from an Access table in Excel, you _____ the data using Get & Transform tools.

import, export

get, transform

copy, paste

export, import

Correct!

Review the section "Importing and Exporting Data."