MS Excel MCQ Questions

MS Excel MCQ Questions

  • Satyam Jaiswal
  • 22nd Nov, 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.

Latest Interview Questions

img
API Testing Interview Questions 08th Aug, 2022
img
Celery Interview Questions 25th Nov, 2021
img
Solaris Interview Questions 24th Feb, 2021
img
Telematics Interview Questions 05th Mar, 2021
img
UFT Interview Questions 08th Aug, 2022
img
Terraform Interview Questions 23rd Nov, 2021

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.

Latest Posts

img
Login With Google using PHP 18th Nov, 2019
img
Working with expressions In Angular JS? 01st Nov, 2019
img
What is AngularJS? Why it is Used. 16th Nov, 2019

Latest MCQ Questions

img
Arduino MCQ Questions 08th Dec, 2021
img
3D Printing MCQ 23rd Nov, 2021
img
Bioinformatics MCQ Questions 12th Mar, 2022
img
Business Intelligence MCQ 15th Apr, 2022
img
Salesforce MCQ 28th Feb, 2022
img
SAP ABAP MCQ 05th Mar, 2022

Related MCQ/Quiz

01st
Nov
MCQ On Discrete Mathematics

MCQ On Discrete Mathematics

01st
Nov
OOPS MCQ Questions

OOPS MCQ Questions

01st
Dec
Database MCQ Questions

Database MCQ Questions

01st
Nov
Fiber Optics MCQ

Fiber Optics MCQ

01st
Nov
Ajax MCQ

Ajax MCQ

01st
Feb
Big Data MCQ Questions

Big Data MCQ Questions