Electronic Spreadsheet Class 9 MCQs | CBSE IT-402 Exam Prep

Bycbsesolutions

Boost your final exam prep with Electronic Spreadsheet Class 9 MCQs! It includes all pattern of questions, and curated as per the latest CBSE IT-402 syllabus.

When exams come, smart practice makes all the difference. These Spreadsheet objective questions set comes with answers, so you can check your progress instantly, strengthen your concepts and prepare to score high in less time.

So why wait? Let’s dive in and start practicing!🚀

Q1. Which of the following best describes an electronic spreadsheet?
a) A software used only for typing documents
b) A grid that interactively manages and organises data in rows and columns
c) A software used only for creating presentations
d) A tool used exclusively for drawing pictures

Q2. Which of the following is the spreadsheet application included in the LibreOffice suite?
a) LibreOffice Writer
b) LibreOffice Impress
c) LibreOffice Calc
d) LibreOffice Base

Q3. Which of the following is NOT a spreadsheet application?
a) Microsoft Excel
b) LibreOffice Calc
c) Apple Numbers
d) Microsoft Access

Q4. A school maintains student marks and calculates their totals and averages. Which spreadsheet feature makes this task easier?
a) Formulae and functions
b) Animation effects
c) Slide transitions
d) Word processing tools

Q5. Which feature allows a user to arrange data in ascending or descending order?
a) Filtering
b) Sorting
c) Formatting
d) Validation

Q6. A teacher wants to display only students belonging to Class 10 from a large student database. Which feature should be used?
a) Sorting
b) Formatting
c) Filtering
d) Alignment

Q7. What is the default name of the first newly created spreadsheet document in Calc?
a) Sheet1
b) Untitled 1
c) Workbook1
d) Calc1

Q8. Which menu contains commands such as Open, Save, Print and Export as PDF?
a) Edit
b) Format
c) File
d) Data

Q9. A user wants to replace multiple occurrences of a particular word in a spreadsheet. Which command should be used?
a) Find and Replace
b) Copy and Paste
c) Sort
d) Filter

Q10. Which menu contains the command to insert a chart into a spreadsheet?
a) Data
b) Insert
c) Tools
d) Window

Q11. Which menu provides commands for modifying the layout of cells, rows, columns and pages?
a) Format
b) File
c) Help
d) Edit

Q12. Which toolbar provides commands related to font selection, font size, alignment and indentation?
a) Standard toolbar
b) Formatting toolbar
c) Formula toolbar
d) Drawing toolbar

Q13. Spelling, Language and Macros are found in the
a) Edit menu
b) Tools menu
c) Format menu
d) Insert menu

Q14. The small box that explains an icon when the mouse is placed over it is called a
a) dialog box
b) text box
c) tooltip
d) status bar

Q15. The Name box shows the
a) cell reference of the active cell
b) name of the user
c) name of the file saved
d) number of sheets

Q16. The Sum button on the formula bar is used to
a) delete a sheet
b) change font size
c) rename a column
d) total the numbers in the cells above the selected cell

Q17. Which component of the formula toolbar allows users to search for a function from the available list?
a) Name box
b) Function Wizard
c) Input line
d) Standard toolbar

Q18. Which component of the formula toolbar displays the contents of the selected cell and allows editing?
a) Input line
b) Name box
c) Sum button
d) Title bar

Q19. What is the maximum number of rows available in a LibreOffice Calc worksheet according to the chapter?
a) 65,536
b) 1,048,576
c) 10,000
d) 1,024

Q20. What is the maximum number of columns available in a Calc worksheet according to the chapter?
a) 256
b) 512
c) 1,024
d) 1,048,576

Q21. The default name of the first worksheet in Calc is
a) Book1
b) Untitled
c) Sheet1
d) Page1

Q22. What is the cell address at the intersection of column J and row 15?
a) 15J
b) J15
c) J-15
d) 15-J

Q23. Which of the following is a valid cell address?
a) 5A
b) AB
c) D4
d) 4D4

Q24. What is an active cell?
a) A cell containing a formula
b) A cell currently selected and ready to accept data
c) A cell containing numerical values only
d) A cell protected by a password

Q25. The active cell is recognised by
a) a thick border and its address in the Name box
b) a red underline
c) a yellow background always
d) blinking of the Title bar

Q26. Pressing Ctrl + Home moves the cursor to
a) the last row
b) the last column
c) the bottom right cell of the data
d) cell A1

Q27. Pressing Ctrl + End moves the cursor to
a) cell A1
b) the bottom right cell of the data range
c) column A of the same row
d) one screen up

Q28. How many cells are in the range C2:C7?
a) 5
b) 6
c) 7
d) 8

Q29. The range B3:D3 is an example of a
a) column range
b) row and column range
c) absolute range
d) row range

Q30. How many cells are there in the range B2:C7?
a) 6
b) 8
c) 12
d) 14

Q31. Which keyboard key is used to select more than one range of cells in a worksheet?
a) Shift
b) Alt
c) Ctrl
d) Tab

Q32. By default, labels in a cell are
a) right aligned
b) left aligned
c) centre aligned
d) justified

Q33. By default, numerical values in a cell are
a) left aligned
b) centre aligned
c) justified
d) right aligned

Q34. Any expression in a cell that begins with ___ is treated as a formula.
a) @
b) #
c) =
d) $

