Microsoft Office suite spreadsheet program is_____.
- (A) MS Word
- (B) MS Excel
- (C) MS PowerPoint
- (D) None of these
- (B) MS Excel
Ctrl + Page Down is used to:
- (A) Moves the cursor one paragraph down
- (B) Moves the cursor one-page down
- (C) Moves the cursor one-line down
- (D) Moves the cursor one screen down
- (B) Moves the cursor one-page down
The bar used to display the current cell and its contents is:
- (A) Menu bar
- (B) Function bar
- (C) Formula bar
- (D) Object bar
- (C) Formula bar
Which command is used to generate a series of data directly from the values of the selected cells.
- (A) Auto fill
- (B) Fill
- (C) Range fill
- (D) Row full
- (A) Auto fill
#Value! Error in Microsoft Excel represents:
- (A) The width of the cell is less to display the answer
- (B) Parameter provided to the function is of the wrong data type
- (C) Value of the answer needs to be rounded off
- (D) When Excel does not recognize the format
- (B) Parameter provided to the function is of the wrong data type
The formula used to perform calculations in the worksheet can be inserted with the help of:
- (A) Insert OLE object icon
- (B) Insert Formula icon
- (C) Insert Applet icon
- (D) Insert Plug-in icon
- (B) Insert Formula icon
Where is a list of all functions displayed:
- (A) Text box
- (B) Dialog box
- (C) Function box
- (D) Category box
- (C) Function box
The main window in a computer spreadsheet is called:
- (A) Workbook
- (B) Work
- (C) Account book
- (D) Worksheet
- (A) Workbook
When a new row is inserted:
- (A) All preceding rows are moved toward the top of the worksheet
- (B) All following are shifted to the right
- (C) All following rows are moving towards the bottom of the worksheet
- (D) Both A & C
- (C) All following rows are moving towards the bottom of the worksheet
In MS-Excel, two common wildcard characters that MS Excel recognizes are:
- (A) *and?
- (B) < and >
- (C) *and>
- (D) None of these
- (A) *and?