# Excel Assignment

MS EXCEL LAB ASSIGNMENT 1
Average, Max, Min

Columns are vertical and are identified by letter, and rows are horizontal and are identified by numbers.   Where a column and row meet is a cell.   A cell is where you enter data, labels, and formulas.   You identify a cell by listing the column first and then the number such as D7 or D8.   See the MS EXCEL LAB ASSIGNMENT 1 EXAMPLE (Apples is in cell A5.   Total Buyers for Pineapples is 3 listed in cell F7.).

If you enter formulas, you must use an equal (=) sign before typing the formula.
For instance, if you add D7 and D8, enter “=D7+D8” without the quotes.

Other information:
To multiply use *.   To divide use /.   To add use +.   To subtract use -.
To get the average, use the format =AVERAGE(D7:D9).   Cells change based on what you want to get the average of.   A colon means everything between the two cells listed, so here it would mean the average of cells D7, D8, and D9.
To get the maximum number, use the format = MAX(D7:D8).   Cells change based on what you want to get the maximum of.
To add consecutive rows of cells or columns of cells, use the format =SUM(D7:D8).   Cells change based on what you want to get the total of.
To get the minimum number, use the format = MIN(D7:D8).   Cells change based on what you want to get the minimum of.
If you combine formulas, use parentheses ( ) to group formulas in order of precedence.   For example,   =AVERAGE(D7:D8)/(SUM(D7:D8) + MAX(D3:D5)).   Here, the Sum and Max will be calculated and added together before division (/) takes place.

Click on the icon with the X (Excel) or use Start, Programs, and find the Excel program.   You will be in a blank worksheet that resembles the MS EXCEL LAB ASSIGNMENT 1 EXAMPLE sheet.   Enter data from the MS EXCEL LAB ASSIGNMENT 1 EXAMPLE sheet.   Enter borders and size columns as shown.   There is a borders button that you can use or you can use Format menu item, Cells, and Borders tab.   Just...