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 intersection of a row and a column in a spreadsheet. Answer: True

3. You cannot merge cells in a spreadsheet. Answer: False

4. The MAX function is used to find the smallest value in a given range. Answer: False (MAX is used to find the largest value

5. A spreadsheet file is commonly saved with the .xls or .xlsx extension. Answer: True

3. Fill in the Blanks

1. The _________ function is used to count the number of numeric values in a range of cells. Answer: COUNT

2. A __________ is a predesigned spreadsheet file that contains formatting, labels, and

formulas already set up. Answer: Template

3. In a spreadsheet, _________ is used to join the content of multiple cells into one cell. Answer: Concatenate

4. The __________ function is used to find the average of a range of cells. Answer: AVERAGE

5. The _________ toolbar contains the functions for Cut, Copy, and Paste. Answer: Standard

4. Short Answer Questions

1. What is the use of an electronic spreadsheet in data management?

Answer: An electronic spreadsheet is used for organizing, analyzing, and storing data in

tabular form. It allows users to perform calculations, create charts, and manage large sets

of data efficiently. 

2. Define a cell in a spreadsheet. Answer: A cell is the intersection point of a row and a column in a spreadsheet. It is the

basic unit where data is entered. 3. What is the difference between a formula and a function in a spreadsheet?

Answer: A formula is a user-defined expression that calculates values using cell

references, operators, and values. A function is a predefined calculation provided by the

software, such as SUM or AVERAGE, used to perform specific tasks.

4. Explain the purpose of cell referencing in a spreadsheet. Answer: Cell referencing allows users to refer to specific cells in formulas. It helps in

performing calculations by using values stored in other cells. There are three types:

relative, absolute, and mixed referencing. 5. How can you apply a formula to multiple cells at once in a spreadsheet?

Answer: You can apply a formula to multiple cells by dragging the fill handle at the

bottom-right corner of a selected cell across the desired range of cells. 

5. Long Answer Questions

1. Explain the different types of cell referencing in a spreadsheet. Answer:

o Relative referencing refers to cells by their position relative to the formula's

location. When copied, the reference adjusts automatically. o Absolute referencing uses a fixed reference to a specific cell, indicated by a

dollar sign ($) before the column and row (e.g., $A$1). The reference doesn’t

change when copied. o Mixed referencing combines relative and absolute references, with either the

column or row being fixed, but not both (e.g., A$1 or $A1). 

2. What are some common functions used in spreadsheets, and how do they work?

Answer:

o SUM: Adds all the numbers in a range of cells. o AVERAGE: Calculates the mean of the numbers in a range. o COUNT: Counts the number of numeric entries in a range of cells. o MAX: Finds the largest number in a range. o MIN: Finds the smallest number in a range.

 3. Describe the process of creating a chart in a spreadsheet. Answer:

To create a chart:

1. Select the data range to be represented.

 2. Go to the "Insert" menu and choose the desired chart type (bar, pie, line, etc.). 

3. Customize the chart with titles, legends, and formatting options. 

4. The chart will visually represent the selected data. 

6. Practical Questions

1. Create a simple expense sheet in a spreadsheet. Include categories like Food, Travel, Entertainment, and Others. Calculate the total and average expenses. 

2. Design a grade sheet for five students with subjects like Math, Science, English, and

History. Use formulas to calculate total marks and percentages for each student.