Selected MCQ

Current Question
How to copy data from one Excel sheet to another Excel sheet?
  • A. Referencing
  • B. Paste Special
  • C. Formulas
  • D. None of these
Correct Answer: B
Explanation:
Paste Special allows copying data, formats, or values between sheets.
Related Question 1
You cannot link excel worksheet data to a word document ____.
  • A. With the copy and paste special commands
  • B. With a hyperlink
  • C. With the copy and paste commands on the standard toolbar
  • D. None of these
Correct Answer: D
Explanation:
All listed methods can be used to link or embed Excel data into Word.
Related Question 2
In Excel, if you want to reference a cell in the same column but a different row on another sheet, what type of reference should you use?
  • A. Absolute reference
  • B. Relative reference
  • C. Mixed reference
  • D. Circular reference
Correct Answer: A
Explanation:
Absolute reference ($A$1) keeps the cell fixed across sheets.
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
Which Excel tool allows you to set specific conditions for data entry, ensuring accuracy and consistency in your analysis?
  • A. Scenario Manager
  • B. Goal Seek
  • C. Data Validation
  • D. Pivot Table
Correct Answer: C
Explanation:
Data Validation enforces rules on data entry.
Related Question 5
In Excel, you can sort data in ____.
  • A. Ascending order
  • B. Descending order
  • C. Both A & B
  • D. None of these
Correct Answer: C
Explanation:
Excel supports both ascending and descending sorts.