wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

Creating and Managing Workbooks

Total questions: 12

Worksheet time: 7mins

Name
Class
Date
1.

Which tab can you find templates?

(a)  

2.

To delete a worksheet by (a)   -clicking its tab and clicking Delete. Deleting a worksheet is permanent, so always make sure there is no important data in the worksheet before you delete it.

3.

Worksheet tabs can be color-coded by right-clicking and clicking Tab Color, then selecting a color. In Image 1, the February worksheet has a tab color applied to it.

a)

True

b)

False

4.

Which tab can you find the "get external data" group?

a)

Home

b)

Insert

c)

Data

d)

Formulas

5.

_____________ imports a table or query from an ____ database.

a)

Access

b)

Web

c)

Text

d)

Other Sources

6.

___________ opens a browser where you can search for data tables on the Internet to import. This is useful for importing bank statements, bills, and credit card transactions into Excel for analysis.

a)

Access

b)

Web

c)

Text

d)

Other Sources

7.

___________ imports .txt files. This is especially useful when the file is delimited in a nonstandard way, such as with tabs or other special characters.

a)

Access

b)

Web

c)

Text

d)

Other Sources

8.

___________ is used to import data from various formats and sources, such as from a SQL server or XML file.

a)

Access

b)

Web

c)

Text

d)

Other Sources

9.

Poll question: I can open a workbook.

a)

I can perform this skill.

b)

I need help with this skill.

c)

I have not learned this skill.

10.

Poll question: I can rename worksheets.

a)

I can perform this skill.

b)

I need help with this skill.

c)

I have not learned this skill.

11.

Poll question: I can reorder and color worksheet tabs.

a)

I can perform this skill.

b)

I need help with this skill.

c)

I have not learned this skill.

12.

Poll question: I can import data from various applications into Excel.

a)

I can perform this skill.

b)

I need help with this skill.

c)

I have not learned this skill.