MABS Institution
11th Computer Technology Weekly Test - 3 ( Data Tools and Printing )-Aug 2020
-
-
-
-
-
-
What will be value returned by = DECIMAL (“16;”1101)
12
13
D
E
-
There are 10000 rows in a spread-sheet. The user need to view a particular row of the database. Which of the following tool is used?
Sorting
Merging
Filtering
Formatting
-
-
If cell A5 contains value 18, then if (A26<5; “True”, “False”) will return
True
False
Blasse
Error
-
The size of an A4 paper is 21 cm x 29 cm. If the user chooses Landscape orientation, then the size of the paper is…..?
21 x 29
29 x 21
None of the above
All of the above
-
-
To protect cell in Open Office Calc Format → Cells and click which tab?
Protect Cell
Protection Cell
Cell Protection
Cell Protect
-
Which command is used to show the hidden row in OpenOffice Calc?
Format → Row → Show
Format → Show → Row
Format→Display→Row
Format → Row → Display
-
To select multiple continuous sheet which key is used?
Ctrl
Shift
Alt
tab
-
To delete a single sheet which command is to be selected?
File → Sheet → Delete
Delete →Sheet→Delete
Sheet → Delete
Edit → Sheet → Delete
-
Write the method to rename sheet.
-
What are the type of the filters?
-
How to select continuous and non-continuous sheets in OpenOffice Calc?
-
What is Chart?
-
What are the types of Cell addressing?
-
What is header and footer?
-
Write the steps to format the margin of the paper as 1” in all sides.
-
What is the use of freezing a sheet?
-
What is sorting?