Selected MCQ

Current Question
Cells in MS Excel can be uniquely identified by ____.
  • A. Column letters and row numbers
  • B. Column numbers and row letters
  • C. Cell coordinates
  • D. None of these
Correct Answer: A
Explanation:
Cells are identified by column letter + row number (e.g., A1).
Related Question 1
Which of the following functions in Microsoft Excel counts the number of cells with numerical data in the argument?
  • A. COUNT
  • B. AVERAGE
  • C. SUM
  • D. MAX
Correct Answer: A
Explanation:
COUNT tallies only numeric cells.
Related Question 2
If you want to add the contents of cells A1 and A2 together in Excel, which formula would you use?
  • A. =SUM(A1, A2)
  • B. #NAME?
  • C. =A1 + A2
  • D. None of these
Correct Answer: C
Explanation:
The simple addition formula =A1+A2 directly adds the two cells.
Related Question 3
Computer spreadsheet capability to allow a pie chart to be generated from data in spreadsheet cells is termed as ____.
  • A. Decoration
  • B. Data appearance
  • C. Functions
  • D. Charting
Correct Answer: D
Explanation:
The feature is called charting or chart creation.
Related Question 4
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 5
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.