10th Class Computers Science Analog and Digital Electronics Question Bank

done Case Based - Electronic Spreadsheet (Advanced) Total Questions - 8

• question_answer1)

  Direction: Q.1. to Q.8.

  Open Office Calc

  Open Office Calc is a powerful spreadsheet program that can be used to store and work with lists of data, perform calculations and create charts and reports. Worksheet is composed of columns and rows and intersection of row and column is cell. Workbook is a file in MS Excel that holds worksheets. Selecting a group of cells is called range of cells. Chartsare graphical representation of numeric data. Charts make it easier for users to compare and understand numbers. Calc offers many types of charts including Column, Line, Pie, Bar, Area, Scatter and more.

  Based on above answer the following Questions. The intersection of a row and a column is called a.....................
  A)
  Sum                  done clear
  B)
  Worksheet done clear
  C)
  Char                   done clear
  D)
  Cell done clear
  View Solution play_arrow

• question_answer2)
  A group of cells is called a...................
  A)
  Cell range             done clear
  B)
  Chart done clear
  C)
  Cell cluster           done clear
  D)
  Multi scale done clear
  View Solution play_arrow

• question_answer3)
  You can click the tabs at the bottom of a work book to switch between....................
  A)
  Permissions       done clear
  B)
  Number formats done clear
  C)
  Worksheets          done clear
  D)
  Formulas done clear
  View Solution play_arrow

• question_answer4)
  Charts are...............representation of data.
  A)
  Numerical             done clear
  B)
  Graphical done clear
  C)
  Cell                   done clear
  D)
  None of the above done clear
  View Solution play_arrow

• question_answer5)
  .............. is a kind of chart in Calc
  A)
  Triangle                done clear
  B)
  AB done clear
  C)
  Line                      done clear
  D)
  Plain done clear
  View Solution play_arrow

• question_answer6)
  Where is the address of the active cell displayed?
  A)
  Row heading     done clear
  B)
  Status bar done clear
  C)
  Name Box          done clear
  D)
  Formula bar done clear
  View Solution play_arrow

• question_answer7)
  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)
  E7                        done clear
  D)
  F7 done clear
  View Solution play_arrow

• question_answer8)
  Which type of chart displays bars side by side?
  A)
  Bar                       done clear
  B)
  Line done clear
  C)
  Pie                        done clear
  D)
  scatter done clear
  View Solution play_arrow