NEW
Font size
WorksheetsPractice Quiz-2(IT)
Total questions: 50
Worksheet time: 25mins
Which of the following functions are available in consolidate window?
Max
Min
Count
All of the above
Subtotals is available in __________ menu.
Data
Tools
Format
Insert
In Subtotals we can select up to _______ groups of arrays.
1
2
3
4
Scenarios are tool to test _________ analysis questions.
if else
what else
what if
none of these
By default ________________ sheets are present in Spreadsheet
1
2
3
4
. Formula to refer a cell A3 in sheet named S1 is
S1.A3
S1A3
A3
'S1.A3
Hyperlink option is available in ______ menu.
DATA
TOOLS
FORMAT
INSERT
Which feature of Calc help to see the changes made in the shared worksheet
Record changes
solver
subtotal
none of the above
1 _________ allows you to gather data from different worksheets into a master worksheet.
Data Consolidation
Goal Seek
Solver
Subtotal
To activate the record changes feature in shared worksheet ___________
Select File > Changes > Record from the menu bar
Select Edit > Changes > Record from the menu bar.
Select View > Changes > Record from the menu bar
Hyperlink in Calc can be used to
to jump from one sheet to another sheet.
to jump from one sheet to website
to link to an email or news
all of the above
_____________ is a saved sequence of commands or keystrokes that are stored for later use
share worksheet
Autosum
Command
Macro
Which option is suitable to calculate the effect of different interest rates on an investment.
Scenario
Subtotal
Consolidate
none of these
We can rename an existing sheet in Calc by
Double click on one of the existing sheet
Right click on existing sheet and then choose rename
Both of the above
None of the above
What should be entered in formula cell, target value and variable cell if we want to calculate marks to be obtained in english in semester 4 in order to attain 75 % using goal seek
Formula cell-B5, TARGET VALUE-75, VARIABLE CELL- B6
FORMULA CELL- B6, TARGET VALUE- B5, VARIABLE CELL-75
FORMULA CELL- B6, TARGET VALUE- 75, VARIABLE CELL-B5
________amounts to a more elaborate form of Goal Seek
what if
find what
solver
multiple operations
Scenario option is accessed from which menu?
Tools
data
Format
Create
Akshat wants to predict his result from the given set of data from recently exam results. Which option is useful for him?
a) Scenario
b) Multiple operations
c) Solver
d) Goal Seek
Scenarios are tool to test _________ analysis questions.
if else
what else
what if
none of these
Shaan is working on a spreadsheet and he performed the operation data consolidation. But he wanted to generate the results in the target instead of the actual results. Select the appropriate option he can choose?
a) Copy to
b) Consolidation Ranges
c) Link to source data
d) Function
Which of the following tool is used to test the what-if questions?
a) goal seek
b) scenarios
c) subtotal
d) Consolidate data
The scenario name is displayed on
a) Sheet tab
b) Name box
c) Navigator and Title bar of scenario
d) Top of the row
Divya wants to prepare a master sheet with a combination of data from another 3 worksheets. Which of the following feature is useful for her?
Data Table
Data Consolidate
Link worksheets
Cell Referencing
Name the toolbar that will appear automatically when you select an image in document
Picture Toolbar
Drawing Toolbar
Formatting Toolbar
None of Above
________ is the process of merging the main document with the mailing address of various persons.
Mail Merge
Mail Maker
Mail dropper
Mailer
What are the steps to modify a heading in a paragraph style?
Right click on a heading -> Modify
Edit-> Modify
Modify->Paragraph
Ananya wants that her company’s logo should automatically appear on the top of the Writer document whenever she opens a new document. Which feature of Writer will help her to do so?
Style
Automatic
Template
All of the above
Which of the following options place the steps in the correct order based on the step by step wizard?
A. Write Letter
B. Perform Mail Merge
C. Create Database
D. Link Letter and Database
B,C,D,A
A,B,C,D
C,B,A,D
C,A,D,B
Which of the following contains the variable data to be merged with the unchanging data?
Data source
Main document
Control document
Master letter
Template option is available in ________________menu
File
Edit
Insert
Tool
A Merge Field appears as:
<<Firstname>>
@Firstname@
Firstname
^Firstname^
click on _____________ menu to open Gallery
Format
Insert
View
Tools
in which of the following, size of image does not change even after cropping image?
keep scale
keep image size
both of the above
none of these
____________ is a model that we use to create other documents.
template
style
image
none of these
Which of the following is not a 'What-if Analysis' tool?
Scenario
Track Change
Solver
Goal Seek
'What-if Analysis' Goal Seeking'- Allows you to define input variables in various situations. The output result for each situation is shown in a summary table.
True
False
Which of the following is NOT an example of a 'What-if analysis'?
Find how raises will affect employee salaries
Find the five top sales people in a company
Find the business profits for different levels of sales
Find the loan payments based for different interest rates
Which of the following is not a 'What-if Analysis' tool?
Scenario
Track Change
Solver
Goal Seek
'What-if Analysis' Goal Seeking'- Allows you to define input variables in various situations. The output result for each situation is shown in a summary table.
True
False
Which of the following is NOT an example of a 'What-if analysis'?
Find how raises will affect employee salaries
Find the five top sales people in a company
Find the business profits for different levels of sales
Find the loan payments based for different interest rates
Which 'What-if analysis' tool will help you solve the following problem? You want to figure out how to keep a car loan under Rs. 12000 a month.
Goal Seeking
Scenario
Solver
This cannot be solved.
What must all formulas start with?
+
=
#
sum
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
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
