Q51. MS-Excel is based on ………
a) WINDOWS
b) DOS
c) UNIX
d) OS
Answer – [A]
Q52. Multiple calculations can be made in a single formula using …….
a) Standard Formula
b) Array Formula
c) Complex Formula
d) Smart Formula
Answer – [B]
Q53. Comments can be added to cells using
a) Home -> Comments
b) Insert -> Comments
c) Data -> Comments
d) View -> Comments
Answer – [B]
Q54. You can copy data or formulas
a) With the Copy, Paste and Cut commands on the Edit menu
b) With commands on the shortcut menu
c) With buttons on the Standard Toolbar
d) All of the above
Answer – [D]
Q55. To hold row and columns titles in place so that they do not scroll when you scroll a worksheet click the
a) Unfreeze Panes command on the Window menu
b) Freeze Panes command on the Window menu
c) Hold titles command on the Edit menu
d) Split command on the Window menu
Answer – [B]
Q56. Which of the following method can not be used to edit the contents of a cell?
a) Press the Alt key
b) Clicking the Formula Bar
c) Pressing the F2 key
d) Double clicking the cell
Answer – [A]
Q57. To save a worksheet, you:
a) Click the Save button on the Standard Toolbar from the menu
b) Press Ctrl + F5
c) Click Save on the Window Start button
d) Select Edit -> Save
Answer – [A]
Q58. Which shortcut key is used to create a new worksheet in Excel?
a) Ctrl + N
b) Ctrl + O
c) Ctrl + S
d) Ctrl + P
Answer – [A]
Q59. …………. appear at the bottom of the Excel Window.
a) Title Bar
b) Formula Bar
c) Worksheet Tabs
d) Name Box
Answer – [C]
Q60. Which term is used to join the selected cells into one cell?
a) Filter
b) Wrap
c) Pivot
d) Merge
Answer – [D]