Online ICT Exam – English Medium – Grade 9 – Spreadsheet Software Lesson



#1. What is the intersection of a column and a row on a worksheet called ?

#2. Which type of chart is a data visualization where each category is represented by a rectangle, with the height of the rectangle being proportional to the values being plotted?

#3. Which function in Excel tells how many numeric entries are there ?

#4. Which is a feature that highlights only the cells in a column according to specified criteria?

#5. Statistical calculations and preparation of tables and graphs can be done using

#6. Which one is not a Function in MS Excel ?

#7. Functions in MS Excel must begin with

#8. In Excel, Columns are labelled as ___

#9. What type of chart is useful for showing trends or changes over time ?

#10. The process of arrenging the items of a column in some sequence or order is known as :

#11. The ____ feature of MS Excel quickly completes a series of data

#12. What type of chart is useful for comparing parts of a whole ?

#13. What is the graph indicated by red square?

#14. Name the items shown on the image in order

#15. By using Cell formatting tools which option should be selected to format date as "Tuesday, February 25, 2021"?

#16. Select the Free and Offline Spreadsheet software from the following list.

#17. Renaming a workbook affects the names of the worksheets inside a workbook.

#18. Spreadsheet software is an application software.

#19. From the following list which is not a use of spreadsheet software?

#20. A Function is an equation designed by a user in Excel, while a Formula is a predefined calculation in the spreadsheet application.