Getting data from sources in Excel - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the formula to import data from another sheet named 'Sales'.

Excel

=[1]('Sales'!A1)

Drag options to blanks, or click blank then click option'

AINDIRECT

BSUM

CVLOOKUP

DAVERAGE

Attempts:

3 left

💡 Hint

Common Mistakes

Using SUM or AVERAGE instead of INDIRECT will not fetch data from another sheet.

VLOOKUP is for searching data, not directly referencing a cell.

The INDIRECT function lets you refer to a cell or range by text, so you can get data from another sheet by specifying its name and cell.

2fill in blank

medium

Complete the formula to import data from a CSV file located at 'C:\Data\report.csv'.

Excel

=[1]("C:\\Data\\report.csv")

Drag options to blanks, or click blank then click option'

AQUERY

BWEBSERVICE

CIMPORTDATA

DFILTER

Attempts:

3 left

💡 Hint

Common Mistakes

WEBSERVICE fetches data from web services, not CSV files.

FILTER and QUERY are for filtering data already in sheets.

IMPORTDATA is used to import data from CSV or TSV files by specifying the file path or URL.

3fill in blank

hard

Fix the error in the formula to import data from a web URL 'http://example.com/data.csv'.

Excel

=IMPORTDATA([1])

Drag options to blanks, or click blank then click option'

A'http://example.com/data.csv'

Bhttp://example.com/data.csv

Chttp://example.com/data.csv"

D"http://example.com/data.csv"

Attempts:

3 left

💡 Hint

Common Mistakes

Leaving the URL without quotes causes a formula error.

Using mismatched or single quotes may not work in Excel formulas.

The URL must be enclosed in double quotes to be recognized as a text string in the formula.

4fill in blank

hard

Fill both blanks to create a formula that imports data from a named range 'DataRange' in another workbook 'Book1.xlsx'.

Excel

='[[1]]Sheet1'![2]

Drag options to blanks, or click blank then click option'

ABook1.xlsx

BBook2.xlsx

CDataRange

DA1:B10

Attempts:

3 left

💡 Hint

Common Mistakes

Using the wrong workbook name or range will cause errors.

Forgetting the square brackets around the workbook name.

The formula references the workbook name in square brackets and the named range to get data from that range.

5fill in blank

hard

Fill all three blanks to create a formula that imports data from a web API URL stored in cell A1, then filters rows where column B is greater than 100.

Excel

=FILTER(IMPORTDATA([1]), [2] > [3])

Drag options to blanks, or click blank then click option'

AA1

BB:B

C100

D"http://api.example.com/data.csv"

Attempts:

3 left

💡 Hint

Common Mistakes

Putting the URL as a text string instead of a cell reference.

Using the wrong column reference or comparison value.

The IMPORTDATA function uses the URL in cell A1. FILTER then selects rows where column B values are greater than 100.