![]() |
Links for K-12 Teachers | Assessment Assistance | On-Line Practice Modules | Daily Dose of the Web
![]()
Using the Data Tab in Excel 2007 ![]()
Other Excel Tabs || Home | Insert | Page Layout | Formulas | Data | Review | View
Tip: If you are unsure what the function of a feature is, let your cursor hover over the button (in Excel) to see a pop-up box explaining the feature.
Get External DataFrom Access -
From Web -
From Text -
From Other Sources -
Existing Connections -
ConnectionsReferesh All -
Connections -
Properties -
Edit Links -
Sort & FilterSort A to Z -
Sort Z to A -
Sort -
Filter -
Clear -
Reapply -
Advanced -
Data ToolsText to Columns -
Remove Duplicates -
`Data Validation -
Consolidate -
What-If Analysis -
OutlineGroup -
Ungroup -
Subtotal -
Show Detail -
Hide Detail -
Diagonal Arrow - Click on the arrow in the bottom right corner of Outline to see the Settings dialog box
In the Table below, select which menu you would use to perform the stated action.
(format only - no questions written yet)
|
|
A document was saved to your
disk and you want to open it. Which menu do you select? |
x |
|
|
The Formatting toolbar has
been removed and you want to add it back to your window.
Which menu do you select? |
x |
|
|
You have selected contents
of a cell that you want to remove from the worksheet. Which
menu do you select? |
x |
|
|
Your spreadsheet is too
wide, and you want to turn the page to landscape orientation
for printing. Which menu do you select? |
x |
|
|
You have a three page
spreadsheet, and where the printing stops on each page is
critical. Which menu do you use to check where the Page
Breaks are located? |
x |
|
|
You have placed comments in
several cells and want to see all of them displayed at the
same time. Which menu do you select? |
x |
|
|
You have changed a worksheet
and now want to save it with a different name. Which menu do
you select? |
x |
|
|
Students have produced a
worksheet and they want to place "Group 4, Ms. Smith's
Class" at the top of each page. Which menu do you
select? |
x |
|
|
You have finished for the
day and want to quit Microsoft Excel. Which menu do you
select? |
x |
Visitors since November 2000 |
Memphis, TN |