Spreadsheet interview questions – page 5

144 questions. Tap “Show answer” to check yourself.

Advertisement
  1. What package permits people to quickly create, manipulate and analyze data arranged in columns and rows?

    1. Application package
    2. Outline processors
    3. Word processing package
    4. Spreadsheet package
    Show answer

    D. Spreadsheet package

  2. The character used to centre a label in a cell is

    1. ‘
    2. “
    3. ^
    4. |
    Show answer

    C. ^

  3. Spreadsheet refers to

    1. Software Package
    2. Hardware
    3. Text
    4. Star Office Calc
    Show answer

    A. Software Package

  4. For selecting a function you have to go to ___ menu.

    1. File
    2. Insert
    3. Copy
    4. Replace
    Show answer

    B. Insert

  5. How many icons appear in the floating tool bar?

    1. 3
    2. 5
    3. 6
    4. 7
    Show answer

    D. 7

  6. Which is used to print the worksheet with grid lines?

    1. Grid checkbox
    2. Check box
    3. Text box
    4. Dialog box
    Show answer

    A. Grid checkbox

  7. Which shortcut icon is used to select and insert functions?

    1. Functional Auto pilot
    2. File series
    3. Function wizard
    4. Category
    Show answer

    C. Function wizard

  8. Star Office Calc has a variety of

    1. Buttons
    2. Functions
    3. Formulae
    4. Options
    Show answer

    B. Functions

  9. The cells are addressed in terms of

    1. Row and column labels
    2. Row labels
    3. Rows
    4. Columns
    Show answer

    A. Row and column labels

  10. Which of the following data can be typed into a Spreadsheet cell?

    1. Formulae
    2. Text
    3. Numbers
    4. All of these
    Show answer

    D. All of these

  11. Which bar is used to display options?

    1. Menu
    2. Function
    3. Formula
    4. Status
    Show answer

    A. Menu

  12. The intersection of rows and columns creates

    1. Cells
    2. Worksheets
    3. Spreadsheets
    4. None of these
    Show answer

    A. Cells

  13. Advertisement
  14. Worksheet data can be viewed in forms of

    1. Charts
    2. Graphs
    3. Charts or graphs
    4. Data
    Show answer

    C. Charts or graphs

  15. By pressing  ____  key and type in the range you want, the suggested range will be accepted.

    1. Backspace
    2. Open
    3. Close
    4. Enter
    Show answer

    A. Backspace

  16. The files that are created with Spreadsheet software are called

    1. Package
    2. Program
    3. Worksheet
    4. Spreadsheet
    Show answer

    C. Worksheet

  17. Which is used to calculate and analyze a set of numbers?

    1. Improve
    2. StarCalc
    3. Spreadsheet
    4. Database
    Show answer

    C. Spreadsheet

  18. A Spreadsheet, sometimes is called as

    1. Cells
    2. Worksheet
    3. Menus
    4. Notebook pages
    Show answer

    B. Worksheet

  19. Which bars have shortcut icons for frequently done tasks in the Spreadsheet?

    1. Main Tool bar
    2. Object bar
    3. Formula bar
    4. Menu bar
    Show answer

    B. Object bar

  20. The Spreadsheet VisiCalc contains

    1. 63 columns and 254 rows
    2. 256 rows and 256 columns
    3. 10000 rows and 256 columns
    4. 36000 rows and 256 columns
    Show answer

    A. 63 columns and 254 rows

  21. A value rule in each cell may store a

    1. Formula
    2. Label
    3. Number
    4. All of these
    Show answer

    C. Number

  22. Who invented VisiCalc for Apple?

    1. Dan Bricklin and Bob Frankston
    2. Bob Frankston
    3. J.H.Biurd
    4. Dan Bricklin
    Show answer

    A. Dan Bricklin and Bob Frankston

  23. Which one of the following is a Spreadsheet?

    1. Star Office Writer
    2. Star Office
    3. Star Office Calc
    4. Star Office base
    Show answer

    C. Star Office Calc

  24. Graphic representations of numbers are known as

    1. Cells
    2. Charts
    3. Bar diagrams
    4. Graphs
    Show answer

    B. Charts

  25. How many columns are there in a VisiCalc Spreadsheet?

    1. 62
    2. 63
    3. 64
    4. 72
    Show answer

    B. 63

Advertisement