Selected MCQ

Current Question
In MS Excel you can use the horizontal and vertical scroll bars to ____.
  • A. Split a worksheet into two panes
  • B. View different rows and columns
  • C. Edit the contents of a cell
  • D. View different worksheets
Correct Answer: B
Explanation:
Scroll bars allow navigation through rows and columns.
Related Question 1
What is placed to the left of the horizontal scroll bar?
  • A. Tab stop buttons
  • B. Split Buttons
  • C. View Buttons
  • D. Indicators
Correct Answer: C
Explanation:
View buttons are placed to the left of the horizontal scroll bar.
Related Question 2
Comment put on Excel cell, which is displayed by taking the Mouse Pointer there, is called ____.
  • A. Smart tip
  • B. Soft Tip
  • C. Web Tip
  • D. Cell Tip
Correct Answer: D
Explanation:
A comment in Excel is displayed as a Cell Tip when hovering the mouse.
Related Question 3
Actual working area of Computer's Microsoft Excel is ____.
  • A. Workbook
  • B. Worksheet
  • C. Notesheet
  • D. Notebook
Correct Answer: B
Explanation:
The worksheet (spreadsheet) is the actual working area in Excel.
Related Question 4
Ctrl+Shift+1 shortcut Keys in excel are used to ____.
  • A. Format the number in comma format
  • B. Format number in currency format
  • C. Format number in date format
  • D. Format number in time format
Correct Answer: A
Explanation:
Ctrl + Shift + 1 applies comma number formatting in Excel.
Related Question 5
What is the function of the IF function in Excel?
  • A. To perform a logical test and return a value based on the result
  • B. To add up a range of cells
  • C. To find the average of a range of cells
  • D. To count the number of cells in a range
Correct Answer: A
Explanation:
The IF function performs a logical test and returns one value if true, another if false.