2014
Section-C
Answer any two questions.
Question 12.
(a) Mention any two demerits of using electronic spreadsheets.
(A) Write a formula in spreadsheet for calculating the “Take Home Pay” under
the given condition:
Salary is more than ₹ 50,000 then the “Take Home Pay ” is 80%.
© How would you create a filter for data stored in a column in a
spreadsheet ?
(d) State the steps involved in merging two cells in a spreadsheet.
(e) What is the difference between the functions AVERAGEA () and
AVERAGEIFS () ?
(a) Write the expression to calculate GROSS PROFIT & NET PROFIT in the
Cells (B5, B9), for the Year 2010.
(A) Write the expression to calculate the average GROSS PROFIT for year
2010, 2011 and 2012.
(c) Write a function to select the maximum Value of NET PROFIT for the years
2010, 2011 and 2012.
(d) Write a suitable expression to calculate the following for 2013 (Estimates)
where :
(i) Sales of goods in Cell E2 where Sales of Goods have decreased 10% over
2012.
(ii) Sales of Services in Cell E3 where Sales of Services have increased 10%
over 2011.
(iii) Income from other sources in cell E4 where Income From Other Sources
have increased 25% over 2010.
(iv) Gross Profit in Cell E5.
Question 14. [10].
(a) What is the use of Data dictionary in RDBMS ?
(A) What is SQL?
(c) What is a Unique Key ?
(d) Define SQL update statement.
(e) What is meant by normalization of a database system ?
2015
Question 12
(a) Give the address of the cell at 25th row and the 8th column.
(b)What do you mean by range of cells? How is a range specified?
(c) List the types of entries which are allowed in a worksheet.
(d)You enter 45+ 15 in a cell. The worksheet does not display the sum
60 in the cell, instead, it shows 45 + 15. What is the reason for this?
(e) Write the formula to calculate the interest amount for a principal
amount which is stored in cell B5, on the basis of the following
specifications:
The time is stored in cell C5
If principal amount ≥ 50,000. Rate of interest 6%
If principal amount < 50,000. Rate of interest 5%
Question 13.
The spread sheet below shows the sales of Jupiter Ltd. made by four
salesmen in the four quarters of the financial year 2013-14:
Answer questions (a) to (d) based on the above spreadsheet:
(a) It is the policy of the company to sell its goods at a profit of 20% on
its sales.
(i) Write the formula to calculate the cost of the goods sold by
Salesman S1 in Qtr 4.
(ii) Salesman S4 sold goods costing 4,800 in Qtr. 3. Calculate the
price at which he sold the goods.
(b)Write the formula to calculate the total sales made by the company
in cell F7.
(c) The company gives a commission of 10% to a salesman on his total
sales. Write the formula to calculate the commission earned by
Salesman S3 in cell G5.
(d) Write an expression to show the effect on the profits if the rate of
commission was increased from 10% to 12% of 10 the sales.
Question 14.**
(a) What is the use of SQL in database management system?
(b)Define the term ‘field’ as used in DBMS.
(c) Arrange the following in hierarchy to create a DBMS
FIELD, DATA, FILE, RECORD
(d)How are the following SQL functions useful in RDBMS :
(i) MAX
(ii) SQRT
(e) What is a table ?
2017
Question 12.**
(a) What is meant by the error #REF! in MS EXCEL?
(b) What is ‘DELETE’ statement?
(c) What is Drop Table?
(d)What is the short-cut key in MS EXCEL to ‘undo the last action’?
(e) Is any symbol used as a prefix for a formula? If yes, give the symbol.
Question 13.**
a. Explain any two types of Databases.
b. Give any two examples where Database can be used.
c. What is composite key?
d. Give the full form of RDBMS.
e. Explain what is meant by:
(i) Form
(ii) Report
Question 14
2018
2019