Question

Write the commands for the operators (a) to (c) based on the spreadsheet shown below
A 1 Name
2 3 Shivani 4 Mohit 5 Kanika 6 Renuka
7 Aryan B Admission Fee C Tuition D Bus F
Library Fee 0.1% Tuition Fee
10250 11230 11330 10300 14375
1400 1450 1350 1475 1300
840 750 845 980 700
G Fine Total Fee
25 10 0 5
45
a. To calculate the library fee as 0.01% of the tuition fee, for all the students.
b. To calculate the Total fee as the sum of the entire Fee (Tuition Fee +Bus fee)
c. To store the maximum fine in cell F9 and maximum Total Fee in cell G9.​

Answer 1

hi ji j I j o j o j onwhsjsjs hwiwjwbwiwvsgstzgah