🏠 Home
← Back Start Quiz
MCQ Practice

Computer & IT MCQs

How to copy data from one Excel sheet to another Excel sheet?

  • A. Referencing
  • B. Paste Special
  • C. Formulas
  • D. None of these
Explanation:
Paste Special allows copying data, formats, or values between sheets.

How do you automatically adjust the width of a column in Excel?

  • A. Double-click the left border of the column
  • B. Double-click the right border of the column
  • C. Double-click the column header
  • D. All of the above
Explanation:
Double-clicking the right border of the column header auto-fits the column width.

Borders can be applied to which of the following elements in a document____.

  • A. Cell, Table & Paragraph
  • B. Images
  • C. Hyperlinks
  • D. Footnotes
Explanation:
Borders can be applied to cells, tables, and paragraphs in Excel/Word.

In MS Excel, to delete duplicate values, which menu is used?

  • A. File
  • B. Data
  • C. Edit
  • D. View
Explanation:
The Remove Duplicates command is located under the Data tab.

Area formula helps for performing ____ calculations.

  • A. Multiple
  • B. Composite
  • C. Nested
  • D. All of these
Explanation:
The AREAS function and area references support multiple, composite, and nested calculations.

In MS Excel, chart wizard term data series refers to _____.

  • A. A chart legend
  • B. A collection of chart data markers
  • C. A set of values you plot
  • D. A data label
Explanation:
A data series is the set of related data points (markers) plotted on the chart.

In MS Excel evaluate the formulae (7-3) (6+1)/4 result will be ____.

  • A. 5
  • B. 3
  • C. 7
  • D. 8
Explanation:
(7-3) × (6+1) ÷ 4 = 4 × 7 ÷ 4 = 7.

When adding two cells in a spreadsheet, which of the following represents the correct formula?

  • A. #REF?
  • B. = A1 + A2
  • C. (A1 + A2)
  • D. SUM(A1,A2)
Explanation:
=A1+A2 is the correct basic addition formula.

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
Explanation:
The simple addition formula =A1+A2 directly adds the two cells.

B2: B6 in MS Excel represents the ____.

  • A. Cell column
  • B. Range of cell
  • C. Cell Row
  • D. Worksheet number
Explanation:
B2:B6 is a range reference covering cells from B2 to B6.