Instructions for the "Using Functions" sheet:
1 Review and understand the example. (Note: Always start a function with an = as the first character.)
2 Enter a column of 5 numbers, in cells B27 to B31 (Pick any numbers you wish.)
3 In cell B33, enter a formula to add the individual 5 cells one at a time.
4 In cell B34, enter a formula to calculate the SUM using the SUM function of cell range B27 through B31
5 In cell B35, enter a formula to calculate the average, but adding the 5 cells and dividing by 5.
6 In cell B36, enter a formula to calculate the AVERAGE using the AVERAGE function of cell range B27 through B31
7 Copy cells, B27 to B36 and paste them to B38 to B47.
8 Insert a row, between B39 and B40 and enter a new value in the cell.
9 Note how one sum value and one average value is now incorrect but the other is updated correctly.
10 Review the other functions in the example, in column J, such as MIN, MAX, COUNT and TODAY. MIN is the minimum value, MAX is the maximum value, COUNT is the number of items in the list and TODAY returns today's date.
11 In cells B50 through B52, enter the functions MIN, MAX, and COUNT using the cell range of your new list.
12 In cell B53, enter the function TODAY to show today's date.
13 In cell B54, enter another Excel function that you choose. You can press the Fx at the top of your spreadsheet to see what's available.
Note: If you see #### in a cell, your column is not wide enough. Be sure to make it larger before turning in your assignment.
Instructions for the "Cell Formatting" sheet:
1 Copy cell B10 to L10 then make it BOLD
2 Copy cell B11 to L11 then make it ITALIC
3 Copy cell B12 to L12 then make it UNDERLINED
4 Copy cell B13 to L13 then make the text BLUE
5 Copy cell B14 to L14 then make the background of the cell GREEN
6 Copy cell B15 to L15 then make the font 14 points
7 Copy cell B16 to L16 then choose the font Times New Roman
8 Type 12.34 in cell L17 and -45.56 in M17 then make for format Currency with negative values in RED
9 Type 123.4567 in cell L18 then reduce the number of decimals showing to 2
10 Type 5 in cell L19 and 90 in cell M19. Using conditional formatting on both have values greater than 10 appear with light red fill and dark red text.
Instructions for the "Graphs" sheet:
1 Create a table, like the one on the Cell Formatting sheet but with different items, with 3 rows and 3 columns. Put your table in cells A26 through D29.
2 Be sure to label the columns and rows and fill in the table with data.
3 Create three charts, like the examples on the Cell Formatting sheet. Be careful that the graphs are correct, including titles.
Instructions for the "Absolute and Relative" sheet:
1 Copy the table in cells A21:D26, into cells A34:D39.
2 Examine the formulas then copy cells F10:H10 to F35:H35
3 Update the tax amount, in H35 to 5%
4 Update cells C35:C39 to point at the new value using the absolute cell reference pointing to H35.
Instructions for the "Puppy Palace" sheet":
This sheet contains a number of errors.
The error might be that a formula is wrong, a word is spelled incorrectly, the chart is not pointing at the right data or something else. You need to find and correct at least 5 errors by making the changes in the Kitten Kingdom spreadsheet. List the errors you've corrected in cells B61:B65
Attachment:- excel20-20new20formulas20and20formatting200607.rar