WorksheetsClass Test Xth
Total questions: 24
Worksheet time: 16mins
Which of the following tools is not available in excel to perform What if Analysis?
Word Art
Data Table
Goal Seek
Scenario manager
Hyperlink in Calc can be used :
TO jump from one sheet to another
To jump from one sheet to website.
To jump from one section to another section.
All the above
We can insert the new sheet in the cal by clicking on ____________menu.
Format
Edit
Insert
Tool
During ____________ the contents of the cells from several sheets can be combined.
Solver
Consolidation
Scenerio
SubTotal
What is the default file extension of Open Office Calc?
.ods
.odt
.obd
.odb
Which of the following deals with equation with multiple unknown variables?
Subtotal
Scenerio
Solver
Goal Seek
Shared workbook don't allow:
Merging Cells
Conditional formatting
Inserting pictures or graphs
All of the above
________ is a saved sequence of commands and keystrokes that are stored for future use.
MACROS
Goal Seek
Solver
Consolidation
Anu could not find certain characters on the keyboard to type in her document. Which feature of the word processor program should help her?
a. Shapes and special characters
b. Shapes and symbols
c. Symbols and special characters
d. WordArt
What is the keyboard shortcut to Cut the text in Writer?
(a) Ctrl +C
(b) Ctrl +V
(c) Ctrl + X
d) Ctrl + P
Why would you put a filter on your spreadsheet?
To view the top row at all times
To view specific criteria in your spreadsheet
To help with formulas
To delete data from your spreadsheet
What is the difference between a worksheet and a workbook?
A worksheet is a workbook within a workbook
A worksheet is a sheet within a workbook
A worksheet has to be inserted into a workbook
A worksheet is part of the cells in a workbook
We can insert the new sheet in the cal by clicking on ____________menu.
Format
Edit
Insert
Tool
What do all calculations start with?
=
(
-
\
What is the difference between a formula and a function?
A function deals with a whole range of cells in one go and has a function name at the beginning, whereas a formula lists each cell individually and puts the correct mathematical operator between them
A formula deals with a whole range of cells in one go and has a function name at the beginning, whereas a function lists each cell individually and puts the correct mathematical operator between them
There is no difference between a formula and a function, they are the same
A formula is something we use in maths, whereas a function is something we use in ICT
Which of the following is a valid function?
=sum(A1:A6)
sum=(A1:A6)
=sum[A1:A6]
=sum(A1,A6)
Naveen has inserted a large picture in his document covering half the page. He wants to keep the picture on one side of the page. Which of the features must help him in doing so?
a. Cropping
b. Rotating
c. Text wrapping
d. Resizing
The label’s height and width are referred to as which of the following?
a. Vertical pitch
b. Horizontal pitch
c. Both a. and b.
d. Page size
Which of the following is not a component of Office Suite?
(a) Writer
(b) Impress
(c) Internet Explorer
(d) Base
Which of the following enables us to send the same letter to different persons?
(a) Writer
(b) Template
(c) Mail Merge
(d) None of the above.
To ungroup or break apart a group of objects, select the group then go to Format > Group > ________________ on the menu bar.
(a) Group
(b) Enter group
(c) Ungroup
(d) None of these
