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.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.
Related download
- to be completed by reference home delta state
- satisfactory academic progress standards revised
- office of hualapai education financial assistance
- office of the university registrar penn state
- department of counseling educational
- grade level guidelines for writing alp s xap
- microsoft excel practice exercise
Related searches
- microsoft excel help excel 2016
- free microsoft office practice tests
- microsoft excel online download excel 2010
- microsoft excel training tutorials excel 2016
- microsoft office practice tests
- practice exercise of future tense
- microsoft access practice database
- microsoft access practice data
- microsoft access practice files
- microsoft access practice test
- microsoft access practice exercises
- excel practice worksheets 2016 free