1. The intersection of rows and columns in a spread sheet is called ______.
a) Cell b) Row c) Grid d) Column.
2. A formula in spread sheet always begins with ____. a) + b) - c) ^ d) =
3. Which of the following operators combines two texts? a) + b) & c) ^ d) =
4. The function used to find the square root of a number in star calc___
a) SQR b) SQT c) SQRT d) SRT
5. The cells A4, A5, A6, B4, B5 and B6 are referred in a worksheet as _____.
a) A4 : B6 b) A1 : B6 c) A1: A6 ; B1 : B6 d) A4 : A6 ; B4 : B6
6. Which of the following icons is used to generate a scrolling screen with in a worksheet?
a) Insert Plug - in b) Insert floating frame c) Insert OLE object d) Insert chart
7. The active cell in a spread sheet is identified by ____.
a) Insertion pointer b) Cell pointer c) Mouse pointer d) Keyboard pointer
8. Which of the following data can be typed into a spreadsheet cell?
a) Numbers b) Text c) Formula d) All of these.
9. How many columns are there is VisiCalc? a) 63 b) 254 c) 32000 d) 256
10. Which bars have shortcut icons for frequently done tasks in the spread sheet?
a) Menu bar b) Formula bar c) Object bar d) Main tool bar.
11. Which key is pressed while editing the contents in a cell? a) F1 b) F2 c) F5 d) F7
12. The operator < > is used to check ___.
a) Equal b) Greater than c) Less than d) In equality
13. Which of the following formula calculates the sum of the numbers in the cell A1 of
sheet 1 And A2 of sheet 2?
a) = sum (sheet1.A1 + sheet2.A2) b) = sum (sheet1.A1; sheet2:A2)
c) = sum (sheet1.A1; sheet2.A2) d) = sum (sheet1.A1; sheet2.A2)
14. Which icon provides a scrolling screen with a worksheet?
a) Insert floating frame b) Insert OLE object c) Insert Applet d) Insert formula
15. The format for entering date in star calc is___.
a) yy/mm/dd b) yy/dd/mm c) dd/mm/yy d) mm/dd/yy
16. Which facility of star calc helps to format the worksheet with different predefined
styles an Colors? a) Chart b) Auto format c) Applet d) Multiple sheets.
17. The bar used to displays the current cell and its content is ___ bar.
a) menu b) Object c) formula d) function
18. The option under the file menu used to quit the star office is ___.
a) Close b) Quit c) exit d) End
19. A continuous group of cells in a worksheet is called ____.
a) Column b) Row c) Data sheet d) Range
20. Graphic representations of numbers are known as _____.
a) Charts b) Graphs c) Bar diagrams d) Cells.
21. To do the calculations for different worksheet in a particular sheet, we use____.
a) 2D formula b) Function c) 3D formula d) Selection
22. The cell referencing that does not get changed when copied is ____.
a) Relative cell addressing b) absolute cell addressing c) Reference d) Comparative.
23. The bar used to display the current cell and its contents in starcalc is ___.
a) Menu b) Object c) Formula d) Function
24. Which is the following is the reference operator? a) % b) < > c) & d) !
25. The pointer that identifies the active cell in a worksheet is ____.
a) Cell pointer b) Insertion c) Keyboard d) Mouse
26. Fill command in star calc is available under the menu___.
a) Edit b) Format c) File d) View
27. The first electronic spread sheet is ____.
a) Visi calc b) Star calc C) Lotus d) Excel.
28. Which of the following operator combine cell areas in starcalc?
a) Reference b) Comparative c) Text d) Arithmetic
29. Non numerical entries are called ____.
a) Text b) Characters c) Labels d) all of these
30. The ___ command is used to generate a series.
a) Edit b) Series - Down c) Series - Left d) Fill
31. ___ & ____ reference operators in star calc. a) : , ! b) ; , ! c) * , = d) none.
32. A continuous group of cell in a worksheet is called ____.
a) Range b) Group c) Set of cells d) Set of rows.
33. A cell address can be made absolute by using the ___ sign in front of rows and columns
Names. a) $ b) 3 c) * d) %
34. The cell can hold upto ____ characters. a) 255 b) 257 c) 258 d) 256
35. Which cell address, do not change when copied?
a) Relative b) Absolute c) Range d) a or b
36. Which operator is used to refer range in star calc? a) ! b) : c) ^ d) &
37. ___ icon is used to import data from different file ULR into a worksheet.
a) Plug - in b) Applet c) OLE object d) Image
38. If the data entered in a worksheet is a number the program recognizes it as a ____.
a) Text b) Number c) Label d) Integer.
39. In order to edit , data in a worksheet ____ keys is used. a) F1 b) F2 c) F4 d) F7
40. ____ Icon is used to import objects from other applications into a worksheet?
a) Insert OLE object b) Insert plug - in c) Insert floating frame d) none.
41. Which one of the following arithmetic operators is meant for exponentiation?
a) * b) ^ c) / d) %
42. The operator that combines two text as a single text is___. a) = b) & c) + d) |
43. To enter the same formula or data in various cells we can use ___ feature of star calc.
a) Copy & paste icon b) automatic fill c) fill series d) fill
44. Star calc has a wide variety of ____.
a) Formula b) options c) buttons d) functions.
45. Improve is a product of ___.
a) Lotus corporation b) Sun micro systems c) Borland d) Microsoft
46. To draw in spread sheet click_____.
a) Insert picture icon b) Color icon c) Draw d) Show draw function icon
47. ___ Icon is used to insert an image from image editor.
a) Insert image editor b) Insert applet c) Insert OLE d) Insert chart.
48. We can enter time in the form of ___.
a) HH : MM : SS b) SS : MM : HH c) MM : SS : HH d) MM : HH : SS
49. ____ operators return numerical results.
a) Text b) Comparative c) Arithmetic d) Reference.
50. To change the column width click on_______. a) Format - width - column
b) Column - Format - width c) Format - Column - Height d) Format - Column - width
51. A spread sheet contains ____ sheets. a) 4 b) 5 c) 6 d) Multiple.
52. ____ are built in formula. a) Values b) Range of cells c) Functions d) Library
53. Which option of file is used to view a worksheet before printing?
a) Print preview b) Open c) Page view d) Save
54. To separate two different sheets in a formula ___ is used.
a) Colon b) Hyphen c) Semicolon d) Comma
55. A data file created using spreadsheet is called____
a) Worksheet b) Application file c) file d) Project
56. The number format currency icon displays contents with ___ decimal digits.
a) 1 b) 2 c) 3 d) 4
57. ___ icon displays the contents of the selected cells in currency format.
a) Number format : dollar b) Number format : currency c) Number format : pound
d) none
58. ___ is the short cut icon on the formula bar that can be used to insert function
a) Function b) Autopilot c) Function Autopilot d) Insert function
59. Auto format option is available on the ___ menu.
a) File b) Edit c) Format d) Style.
60. A ___ lets you create a value in one cell that is calculated based on the values in other
cells.
a) Text b) Value c) Formula d) All the above.
No comments:
Post a Comment