Mike Kreicker
Ann Zinyemba

Word
Access
Excel
Publisher
PowerPoint

Microsoft Excel Toolbars

The Standard Toolbar

This entire toolbar could become a floating window by double-clicking on the control bar at the far left end of this toolbar. That gives the following window, which can be placed anywhere on the screen:

This toolbar can be restored to its original position by clicking in the gray bar at the top and dragging it back to the top of the screen. Push the top of the window up to the bottom of the menu bar.

Function of commonly used buttons
	Creates a new blank document based on the default template		Opens or finds a file
	Saves the active file with its current file name, location and file format		Prints the active file - for more print options go to the File menu and select Print
	Print preview - Shows how the document will look when you print it.		Spelling, grammar and writing style checker
	Cut - Removes the selection from the document and places it on the clipboard		Copy - Copies the selected item(s) to the clipboard
	Paste - Places the content of the clipboard at the insertion point		Format painter - Copies the format from a selected object or text and applies to other objects or text
	Undo - Reverses the last command, use pull-down menu to undo several steps		Redo - Reverses the action of the Undo button, use the pull-down menu to redo several steps
	Auto Sum - Adds numbers automatically, and suggests the range of numbers to be added		Sort Ascending - Sorts selected items from the beginning of the alphabet, the lowest number or the earliest date
	Sort Descending - Sorts selected items from the end of the alphabet, the highest number or the latest date		Chart Wizard - Guides you through the steps for creating an embedded chart (graph)
	Displays or hides the Drawing toolbar		Zoom - Enlarge or reduce the display of the active document

Carefully review the function of each of the buttons above. When you think that you are familiar with each of the buttons take the short quiz below. (The Standard toolbar has been included as a reference)

 

	A	B	C	D
1					You have completed the worksheet and want to make certain that you have not made spelling or grammar errors. Which button do you select?
2					Text is highlighted and you want to remove the selection from the active document and place it on the clipboard. Which button do you select?
3					You have made a change to the active document and want to make certain that those changes are saved. Which button do you select?
4					You want to get a quick sum of a column of numbers. Which button do you select?
5					The worksheet had been checked for spelling errors, it has been saved, and now you are ready to print. Which button do you select?
6					A worksheet which has been saved into a folder on your computer is to be opened so changes can be made. Which button do you select?
7					The worksheet had been checked for spelling and has been saved. Before sending it to the printer you want to see how it will look. Which button do you select?

The Formatting Toolbar

This entire toolbar could become a floating window by double-clicking on the control bar at the far left end of this toolbar. That gives the following window, which can be placed anywhere on the screen:

This toolbar can be restored to its original position by clicking in the gray bar at the top and dragging it back to the top of the screen. Push the top of the window up to the bottom of the menu bar.

Function of commonly used buttons
	Changes the font of the selected text		Changes the size of selected text and numbers
	Makes selected text and numbers bold		Makes selected text and numbers italic
	Underlines selected text and numbers		Aligns to the left with a ragged right margin
	Centers the selected text		Aligns to the right with a ragged left margin
	Merge and Center - Merges two or more selected cells and centers the entry		Currency Style - Formats selected text to display currency style
	Percent Style - Formats selected cells to display percent		Comma Style - Formats selected cells to display commas in large numbers
	Increase Decimal - Increases the number of decimals displayed after the decimal point		Decrease Decimal - Decreases the number of decimals displayed after the decimal point
	Decreases the indent to the previous tab stop		Indents the selected paragraph to the next tab stop
	Adds or removes a border around selected text or objects		Marks text so that it is highlighted and stands out
	Formats the selected text with the color you click

Carefully review the function of each of the buttons above. When you think that you are familiar with each of the buttons take the short quiz below. (The Formatting toolbar has been included as a reference)

 

	A	B	C	D
1					You wish to call attention to a portion of your worksheet by making the text bold. Which button do you select?
2					You want to center the entries in selected cells. Which button do you select?
3					Cell A1 is to be stretched so it covers 6 cells Which button do you select?
4					To call attention to text, you want place a block of color behind the text to highlight it. Which button do you select?
5					Another way to call attention to a block of cells is to place a border around them. Which button do you select?
6					A column of numbers represents money and you want to apply currency style. Which button do you select?
7					A column of numbers has too many decimal places after the decimal point. Which button do you select?

 

The Drawing Toolbar

This entire toolbar could become a floating window by double-clicking on the control bar at the far left end of this toolbar. That gives the following window, which can be placed anywhere on the screen:

This toolbar can be restored to its original position by clicking in the gray bar at the top and dragging it back to the top of the screen. Push the top of the window up to the bottom of the menu bar.

Function of commonly used buttons
	A pull down menu with several drawing options		Changes the pointer to a selection arrow
	Rotates the selected object to any degree		A pull down menu with several libraries of shapes
	Draws a line where you click and drag. Hold the Shift key down to make the line straight		Inserts a line with an arrowhead where you click and drag
	Draws a rectangle where you click and drag. Hold down Shift to draw a square		Draws an oval where you click and drag. Hold down Shift to draw a circle
	Draws a text box where you click and drag		Create text effects with Word Art
	Add, modify, or remove fill color from a selected object		Add, modify, or remove line color
	Formats the selected text with the color you click		Changes the thickness of lines
	Selects dash style for dashed lines		Select arrow style; placement and shape of arrowhead
	A pull down menu offers shadow choices		Add 3-d effects to rectangles or ovals

 

Carefully review the function of each of the buttons above. When you think that you are familiar with each of the buttons take the short quiz below. (The Drawing toolbar has been included as a reference)

 

	A	B	C	D
1					Instead of striking the underline key fifteen times, you plan to draw a single line by clicking and dragging. Which button do you select?
2					You have drawn a line, and now want to change the color of the selected line. Which button do you select?
3					The last line you drew had an arrowhead at the wrong end. You want to change the arrowhead to the other end of the line. Which button do you select?
4					You created an object in a worksheet and you want to tilt it at an angle. Which button do you select?
5					You have drawn a rectangle around a selection of cells and want to change it to a dashed line. Which button do you select?
6					The heading of a worksheet is just plain text and you would rather create special effects with text. Which button do you select?
7					You are going to draw a perfect circle on your worksheet by holding down the shift key, clicking and dragging. Which button do you select?

   

DMS Comp App Home ~ MSD Decatur Home Page ~ Decatur Middle School Home Page

Ann Rosborough
Decatur Middle School Computer Applications
5108 S. High School Rd.
Indianapolis, Indiana 46224