Links for K-12 Teachers | Assessment Assistance | On-Line Practice Modules | Daily Dose of the Web


Using the Page Layout 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.
Themes
Themes -
Colors -
Fonts -
Effects -

Page Setup
Margins -
Orientation -
Size -
Print Area -
Breaks -
Background -
Print Titles -
Diagonal Arrow - Click on the arrow in the bottom right corner of Font to see the Format Cells dialog box (Font tab selected)

Scale to Fit
Width -
Height -
Scale -
Diagonal Arrow - Click on the arrow in the bottom right corner of Alignment to see the Format Cells dialog box (Alignment tab selected)

Sheet Options
Gridlines -
Headings -
Diagonal Arrow - Click on the arrow in the bottom right corner of Alignment to see the Format Cells dialog box (Number tab selected)

Arrange
Bring to Front -
Send to Back -
Selection Pane -
Align -
Group -
Rotate -

This quiz is available without the information above   

In the Table below, select which menu you would use to perform the stated action.
(format only - no questions written yet)
1.

You want to find where the entry "$235.54" appears in your worksheet. Which menu do you select?
           

x

2.

A document was saved to your disk and you want to open it. Which menu do you select?
           

x

3.

The Formatting toolbar has been removed and you want to add it back to your window. Which menu do you select?
           

x

4.

You have selected contents of a cell that you want to remove from the worksheet. Which menu do you select?
           

x

5.

Your spreadsheet is too wide, and you want to turn the page to landscape orientation for printing. Which menu do you select?
           

x

6.

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

7.

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

8.

You have changed a worksheet and now want to save it with a different name. Which menu do you select?
           

x

9.

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

10.

You have finished for the day and want to quit Microsoft Excel. Which menu do you select?
           

x

Go to Using Excel menu items, part 2
Go back to
Using Microsoft Excel to Analyze Classroom Data


Enter text in the search box
Search the Internet4Classrooms site


Visitors since November 2000
Click for Memphis, Tennessee Forecast
Memphis, TN
Internet4Classrooms is a collaborative effort by Susan Brooks and Bill Byles