plz solve the excel based question fast. I will will mark them as a brainlist
Answers
Solution:
a) Enter at least 10 item details. - Given.
b) Find the rate of interest using the following condition.
It total units >100 then Rate per Unit is Rs. 7
It total units >70 and <=100 then Rate per Unit is Rs. 5
It total units >50 and <=70 then Rate per Unit is Rs. 3
Otherwise Rate per unit is Rs. 1
So, let us create an if-else branch before solving.
rate = ??
if (total > 100)
rate = 7
else if (total > 70)
rate = 5
else if (total > 50)
rate = 3
else
rate = 1
The general syntax of if statement is:
= IF(condition, true_part, false_part)
So, the formula to calculate rate will be:
=IF(cell > 100, 7, IF(cell > 70, 5, IF(cell > 50, 3, 1)))
Where cell is the cell reference of the units consumed (here, its D2 to D11). To calculate the rate of all the customers, enter the formula in the first cell (E2) and then use autofill feature.
c) Calculate the total amount for each customer.
Total amount will be equal to the product of the number of units consumed and the rate per unit.
So, the formula to calculate total amount will be:
= unit * rate
Where unit and rate will be the cell references of the cells where the total no of unit and the rate per unit is given (Here D2-D11 and E2-E11)
A screenshot of the table has been attached.
