-
question_answer1)
Calc is the ................... component of the Open Office/Libre Office.
A)
Text done
clear
B)
Presentation done
clear
C)
Spreadsheet done
clear
D)
Database done
clear
View Solution play_arrow
-
question_answer2)
Calc is a spreadsheet application that can be used to...................
A)
calculate done
clear
B)
analyze done
clear
C)
manage your data done
clear
D)
All of the above done
clear
View Solution play_arrow
-
question_answer3)
In spreadsheet, letters are used to represent..................
A)
Rows done
clear
B)
Columns done
clear
C)
Cells done
clear
D)
Block done
clear
View Solution play_arrow
-
question_answer4)
................helps us to see patters.
A)
Graph done
clear
B)
Spreadsheet done
clear
C)
Range done
clear
D)
Charts done
clear
View Solution play_arrow
-
question_answer5)
In spreadsheet, tool used to construct formulas is called.................
A)
Filter done
clear
B)
Formula Bar done
clear
C)
Formatting Toolbar done
clear
D)
Cell done
clear
View Solution play_arrow
-
question_answer6)
Computer Teacher of 'Shanti Education School' wants to graphically analyse the performance of her students over the last three Computer Tests. Which one of the following office tools she should use to get graphical report in most effective manner with minimum effort
A)
Word Processing Software done
clear
B)
Presentation Software done
clear
C)
Spreadsheet Software done
clear
D)
Database Management System done
clear
View Solution play_arrow
-
question_answer7)
The school tuck-shop would like to keep a record of its sales on the computer. Which program would be most suitable?
A)
Word processor done
clear
B)
Spreadsheet done
clear
C)
Database done
clear
D)
Desk top publisher done
clear
View Solution play_arrow
-
question_answer8)
A worksheet is better than calculations by hand because
A)
The worksheet finds the answers faster done
clear
B)
The worksheet is more accurate done
clear
C)
The worksheet recalculates the results whenever you change a number in the cell done
clear
D)
All of the above done
clear
View Solution play_arrow
-
question_answer9)
Nilesh Aiyar is interested in storing his salary details and he also wants to perform some calculations and analysis. Which Office application, will you suggest Nilesh should use for this purpose?
A)
Word Processing Software done
clear
B)
Presentation Software done
clear
C)
Spreadsheet Software done
clear
D)
Database Management System done
clear
View Solution play_arrow
-
question_answer10)
How many sheets are there in a work book by default?
A)
One done
clear
B)
Two done
clear
C)
Three done
clear
D)
Four done
clear
View Solution play_arrow
-
question_answer11)
Where is the address of the active cell displayed?
A)
Row heading done
clear
B)
Status bar done
clear
C)
Formula bar done
clear
D)
Name Box done
clear
View Solution play_arrow
-
question_answer12)
Spreadsheet cell that is highlighted with heavy border is..................
A)
Main Cell done
clear
B)
Active Cell done
clear
C)
Cell done
clear
D)
Locked Cell done
clear
View Solution play_arrow
-
question_answer13)
Spreadsheet, sometimes is called as
A)
Cells done
clear
B)
Worksheet done
clear
C)
Menus done
clear
D)
Notebook pages done
clear
View Solution play_arrow
-
question_answer14)
Which of the following data can be typed into a Spreadsheet cell?
A)
Formulae done
clear
B)
Text done
clear
C)
Numbers done
clear
D)
All of these done
clear
View Solution play_arrow
-
question_answer15)
What is the maximum number of characters in one cell in calc spreadsheet?
A)
6000 done
clear
B)
32767 done
clear
C)
255 done
clear
D)
1021 done
clear
View Solution play_arrow
-
question_answer16)
A formula in calc may begin with
A)
= done
clear
B)
+ done
clear
C)
- done
clear
D)
All the above done
clear
View Solution play_arrow
-
question_answer17)
What is the answer to the formula = B2+B3*B4 on the worksheet below?
|
|
A)
16 done
clear
B)
21 done
clear
C)
18 done
clear
D)
13 done
clear
View Solution play_arrow
-
question_answer18)
What will be the result from the following formula \[(\text{Assume }A1=5,\text{ }B2=2)?=A1\hat{\ }B2\]
A)
7 done
clear
B)
25 done
clear
C)
10 done
clear
D)
52 done
clear
View Solution play_arrow
-
question_answer19)
What does ##### mean?
A)
The column is not wide enough to display the content. done
clear
B)
The cell reference is not valid. done
clear
C)
You have misspelled a function name done
clear
D)
None of above done
clear
View Solution play_arrow
-
question_answer20)
What is the result of this formula: = 1 + 2*3-1?
A)
4 done
clear
B)
6 done
clear
C)
8 done
clear
D)
10 done
clear
View Solution play_arrow
-
question_answer21)
What will happen if you type F5 + F6 into a cell without a beginning equal sign?
A)
The entry is the same as the formula = F5 + F6. done
clear
B)
The cell will display the information cell F5 plus F6. done
clear
C)
The entry will be treated as a text entry and F5 + F6 will show in the cell done
clear
D)
None of above done
clear
View Solution play_arrow
-
question_answer22)
You are working in a spreadsheet and have selected cell C4. If you moved two columns to the right and three rows down, which cell would then be selected?
A)
D6 done
clear
B)
E6 done
clear
C)
F7 done
clear
D)
E7 done
clear
View Solution play_arrow
-
question_answer23)
............... displays the information about the current status of a worksheet.
A)
Menu bar done
clear
B)
Status Bar done
clear
C)
Tool bar done
clear
D)
All of the above done
clear
View Solution play_arrow
-
question_answer24)
Marks scored by students in a class are entered in a spreadsheet along with their names as follows
Name |
Marks |
Aman |
445 |
Rahman |
432 |
Anita |
456 |
Amisha |
421 |
Gorge |
442 |
Fatima |
487 |
If we want to have a Merit List of these students i.e. student's marks appearing in descending order with corresponding names, which one of the following options will accomplish this task in one go
A)
Copy & Paste done
clear
B)
Reverse done
clear
C)
Search done
clear
D)
Sort done
clear
View Solution play_arrow
-
question_answer25)
Which command reverses the last action performed in the worksheet?
A)
Cut done
clear
B)
Undo done
clear
C)
Redo done
clear
D)
Paste done
clear
View Solution play_arrow
-
question_answer26)
............... allows you to gather data from different worksheets into a master worksheet.
A)
Data Consolidation done
clear
B)
Goal Seek done
clear
C)
Solver done
clear
D)
Total data done
clear
View Solution play_arrow
-
question_answer27)
Data can be consolidated from two sheets only.
A)
True done
clear
B)
False done
clear
C)
Both of the above done
clear
D)
None of the above done
clear
View Solution play_arrow
-
question_answer28)
Which of the following option allows to select the source of data for the consolidation?
A)
Function done
clear
B)
Consolidation Ranges done
clear
C)
Source Data range done
clear
D)
Copy results to done
clear
View Solution play_arrow
-
question_answer29)
Which of the following option of consolidate dialog box allow to select destination cells?
A)
Function done
clear
B)
Consolidation Ranges done
clear
C)
Source Data range done
clear
D)
Copy results to done
clear
View Solution play_arrow
-
question_answer30)
The ................ feature provides the contents of one cell from more than one sheet that can be combined in one place.
A)
Goal Seek done
clear
B)
Solver done
clear
C)
Total data done
clear
D)
Data Consolidation done
clear
View Solution play_arrow
-
question_answer31)
Consolidate option is available under.................... menu.
A)
View done
clear
B)
Tool done
clear
C)
Insert done
clear
D)
Data done
clear
View Solution play_arrow
-
question_answer32)
We can consolidate data by .....................
A)
Row Label done
clear
B)
Column Label done
clear
C)
Both of the above done
clear
D)
None of the above done
clear
View Solution play_arrow
-
question_answer33)
Which of the following functions are available in consolidate window?
A)
Max done
clear
B)
Min done
clear
C)
Count done
clear
D)
All of the above done
clear
View Solution play_arrow
-
question_answer34)
In which option we have to specify the target range (Where we want the result to be displayed)
A)
Source data range done
clear
B)
Copy results to done
clear
C)
Need result at done
clear
D)
target range done
clear
View Solution play_arrow
-
question_answer35)
If you select................ then any values modified in the source range are automatically updated in the target range.
A)
Link to source data done
clear
B)
Link to sheet data done
clear
C)
Link to original data done
clear
D)
Link to source range done
clear
View Solution play_arrow
-
question_answer36)
Which option is used to name a range of cells?
A)
Range name done
clear
B)
Cell Range done
clear
C)
Define Range done
clear
D)
Select Range done
clear
View Solution play_arrow
-
question_answer37)
Define range option is available under .................menu.
A)
Insert done
clear
B)
View done
clear
C)
Developer done
clear
D)
Data done
clear
View Solution play_arrow
-
question_answer38)
The ............ feature allows us to make a total of given data into a group with row labels and column headers.
A)
Data Consolidation done
clear
B)
Goal Seek done
clear
C)
Solver done
clear
D)
Sub Total done
clear
View Solution play_arrow
-
question_answer39)
Which function is not a Subtotal function?
A)
MAX done
clear
B)
SUM done
clear
C)
AGGREGATE done
clear
D)
AVERAGE done
clear
View Solution play_arrow
-
question_answer40)
SUBTOTALS ............... data arranged in a group of cells.
A)
Add done
clear
B)
Average done
clear
C)
Find done
clear
D)
Clear done
clear
View Solution play_arrow
-
question_answer41)
In Subtotals we can select up to.................groups of arrays.
A)
3 done
clear
B)
2 done
clear
C)
4 done
clear
D)
Infinite done
clear
View Solution play_arrow
-
question_answer42)
Identify the correct sequence
A)
First open subtotals window and then select the data where we need to apply subtotals. done
clear
B)
First Select data and then open subtotals window. done
clear
C)
Both of the above are correct done
clear
D)
None of the above done
clear
View Solution play_arrow
-
question_answer43)
A worksheet of faculty members of a university contains these columns in this sequence: Designation, Last Name, First Name, Department and Salary. What is the first step to subtotal departmental salaries?
A)
Sort by Last Name done
clear
B)
Sort by Salary done
clear
C)
Sort by Rank done
clear
D)
Sort by Department done
clear
View Solution play_arrow
-
question_answer44)
In Calc which is used to perform what if analysis?
A)
Solver done
clear
B)
Goal seek done
clear
C)
Scenario Manager done
clear
D)
All of the above done
clear
View Solution play_arrow
-
question_answer45)
Which of the following is NOT one of Calc what if functions?
A)
Goal seek done
clear
B)
Solver done
clear
C)
Scenario Manager done
clear
D)
Auto Outline done
clear
View Solution play_arrow
-
question_answer46)
Scenario option is available in........................menu.
A)
Data done
clear
B)
Tools done
clear
C)
Insert done
clear
D)
Windows done
clear
View Solution play_arrow
-
question_answer47)
Which option is suitable to calculate the effect of different interest rates on an investment?
A)
Scenario done
clear
B)
Subtotal done
clear
C)
Consolidate done
clear
D)
None of the above done
clear
View Solution play_arrow
-
question_answer48)
.............. is more elaborate form of Goal Seek.
A)
Scenario done
clear
B)
Subtotal done
clear
C)
Solver done
clear
D)
All of the above done
clear
View Solution play_arrow
-
question_answer49)
Which of the following in not information you can specify using the solver?
A)
Input cells done
clear
B)
Constraints done
clear
C)
Target cell done
clear
D)
Changing cell done
clear
View Solution play_arrow
-
question_answer50)
Which terms refers to specific set of values saved with workbook?
A)
Range done
clear
B)
Scenario done
clear
C)
What if analysis done
clear
D)
Function done
clear
View Solution play_arrow
-
question_answer51)
................ feature provides a target based result and informs the user about the changes in value in the applied formula.
A)
Goal Seek done
clear
B)
Subtotal done
clear
C)
Data Consolidation done
clear
D)
Function done
clear
View Solution play_arrow
-
question_answer52)
To run a Goal Seek, at least one of the values for an argument must be
A)
Value done
clear
B)
Function done
clear
C)
Cell reference done
clear
D)
All of the above done
clear
View Solution play_arrow
-
question_answer53)
Which of the following option is used to type a resultant value to achieve the goal?
A)
Goal Value done
clear
B)
Target Value done
clear
C)
Variable Value done
clear
D)
Goal Seek Value done
clear
View Solution play_arrow
-
question_answer54)
We can shift from one scenario to another by.................
A)
Navigator done
clear
B)
Find and Replace done
clear
C)
Data Source done
clear
D)
None of the above done
clear
View Solution play_arrow
-
question_answer55)
We can create only 3 scenarios for a given range of cells.
A)
True done
clear
B)
False done
clear
C)
May be done
clear
D)
None of the above done
clear
View Solution play_arrow
-
question_answer56)
By default sheets tab are present at the .................... of the spreadsheet.
A)
Top done
clear
B)
Bottom done
clear
C)
Both of the above done
clear
D)
None of the above done
clear
View Solution play_arrow
-
question_answer57)
We can insert the new sheet in Calc by clicking on .................. menu.
A)
Format done
clear
B)
Edit done
clear
C)
Insert done
clear
D)
Tool done
clear
View Solution play_arrow
-
question_answer58)
Which of the following elements are present in "Insert Sheet" dialog box?
A)
After Current Sheet done
clear
B)
Before Current Sheet done
clear
C)
No. of Sheets done
clear
D)
All of the above done
clear
View Solution play_arrow
-
question_answer59)
We can rename a new sheet in Calc
A)
After inserting a new sheet done
clear
B)
While inserting a new sheet done
clear
C)
Both of the above done
clear
D)
None of the above done
clear
View Solution play_arrow
-
question_answer60)
Formula to refer a cell A3 in sheet named S1 is
A)
= S1A3 done
clear
B)
= S1.A3 done
clear
C)
= "S1" .A3 done
clear
D)
None of the above done
clear
View Solution play_arrow
-
question_answer61)
In a Spreadsheet, the following reference changes rows and columns automatically when it is copied to a new cell
A)
Relative Reference done
clear
B)
Absolute Reference done
clear
C)
Mixed Reference done
clear
D)
All of the above done
clear
View Solution play_arrow
-
question_answer62)
How is a relative reference different from an absolute reference?
A)
It includes column and row references. done
clear
B)
It adjusts to its location on the worksheet. done
clear
C)
It refers to an existing cell on the worksheet. done
clear
D)
It resets to its original value. done
clear
View Solution play_arrow
-
question_answer63)
Hyperlink in Calc can be used
A)
To jump from one sheet to another sheet. done
clear
B)
To jump from one sheet to website done
clear
C)
To jump from one section to another section of same sheet done
clear
D)
All of the above done
clear
View Solution play_arrow
-
question_answer64)
If you have two spreadsheets in the same folder linked to each other and you move the entire folder to a new location, a relative hyperlink will.......................
A)
not work done
clear
B)
work done
clear
C)
may work done
clear
D)
None of the above done
clear
View Solution play_arrow
-
question_answer65)
Hyperlink option is available in................. menu.
A)
File done
clear
B)
Edit done
clear
C)
Format done
clear
D)
Insert done
clear
View Solution play_arrow
-
question_answer66)
When you group worksheets
A)
You can enter variable data on multiple worksheets at one time done
clear
B)
You can print more than one worksheet at a time done
clear
C)
You can enter common data, formats, and formulas on multiple worksheets at one time done
clear
D)
Both (a) and (b) done
clear
View Solution play_arrow
-
question_answer67)
If a cell addresses changes after copying the formula then the address is known as
A)
Absolute Address done
clear
B)
Relative Address done
clear
C)
Mixed Address done
clear
D)
Dynamic Address done
clear
View Solution play_arrow
-
question_answer68)
How many types of cell references are there in Calc?
A)
1 done
clear
B)
2 done
clear
C)
3 done
clear
D)
4 done
clear
View Solution play_arrow
-
question_answer69)
In Calc link to external data is present in..................menu.
A)
File done
clear
B)
Edit done
clear
C)
Insert done
clear
D)
view done
clear
View Solution play_arrow
-
question_answer70)
Absolute link will stop working only if the target is moved.
A)
True done
clear
B)
False done
clear
C)
None of above done
clear
D)
Both of above done
clear
View Solution play_arrow
-
question_answer71)
Namya and her friends want to work together in a spreadsheet. They can do so by
A)
Sharing Workbook done
clear
B)
Linking Workbook done
clear
C)
Both of the above done
clear
D)
None of the above done
clear
View Solution play_arrow
-
question_answer72)
In Calc "Share Document" dialog box can open by clicking on ................. menu.
A)
File done
clear
B)
Edit done
clear
C)
View done
clear
D)
Tools done
clear
View Solution play_arrow
-
question_answer73)
After sharing the worksheet, the word .................. is then shown on the title bar after the worksheet's tide
A)
Sharing done
clear
B)
Shared done
clear
C)
Sharing Sheet done
clear
D)
None of the above done
clear
View Solution play_arrow
-
question_answer74)
Share document option available in ............... menu.
A)
Tools done
clear
B)
View done
clear
C)
Edit done
clear
D)
File done
clear
View Solution play_arrow
-
question_answer75)
Comments put in cells are called?
A)
Smart tip done
clear
B)
Cell tip done
clear
C)
Web tip done
clear
D)
Soft tip done
clear
View Solution play_arrow
-
question_answer76)
.................. feature of Calc help to see the changes made in the shared worksheet.
A)
Comments done
clear
B)
Tools done
clear
C)
Record Changes done
clear
D)
None of the above done
clear
View Solution play_arrow
-
question_answer77)
................ coloured border appears around a cell where changes were made in shared worksheet.
A)
Blue done
clear
B)
Yellow done
clear
C)
Green done
clear
D)
Red done
clear
View Solution play_arrow
-
question_answer78)
Record Changes feature of Calc help
A)
Authors and other reviewers to know which cells were edited done
clear
B)
to record the screen done
clear
C)
to make changes permanent done
clear
D)
None of the above done
clear
View Solution play_arrow
-
question_answer79)
Which of the following changes are not recorded in shared worksheet?
A)
Changes any number done
clear
B)
Changes any text done
clear
C)
Cell Formatting done
clear
D)
None of the above done
clear
View Solution play_arrow
-
question_answer80)
Worksheets can be merged from ................... menu.
A)
Edit done
clear
B)
File done
clear
C)
View done
clear
D)
Tools done
clear
View Solution play_arrow
-
question_answer81)
A ..................... is a saved sequence of commands or keystrokes that are stored for later use
A)
Solver done
clear
B)
Autosum done
clear
C)
Consolidate done
clear
D)
Macro done
clear
View Solution play_arrow
-
question_answer82)
Which language is used to create macros in Excel?
A)
Visual Basic done
clear
B)
C done
clear
C)
Visual C++ done
clear
D)
Java done
clear
View Solution play_arrow
-
question_answer83)
What is a macro used for?
A)
To access programs done
clear
B)
To create buttons and forms done
clear
C)
To automatically complete a series of steps done
clear
D)
To link files together done
clear
View Solution play_arrow
-
question_answer84)
A piece of a macro that completes some sub task is called a .................. procedure.
A)
function done
clear
B)
sub done
clear
C)
visual done
clear
D)
sub macro done
clear
View Solution play_arrow
-
question_answer85)
Macros are run or executed from the................... menu.
A)
Insert done
clear
B)
Format done
clear
C)
Tools done
clear
D)
Data done
clear
View Solution play_arrow
-
question_answer86)
Why macros are used?
A)
To link formulas of different worksheets done
clear
B)
To find value of a variable done
clear
C)
To draw charts done
clear
D)
To automate repetitive tasks done
clear
View Solution play_arrow
-
question_answer87)
Use
Macro to start the macro recorder.
A)
Tools > Macros > Record done
clear
B)
Tools > Record > Record Macro done
clear
C)
Data > Macros > Record done
clear
D)
None of the above done
clear
View Solution play_arrow
-
question_answer88)
Click .................. to stop the macro recorder
A)
Close Recording done
clear
B)
End Recording done
clear
C)
Stop Recording done
clear
D)
None of the above done
clear
View Solution play_arrow
-
question_answer89)
Study the screenshot below. What is the appropriate action to take when a workbook displays this message. |
|
A)
Close it immediately and delete the file. done
clear
B)
Check where the file originates from, and if it is a trusted source or your own workbook, click Enable Content. done
clear
C)
Close the file then right-click and rename it before opening it again. done
clear
D)
None of the options listed above are correct. done
clear
View Solution play_arrow
-
question_answer90)
Function names in Calc are not case sensitive.
A)
True done
clear
B)
False done
clear
C)
Both (a) and (b) done
clear
D)
None of the above done
clear
View Solution play_arrow
-
question_answer91)
............... is specifically designed to minimise or maximise the result according to a set of rules that you define in aspreadsheet. (C.B.S.E. Sample Paper 2021)
A)
Goal Seek done
clear
B)
Scenario done
clear
C)
Solver done
clear
D)
Subtotal done
clear
View Solution play_arrow
-
question_answer92)
The intersection point between a row and column is called............ (C.B.S.E. Sample Paper 2021)
A)
Row done
clear
B)
Column done
clear
C)
Table done
clear
D)
Cell done
clear
View Solution play_arrow
-
question_answer93)
Formulas in a Spreadsheet must begin with a.............. sign. (C.B.S.E. Sample Paper 2021)
A)
$ done
clear
B)
@ done
clear
C)
# done
clear
D)
= done
clear
View Solution play_arrow
-
question_answer94)
................. is a tool to test "what-if" questions. (C.B.S.E. Sample Paper 2021)
A)
Scenario done
clear
B)
Solver done
clear
C)
Macro done
clear
D)
Average done
clear
View Solution play_arrow
-
question_answer95)
Rohit scored 25 out of 30 in English, 22 out of 30 in Maths. He wants to calculate the score in IT he needs to achieve 85 percent in aggregate. Suggest him the suitable option out of the following to do so. (C.B.S.E. Sample Paper 2021)
A)
Macro done
clear
B)
Solver done
clear
C)
Goal Seek done
clear
D)
Sub Total done
clear
View Solution play_arrow
-
question_answer96)
................ can be used in a spreadsheet software to jump to a different location from within a spreadsheet and can lead to other parts of the current file, to different files or even to websites. (C.B.S.E. Sample Paper 2021)
A)
Illustrations done
clear
B)
Hyperlinks done
clear
C)
Links done
clear
D)
Filter done
clear
View Solution play_arrow
-
question_answer97)
Krish and Kritika have done a survey of age wise literacy rates of their locality as a school project, which they have created in a Spreadsheet. They both want to work simultaneously to complete it on time. Which option they should use to access the same Spreadsheet to speed up their work. (C.B.S.E. Sample Paper 2021)
A)
Consolidate Worksheet done
clear
B)
Shared Worksheet done
clear
C)
Link Worksheet done
clear
D)
Lock Worksheet done
clear
View Solution play_arrow