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

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.

Clipboard
		Cut - Prepare selected content to be removed and placed somewhere else in the workbook. Keyboard shortcut - Ctrl + X
		Copy - Send selected content to the clipboard. Keyboard shortcut - Ctrl + C
		Paste - Place an item from the clipboard at the selected location on a worksheet. Keyboard shortcut - Ctrl + V
		New in Paste - Copy selected portion of a worksheet as a Picture. The pasted content can then be moved like any other image object.
		Format Painter - Copy formatting from one place to apply to another. Double-click to apply the same format multiple times.
		Diagonal Arrow - Click on the arrow in the bottom right corner of Clipboard to see all items currently in the clipboard.

Font
		Font Pull-down List - See a listing of all available font styles
		Font Size Pull-down List - See a listing of available font sizes
		Increase/Decrease Font Size - Increase or decrease font size by clicking on the big A or little A
		Formatting Buttons - Change the formatting of selected cells by clicking on B (Bold), I (Italic), or U (Underline). The pull down arrow to the right of U allows double underline. Keyboard shortcuts - Ctrl + B (or I, or U) no shortcut for double
		Borders - Select the down arrow to the right of the square window pane to see a large number of possible borders
		Color - Use the paint bucket to fill selected cells with color or the A to change the color of selected text; select the down arrow to the right of the paint bucket or the A to see available Theme Colors or select More Colors to see those you are accustomed to from earlier versions of Excel.
		Diagonal Arrow - Click on the arrow in the bottom right corner of Font to see the Format Cells dialog box (Font tab selected)

Alignment
		Vertical Align - Select top of cell, middle of cell, or bottom of cell for vertical alignment in a cell
		Horizontal Align - Select left align, centered, or right aligned for horizontal alignment in a cell
		Orientation - Change the text orientation within a cell for placing a label above a column
		Indent - Increase, or decrease, the amount of indentation within a cell
		Wrap Text - Make all content within a cell visible by displaying it on multiple lines
		Merge and Center - Join selected cells together and center the content of the cell (unmerge is available)
		Diagonal Arrow - Click on the arrow in the bottom right corner of Alignment to see the Format Cells dialog box (Alignment tab selected)

Number
		General - Eleven of the most commonly used formats with a link to more formats; which brings up the Format Cells dialog box (General tab selected)
		Format Cell Contents - Convert a number to one of several formats; currency, percent, or decimal
		Move Decimal - Increase or decrease the number of zeroes after the decimal
		Diagonal Arrow - Click on the arrow in the bottom right corner of Alignment to see the Format Cells dialog box (Number tab selected)

Styles
		Conditional Formatting - highlight interesting cells, emphasize unusual values, and visualize data using Data Bars, Color Scales, and Icon sets
		Format as Table - format a range of cells and convert the range to a table by selecting a pre-defined table style
		Cell Styles - pre-defined styles available to quickly format a cell

Cells
		Insert - insert cells, rows, or columns into a worksheet, or insert additional worksheets into a workbook
		Delete - delete rows or columns
		Format - change row height or column width, organize sheets or protect or hide cells

Editing
		Auto Sum - display the sum or selected cells directly after the selected cells
		Fill - continue a pattern into one or more adjacent cells (you can fill cells in any direction)
		Clear - delete everything from a cell, or remove formatting, contents, or comments
		Sort & Filter - arrange data for easy analysis (data can be sorted in ascending or descending order, or filter out specific values)
		Find & Select - find and select (or replace) specific text, formatting or type of information within the workbook (data validation is found in the drop down list)

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

1.	You have established a pattern that you want to continue in adjacent cells. Which portion of the home tab do you go to?	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

Enter text in the search box Search the Internet4Classrooms site

Visitors since November 2000

Memphis, TN

Internet4Classrooms is a collaborative effort by Susan Brooks and Bill Byles