🏠 Home
← Back Start Quiz
MCQ Practice

Computer & IT MCQs

If the company wants to check the customer preferences, then it will use the ____ option.

  • A. Data Sorting
  • B. Experience
  • C. Return Component
  • D. None of these
Explanation:
Data Sorting helps analyze customer preferences.

In Excel, you can sort data in ____.

  • A. Ascending order
  • B. Descending order
  • C. Both A & B
  • D. None of these
Explanation:
Excel supports both ascending and descending sorts.

Arrangement of data in a logical sequence is known as ____.

  • A. Sorting
  • B. Classifying
  • C. Reproducing
  • D. Summarizing
Explanation:
Sorting puts data into a logical (ascending/descending) order.

In MS Excel data can be arranged by ____.

  • A. Data Menu
  • B. Data Sort
  • C. Data View
  • D. None of these
Explanation:
Data Sort is the feature for rearranging data.

Which is used for arranging data in ascending and descending order in MS Excel?

  • A. Data, Order
  • B. Data, all
  • C. Data, Sort
  • D. None of these
Explanation:
The Sort command arranges data in ascending or descending order.

Which query do you use to answer an employee's question, “How much do they earn more than 5000$ a month?”

  • A. Select employees
  • B. Search query
  • C. Search tab query
  • D. None of these
Explanation:
A SELECT query with a condition filters employee salary data.

The “Count” function is used to find which type of cells?

  • A. Numeric cells
  • B. Alphanumeric cells
  • C. Non-empty cells
  • D. None of these
Explanation:
COUNT works only on numeric cells.

In MS Excel 2016, = Now () is used ____.

  • A. To show the day name
  • B. To show time only
  • C. To show date and time
  • D. To show the current date and time
Explanation:
NOW() returns the current date and time.

Which function is used to find the related data in MS Excel?

  • A. VLOOKUP
  • B. FLOOKUP
  • C. RLOOKUP
  • D. HLOOKUP
Explanation:
VLOOKUP searches vertically for related data.

What is the main purpose of the formula palette in MS Excel?

  • A. Create and edit formulas containing functions
  • B. Edit existing formulas
  • C. Format cells
  • D. Perform complex calculations
Explanation:
The Formula Palette (Function Arguments dialog) helps build and edit formulas.