Basic Excel Functions

Basic Excel functions
Follow the directions to create your own excel time entry sheet
Step 1
Locate the Microsoft excel and open a new blank template
Basic functions and terms
Rows are numbered going down the left side of the page
Columns are lettered going across the top of your page
Tabs are located across the very top of your page

Home, Insert, Page Layout, Formulas, Data, Review, View, Acrobat
Sub-bars are located within each tab
Home
Clipboard, Font, Alignment, Number, Styles, Cells, Editing
Step 2
Locate cell A1, left click your mouse on the cell, a boarder will appear around the cell, hold and drag
your mouse to the right, the cells will highlight as you move your mouse across. Stop once you reach
column I
Under the home tab, locate the “Alignment” sub-bar, find the little icon on the bottom right with the
letter “a” (merge & center) on it, and click on the button to join the highlighted cells. You should now
see one large cell along the top of your page
Step 3
Click on the cell you just created, again under the home tab, locate the format button under the “Cells”
sub-bar click on the format button.
A drop down menu will appear
Click on the first tab you see – Row height
Another pop up will appear on your page, change the row height from 15 to 30
Step 4
Click on the “A” at the top of first column, this will highlight the entire column
Again locate the format button under the “Cells” sub-bar. Use the same process as the previous
step, except this time, adjust the column width to 20
Step 5
Click on cell A2 and type “Job/ Task”
Step 6
In row 2, column “B” type Monday

“C” type Tuesday
“D” type Wed.
“E” type Thurs.
“F” type Friday
Step 7
Move your mouse over top of column G until a cross hair with an arrow that points left and right
appears. Once this arrow appears left click and drag the column to the left until the column width hits 6
release the mouse
In this newly sized column, in row 2 type “hours”
Step 8
In column H row 2 type “pay”

In column I row 2 type “total”
Step 9
Resize column H width to 7
Step 10
Click on cell A1, and type “hours & pay log”
Step 11
Again click on cell A1, locate the middle align button on the “alignment sub-bar”, click on the button this
will move your text to the center of the cell
Step 12
Move your mouse to the numbers that indicate each row, find row 2, an arrow will appear, left click.
This will highlight the entire row; with the row highlighted locate the center text button on the
“alignment sub-bar” and click on it
Step 13
Left click and hold your mouse down on your top cell, drag your mouse down to row 30, release the
button on your mouse, you should now see all those cells highlighted.
Locate the grid button in the “font” sub-bar. Click on the small arrow that is pointing down beside the
grid button.
A drop down menu will appear

Click on the all boarders button
You should now have a grid surrounding all your columns and widths
Step 14
Repeat all the previous steps, once you have brought up your drop down menu again
Click on the thick boarder box button
This will darken the boarder around your grid
Step 15
Click on cell G3 and complete the following:

Press the equal’s (=) button on your keyboard,
Then click on cell F3, then the enter the addition (shift +) symbol on your keyboard
then click on cell E3, complete this process to cell B3
A 0 should appear in cell G3
Step 16
Right click on G3, and hit the copy command

High light cells G3, to G30
Right click again, and hit the paste special command, a popup menu will appear
Click on the formulas button and hit ok
You should now have zeros showing from cell G3 to 30
Step 17
High light column H, once highlighted locate the number sign ($) under the “number sub-bar”
This will change the cell format from general to accounting
Complete the same steps as above for column I

Enter the number 25 in to cell H3, it should look as follows: $25.00
Step 18
In cell I3 press the equals (=) sign on your keyboard

Click on cell H3 it will become temporarily boxed, now enter an asterisk (*) shift 8) and then click on cell
G3, and hit enter a number sign with a dash should appear.
Step 19
Click and copy cell I3, left click and high light cells I3 to I30, right click and press the past special
command
Again press the formulas button and hit ok
Step 20
High light Cells H and I 31, and create a dark boarder box around these cells
Step 21
In cell H 31 type total

Click on I 31 and high light up to I 3, click on the sum button found in the “editing sub-bar”
Step 22
Center all the information in your cells
Step 23
High light cells G3-G 30, click on the format cells button
In the drop down menu click on the lock cells button
A small caution sign should appear on your screen, click on the icon, a drop down menu will appear,
again click on the lock cell button
Step 24
Save your newly created spread sheet
Step 25
Enter in numbers to make sure everything works

Basic Excel Functions

Uploaded by

Copyright:

Available Formats

Basic Excel Functions

Uploaded by

Document Information

Original Title

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

Basic Excel Functions

Uploaded by

Copyright:

Available Formats

Basic Excel functions

Locate the Microsoft excel and open a new blank template

Basic functions and terms

Tabs are located across the very top of your page

Click on cell A2 and type “Job/ Task”

In row 2, column “B” type Monday

In column H row 2 type “pay”

Resize column H width to 7

Click on cell A1, and type “hours & pay log”

A drop down menu will appear

Click on cell G3 and complete the following:

A 0 should appear in cell G3

Right click on G3, and hit the copy command

Complete the same steps as above for column I

In cell I3 press the equals (=) sign on your keyboard

In cell H 31 type total

Center all the information in your cells

Save your newly created spread sheet

You might also like