CBSE Class 10 Computer Science Electronic Spreadsheet Advanced

Question. Which of the following help us to perform various calculations?
a. Writer
b. Spreadsheet
c. Impress
d. None of the above

Answer : B

Question. Which of the following is not a Spreadsheet Software?
a. Microsoft Excel
b. LibreOffice Calc
c. OpenOffice Calc
d. None of the above

Answer : D

Question. Default name of spreadsheet open in LibreOffice Calc is _______
a. Untitled X, where X is a number
b. Calc X, where X is a number
c. Spreadsheet X, where X is a number
d. None of the above

Answer : A

Question.  _____________ contains the menus with commands for various tasks.
a. Status bar
b. Standard Tool bar
c. Formatting Tool bar
d. Menu bar

Answer : D

Question. Placing the mouse cursor over any icon displays a small box called _________________ which gives a brief explanation of the icon.
a. Toolbar
b. Toolbox
c. Tooltip
d. All of the above

Answer : C

Question. The intersection of a row and column is called _________.
a. Cell Address
b. Cell
c. Point of intersection
d. None of the above

Answer : B

Question. Which key combination moves the active cell (Selected Cell) to A1 cell?
a. Ctrl + Home
b. Ctrl + End
c. Ctrl + Arrow keys
d. None of the above

Answer : A

Question. Cell Range A1:D3 consist of ___________ cells.
a. 3
b. 4
c. 12
d. 10

Answer : C

Question. The data consisting of only numbers are called _______
a. Labels
b. Values
c. Functions
d. None of the above

Answer : B

Question. Evaluate the following formula := 16/(4^2)
a. 0
b. 1
c. 16
d. 8

Answer : B

Question. When we enter an equal sign (‘=’) in any cell, then ____________ bar gets activated automatically.
a. Formula
b. Formatting
c. Menu
d. None of the above

Answer : A

Question. To insert the column before any column select ___
a. Sheet → Insert Columns → Columns left
b. Sheet → Insert Columns → Columns right
c. Sheet → Insert Columns → Columns
d. None of the above

Answer : A

Question. Evaluate the following expression, if cell A1, B2, C2 and D3 has values 10, 2, 3, 36.=(D3/(A1+B2))^C2
a. 64
b. 216
c. 27
d. 125

Answer : C

Question. Which of the following function calculate the average in LibreOffice Calc?
a. AVG( )
b. AVERAGE( )
c. Both of the above
d. None of the above

Answer : B

Question. Which of the following formula will calculate area of square (side = 9)
a. =9 * 9
b. = 9 ^ 2
c. Both of the above
d. None of the above

Answer : C

Question. In _________________ tab of Format cell dialog box, we can specify the number of decimal places.
a. Borders
b. Background
c. Numbers
d. Font

Answer : C

Question.  _____________ tool is used to fill the next cells till you drag it with the next predefined value.
a. Fill Handle
b. Fill
c. Fill Series
d. None of the above

Answer : A

Question. When the formula =C2 * D2 is dragged from cell E2 to E6 then the formula in cell E6 will be ______
a. =G2 * H2
b. =C6 * D6
c. =C2 * D6
d. =G2 * H6

Answer : B

Question. When the formula = H2 + C$14 is dragged from cell J2 to J11 then the formula in cell J11 will be ________
a. =H11 + C$14
b. =H11 + C$25
c. =H2 + C$14
d. None of the above

Answer : A

Question. When you drag formula = A$7 downward then __
a. Only row number will changes
b. Only column heading will changes
c. Both row number and column heading will change
d. None of the above

Answer : D

Question. In which of the following referencing, the cell address remains unchanged even after dragging in any direction?
a. Mixed
b. Relative
c. Absolute
d. None of the above

Answer : C

Question. Shortcut of Print preview in LibreOffice Calc is ____Q69.
a. Ctrl + P
b. Ctrl + Shift + P
c. Ctrl + Shift + O
d. Ctrl +O

Answer : C

Question. Spreadsheet is used for :
a. Managing financial and accounting documents
b. Creating data reports.
c. Data analysis
d. All of the above.

Answer : D

Question. Quick Access Tool bar icon is present on ________
a. Menu Bar
b. Standard Tool bar
c. Title bar
d. Status bar

Answer : C

Question. Cut, Copy, Paste options are available in ________ menu.
a. File
b. Edit
c. Format
d. View

Answer : B

Question. Columns are ________ in the table.
a. Horizontal
b. Vertical
c. Diagonal
d. None of the above

