1. A data file created with spreadsheet is called a
(a) Chart (b) Formula (c) Cell (d) Worksheet
2. StarOffice Calc is a part of
(a) Windows (b) Linux (c) MS Office (d) StarOffice
3. Which is a tool for working with numbers?
(a) StarOffice Impress (b) Database (c) StarOffice Writer (d) Spreadsheet
4. The first electronic Spreadsheet is (or) The first commercial spreadsheet package is
(a) Visicalc (b) StarOffice Calc (c) Lotus 1-2-3 (d) QPro
5. Every formula should begin with the symbol _ ___ ___ ___ ___.
(a) = (b) > (c) + (d) !
6. A cell address is made absolute by using the
(a) ! (b) = (c) $ (d) *
7. The text operator in StarOffice Calc is
(a) $ (b) & (c) ! (d) *
8. The active cell is identified by the
(b) Cursor (c) Cell pointer (d) Insertion point
9. A continuous group of cells is known as
(a) Row (b) Column (c) Range (d) Group
10. To preview a worksheet before printing, click Page View from
(a) Edit menu (b) View menu (c) File menu (d) Format menu
11. Two or more adjacent cells are referred to as
(a) Column (b) Range (c) Row (d) Cell
12. Which of the following is an example of spreadsheet package?
(a) Improve (b) Excel (c) Quattro Pro (d) All the other three choices
13. Which is the default type of cell addressing?
(a) Both Relative & Absolute (b) Reference (c) Relative (d) Absolute
14. Which icon is used for inserting a formula in the worksheet?
(a) Insert Formula icon (b) Insert Chart icon (c) Insert Applet icon (d) Insert Object icon
15. The format for entering Time is
(a) HH:MM:SS (b) SS:MM:HH (c) MM:HH:SS (d) HH:SS:MM
16. Which of the following is a reference operator?
(a) : (or) ! (b) ; (c) & (d) =
17. The Insert_Function option is used to select a
(a) AutoFormat (b) Chart (c) Function (d) Graph
18. In order to shift the content of a cell to the right and create an empty cell, select the cell and click the icon
(a) Insert Cells Right (b) Insert Rows (c) Insert Columns (d) Insert Cells Down
19. Which command is used to print a part of a worksheet?
(a) Format_Print Ranges_Edit (b) Format_Print Ranges_Delete
(c) File_Print (d) Print icon
20.In StarOffice Calc Screen, below the menu bar is the function bar and
(a) Tool bar (b) Formula bar (c) Status bar (d) Object bar
21. One of the most commonly used functions in Star Office Calc is
(a) SUM (b) AVERAGE (c) SQRT (d) ABS
22. Which operator combines sections of text to the entire text?
(a) = (b) > (c) ! (d) &
23. Which icon is selected to display the numbers in currency format?
(a) Currency (b) Add Decimal (c) Percent (d) Standard
24. The date format is
(a) MM/DD/YY (b) DD/MM/YY (c) YY/MM/DD (d) DD/YY/MM
25. The syntax of formula begins with the sign
(a) < (b) ( (c) + (d) =
26. The predefined formulae that are available in Star Office Calc are
(a) Keywords (b) Constants (c) Functions (d) Variables
27. The option used to open a worksheet that has been saved is
(a) File_Save (b) File_SaveAs (c) File_New (d) File_Open
28. To change the height of a row, the command used is
(a) Format_Row_Height (b) Format_Row_Width
(c) Format_Column_Width (d) Format_Column_Height
(a) Chart (b) Formula (c) Cell (d) Worksheet
2. StarOffice Calc is a part of
(a) Windows (b) Linux (c) MS Office (d) StarOffice
3. Which is a tool for working with numbers?
(a) StarOffice Impress (b) Database (c) StarOffice Writer (d) Spreadsheet
4. The first electronic Spreadsheet is (or) The first commercial spreadsheet package is
(a) Visicalc (b) StarOffice Calc (c) Lotus 1-2-3 (d) QPro
5. Every formula should begin with the symbol _ ___ ___ ___ ___.
(a) = (b) > (c) + (d) !
6. A cell address is made absolute by using the
(a) ! (b) = (c) $ (d) *
7. The text operator in StarOffice Calc is
(a) $ (b) & (c) ! (d) *
8. The active cell is identified by the
(b) Cursor (c) Cell pointer (d) Insertion point
9. A continuous group of cells is known as
(a) Row (b) Column (c) Range (d) Group
10. To preview a worksheet before printing, click Page View from
(a) Edit menu (b) View menu (c) File menu (d) Format menu
11. Two or more adjacent cells are referred to as
(a) Column (b) Range (c) Row (d) Cell
12. Which of the following is an example of spreadsheet package?
(a) Improve (b) Excel (c) Quattro Pro (d) All the other three choices
13. Which is the default type of cell addressing?
(a) Both Relative & Absolute (b) Reference (c) Relative (d) Absolute
14. Which icon is used for inserting a formula in the worksheet?
(a) Insert Formula icon (b) Insert Chart icon (c) Insert Applet icon (d) Insert Object icon
15. The format for entering Time is
(a) HH:MM:SS (b) SS:MM:HH (c) MM:HH:SS (d) HH:SS:MM
16. Which of the following is a reference operator?
(a) : (or) ! (b) ; (c) & (d) =
17. The Insert_Function option is used to select a
(a) AutoFormat (b) Chart (c) Function (d) Graph
18. In order to shift the content of a cell to the right and create an empty cell, select the cell and click the icon
(a) Insert Cells Right (b) Insert Rows (c) Insert Columns (d) Insert Cells Down
19. Which command is used to print a part of a worksheet?
(a) Format_Print Ranges_Edit (b) Format_Print Ranges_Delete
(c) File_Print (d) Print icon
20.In StarOffice Calc Screen, below the menu bar is the function bar and
(a) Tool bar (b) Formula bar (c) Status bar (d) Object bar
21. One of the most commonly used functions in Star Office Calc is
(a) SUM (b) AVERAGE (c) SQRT (d) ABS
22. Which operator combines sections of text to the entire text?
(a) = (b) > (c) ! (d) &
23. Which icon is selected to display the numbers in currency format?
(a) Currency (b) Add Decimal (c) Percent (d) Standard
24. The date format is
(a) MM/DD/YY (b) DD/MM/YY (c) YY/MM/DD (d) DD/YY/MM
25. The syntax of formula begins with the sign
(a) < (b) ( (c) + (d) =
26. The predefined formulae that are available in Star Office Calc are
(a) Keywords (b) Constants (c) Functions (d) Variables
27. The option used to open a worksheet that has been saved is
(a) File_Save (b) File_SaveAs (c) File_New (d) File_Open
28. To change the height of a row, the command used is
(a) Format_Row_Height (b) Format_Row_Width
(c) Format_Column_Width (d) Format_Column_Height
29. Which command is used to save a worksheet?
(a) File_Save (b) File_Open (c) File_Quit (d) File_Exit
30. In order to insert a column, use the icon
(a) Insert Columns (b) Insert Cells Down (c) Insert Cells Right (d) Insert Rows
31. The intersection of rows and columns are cal led
(a) Spreadsheets (b) Labels (c) Grids (d) Cells
32. The option used to close the worksheet is
(a) File_Exit (b) File_Close (c) File_New (d) File_Open
33. StarOffice Calc was developed (c) Lotus Corporation (d) Borland International
(a) Microsoft International (b) Sun Microsystems
34. Which cell addresses do not change when copied?
(a) Reference (b) Absolute (c) Relative (d) Both Relative & Absolute
35. The full form of Visicalc is
(a) Visicalculation (b) No full form it is a company name
(c) Visicalculator (d) Visible Calculator
36. The command used to generate a series of data in a spreadsheet is
(a) Auto number (b) Auto (c) Auto generate (d) Fill
37. Which is the first cell of the Spreadsheet?
(a) 1 (b) 1A (c) A (d) A1
38. Who inve nted Visicalc f or AppleII?
(a) Bon Frankston (b) Dan Bricklin and Bon Frankston (c) Dan Bricklin (d) Charless Babbage
39. Which operators combine cell areas?
(a) Comparative (b) Reference (c) Arithmetic (d) Text
40. Electronic spreadsheet uses the concept of
(a) 'Where to' analysis (b) 'What if' analysis (c) WYSISWYG (d) 'Why if' analysis
41. The PCs became popular due to the invention of
(a) Excel (b) Visicalc (c) QPro (d) Lotus 1-2-3
42. The command used to gene rate a series of data is
(a) Edit_Series (b) Insert_Series (c) Fill_Series (d) Edit_Fill_Series
43. What is the function used to find the square root of a number?
(a) SQTR (b) SQR (c) SQT (d) SQRT
44.To draw in spreadsheet, click
(a) Image icon (b) Draw icon (c) Insert Picture icon (d) Show Draw Functions icon
45. Which of the following functions calculates the total of a given set of numbers?
(a) SQRT (b) ADD (c) COUNT (d) SUM
46. Visual representation of data is referred as
(a) Charts (b) Frames (c) Bar diagrams (d) Graphs
47. Which formula is for working with multiple sheets in StarOffice Calc ?
(a) 2-D (b) 1-D (c) Mathematical (d) 3-D
48. Dan Bricklin and Bon Frankston invented
(a) Lotus 1-2-3 (b) Visicalc (c) StarOffice Calc (d) Excel
49. To insert objects like charts, images and formula in a worksheet, click the option
(a) Insert Object (b) Insert Chart (c) Insert Picture (d) Insert Formula
50. Graphical representation of numbers is known as
(a) Bar diagrams (b) Graphs (c) Frames (d) Charts
51. The cells are addressed in terms of
(a) Row labels (b) Row and Column labels
(c) Labels (d) Cell labels
52. Which key is used to edit data in a worksheet?
(a) Ctrl + F (b) F6 (c) F2 (d) F7
53. To format the data in a cell, click
(a) Tools_Cells (b) Format_Cells (c) Insert_Cells (d) Edit_Cells
54. Which command is used for preparing the chart in Star Office Calc?
(a) Chart_From File (b) Insert_From File (c) Insert_Objects (d) Insert_Charts
55. Automatic fill command of StarOffice Calc is equivalent to
(a) Cut and Paste (b) Copy and Insert (c) Cut and Insert (d) Copy and Paste
56. The combination of column and row headings is known as
(a) Cell Address (b) Cell (c) Cell Pointer (d) Cell Range
57. Which is the shortcut icon for Function Wizard in Spreadsheet?
(a) Insert_Function (b) Ctrl + F2 (c) fan(x) (d) f(x)
58. The command used for inserting special characters in Spreadsheet is
(a) Insert_Special Characters (b) Insert_ASCII Characters
(c) Insert_Picture_From File (d) Insert_Special Symbols
59. The OLE stands for
(a) Object Linking Embedded (b) Object Linking Enrolled
(c) Object Linking Environment (d) Object Linking Enrichment
60. Over the time, the term spreadsheet has come to refer specifically to
(a) File (b) Tabular column (c) Software package (d) Worksheet
61. Which of the following bars is used to display the current cell and its content in StarOffice Calc?
(a) Formula bar (b) Tool bar (c) Status bar (d) Menu bar
62. To remove print range setting, click
(a) Format_Print Ranges_Erase (b) Format_Print_Delete
(c) Format_Print Ranges_Edit (d) Format_Print Ranges_Delete
63. Data and formula can be entered into the
(a) Cell address bar (b) Status bar (c) Menu bar (d) Cell
63. Data and formula can be entered into the
(a) Cell address bar (b) Status bar (c) Menu bar (d) Cell
65. The function bar is below the
(a) Menu bar (b) Scroll bar (c) Status bar (d) Object bar
66. Lotus 1-2-3 was introduced in the year
(a) 1982 (b) 1980 (c) 1985 (d) 1984
67. In order to insert an empty row, the icon to be selected is
(a) Insert Cells Right (b) Insert Cells Down (c) Insert Columns (d) Insert Rows
68. Visicalc contained______ of columns.
(a) 65 (b) 62 (c) 63 (d) 64
69. The spreadsheet developed by Lotus Development Corporation is
(a) Quattro Pro (b) Improve (c) StarOffice Calc (d) Excel69
70. Which icon is used to import objects from other applications into a worksheet?
(a) Insert OLE Object (b) Insert Formula (c) Insert Chart (d) Insert Applet
71. Borland International introduced
(a) Quattro Pro (b) Improve (c) StarOffice Calc (d) Excel
72. Which facility of StarOffice Calc helps to format the worksheet with different predefined styles and colours?
(a) AutoPilot sheet (b) AutoStyle Sheet (c) AutoCorrect sheet (d) AutoFormat sheet
73. To change the width of a column, the command used is
(a) Format_Row_Height (b) Format_Column_Width
(c) Format_Row_width (d) Format_Column_Height
74. In Spreadsheet, each cell is referred to by its
(a) Insertion Point (b) Record Pointer (c) Cell Address (d) Cursor
75. Which function key is pressed to appear a vertical cursor on the formula bar?
(a) F7 (b) F1 (c) F5 d) F2
76. Which icon provides to generate a scrolling screen within a worksheet?
(a) Insert Applet (b) Insert OLE Object (c) Insert Floating Frame (d) Insert Chart
77. Which menu is selected to quit from StarOffice?
(a) File_Exit (b) File_Quit (c) Menu_Exit (d) Menu_Quit
78. In which menu, Function option is a vailable?
(a) Open (b) Reference (c) Insert (d) File
79. Exponentiation is represented by
(a) + (b) % (c) / (d) ^
80. Which one of the following is not a comparative opera tor?
(a) = (b) <> (c) / (d) >
81. The option under the File menu used to print the worksheet is
(a) Page View (b) Print Preview (c) Print Range (d) Print
82. In Fill Series dialog box, the equivalent type for multiplication
(a) Growth (b) Date (c) Autofill (d) Linear
83. The percent age (% ) icon multiplies the contents of the cell by
(a) 1000 (b) 10 (c) 1 (d) 100
84. Which of the following is an inter section operator?
(a) ; (b) & (c) ! (d) :
85. To view data in the for m of charts, use
(a) Spreadsheet (b) StarOffice Base (c) StarOffice Writer (d) Table
86. Which reference operator is used to set the range in a spreadsheet?
(a) : (b) ! (c) ; (d) $
87. Which number format icon is used to display the contents of the selected cells in default format?
(a) Percent (b) Currency (c) Add Decimal (d) Standard
88. Spreadsheet columns are labeled from
(a) A to IV (b) A to IU (c) A to Z (d) A to IA
89. The number of icons appeared in the Insert Cell floating tool bar are
(a) Four (b) Five (c) Three (d) Six
90. In StarOffice Calc, rows are numbered from 1 to
(a) 21000 (b) 22000 (c) 31000 (d) 32000
91. The status bars and scroll bars are at the
(a) Extreme right (b) Extreme bottom (c) Top (d) Extreme left
92. Visicalc for Apple II was invented in the year
(a) 1977 (b) 1981 (c) 1982 (d) 1979
93. Lotus 1-2-3 became very popular because of its ability to combine
(a) Graphics features (b) Both Graphics and Database Management features
(c) Database management features (d) Mathematical formulae
94. Excel was introduced by
(a) Borland International (b) Microsoft Corporation (c) Lotus Corporation (d) Sun Microsystems
95. The automatic fill feature of StarOffice Calc is used for the purpose of
(a) Moving (b) Inserting (c) Copying (d) Deleting
(a) File_Save (b) File_Open (c) File_Quit (d) File_Exit
30. In order to insert a column, use the icon
(a) Insert Columns (b) Insert Cells Down (c) Insert Cells Right (d) Insert Rows
31. The intersection of rows and columns are cal led
(a) Spreadsheets (b) Labels (c) Grids (d) Cells
32. The option used to close the worksheet is
(a) File_Exit (b) File_Close (c) File_New (d) File_Open
33. StarOffice Calc was developed (c) Lotus Corporation (d) Borland International
(a) Microsoft International (b) Sun Microsystems
34. Which cell addresses do not change when copied?
(a) Reference (b) Absolute (c) Relative (d) Both Relative & Absolute
35. The full form of Visicalc is
(a) Visicalculation (b) No full form it is a company name
(c) Visicalculator (d) Visible Calculator
36. The command used to generate a series of data in a spreadsheet is
(a) Auto number (b) Auto (c) Auto generate (d) Fill
37. Which is the first cell of the Spreadsheet?
(a) 1 (b) 1A (c) A (d) A1
38. Who inve nted Visicalc f or AppleII?
(a) Bon Frankston (b) Dan Bricklin and Bon Frankston (c) Dan Bricklin (d) Charless Babbage
39. Which operators combine cell areas?
(a) Comparative (b) Reference (c) Arithmetic (d) Text
40. Electronic spreadsheet uses the concept of
(a) 'Where to' analysis (b) 'What if' analysis (c) WYSISWYG (d) 'Why if' analysis
41. The PCs became popular due to the invention of
(a) Excel (b) Visicalc (c) QPro (d) Lotus 1-2-3
42. The command used to gene rate a series of data is
(a) Edit_Series (b) Insert_Series (c) Fill_Series (d) Edit_Fill_Series
43. What is the function used to find the square root of a number?
(a) SQTR (b) SQR (c) SQT (d) SQRT
44.To draw in spreadsheet, click
(a) Image icon (b) Draw icon (c) Insert Picture icon (d) Show Draw Functions icon
45. Which of the following functions calculates the total of a given set of numbers?
(a) SQRT (b) ADD (c) COUNT (d) SUM
46. Visual representation of data is referred as
(a) Charts (b) Frames (c) Bar diagrams (d) Graphs
47. Which formula is for working with multiple sheets in StarOffice Calc ?
(a) 2-D (b) 1-D (c) Mathematical (d) 3-D
48. Dan Bricklin and Bon Frankston invented
(a) Lotus 1-2-3 (b) Visicalc (c) StarOffice Calc (d) Excel
49. To insert objects like charts, images and formula in a worksheet, click the option
(a) Insert Object (b) Insert Chart (c) Insert Picture (d) Insert Formula
50. Graphical representation of numbers is known as
(a) Bar diagrams (b) Graphs (c) Frames (d) Charts
51. The cells are addressed in terms of
(a) Row labels (b) Row and Column labels
(c) Labels (d) Cell labels
52. Which key is used to edit data in a worksheet?
(a) Ctrl + F (b) F6 (c) F2 (d) F7
53. To format the data in a cell, click
(a) Tools_Cells (b) Format_Cells (c) Insert_Cells (d) Edit_Cells
54. Which command is used for preparing the chart in Star Office Calc?
(a) Chart_From File (b) Insert_From File (c) Insert_Objects (d) Insert_Charts
55. Automatic fill command of StarOffice Calc is equivalent to
(a) Cut and Paste (b) Copy and Insert (c) Cut and Insert (d) Copy and Paste
56. The combination of column and row headings is known as
(a) Cell Address (b) Cell (c) Cell Pointer (d) Cell Range
57. Which is the shortcut icon for Function Wizard in Spreadsheet?
(a) Insert_Function (b) Ctrl + F2 (c) fan(x) (d) f(x)
58. The command used for inserting special characters in Spreadsheet is
(a) Insert_Special Characters (b) Insert_ASCII Characters
(c) Insert_Picture_From File (d) Insert_Special Symbols
59. The OLE stands for
(a) Object Linking Embedded (b) Object Linking Enrolled
(c) Object Linking Environment (d) Object Linking Enrichment
60. Over the time, the term spreadsheet has come to refer specifically to
(a) File (b) Tabular column (c) Software package (d) Worksheet
61. Which of the following bars is used to display the current cell and its content in StarOffice Calc?
(a) Formula bar (b) Tool bar (c) Status bar (d) Menu bar
62. To remove print range setting, click
(a) Format_Print Ranges_Erase (b) Format_Print_Delete
(c) Format_Print Ranges_Edit (d) Format_Print Ranges_Delete
63. Data and formula can be entered into the
(a) Cell address bar (b) Status bar (c) Menu bar (d) Cell
63. Data and formula can be entered into the
(a) Cell address bar (b) Status bar (c) Menu bar (d) Cell
65. The function bar is below the
(a) Menu bar (b) Scroll bar (c) Status bar (d) Object bar
66. Lotus 1-2-3 was introduced in the year
(a) 1982 (b) 1980 (c) 1985 (d) 1984
67. In order to insert an empty row, the icon to be selected is
(a) Insert Cells Right (b) Insert Cells Down (c) Insert Columns (d) Insert Rows
68. Visicalc contained______ of columns.
(a) 65 (b) 62 (c) 63 (d) 64
69. The spreadsheet developed by Lotus Development Corporation is
(a) Quattro Pro (b) Improve (c) StarOffice Calc (d) Excel69
70. Which icon is used to import objects from other applications into a worksheet?
(a) Insert OLE Object (b) Insert Formula (c) Insert Chart (d) Insert Applet
71. Borland International introduced
(a) Quattro Pro (b) Improve (c) StarOffice Calc (d) Excel
72. Which facility of StarOffice Calc helps to format the worksheet with different predefined styles and colours?
(a) AutoPilot sheet (b) AutoStyle Sheet (c) AutoCorrect sheet (d) AutoFormat sheet
73. To change the width of a column, the command used is
(a) Format_Row_Height (b) Format_Column_Width
(c) Format_Row_width (d) Format_Column_Height
74. In Spreadsheet, each cell is referred to by its
(a) Insertion Point (b) Record Pointer (c) Cell Address (d) Cursor
75. Which function key is pressed to appear a vertical cursor on the formula bar?
(a) F7 (b) F1 (c) F5 d) F2
76. Which icon provides to generate a scrolling screen within a worksheet?
(a) Insert Applet (b) Insert OLE Object (c) Insert Floating Frame (d) Insert Chart
77. Which menu is selected to quit from StarOffice?
(a) File_Exit (b) File_Quit (c) Menu_Exit (d) Menu_Quit
78. In which menu, Function option is a vailable?
(a) Open (b) Reference (c) Insert (d) File
79. Exponentiation is represented by
(a) + (b) % (c) / (d) ^
80. Which one of the following is not a comparative opera tor?
(a) = (b) <> (c) / (d) >
81. The option under the File menu used to print the worksheet is
(a) Page View (b) Print Preview (c) Print Range (d) Print
82. In Fill Series dialog box, the equivalent type for multiplication
(a) Growth (b) Date (c) Autofill (d) Linear
83. The percent age (% ) icon multiplies the contents of the cell by
(a) 1000 (b) 10 (c) 1 (d) 100
84. Which of the following is an inter section operator?
(a) ; (b) & (c) ! (d) :
85. To view data in the for m of charts, use
(a) Spreadsheet (b) StarOffice Base (c) StarOffice Writer (d) Table
86. Which reference operator is used to set the range in a spreadsheet?
(a) : (b) ! (c) ; (d) $
87. Which number format icon is used to display the contents of the selected cells in default format?
(a) Percent (b) Currency (c) Add Decimal (d) Standard
88. Spreadsheet columns are labeled from
(a) A to IV (b) A to IU (c) A to Z (d) A to IA
89. The number of icons appeared in the Insert Cell floating tool bar are
(a) Four (b) Five (c) Three (d) Six
90. In StarOffice Calc, rows are numbered from 1 to
(a) 21000 (b) 22000 (c) 31000 (d) 32000
91. The status bars and scroll bars are at the
(a) Extreme right (b) Extreme bottom (c) Top (d) Extreme left
92. Visicalc for Apple II was invented in the year
(a) 1977 (b) 1981 (c) 1982 (d) 1979
93. Lotus 1-2-3 became very popular because of its ability to combine
(a) Graphics features (b) Both Graphics and Database Management features
(c) Database management features (d) Mathematical formulae
94. Excel was introduced by
(a) Borland International (b) Microsoft Corporation (c) Lotus Corporation (d) Sun Microsystems
95. The automatic fill feature of StarOffice Calc is used for the purpose of
(a) Moving (b) Inserting (c) Copying (d) Deleting
96. Which option is used to delete a row?
(a) Edit_Delete Cells (b) Edit_Delete (c) Edit_Delete Rows (d ) Edit_Delete Contents
97. To increase the width of a column, the mouse is clicked and dragged towards the
(a) Right (b) Upward direction (c) Left (d) Downward direction
(a) Edit_Delete Cells (b) Edit_Delete (c) Edit_Delete Rows (d ) Edit_Delete Contents
97. To increase the width of a column, the mouse is clicked and dragged towards the
(a) Right (b) Upward direction (c) Left (d) Downward direction
98. To decrease the width of the cell, the mouse is dragged
(a) Upwards (b) Towards the right (c) Downwards (d) Towards the left
99. In StarOffice Calc, the non-numeric entries are referred with--------
(a) Character (b) String (c) Label (d) Non-numeric
100. The Personal Computer was introduced in the yea r
(a) 1976 (b) 1982 (c) 1975 (d) 1979
101. Which is not a comparative operator?
(a) <> (b) >= (c) < (d) &
102. Visible calculator package was developed for
(a) Super Computers (b) Mainframe Computers (c) Micro Computers (d) Mini Computers
103. Lotus1-2-3 was introduced by
(a) Sun Microsystems (b) Microsoft Corporation
(a) Upwards (b) Towards the right (c) Downwards (d) Towards the left
99. In StarOffice Calc, the non-numeric entries are referred with--------
(a) Character (b) String (c) Label (d) Non-numeric
100. The Personal Computer was introduced in the yea r
(a) 1976 (b) 1982 (c) 1975 (d) 1979
101. Which is not a comparative operator?
(a) <> (b) >= (c) < (d) &
102. Visible calculator package was developed for
(a) Super Computers (b) Mainframe Computers (c) Micro Computers (d) Mini Computers
103. Lotus1-2-3 was introduced by
(a) Sun Microsystems (b) Microsoft Corporation
(c) Borland International (d) Lotus Development Corporation
104. The automatic fill feature is used to
(a) Type the formula (b) Draw charts (c) Create a series (d) Copy the cell contents
105. Visicalc was an essential program f or
(a) Cost benefit analysis (b) Tender evaluation (c) Inventory control (d) Financial analysis
106. The cell A4 becomes absolute when you enter
(a) A$4 (b) A$4$ (c) $A4$ (d) $A$4
107. In spreadsheet of multiple sheets, a list of sheets appear as tabs
(a) at the bottom (b) at right (c) at left (d) at the top
108. Cells B3 B4 C3 C4 D3 D4 in StarOffice Calc can be referred as
(a) B3:D4 (b) B3:D3 (c) B4.D4 (d) B3.D4
109. The cell D7 in StarOffice Calc becomes absolute, when you type it as
(a) $D*7 (b) *D$7 (c) *D*7 (d) $D$7
110. The cells A4, A5, A6, B4, B5 & B6 are referred in a Worksheet as
(a) A1:B6 (b) A4:A6 ; B4:B6 (c) A4:B6 (d) A1:A6 ; B1:B6
111. How many rows and columns are in Visicalc?
(a) 254, 36 (b) 524, 36 (c) 63, 254 (d) 254, 63
112. How many cells are available in the worksheet range C1:E2?
(a) 6 (b) 10 (c) 4 (d) 8
113. Which cell of worksheet is referred as Home Cell?
(a) 1A (b) AA (c) First cell (d) A1
114. Which refers to the files that you create with spreadsheet software?
(a) Rows and columns (b) Spreadsheet (c) Table (d) Worksheet
115. Which of the following statements is false?
(a) Small red triangles indicate column width is enough
(b) Spreadsheets are made up of rows and columns
(c) Exit under File can be used to quit from StarOffice
(d) At the top of Spreadsheet window is the Menu bar
104. The automatic fill feature is used to
(a) Type the formula (b) Draw charts (c) Create a series (d) Copy the cell contents
105. Visicalc was an essential program f or
(a) Cost benefit analysis (b) Tender evaluation (c) Inventory control (d) Financial analysis
106. The cell A4 becomes absolute when you enter
(a) A$4 (b) A$4$ (c) $A4$ (d) $A$4
107. In spreadsheet of multiple sheets, a list of sheets appear as tabs
(a) at the bottom (b) at right (c) at left (d) at the top
108. Cells B3 B4 C3 C4 D3 D4 in StarOffice Calc can be referred as
(a) B3:D4 (b) B3:D3 (c) B4.D4 (d) B3.D4
109. The cell D7 in StarOffice Calc becomes absolute, when you type it as
(a) $D*7 (b) *D$7 (c) *D*7 (d) $D$7
110. The cells A4, A5, A6, B4, B5 & B6 are referred in a Worksheet as
(a) A1:B6 (b) A4:A6 ; B4:B6 (c) A4:B6 (d) A1:A6 ; B1:B6
111. How many rows and columns are in Visicalc?
(a) 254, 36 (b) 524, 36 (c) 63, 254 (d) 254, 63
112. How many cells are available in the worksheet range C1:E2?
(a) 6 (b) 10 (c) 4 (d) 8
113. Which cell of worksheet is referred as Home Cell?
(a) 1A (b) AA (c) First cell (d) A1
114. Which refers to the files that you create with spreadsheet software?
(a) Rows and columns (b) Spreadsheet (c) Table (d) Worksheet
115. Which of the following statements is false?
(a) Small red triangles indicate column width is enough
(b) Spreadsheets are made up of rows and columns
(c) Exit under File can be used to quit from StarOffice
(d) At the top of Spreadsheet window is the Menu bar
116. The Inequality comparative operator symbol is
(a) >< (b) <> (c) = (d) >=
117. Which Series type option can be used for both positive and negative increment?
(a) Linear (b) Date (c) Growth (d) AutoFill
118. The 3D formula to calculate the sum of the numbers in the cell A1 of Sheet1 and A1 of Sheet2 is
(a) =SUM(Sheet1.A1:Sheet2.A1) (b) =SUM(Sheet1.A1;Sheet2.A1)
(c) =SUM(Sheet1:A1;Sheet2:A1) (d) =SUM(Sheet1.Sheet2.A1:A2)
119. Which command is used to print the worksheet with grids?
(a) Format_Borders (b) Format_Grids (c) Format_Sheet (d) Format_Page
120. By default, how many numbers of sheets are available in a spreadsheet?
(a) 4 (b) 3 (c) 1 (d) 2
121. Which of the following data can be typed into a spreadsheet cell?
(a) All these three choices (b) Text (c) Numbers (d) Formulae
122. Which bars have shortcut icons for frequently done tasks in the spreadsheet?
(a) Menu bar (b) Formula bar (c) Object bar (d) Main Tool bar
123. The operator <> is used to check
(a) greater than (b) equal (c) inequality (d) less than
124. Fill command in Star Office Calc is available under the menu is
(a) Edit (b) Format (c) Mouse (d) Keyboard
125. The process of arranging the data in some order in a table is cal led
(a) Merging (b) Sorting (c) Filtering (d) Searching
126. Which of the following has short cut icons for frequently done tasks in spreadsheet?
(a) Function bar & Object bar (b) Formula bar
(c) Main Tool bar (d) Menu bar
(a) >< (b) <> (c) = (d) >=
117. Which Series type option can be used for both positive and negative increment?
(a) Linear (b) Date (c) Growth (d) AutoFill
118. The 3D formula to calculate the sum of the numbers in the cell A1 of Sheet1 and A1 of Sheet2 is
(a) =SUM(Sheet1.A1:Sheet2.A1) (b) =SUM(Sheet1.A1;Sheet2.A1)
(c) =SUM(Sheet1:A1;Sheet2:A1) (d) =SUM(Sheet1.Sheet2.A1:A2)
119. Which command is used to print the worksheet with grids?
(a) Format_Borders (b) Format_Grids (c) Format_Sheet (d) Format_Page
120. By default, how many numbers of sheets are available in a spreadsheet?
(a) 4 (b) 3 (c) 1 (d) 2
121. Which of the following data can be typed into a spreadsheet cell?
(a) All these three choices (b) Text (c) Numbers (d) Formulae
122. Which bars have shortcut icons for frequently done tasks in the spreadsheet?
(a) Menu bar (b) Formula bar (c) Object bar (d) Main Tool bar
123. The operator <> is used to check
(a) greater than (b) equal (c) inequality (d) less than
124. Fill command in Star Office Calc is available under the menu is
(a) Edit (b) Format (c) Mouse (d) Keyboard
125. The process of arranging the data in some order in a table is cal led
(a) Merging (b) Sorting (c) Filtering (d) Searching
126. Which of the following has short cut icons for frequently done tasks in spreadsheet?
(a) Function bar & Object bar (b) Formula bar
(c) Main Tool bar (d) Menu bar
No comments:
Post a Comment