🏠 Home
MCQ Practice

Computer & IT MCQs

Working area of MS Excel is called ____.

  • A. Worksheet
  • B. Workbook
  • C. Spreadsheet
  • D. None of these
Explanation:
The working area is called a worksheet.

In MS Excel 2016, a window can be split into two parts by which of the following options?

  • A. Format → Window → Split
  • B. View → Window → Split
  • C. Page Layout → Split
  • D. None
Explanation:
Split is available in the View tab.

How many users can open an MS Excel 2016 file at the same time?

  • A. 100
  • B. 50
  • C. 256
  • D. None of these
Explanation:
Up to 256 users can open the same Excel file simultaneously in shared mode.

Statistical calculations and preparation of tables and graphs can be done using ____.

  • A. Text
  • B. Boolean
  • C. Excel
  • D. Adobe Photoshop
Explanation:
Excel is used for statistical tables.

The valid data type in Excel is ____.

  • A. Text
  • B. Boolean
  • C. Dictionary
  • D. None of these
Explanation:
Text is a valid data type in Excel.

Which of the following is not an element of a computer spreadsheet interface?

  • A. Pencil work
  • B. Active cell
  • C. Menu bar
  • D. Workbook
Explanation:
Pencil work is not part of the Excel interface.

To create a table of columns and rows for statistical or mathematical calculations, using spreadsheet software is used.

  • A. Excel
  • B. Word Pad
  • C. WordPerfect
  • D. Corel Draw
Explanation:
Excel is used for tables and calculations.

What is Microsoft Excel primarily used for?

  • A. Organizing data
  • B. Writing documents
  • C. Creating presentations
  • D. Email communication
Explanation:
Excel is primarily used for organizing and analyzing data.

Extension for MS-Excel is ____.

  • A. Xls
  • B. Docs
  • C. .ppt
  • D. None of these
Explanation:
.xls (or .xlsx) is the file extension for Excel.

Which of the following is the latest version of MS Excel?

  • A. Excel 2021
  • B. Excel 2016
  • C. Excel 2017
  • D. None of these
Explanation:
Excel 2021 is the latest version mentioned.