10th Class Computers Science Analog and Digital Electronics Question Bank

done MCQs - Electronic Spreadsheet (Advanced) Total Questions - 97

• 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