Answer : B

Question. Address of cell formed by intersection of tenth column and nineteenth row is _______________
a. K19
b. 19K
c. J19
d. 19J

Answer : C

Question. A block of adjacent cells in a worksheet which is highlighted or selected is called _____________
a. Block of cells
b. Range of Cells
c. Both of the above
d. None of the above

Answer : B

Question. ________ key is used to select more than one ‘range of cells’ in a worksheet.
a. Ctrl
b. Shift
c. Alt
d. None of the above

Answer : A

Question. By default labels are _________ aligned.
a. left
b. right
c. top
d. None of the above

Answer : A

Question. Which of the following symbol is used for exponentiation(power) in LibreOffice Calc?
a. **
b. /*
c. ^
d. None of the above

Answer : C

Question. Which of the following operator has the highest priority?
a. ( )
b. *
c. ^
d. +

Answer : A

Question. Can a new sheet be renamed in Calc?
a. While inserting a new sheet
b. After inserting a new sheet
c. Both a) and b)
d. None of the above

Answer : C

Question. How many sheets are present in a spreadsheet by default?
a. 2
b. 3
c. 4
d. 5

Answer : B

Question. What is the purpose of the Record Changes feature in Calc?
a. To record the screen.
b. To make changes permanent.
c. To allow authors and reviewers to know which cells were edited.
d. None of the above.

Answer : C

Question. An absolute hyperlink will stop working only if the target is moved.
a. True
b. False

Answer : A

Question. Can we link a text in a spreadsheet to any web URL in Calc?
a. True
b. False

Answer : A

Question. Can multiple users access a shared workbook simultaneously?
a. True
b. False

Answer : A

Question. Once a spreadsheet is shared, can it be unshared?
a. True
b. False

Answer : B

Question. What is a saved sequence of commands or keystrokes in Calc called?
a. Solver
b. Macro
c. Autosum
d. Consolidate

Answer : B

Question. Which of the following functions are available in consolidate window?
a. Max
b. Min
c. Count
d. All of the above

Answer : D

Question. Which functions can you use in the Consolidate window in SpreadSheet?
a. Count
b. Max
c. Min
d. All of the above

Answer : D

Question. What option should be clicked to stop the macro recorder in Calc?
a. End Recording
b. Close Recording
c. Stop Recording
d. None of the above

Answer : C

Question. _________ allows you to gather data from different worksheets into a master worksheet.
a. Data Consolidation
b. Goal Seek
c. Solver
d. Total data

Answer : A

Question. Scenarios are a tool to test __________ questions.
a. if
b. what else
c. if else
d. what if

Answer : D

Question. Consolidate option is available under _________ menu.
a. View
b. Tool
c. Insert
d. Data

Answer : D

Question. If you select ________ then any values modified in the source range are automatically updated in the target range.
a. Link to source data
b. Link to sheet data
c. Link to original data
d. Link to source range

Answer : A

Question. Each scenario has a name.(T/F)
a. True
b. False

Answer : A

Question. SUBTOTALS _________ data arranged in an array (that is, a group of cells )
a. Add
b. Average
c. Find
d. Clear

Answer : A

Question. In Subtotals we can select up to _______ groups of arrays.
a. 3
b. 2
c. 4
d. Infinite

Answer : A

Question. Which option is used to name a range of cells?
a. Range name
b. Cell Range
c. Define Range
d. Select Range

Answer : C

Question. Is it true or false that you can create only three scenarios for a given range of cells in SpreadSheet?
a. True
b. False

Answer : B

Question. By default ________________ sheets are present in Spreadsheet.
a. 1
b. 2
c. 3
d. 4

Answer : C

Question. Scenario option is available in ___________________ menu.
a. Data
b. Tools
c. Insert
d. Windows

Answer : B

Question. Define range option is available under ________ menu.
a. Insert
b. View
c. Developer
d. Data

Answer : D

Question. Subtotals is available in __________ menu.
a. Tools
b. Format
c. Insert
d. Data

Answer : D

Question. Identify the correct sequence
a. First open subtotals window and then select the data where we need to apply subtotals.
b. First Select data and then open subtotals window.
c. Both of the above are correct
d. None of the above

Answer : B

Question. Hyperlink in Calc can be used
a. to jump from one sheet to another sheet.
b. to jump from one sheet to website
c. to jump from one section to another section of same sheet
d. All of the above

Answer : D

Question. Scenarios are tool to test _________ questions.
a. if else
b. what else
c. what if
d. if

Answer : C

Question. Goal Seek Option available in __ menu.
a. Tools
b. Format
c. Data
d. Insert

Answer : A

Question. When we print a spreadsheet, only content of active scenario is printed.(T/F)
a. True
b. False

Answer : A

Question. We can shift from one scenario to another by _____________
a. Navigator
b. Find and Replace
c. Data Source
d. None of the above

Answer : A

Question. ____________ is more elaborate form of Goal Seek.
a. Scenario
b. Subtotal
c. Solver
d. All of the above

Answer : C

Question. When you open a new spreadsheet, by default it has sheet named ______________.
a. Sheet1
b. Sheet_1
c. Sheet 1
d. None of the above

Answer : A

Question. We can create only 3 scenario for a given range of cells.(T/F)
a. True
b. False

Answer : B

Question. In which menu can you find the Define Range option in SpreadSheet?
a. Developer
b. View
c. Insert
d. Data

Answer : D

Question. In which option we have to specify the target range(Where we want the result to be displayed)
a. Source data range
b. Copy results to
c. Need result at
d. target range

Answer : B

Question. Which option is suitable to calculate the effect of different interest rates on an investment.
a. Scenario
b. Subtotal
c. Consolidate
d. None of the above

Answer : A

Question. The text in the row label or column label must be identical, otherwise, new row or column will be inserted.(T/F)
a. True
b. False

Answer : A

Question. Hyperlink option is available in ______ menu.
a. File
b. Edit
c. Format
d. Insert

Answer : D

Question. We can consolidate data by ________
a. Row Label
b. Column Label
c. Both of the above
d. None of the above

Answer : C

Question. We can give different colors to different scenario?(T/F)
a. True
b. False

Answer : A

Question. By default sheets tab are present at the _____________ of the spreadsheet.
a. Top
b. Bottom
c. Both of the above
d. None of the above

Answer : B

Question. Formula to refer a cell A3 in sheet named S1 is
a. =S1A3
b. =S1.A3
c. =”S1″.A3
d. None of the above

Answer : B

Question. We can insert the new sheet in Calc by clicking on __ menu.
a. Format
b. Edit
c. Insert
d. Tool

Answer : C

Question. Default name of first scenario created in Sheet1 of Calc is ________
a. Sheet1_Scenario1
b. Sheet1_Scenario_1
c. Sheet_1_Scenario1
d. Sheet_1_Scenario_1

Answer : B

Question. Hyperlink icon is present on _________________
a. Format Toolbar
b. Standard Toolbar
c. Menu Bar
d. None of the Above

Answer : B

Question. We can rename a new sheet in Calc.
a. After inserting a new sheet
b. While inserting a new sheet
c. Both of the above
d. None of the above

Answer : C

Question. Comment in Create Scenario dialog box is Optional(T/F)
a. True
b. False

Answer : A

Question. Data can be consolidated from two sheets only.(T/F)
a. True
b. False

Answer : B

Question. We can rename an existing sheet in Calc by
a. Double click on one of the existing sheet
b. Right click on existing sheet and then choose rename
c. Both of the above
d. None of the above

Answer : C

Question. Hyperlink in Calc can be either relative or absolute.(T/F)
a. True
b. False

Answer : A

Question. Hyperlink dialog box shows ___________ types of hyperlinks on left hand side.
a. 1
b. 2
c. 3
d. 4

Answer : D

Question. Absolute link will stop working only if the target is moved(T/F)
a. True
b. False

Answer : A

Question. Solver option is available under _________ menu
a. Tools
b. Format
c. Edit
d. Insert

Answer : A

Question. To select random multiple cell hold down ________ key as you click on each cell.
a. Alt
b. Shift
c. Ctrl
d. All of the above

Answer : C

Question. Which of the following elements are present in “Insert Sheet” dialog box.
a. After Current Sheet
b. Before Current Sheet
c. No. of Sheets
d. All of the above

Answer : D

Question. We can link one worksheet to another worksheet.(T/F)
a. True
b. False

Answer : A

Question. 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
b. work
c. may work
d. None of the above

Answer : B

Question. Can we add/insert more sheets in a spreadsheet?
a. True
b. False

Answer : A

Q30. We can not add/insert more sheets in a spreadsheet.(T/F)
a. True
b. False

Answer : B

Q 42. A relative link will stop working only if the target is moved.(T/F)
a. True
b. False

Answer : B