Home > CBSE IT 402 > Quizzes > IT-402 Electronic Spreadsheet Class 9 Practice Test 2
IT-402 Electronic Spreadsheet Class 9 Practice Test 2
Fast practice, instant feedback. Timer auto-submits when time’s up.
Avg score: 50% • Most missed: “Which key combination moves the active cell (Selected Cell) to A1 cell?”

Related test: IT 402 Electronic Spreadsheet Class 9 Practice Test 

IT-402 Electronic Spreadsheet Class 9 Practice Test 2
Time left 00:00
25 Questions

1. Cell Range A1:D3 consist of ___________cells.
2. Which key / key combination moves the worksheet one screen up?
3. Evaluate the following expression, if cell A1, B2, C2 and D3 has values 10, 2, 3, 36.
=(D3/(A1+B2))^C2
4. C3 : F3 is an example of ___________
5. Which of the following chart shows values as circular sectors of the total circle?
6. Write formula in G5 to calculate the highest marks of Aviral.
7. When you drag the formula =B2 + C2 + D2from E2 to E4, then the formula becomes :
8. ___________________ is located just below the Title bar.
9. Which of the following alignment is not available in LibreOffice Calc?
10. Which of the following operator has the highest priority?
11. Write the formula/function in cell B7 to find the highest score in Hindi.
12. When the formula =C2 * D2 is dragged from cell E2 to G2 then the formula in cell G2 will be ______
13. =A1 + B1 is an example of ______referencing.
14. Write formula in cell F4 to calculate average marks of Riya.
15. Which of the following is a valid way of writing formula ?
16. A _________referencing is a referencing in which one cell address name is variable and one cell address is constant.
17. When you drag formula = A$7 downward then __
18. In LibreOffice Calc, Row headings are in ________________
19. When the formula = H2 + C$14 is dragged from cell J2 to J11 then the formula in cell J11 will be ________
20. Shortcut of Left Alignment in LibreOffice Calc is _____
21. Which of the following feature in LibreOffice Calc speed up the data entry?
22. Format cell dialog box can be opened by _____
23. ________key is used to select more than one ‘range of cells’ in a worksheet.
24. Evaluate the following expression, if cell A1, B1 and C1 has values 10, 20 and 30 respectively.
=A1 * B1 – C1
25. Which of the following is not true about Currently Selected Cell?

⚡ Recently practiced quizzes in this topic
Live quiz activity
IT 402 Unit 2 Electronic Spreadsheet Advanced Class 10 Practice Test: Link Data And Spreadsheet IT-402 Data Entry and Keyboarding Skills Class 9 Practice Test IT 402 Important Communication Skills Class 9 Practice Test IT 402 Unit 3 RDBMS Class 10 Practice Test IT 402 Important Communication Skills Class 10 Practice Test 2 IT 402 Digital Documentation Class 10 Practice Test IT 402 ICT Skills Class 10 Practice Test 2 IT 402 Unit 2 Electronic Spreadsheet Advanced Class 10 Practice Test IT-402 Digital Documentation Class 9 Practice Test IT 402 Digital Documentation Class 10 Practice Test
 
❤ If you liked Fatskills, consider supporting us by checking out The Life Manuals You Never Got.

🌈  Our mission is to help improve your scores in any subject and exam withonline quizzes, practice tests, study guides, & advice for students. Since 2018.
About | Explore | User Guide | Topics | Subjects | Doubt Solver | Career Aptitude Test | Answers | Free Tools | OSHA Basics Quiz | What Should We Know?
Privacy | Terms |
Without work one finishes nothing. - Ralph Waldo Emerson
© 2026 Fatskills.com

All trademarks, logos and brand names are the property of their respective owners. All company, product and service names used in this website are for identification purposes only. Use of these names, trademarks and brands does not imply endorsement.