Q35. Which of the following is treated as a formula in a spreadsheet?
a) A1+B1
b) A1=B1
c) =A1+B1
d) SUM(A1:B1)

Q36. Which mathematical operator is used for exponentiation in Calc?
a) *
b) /
c) ^
d) %

Q37. What is the result of the formula =4+5*3?
a) 27
b) 19
c) 27?
d) 24

Q38. If you type B1=A2+A3 in a cell, Calc treats it as
a) a formula
b) a label
c) a function
d) an error value

Q39. Which symbol is used for exponentiation (power) in Calc formulae?
a) *
b) /
c) ~
d) ^

Q40. The default file format in which a Calc spreadsheet is saved is
a) .xls
b) .odd
c) .ods
d) .doc

Q41. In the Stationery Bill example, the formula to find the total cost of Register (Qty in B2, Unit Price in C2) is
a) =B2+C2
b) =B2*C2
c) =C2/B2
d) =B2-C2

Q42. What will be the result of =(4+5)*3?
a) 19
b) 15
c) 27
d) 32

Q43. What will be the result of =2^5?
a) 10
b) 16
c) 25
d) 32

Q44. Which formula correctly calculates the sum of values in cells A1 and A2?
a) A1+A2
b) =A1+A2
c) SUM=A1+A2
d) A1=A2

Q45. Which function is used to calculate the total of a range of cells?
a) COUNT
b) MAX
c) SUM
d) AVERAGE

Q46. Which function is used to calculate the average of numerical values in a range?
a) MIN
b) AVERAGE
c) COUNT
d) SUM

Q47. Which function identifies the largest numerical value in a selected range?
a) MAX
b) MIN
c) COUNT
d) SUM

Q48. Which function identifies the smallest numerical value in a selected range?
a) MAX
b) AVERAGE
c) MIN
d) COUNT

Q49. The COUNT function
a) adds the values in a range
b) finds the smallest value
c) finds the average
d) counts the cells that contain numbers

Q50. Which formula correctly calculates the total of values from D2 to D7?
a) =SUM(D2:D7)
b) =TOTAL(D2:D7)
c) =ADD(D2-D7)
d) =COUNT(D2:D7)

Q51. Which formula calculates the average of cells A1 to A5?
a) =SUM(A1:A5)
b) =AVERAGE(A1:A5)
c) =COUNT(A1:A5)
d) =MAX(A1:A5)

Q52. Which function would a teacher use to identify the highest marks obtained by students?
a) MIN
b) SUM
c) MAX
d) COUNT

Q53. Which function would help identify the lowest marks obtained in a subject?
a) AVERAGE
b) MIN
c) COUNT
d) SUM

Q54. Which dialog box is used to change font, alignment, decimal places and other cell formatting properties?
a) Save dialog box
b) Format Cells dialog box
c) Print dialog box
d) Find dialog box

Q55. A telephone number entered as a numerical value loses its initial zero. Which format should be applied to retain the zero?
a) Currency
b) Date
c) Text
d) Scientific

Q56. Which tab is selected in the Format Cells dialog box to change a cell range into text format?
a) Alignment
b) Number
c) Font
d) Border

Q57. What is the default date format used in the spreadsheet application?
a) dd/mm/yyyy
b) yyyy/mm/dd
c) mm/dd/yyyy
d) dd-yyyy-mm

Q58. In the time format hh:mm:ss AM/PM, what does ss represent?
a) Hours
b) Minutes
c) Seconds
d) Days

Q59. The fill handle is
a) the small black square at the bottom-right corner of the selected cell or range
b) a menu in the Title bar
c) a button on the Status bar
d) the border of a sheet tab

Q60. Where is the fill handle located in a selected cell or range?
a) Top-left corner
b) Top-right corner
c) Bottom-left corner
d) Bottom-right corner

Q61. The type of referencing used by default in spreadsheets is
a) absolute
b) mixed
c) fixed
d) relative

Q62. If D7 contains =SUM(D2:D6) and it is dragged horizontally to E7, the formula becomes
a) =SUM(D2:D6)
b) =SUM(E2:E6)
c) =SUM(E3:E7)
d) =SUM(D3:D7)

Q63. Which of the following represents a mixed cell reference with a constant row number?
a) A1
b) $A1
c) A$1
d) $A$1

Q64. Which of the following represents a mixed reference with a constant column?
a) A1
b) $A1
c) A$1
d) $A$1

Q65. Which of the following is an absolute cell reference?
a) A1
b) $A1
c) A$1
d) $A$1

Q66. What is the purpose of using the $ symbol in mixed referencing?
a) To delete the cell address
b) To make a row number or column name constant
c) To convert a formula into a function
d) To change a numerical value into text

Q67. Which chart is most appropriate for comparing data items as percentages?
a) Column Chart
b) Bar Chart
c) Pie Chart
d) XY Scatter Chart

Q68. Which chart is used for comparing data in pairs?
a) Pie Chart
b) XY Scatter Chart
c) Column Chart
d) Bar Chart

Q69. Which of the following charts is used for group comparison?
a) Column Chart
b) Pie Chart
c) XY Scatter Chart
d) None of these

Q70. Which menu is used to begin creating a chart in LibreOffice Calc?
a) File → Chart
b) Insert → Chart
c) Tools → Chart
d) Format → Chart

Similar Posts

Leave a Reply

Your email address will not be published. Required fields are marked *