Selected MCQ

Current Question
When you move to the same row but to other columns?
  • A. To perform a vertical lookup and return a value based on a specified criterion
  • B. To perform a horizontal lookup and return a value based on a specified criterion
  • C. To add up a range of cells
  • D. To find the average of a range of cells
Correct Answer: B
Explanation:
This describes the HLOOKUP function (horizontal lookup).
Related Question 1
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 2
In website we move from one place to another ____.
  • A. Web links
  • B. Pointer
  • C. URL
  • D. None of these
Correct Answer: A
Explanation:
Web links (hyperlinks) allow navigation between pages.
Related Question 3
Computers that are used in large organizations such as insurance companies and banks, where many people frequently need to use same data, are ____.
  • A. Mainframe computers
  • B. Supercomputers
  • C. Hybrid computers
  • D. Desktop computers
Correct Answer: A
Explanation:
Mainframe computers are designed for high-volume data processing in large organizations.
Related Question 4
Columns dialog box can be opened from ____.
  • A. Press Alt + O + C
  • B. Format menu Columns submenu
  • C. Double-click on the column space in the ruler
  • D. All of these
Correct Answer: D
Explanation:
All listed methods can open the Columns dialog in Word.
Related Question 5
Collecting personal information and effectively posing as another individual is known as the crime of ____.
  • A. Spooling.
  • B. Identity theft.
  • C. Spoofing.
  • D. Hacking.
Correct Answer: B
Explanation:
Identity theft involves stealing personal information to impersonate someone.