MS Excel MCQ Questions

MS Excel MCQ Questions | Freshers & Experienced

  • Satyam Jaiswal
  • 22nd May, 2021

We are introducing here the best MS Excel MCQ Questions, which are very popular & asked various times. This Quiz contains the best 25+ MS Excel MCQ with Answers, which cover the important topics of MS Excel. for which, you can perform best in MS Excel Exams, Interviews, and Placement activities.

MS Excel MCQ Questions and Answers

1) Microsoft Excel is a _______ program included in the Microsoft Office suite.

  • A. Document
  • B.Spreadsheet
  • C.Presentation
  • D.Text

2) ______ are the features of MS Excel.

  • A. Data Filtering
  • B.Data Sorting
  • C.Built-in formulae
  • D.All of the above

3) The intersection of a column and a row on a worksheet is called __________.

  • A. Column
  • B.Value
  • C.Cell
  • D.Address

4) MS Excel functions are _______.

  • A. sum
  • B.average
  • C.count
  • D.All of the above

5) _______ are the basic math operations in Excel.

  • A. Addition
  • B.Subtraction
  • C.Multiplication
  • D.All of the above

6) ________ are the tools used in Excel.

  • A. Tab Hound
  • B.List Search
  • C.List Search
  • D.All of the above

7) _______ type of chart is useful for comparing values over categories.

  • A. Pie Chart
  • B.Column Chart
  • C.Dot Graph
  • D.All of the above

8) ______ tells how many numeric entries are there.

  • A. NUM
  • B.COUNT
  • C.SUM
  • D.COUNT

9) What among the following is a MS Excel file format?

  • A. xlsm
  • B..xlsx
  • C.Both A and B
  • D.None of the above

10) Who is the father of MS Excel?

  • A. James Gosling
  • B.Charles Simonyi
  • C.Guido van Rossum
  • D.None of the above

11) The advantages of MS Excel are __________.

  • A. Best way to store data.
  • B.You can perform calculations.
  • C.You can code to automate.
  • D.All of the above

12) Statistical calculations and preparation of tables and graphs can be done using ________.

  • A. Notepad
  • B.Excel
  • C.Power Point
  • D.All of the above

13) ______ is not a Function in MS Excel .

  • A. AVG
  • B.SUM
  • C.MIN
  • D.MAX

14) In Excel, Columns are labelled as _______.

  • A. 1,2,3 etc
  • B.A1, A2, etc.
  • C.A, B, C, etc
  • D.None of the above

15) The ____ feature of MS Excel quickly completes a series of data.

  • A. Auto Complete
  • B.Auto Fill
  • C.Auto Store
  • D.None of the above

16) ________ is useful for comparing parts of a whole chart.

  • A. Line Chart
  • B.Pie Chart
  • C.Column Chart
  • D.None of the above

17) The main uses of Excel include _________.

  • A. Data entry
  • B.Data management
  • C.Charting and graphing
  • D.All of the above

18) __________ function determines the highest cell value included in the argument.

  • A. MIN()
  • B.MAX()
  • C.MAXIMUM()
  • D.None of the above

19) By default, there are ______ sheets when we create a new Excel file.

  • A. 2
  • B.5
  • C.1
  • D.3

20) Which function adds all of the values of the cells in the argument?

  • A. SUM()
  • B.ADD()
  • C.Both A and B
  • D.None of the above

21) Cell Range from A1 to A10 is denoted as ________.

  • A. 10A:A1
  • B.10A:A10
  • C.A1:A10
  • D.None of the above

22) The process of arranging the items of a column in some sequence or order is known as _________.

  • A. Sorting
  • B.Filtering
  • C.Both A and B
  • D.None of the above

23) A worksheet is a collection of cells where you keep and manipulate the data.

  • A. Yes
  • B.No
  • C.May be
  • D.Can't say

24) Microsoft Excel doesn't allows you to manipulate, manage and analyze data, helping assist in decision-making.

  • A. Yes
  • B.No
  • C.May be
  • D.Can't say

25) An Excel file is generally called as _________.

  • A. Sheet
  • B.Worksheet
  • C.Workbook
  • D.None of the above

26) _________ is a collection of data that is stored electronically as a series of records in a table.

  • A. Sheet
  • B.Worksheet
  • C.Workbook
  • D.Database

27) Disadvantages of MS Excel are _______.

  • A. Calculation Errors
  • B.Cost of Entry
  • C.Both A and B
  • D.None of the above

28) Excel works with almost every other piece of software in Office.

  • A. Yes
  • B.No
  • C.May be
  • D.Can't say

29) Importance of Microsoft Excel in Business is _______.

  • A. for generating memos
  • B.tracking sale trends
  • C.managing customer details
  • D.All of the above

30) Microsoft Excel helps the user to organize the business systems and process data and information using columns and rows with formulas

  • A. Yes
  • B.No
  • C.May be
  • D.Can't say

31) Default header for a worksheet is

  • A. Date and Time
  • B.Sheet name
  • C.Username
  • D.None of the above

Leave A Comment :

Valid name is required.

Valid name is required.

Valid email id is required.

Related MCQ/Quiz

01st
Feb
RDBMS MCQ
01st
Feb
JBehave Mcq
01st
Feb
Oracle MCQ
01st
Jun
PL/SQL MCQ