Font size
WorksheetsCreating and Managing Workbooks
Total questions: 12
Worksheet time: 7mins
Which tab can you find templates?
(a)
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.
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.
True
False
Which tab can you find the "get external data" group?
Home
Insert
Data
Formulas
_____________ imports a table or query from an ____ database.
Access
Web
Text
Other Sources
___________ 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.
Access
Web
Text
Other Sources
___________ imports .txt files. This is especially useful when the file is delimited in a nonstandard way, such as with tabs or other special characters.
Access
Web
Text
Other Sources
___________ is used to import data from various formats and sources, such as from a SQL server or XML file.
Access
Web
Text
Other Sources
Poll question: I can open a workbook.
I can perform this skill.
I need help with this skill.
I have not learned this skill.
Poll question: I can rename worksheets.
I can perform this skill.
I need help with this skill.
I have not learned this skill.
Poll question: I can reorder and color worksheet tabs.
I can perform this skill.
I need help with this skill.
I have not learned this skill.
Poll question: I can import data from various applications into Excel.
I can perform this skill.
I need help with this skill.
I have not learned this skill.
