Part A: Multiple Choice Questions (1 mark each)
1. Which of the following is an example of spreadsheet software?
• a. MS Word
• b. MS Excel
• c. MS PowerPoint
• d. Notepad
Answer: MS Excel
2. In a spreadsheet, the intersection of a row and a column is called?
• a. Cell
• b. Table
• c. Box
• d. Block
Answer: Cell
3. What is the default extension of an Excel workbook?
• a. .docx
• b. .xlsx
• c. .pptx
• d. .txt
Answer: .xlsx
4. Which symbol is used to begin a formula in Excel?
• a. #
• b. =
• c. +
• d. %
Answer: =
5. What is the range in Excel?
• a. A group of cells
• b. A single cell
• c. A row
• d. A column
Answer: A group of cells
6. Which function is used to find the average of numbers?
• a. =ADD()
• b. =SUM()
• c. =AVERAGE()
• d. =MEAN()
Answer: =AVERAGE()
7. In Excel, a row is identified by?
• a. Alphabet
• b. Number
• c. Combination
• d. Symbol
Answer: Number
8. In Excel, a column is identified by?
• a. Alphabet
• b. Number
• c. Combination
• d. Symbol
Answer: Alphabet
9. Which of these is not a valid chart type in Excel?
• a. Bar
• b. Pie
• c. Line
• d. Flow
Answer: Flow
10. What is the shortcut key to create a new workbook?
• a. Ctrl + N
• b. Ctrl + O
• c. Ctrl + C
• d. Ctrl + W
Answer: Ctrl + N
11. Which function is used to find the largest value in a range?
• a. =MAX()
• b. =MIN()
• c. =LARGE()
• d. =BIG()
Answer: =MAX()
12. Which function is used to count numeric values in a range?
• a. =SUM()
• b. =COUNT()
• c. =COUNTA()
• d. =AVERAGE()
Answer: =COUNT()
13. In Excel, data can be sorted in?
• a. Ascending order only
• b. Descending order only
• c. Both Ascending and Descending
• d. Random order
Answer: Both Ascending and Descending
14. Which key is used to edit the active cell?
• a. F1
• b. F2
• c. F5
• d. F12
Answer: F2
15. What is a formula in Excel?
• a. Predefined calculation
• b. Equation to calculate values
• c. Data entry
• d. File name
Answer: Equation to calculate values
16. Which of the following represents a cell address?
• a. A1
• b. 1A
• c. Row1
• d. ColumnA
Answer: A1
17. Which feature allows you to display data graphically?
• a. Formula
• b. Function
• c. Chart
• d. Table
Answer: Chart
18. Which option is used to combine two or more cells?
• a. Merge & Center
• b. Format
• c. Wrap Text
• d. AutoFit
Answer: Merge & Center
19. Which of these is not a valid data type in Excel?
• a. Text
• b. Number
• c. Date
• d. Picture
Answer: Picture
20. Which operator is used for multiplication in Excel?
• a. x
• b. *
• c. X
• d. /
Answer: *
Part B: Short Answer Questions (2 marks each)
1. What is a spreadsheet? Give two examples of spreadsheet software.
2. Differentiate between a workbook and a worksheet.
3. What is the use of the AutoFill feature in Excel?
4. Explain the difference between relative and absolute cell referencing.
5. What is the difference between formula and function in Excel?
6. Write the steps to insert a chart in Excel.
7. What is the purpose of the 'Wrap Text' option?
8. Differentiate between 'COUNT' and 'COUNTA' functions.
9. What are cell ranges? Give an example.
10. What is the use of the 'Freeze Panes' option?
11. What is conditional formatting? Give one example.
12. Explain the difference between Save and Save As.
13. What are row headers and column headers?
14. What is sorting? How is it different from filtering?
15. Explain the purpose of the 'Merge and Center' option.
Part C: Long Answer Questions (4 marks each)
1. Explain the different types of charts available in Excel with examples.
2. Describe the steps to create, format, and save a worksheet in Excel.
3. What is conditional formatting? Explain with two examples.
4. Explain different types of cell references with examples.
5. Discuss the importance and applications of spreadsheets in daily life and business.