Question

Q4. Consider the spreadsheet given below:
[5]
Kettled 1 - OpenOffice Cale
Fie Edit Mew Insert Format Tools Data Windows Help
Ansi
12
В I U
2%.
B
D
PH
Unit Price
Amount
Net payable amount
ItemName
Тотече
Biscurt
Popins
Chips
Oty
150
300
10
Discount
10 00%
5.00%
2.00%
500%
2.5
40
15
250
Total
13
12
14
15
Default
STO
Sum200
Based on above worksheet answer the following questions:
Write the formula to calculate total amount for each item which is calculated as Unit
Price * Quantity in column D
Write the formula to calculate net payable amount which is calculated as Amount-
discount amount in column F2.
Write the formula to find total amount to be paid which is calculated as the sum of all
values in Net Payable Amount in the cell F7.
iv
Which cell contains the value "Popins"?
In the above sheet data is written from cell A1 to FS. How do you depict it as range?
V.​

Answer 1

Answer:

fjstiststostostostostistsfegdvhdfkstodfjsfizddgkagodfidfjrglfiddjaglsfjsgosifevfhsydyyfyryrhendhfyehejncncbcbcbcchhfurq Or good DNC he paper things