Use app×
Join Bloom Tuition
One on One Online Tuition
JEE MAIN 2025 Foundation Course
NEET 2025 Foundation Course
CLASS 12 FOUNDATION COURSE
CLASS 10 FOUNDATION COURSE
CLASS 9 FOUNDATION COURSE
CLASS 8 FOUNDATION COURSE
0 votes
4.6k views
by (72.4k points)

Arihant stationery keeps stock of various stationeries in his shop. The proprietor wants to maintain a stock value and reorder level for following items as given in a spreadsheet. Write formulas for the operations (i) to (iii) and answer the questions (iv) and (v) based on the spreadsheet given below along with the relevant cell address:

1. To calculate the Stock Value as product of ‘Quantity in Stock1 and ‘Rate’ for each item present in the spreadsheet.

2. To calculate the ‘Quantity to Order’ as ‘Minimum Stock Quantity’-‘Quantity in Stock’ for each item.

3. To calculate the ‘Order Value’ as product of ‘Quantity to Order’ and ‘Rate’ for the items if ‘Quantity to Order’>=0, else assign the value as 0.

4. Proprietor wants to graphically represent his stationery stock. Suggest him the most appropriate feature of MS-Excel.

5. If Quantity in Stock’s value changes, will have to redo all the calculations for that particular column? Explain.

1 Answer

0 votes
by (89.4k points)
selected by
 
Best answer

1. At cell F2, type = D2*E2 and then copy this formula using Fill handle in range F3: F5.

2. At cell G2, type = C2 – D2 and then copy this formula using Fill handle in range G3: G5.

3. At cell H2, type = IF (G2 > = 0, G2*E2, 0) and copy this formula using Fill handle in the range H3 : H5.

4. He should create chart of any type to graphically represent his data.

5. No, the recalculation is not again required because the formula and functions that are given changes according to the values in the cells.

Welcome to Sarthaks eConnect: A unique platform where students can interact with teachers/experts/students to get solutions to their queries. Students (upto class 10+2) preparing for All Government Exams, CBSE Board Exam, ICSE Board Exam, State Board Exam, JEE (Mains+Advance) and NEET can ask questions from any subject and get quick answers by subject teachers/ experts/mentors/students.

Categories

...