05th
May
MS Excel MCQ

MS Excel MCQ

  • Admin
  • 05th May, 2021
  • 874 Followers

MS Excel MCQ Quiz

Following are mostly asked Ms excel MCQ test that are designed for professionals like you to crack you interviews. You can take this Ms excel online test before appearing to you real interview. This Ms excel quiz there are around 30+ multiple choice questions on Ms excel with four options.

1) What is Microsoft Excel?

  • A. spreadsheet program
  • B. language
  • C. framework
  • D. None of the above

2) What is the use of the formula palette in MS Excel?

  • A. Format cells containing numbers
  • B. Create and edit formula containing functions
  • C. Enter assumptions data
  • D. Copy a range of cells

3) In MS Excel, What is worksheet?

  • A. A worksheet is a collection of cells where you keep and manipulate the data.
  • B. A worksheet is a collection of workbook.
  • C. Both A and B
  • D. All of the above

4) What is cell in MS Excel?

  • A. intersection area of a row and column
  • B. row
  • C. column
  • D. All of the above

5) What do you mean by Function in MS Excel?

  • A. A function is a predefined formula that performs calculations using specific values in a particular order.
  • B. A function is a user defined formula that performs calculations using specific values in a particular order.
  • C. Expression
  • D. None of the above
Download Free : MS Excel MCQ PDF

6) Function's Arguments can refer to ___ and must be enclosed within parentheses.

  • A. individual cells
  • B. cell ranges
  • C. Both A and B
  • D. None of the above

7) __ function counts the number of cells with numerical data in the argument.

  • A. COUNT()
  • B. AVERAGE()
  • C. RANGE()
  • D. ROUND()

8) __ function determines the highest cell value included in the argument.

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

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

  • A. SUM()
  • B. ADD()
  • C. COUNT()
  • D. All of the above

10) The cell or intersection area of column B and row 3 is refereed as ___.

  • A. 3B
  • B. B3
  • C. B12
  • D. 123AB

11) Cell Range from A1 to A10 is denoted as:

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

12) Which of the following is syntax for the IF() in MS Excel?

  • A. IF(CellName="VALUE" ,"PRINT to DO","ELSE PRINT to DO")
  • B. IF(B3>="35" ,"Promoted","Failed")
  • C. IF(B3<="35" ,"Failed","Passed")
  • D. All of the above

13) What is the use of the PRODUCT() in MS Excel?

  • A. Add multiple cells values together. For example, =PRODUCT(A1:A30)
  • B. Multiples multiple cells values together. For example, =PRODUCT(A1:A30)
  • C. Both A and B
  • D. None of the above

14) If the value of A2 is 4.7614, then what will be the calculated value of ROUND(A2,2) in MS Excel?

  • A. 4.76
  • B. 4.761
  • C. 47.61
  • D. All of the above

15) What is a feature that displays only the data in columns according to specified criteria?

  • A. Formula
  • B. Sorting
  • C. Filtering
  • D. Pivot

16) Statistical calculations and preparation of tables and graphs can be done using __.

  • A. Adobe Photoshop
  • B. Excel
  • C. Notepad
  • D. Power Point

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

  • A. Arranging
  • B. Autofill
  • C. Sorting
  • D. Filtering

18) The ____ feature of MS Excel quickly completes a series of data?

  • A. Auto Complete
  • B. Auto Fill
  • C. Fill Handle
  • D. Sorting

19) Which type of chart is useful for single series of data?

  • A. Column Chart
  • B. Line Chart
  • C. Pie Chart
  • D. Cone Chart

20) What type of chart will you use to compare performance of sales of two products?

  • A. Column Chart
  • B. Line Chart
  • C. Pie Chart
  • D. Both A and B

21) Which type of chart is used to compare performance of sales of two products?

  • A. Column Chart
  • B. Line Chart
  • C. Pie Chart
  • D. Both A and B

22) How is the COLUMN in a MS Excel Spreadsheet named?

  • A. Cells
  • B. Numbers
  • C. Letters
  • D. Columns

23) What is a rectangular box in a MS EXCEL Spreadsheet called?

  • A. Row
  • B. Cell
  • C. Column
  • D. None of the above

24) What does every formula in MS EXCEL start with?

  • A. +
  • B. -
  • C. =
  • D. *

25) What does every formula in MS EXCEL start with?

  • A. +
  • B. -
  • C. =
  • D. *

26) What is an example of a RANGE in MS Excel.

  • A. (B2:F5)
  • B. B2-F5
  • C. B2:5F
  • D. F5:B2

27) When is a MS Excel Spreadsheet used?

  • A. Making a Drawing
  • B. When Reading
  • C. For Baking a Cake
  • D. For Collecting Information

28) Located on the left side or the entry bar, displays the active cell reference:

  • A. Entry Bar
  • B. Name Box
  • C. Cell Reference
  • D. None of the above

29) A program using a table comprising of rows, columns and cells

  • A. MS Word
  • B. MS PowerPoint
  • C. MS Outlook
  • D. MS Excel

30) Key combination to move to the adjacent cell on the left

  • A. Shift + Tab
  • B. Ctrl + Home
  • C. Ctrl + G
  • 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
May
Android MCQ
01st
May
MVC MCQ
01st
Apr
LISP MCQ