Happy Computers Essentials Guide to

Other Functions That You Can Use

Statistical Functions

There are over 150 other functions that can be applied in Excel. See the Appendix for a complete list. Some of the useful ones include:
=AVERAGE(range) Average of numbers in a range of cells

=COUNT(range) Count of number of values in a range of cells

=MAX(range) Maximum value in a range of cells

=MIN(range) Minimum value in a range of cells

The IF Function - Getting Conditional Answers

You can use the =IF function to give different results depending on the circumstances. For example a salesman may receive a bonus if his sales reach a certain value.
The =IF function takes the following format:
=IF(THIS IS TRUE, PUT THIS IN THE CELL, OTHERWISE PUT THIS IN THE CELL)

So here's an example:

The formula in cell C3 (shown on the entry line above) is saying:
IF B3 (BORIS’ SALES) IS GREATER THAN THE QUALIFYING AMOUNT THEN PUT THE WORD “BONUS” INTO CELL C3 OTHERWISE PUT THE WORDS “NO BONUS” IN THE CELL.
Text

If you want text to appear as one of the results (as in the above example) you must put the text in quotes.

Use The Paste Function

The Paste Function makes it easy to use the functions that are available in Excel- See Paste Function

The Paste Function

Using The Paste Function

Select the cell where the function is to go

Click on the Paste Function Icon A dialog box appears




Select a function from the Function Category

list on the left.
Select the function you want from those listed

on the right.



Click OK A dialog box will appear giving a description of the function you have chosen
For example the Average function

The information you need to enter in each box will depend on the function chosen.
Enter the information into the first box.

Click into the next box (if applicable) and enter the information.

Do the same for any other boxes (if applicable)

Click OK
Easy Entering of Cell Ranges

Click on the to stop the paste function dialog box getting in the way. Select you range and click on to get back to the paste function dialog box.

Inserting & Deleting Rows and Columns

Inserting A Row

Select any cell below the place you want to insert a row

Click on Insert Menu The menu will drop down

Click on Rows

Inserting a Column

Select any cell to the right of the place you want to insert a column

Click on Insert Menu The menu will drop down

Click on Columns

Inserting Several Rows Or Columns

Click & drag over number of rows or columns to be inserted

Click on Insert Menu The menu will drop down

Click on Rows or Columns

Deleting Rows And Columns

You can use this option to delete rows or columns but take care that you do not delete cell with information you need.
Highlight range Highlight range covering row numbers to be deleted

Click On Edit The Edit Menu will drop down

Click On Delete The dialog box will appear


Select Entire Row or Entire Column

Click OK

Using the Right Mouse Button

Select the Rows or Columns that you wish to insert or delete

Release your mouse button

Right Click over the Selection



Choose Insert or Delete The selected row(s) or column(s) will be inserted or deleted

Saving Your WorkBook

Saving A Workbook for the First Time

Click on the Save icon Shown below (top left of the screen)

The following dialog box will appear



Type in the name of the document (up to 255 characters long).

Change the folder to save the file to, if required

Click Save or press Return

Saving a WorkBook Again after Changes

Click on the Save icon Shown below (It's at the top left of the screen)

The Workbook will be saved without further prompts.

More Options In Saving

Creating a Copy of a WorkBook using Save As

Click on File The File Menu will drop down

Click on Save As The Save As box will appear (shown above)

Type in a new name for the document

Select the folder to save the file to if required

Click Save Or press Return
You may be prompted for Document Properties (Depending on how Word has been set up on your computer). If so enter the necessary information and click OK.

Changing Where WorkBooks Are Normally Saved

Click On Tools Menu The menu will drop down

Click On Options The dialog box will appear

Click on the General tab

Click into the box next to the Default file location

Type in the Default file location for your Workbooks

Click OK

Creating a Folder in the Save Dialog Box

In the Save Dialog box using the Save in Drop-Down list change to the drive or folder that will be the parent of the new folder.

Click on the Create New Folder button



Type a name for the folder

Click OK