MICROSOFT EXCEL PRACTICE EXERCISE



3800475120650MS EXCELPRACTICE EXERCISEEXERCISE 1: FORMULAEnter the following data into Ms Excel.Calculate Dividend in cell D6 based on Dividend rate in cell B10.This formula can be copies until cell D8. Formula :[ Current Account * Dividend rate]Calculate Dividend in cell E6 based on Dividend rate in cell C10.This formula can be copies until cell E8.[ Current Account * Dividend rate]Calculate the total amount of current and saving account after dividend. EXERCISE 2: FORMULA & CHARTEnter the following data into MS ExcelWrite the formula to:Calculate the Total for G and B based on District.Find Max, Min, Total and Average for G and B for primary and secondaryCreate a line and pie Chart to represent Primary Students by gender for each district.EXERCISE 3: IF FUNCTIONEnter the following data into MS ExcelUsing the Paste Function button create the following formula=IF(B4>C4,"A","B")Using the pull handle copy this formula on down to cell D9In cell E4 create the following formula by typing the formula in the formula bar=IF(B4>C4,"A",IF(C4>B4,"B","Equal"))Copy this formula down to cell E9EXERCISE 4: IF FUNCTIONFollow the instruction below:1. You will be constructing a spreadsheet that you can use to calculate your current Grade Point Average. (GPA) 2. Copy the spreadsheet shown3. Under the heading SUBJECT, list the subject that you currently are enrolled in.In the column titled, CURRENT GRADE, enter your current grades in each subject in the appropriate cell.Use an IF Function to create the Grade Values. Use the NOTE: Grade Values to help you.[Condition: IF Current Grade = “A”, then 4.0, else IF Current Grade = “B”, then 3.0, else IF Current Grade = “C”, then 2.0, else IF Current Grade = “D”, then 1.0, else IF Current Grade = “F”, then 0.0, else 0.0]In the TOTAL VALUES: cell, insert a formula that calculates the Total of all individual letter grade values found in the Grade Values Column. (Add up all the individual letter grade values).In the MY GPA [C13]: cell, insert a formula that calculates the AVERAGE of all the individual Grade Values. You can do this either by using the Function Button and selecting AVERAGE for the range of cells or by entering a formula for calculating averages. (Total of all values / total # of individual values).Under the cell that calculates MY GPA [B14], Insert an IF Statement for the following condition: If a student's GPA is greater than or equal to a 3.50, then have the cell display HONOR ROLL! If the student's GPA is less than the 3.50, have the cell display, KEEP TRYING! ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download