Save

•         •Save As the first time and give your workbook a name. Use the Save (diskette icon) to save any changes to your worksheet.

•         Save OFTEN!!!

 

 

 

Worksheet and Booklets

•         When you start a new Excel document, you are opening a blank booklet.

•         There are 3 worksheets already available.

•         You can insert more or delete ones you don’t need.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 


Page Setup

 

Reserved: • Click on File – page set up. • Page tab – You can change the orientation for Portrait to Landscape by clicking in the radio button beside the desired orientation. – You can also change the scaling from 100% to whatever is desired or click to fit the spreadsheet onto a certain number of pages.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 


Highlight and Format

Reserved: 1. To highlight an entire row, click on the row number in the gray area to the left. 2. To highlight an entire column, click on the letter in the gray area at the top. 3. Once the desired rows, columns or individual cells are highlighted, then you can format the area – font, font size, color, border, etc.  

 

 

 

 

 

 

 


Format

Reserved: • Use the number tab to format the cells – currency, text, time. etc., then click OK.

 

Reserved: 1. Use the font tab to choose the font, style and size. 2. Then click OK.
 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 


                                         


Reserved: 1. Use the border tab to choose what borders lines are desired. 2. Choose the style and color BEFORE clicking on the actual border lines. 3. Then click OK.  

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 


Adjusting Rows and Columns

Reserved: 1. To adjust the width of the column, place the cursor in the gray area between the column letters. The cursor becomes a double headed arrow with a line in between. 2. Hold down the left mouse button and expand the column to the desired width. 3. To adjust the height of the row, place the cursor in the gray area between the numbers and follow step # 2.  

 

 

 

 

 

 

 

 

 



 

Fill in

Reserved: • Type in the cell. • Highlight the cell. • •Grab the black square at the bottom right corner of the cell. •Click the left mouse button and hold it while highlighting the cells across or down. Release the mouse button.  

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 


Auto Fill

Reserved: • Use the Auto Fill option to fill in a series , for example, days of the week or numbers in order – Type in the cell. – Highlight the cell. – Grab the black square at the bottom right corner of the cell. – Click the left mouse button and hold it while highlighting the cells across or down. – Release the mouse button.  

 

 

 

 

 

 

 

 

 

 

 

 

 

 



 

Reserved: • Clipart – Insert – picture – clipart. – Or click on the cartoon man icon – Type in word , click search, choose picture. • File – Insert – picture – file – Or click on the mountain icon • Locate picture file (usually in My Pictures in the My Documents folder). • Internet (copy, paste or save as) • Right click on the photo, choose copy and then paste it into your slide. • OR Right click on the photo, choose Save As and save the photo and insert as a file. Insert a Picture

 

 

 

 

 

 

 

 

 

 

Sort

Reserved: • One column or row – Highlight the area to be sorted and click on the ascending or descending buttons
Reserved: • Several columns or rows – Highlight the area to be sorted – Make sure to highlight all the cells connected to the data you want to sort. – Click on Data-Sort –choose the column you wish to sort by
 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 


Chart

Reserved: • Type in the data that you need. • Highlight the data. • Click on the Chart icon. – Choose the style chart. Click Press and Hold to View Sample. Click Next. – Choose whether data will viewed by rows or columns. Click Next. – Type in the chart name, the name for the X axis and Y axis. Click Next. – Choose where to place the chart and click Finish.  

 



Reserved: • Change the color of the columns. – Click on the bar so that all the bars for the same color are highlighted. – Double-click and the color palette will appear. Make your color and pattern choice and click OK. – Do the above directions for every color change.  

 

 

 

 

 

 

 

 

 

 

 

 

 

Reserved: • Change the color of the plot area – Click anywhere in the gray area. The plot area will now have black squares around it. – Double-click and the color palette will appear. Make your color and pattern choice and click OK.
 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 


ό

 
Reserved: • Once the data is typed, click in the cell below. • Click on the AutoSum icon. Click on the type of function. • Accept the formula by clicking the green checkmark beside the formula. Formulas

 

 

 

 

 

 

 

 

 

Reserved: • •Click in the cell to the side or beneath the data. Type = and then type exactly what you want to happen. Click the green checkmark to accept the formula. • Example = (C1/B1)+A1

ό