case class 9 IT question bank electronic spreadsheet
QUESTION BANK CLASS – IX SUBJECT – INFORMATION TECHNOLOGY CHAPTER – 4 ELECTRONIC SPREADSHEET Chapter 4: Electronic Spreadsheet - Question Bank 1. Multiple Choice Questions (MCQs) 1. Which of the following is a spreadsheet software? a) MS Word b) MS Excel c) MS PowerPoint d) MS Paint Answer: b) MS Excel 2. In a spreadsheet, rows are represented by: a) Letters b) Numbers c) Special characters d) None of the above Answer: b) Numbers 3. Which symbol is used to begin a formula in a spreadsheet? a) # b) $ c) = d) @ Answer: c) = 4. Which function is used to calculate the total of a range of cells? a) COUNT b) SUM c) AVERAGE d) MAX Answer: b) SUM 5. In Excel, what does the acronym ‘CSV’ stand for? a) Compact Separated Values b) Comma Structured Values c) Comma Separated Values d) Computer Standard Values Answer: c) Comma Separated Values 2. True or False 1. Formulas in spreadsheets always start with the "+" symbol. Answer: False (they start with "=") 2. A cell is the inters