G9 - Final Exam It
G9 - Final Exam It
G9 - Final Exam It
General Instructions:
ii. You want to make a table for the scores achieved by the 1
students. While typing “Name of the students”, you noticed
that the text couldn’t be accommodated within a cell. In this
case, for creating a proper table what should you do?
ii. _________ menu allows to start and control the Open office Help 1
system to get information about any topic related with Open
office package.
a. View b. File c. Menu d. Help
iii. The cell reference in a spreadsheet for cell range B2 to F15 is 1
________.
a. B2. F15 b.B2; F15 c.B2: F15 d. B2-F15
iv. Identify the part of a Spreadsheet using which a user can 1
manage multiple sheets.
a. Status Bar b. Sheet Tab c. Formula Bar d. Worksheet Area
v. The default setting of margins on top and bottom in a 1
document is:
a. 0.79” b. 0.83” c. 0.81” d. 0.80”
vi. Which of the following is not true about currently selected cell? 1
a. Currently selected cell is called Active cell.
b. Currently selected cell’s Address is visible in Name box.
c. Currently selected cell has thick border.
d. None of the above.
A B C D E F
1 NAME BASIC HRA DA Bonus NET
(Monthly) (% of (Rs) SALAR
(Rs.) Basic) Y
2 Suresh 5000 10 450 600
3 Karishma 5600 13 800 600
4 Atul 3500 15 900 400
5 Harmeet 4500 15 500 500
6 Abhay 6000 20 400 700
7 Jyotsana 7500 12 500 700
8 Amit 2500 10 300 700
9 Total
salary
10 No. of
Emp
iv. The manager wants to insert a new column next to HRA for
Travel Allowance. How will he do it?