I want to solve question 6 !!??

Exercise- Absolute Cell References Fu... 1. Open a new workbook and save the file with the name "Exercise" 2. Rename the sheet as Staff Information. etting started with excel - Excel Home Page Layout Q Tell me what you want to do. Allam Mohammad Al Balushi & Share Calibri 11 . A A . M . Wrap Text Currency BIN . B . D . A . = Merge & Center . $ - 9% . " / Conditional Format as Cel Insert Delete Format Sort & Find & Formatting. Table" Styles . Filter . Select" Alignment Number Styles Eating I X V f 200 C Bouns 35% Staff ID Staff Name Base Salary Transportation Allowance Accomodation Allowance Bouns Total Salary Abdullah OMR 980.127 OMR 200 OMR 300 10025 Asma OMR 870.897 OMR 200 OMR 300 10010 | Faisal OMR 920.341 OMR 200 OMR 300 3. Create the table as shown above. 4. Change the format of the following cell range (C3:G7) to Omani Rial with one decimal place. 5. Find the total Salary in column G by MS Excel function. 6. Find the bonus in column F by using an Absolute Cell Reference. 7. Apply the following functions for the column G: a. Count b. CountBlank c. Maximum value Minimum value e. Average