Q41. The software which contains rows and columns is called …..
a) Spreadsheet
b) Word Processing
c) Database
d) None of the above
Answer – [A]
Q42. Which of the following option is not located in the Page Setup dialog box?
a) Page Break Preview
b) Page Orientation
c) Margins
d) Headers and Footers
Answer – [A]
Q43. What are the basic rectangular building blocks of a spreadsheet?
a) Cells
b) Zoom Slider
c) Help Button
d) All of these
Answer – [A]
Q44. What is the shortcut key to delete columns in Excel?
a) Ctrl + H + D + C
b) Alt + H + D + C
c) Shift + H + D + C
d) Shift + Ctrl + H + D + C
Answer – [B]
Q45. Which of the following is an absolute cell reference?
a) !A!1
b) $A$1
c) A#1
d) A1
Answer – [B]
Q46. Hyperlinks can be
a) Text
b) Drawing Objects
c) Pictures
d) All of the above
Answer – [D]
Q47. You can use the horizontal and vertically scroll bar to
a) Split a worksheet into two panes
b) View different rows and columns edit the contents of a cell
c) Edit the contents of a cell
d) View different worksheets
Answer – [B]
Q48. Getting data from a cell located in a different sheet is called.
a) Referencing
b) Accessing
c) Functioning
d) None of the above
Answer – [A]
Q49. Which function is used to calculate depreciation, rates of return, future values and loan payment amounts?
a) Financial
b) Statistical
c) Logical
d) None of the above
Answer – [A]
Q50. To create a formula, you can use:
a) Value and cell references
b) Value but not cell references
c) Cell references but not values
d) None of the above
Answer – [A]