Skip to content
← Accountancy

Accountancy · Class 12 Commerce

Ch 13Spreadsheet — Class 12 Accountancy, concept-first.

Every question solved the concept-first way: concept → why this formula → step-by-step.

18

Q&A

8

Concepts

Not available

Exam weightage

Start learning — read this chapter →

Key concepts

Hover a concept to preview it and jump to its most relevant Q&A.

Formulas and Operators

A formula begins with an equals sign and performs a calculation using cell references, numbers and arithmetic operators (+, -, *, /, ^). The result updates automatically whenever any referenced value changes, which is th…

Most relevant Q&A

Start with this concept →

Questions & Answers

Open any question to start with the concept, not the answer.

+Sample & Board questionsi18 questions
  1. Q1The details of sales is given below in the following spread sheet: | | A | B | C | D | |---|---|---|---|---| | 1 | Code | Name of Salesmen |…Preview
  2. Q2Describe the use and Syntax of the following functions in Libre Office Calc: (a) Now (b) Count (c) IF (d) Rate (e) ConcatenatePreview
  3. Q3Each cell in a Spreadsheet is identified with a unique name, which is known as ______. (a) Range (b) Columns (c) Cell address (d) RowsPreview
  4. Q4Write any 2 methods to add a new worksheet in a Spreadsheet (Libre Office calc).Preview
  5. Q5Name the functions and syntax used to display the following results in Libre Office Calc. (a) Current system date (b) Current date with time…Preview
  6. Q6Write down the 5 features of Libre Office Calc. Briefly explain.Preview
  7. Q7Identify the function which helps to convert a date in the form of text to a number. (a) DATE (b) DAY (c) NOW (d) DATE VALUEPreview
  8. Q8Write the syntax for the following functions : (a) SLN (b) DB (c) PMTPreview
  9. Q9(a) Using the following spreadsheet function, write the result displayed in the cell. (i) = ROUND (412.654, –1) (ii) = ROUND UP (25.314, 0)…Preview
  10. Q10The function that returns the current system date and time is __________. (a) TODAY Function (b) NOW Function (c) DAY Function (d) MONTH Fun…Preview
  11. Q11Write the appropriate spreadsheet functions from the following : (a) To count number of empty cell in the given range. (b) The function comb…Preview
  12. Q12Write the application of the following functions : (a) COUNTIF (b) PMT (c) SUM IFPreview
  13. Q13The result of the function = ROUNDUP (2349.9876, –2) will be __________ .Preview
  14. Q14Briefly explain the Text functions available in LibreOffice Calc.Preview
  15. Q15(a) List out the various data entry options available in LibreOffice Calc to input data into a worksheet. (1½) (b) Differentiate between fun…Preview
  16. Q16Libre Office Calc is a ______ software. (a) Text document (b) Spreadsheet (c) Database (d) None of the abovePreview
  17. Q17List out any four features of Libre Office Calc.Preview
  18. Q18Explain the components of Libre Office Calc.Preview