MCQ on Excel – functions, formulas, charts, shortcut keys

• Microsoft Excel (Microsoft Office Excel) is a spreadsheet program created by Microsoft for Microsoft Windows, Windows NT, and Mac OS, as well as Android, iOS, and Windows Phone.
• The Microsoft Excel program is convenient for drawing up tables and making calculations. A workspace is a set of cells that can be filled with data.
• Excel allows you to quickly and efficiently analyze data, visualize your work, create reports, optimize costs and increase profits based on them.
• Excel greatly facilitates the task of counting and analyzing various data in tables.
• Apart from organizing the data, MS Excel provides the facility to make calculations, make decisions, graph the data, generate reports, work with the data on the website, etc.
• In this, many formulas, and functions are given to do mathematical or logical calculations of the biggest data, using which any big calculations can also be done in a pinch.
• In Excel, any data is arranged in rows and columns and the systematic form of these rows and columns is called a worksheet. A worksheet has 10,48,576 rows and 16,384 columns.
• The food made by cutting rows and columns is called cells. In these cells, we fill any data. The number of cells in a worksheet is 17,17,98,69,184.
• The complete file of MS Excel is called a workbook. A maximum of 255 worksheets can be created in a workbook.
• Excel is useful for Financiers and financial analysts, Banking professionals, Business Consultants, Accountants, Marketers, Entrepreneurs and managers, Business Analytics, etc.

Read: MCQ on MS Word

Features of MS Excel

• The User Interface of MS Excel is very simple, Microsoft has designed it in such a way that any person can start their own business in no time by taking basic training in MS Excel.
• This is the world’s most trusted Spread Sheet Program, without this computer knowledge is incomplete, and complex calculations can be done very easily with the help of MS Excel, if you have learned MS Excel once, then you will find work somewhere.
• The design of MS Excel is like this in which you get Automatic Tables made, no need to create tables, you open Excel and you can start Data Entry.
• MS Excel Formulas Make The Work Easier If You Take Basic Knowledge Of Excel Formulas Then Many Hours Of Work Can Be Done In Minutes With The Help Of Excel Formulas Which Are Auto Updated Also
• In MS Excel, one seat to another seat and one file to another file can also be linked, no matter how much data you have, Excel will handle it.
• You Can Create Automatic Charts And Dashboard Through MS Excel.

MCQ on Excel – Functions, Formulas, Charts, Shortcut Keys

1. Another name for a pre-programmed formula in Excel is____________
A. Cell
B. Graph
C. Function
D. Range
Answer: (C) Function
Explanation: In Excel, a function is a built-in formula used for calculations.

Read: Computer GK – Basic Computer Knowledge Questions

2. By default, the extension of an Excel document is__________
A. doc
B. ppt
C. xls
D. BMP
Answer: (C) xls
Explanation: Excel files traditionally used the .xls extension.

Read: E Commerce MCQ

3. Microsoft Excel Worksheet command is used?
A. To organize all the worksheets
B. Displaying the range
C. To change the worksheet
D. All of the above
Answer: (A) To organize all the worksheets
Explanation: This command helps manage the arrangement of multiple sheets.

Read: MCQs on Current Affairs for Competitive Exams

4. The entire worksheet of Excel is selected together, by the shortcut key_______
A. CTRL + A
B. CTRL + All
C. CTRL + N
D. CTRL + M
Answer: (A) CTRL + A
Explanation: Pressing Ctrl + A selects all cells in the worksheet.

Read: MCQ on Digital Signature with Answers Pdf

5. The shortcut for Macros in Excel is_______
A. ALT + F9
B. ALT + F8
C. ALT + F11
D. All of the above
Answer: (B) ALT + F8
Explanation: ALT + F8 opens the Macro dialog box.

Read: Introduction to DBMS MCQ Pdf

6. There is a shortcut key to apply data format in MS Excel_________
A. CTRL + SHIFT + #
B. CTRL + SHIFT + $
C. CTRL + SHIFT + =
D. CTRL + SHIFT + K
Answer: (A) CTRL + SHIFT + #
Explanation: This shortcut applies the date format.

Read: MCQ on DBMS ( Database Management System MCQ )

7. If you use the same formula for multiple calculations in Excel, then it is__________
A. Standard Formula
B. Array Formula
C. Complex Formula
D. Smart Formula
Answer: (B) Array Formula
Explanation: Array formulas allow performing multiple calculations in a single formula.

Read: MCQ on Operating System with Answers

8. Which of the following data is not validated in Excel______
A. NUMBER
B. CHARACTER
C. CABLE
D. DATE/TIME
Answer: (C) CABLE
Explanation: “CABLE” is not a recognized data type in Excel.

9. Which is the latest version of Excel______
A. Excel-2000
B. Excel-2002
C. Excel-M.E.
D. Excel-SP
Answer: (D) Excel-SP
Explanation: Excel-SP refers to the most recent Service Pack or version (subject to update).

10. The extension of the file created in Excel is_________
A. XLS
B. XLW
C. WALL
D. 123
Answer: (A) XLS
Explanation: .xls is the standard extension for Excel 97–2003 files.

11. Which of the following is the oldest spreadsheet package______
A. VISI CALL
B. LOTUS 1-2-3
C. Excel
D. STAR CALL
Answer: (A) VISI CALL
Explanation: VisiCalc was the first spreadsheet software developed in 1979.

12. Which of the following is the extension name of the file made in Lotus________
A. DOS
B. XLS
C. 123
D. WIKI
Answer: (C) 123
Explanation: Lotus 1-2-3 files used the .123 extension.

13. How many columns are there in an Excel worksheet______
A. 128
B. 256
C. 512
D. 1024
Answer: (B) 256
Explanation: Earlier versions of Excel had 256 columns (Excel 2003 and earlier).

14. How many rows are there in a worksheet_________
A. 256
B. 1,024
C. 32,000
D. 65,536
Answer: (D) 65,536
Explanation: Excel 2003 had a maximum of 65,536 rows.

15. What is the total number of worksheets in the Excel file______
A. 512
B. 15
C. 100
D. 10
Answer: (B) 15
Explanation: Earlier versions set the default at 3, but users could increase it to 15 or more.

16. How many letters and lines are present in the monitor______
A. 82 characters and 25 lines
B. 80 characters and 25 lines
C. 85 characters and 28 lines
D. 80 characters and 24 lines
Answer: (B) 80 characters and 25 lines
Explanation: A standard display shows 80 characters and 25 lines.

17. Excel’s worksheet and chart are used on HTML document____
A. Internet
B. Internet Assistant Wizard
C. HTML Assistant Wizard
D. Link Wizard
Answer: (B) Internet Assistant Wizard
Explanation: It helps convert Excel documents into HTML for web publishing.

18. Which symbol is used before writing any formula in the formula bar in Excel?
A. “=”
B. “@”
C. “#”
D. “$”
Answer: (A) “=”
Explanation: All formulas in Excel start with the “=” sign.

19. What are many worksheets called in Excel_____
A. Excel Sheet
B. Worksheet
C. Excel Worksheet
D. Excel Book
Answer: (B) Worksheet
Explanation: A single Excel file (Workbook) contains multiple Worksheets.

20. What is the name of a field between Column and Row in MS Excel worksheet______
A. Square
B. Cubicle
C. Cell
D. Worksheet
Answer: (C) Cell
Explanation: The intersection of a row and column is called a “cell”.

21. What is the total size of the Excel worksheet_________
A. High Level
B. Low Level
C. Middle Level
D. Machine Level
Answer: (B) Low Level
Explanation: Refers to Excel’s low-level data structure and memory access.

22. Which option is displayed in both Excel and PowerPoint by pressing Function-Key with Control in MS Excel file______
A. Find Menu
B. Point Menu
C. Special Check Option
D. New Page Option
Answer: (A) Find Menu
Explanation: Ctrl + F opens the Find dialog box in most Office applications.

23. What happens with the F-11 key in MS Excel file_____
A. Macros open
B. Chart menu opens
C. Row is inserted
D. All of the above
Answer: (B) Chart menu opens
Explanation: F11 creates a chart from selected data in Excel.

24. Pivot Table is related to_____
A. Excel
B. E-mail
C. Chat
D. Mother Board
Answer: (A) Excel
Explanation: Pivot Tables summarize large datasets in Excel.

25. What is the intersection of a column and a row on a worksheet called?
A. Column
B. Value
C. Address
D. Cell
Answer: (D) Cell
Explanation: A cell is formed at the intersection of a row and column.

26. The option for setting the horizontal alignment of Excel cells is__________
A. Centered
B. Vertically centered
C. Top alignment
D. Align the bottom
Answer: (A) Centered
Explanation: “Center” aligns text horizontally in the cell.

27. Which function in Excel tells how many numeric entries are there?
A. NUM
B. COUNT
C. SUM
D. CHKNUM
Answer: (B) COUNT
Explanation: The COUNT function counts numeric entries in a range.

28. In Excel, if the content of a cell starts with “=”. Then the content of the cell is
A. Constant
B. Formula
C. Prompt information
D. Invalid data
Answer: (B) Formula
Explanation: Formulas always begin with “=”.

29. In the Excel table, “D3” means that the cell is located in__________
A. Row 4, Column 3
B. Row 3, Column 4
C. Row 3, Column 3
D. Row 4, Column 4
Answer: (B) Row 3, Column 4
Explanation: D3 refers to column D and row 3.

30. How do you display the current date only in MS Excel?
A. Date
B. Today
C. Now
D. Time
Answer: (B) Today
Explanation: The =TODAY() function returns the current date

31. Functions should be used when performing numerical analysis in Excel. Which of the following statements about functions is correct?
A. The Average function can find the number of data in the selected area
B. The Sum(∑) function can calculate the sum of the selected area data
C. Count function can sort the data of the selected area in descending order
D. The Max function is to find the minimum value of the data in the selected area
Answer: (B) The Sum(∑) function can calculate the sum of the selected area data
Explanation: SUM() adds all numeric values in a range.

32. Excel is a program that is used to prepare a______
A. Slide presentation
B. Spreadsheet
C. Text document
D. Database
Answer: (B) Spreadsheet
Explanation: Excel is primarily used for creating spreadsheets.

33. What does the COUNTA function do?
A. Counts cells having alphabets
B. Counts empty cells
C. Counts cells having a number
D. Counts non-empty cells
Answer: (D) Counts non-empty cells
Explanation: COUNTA() counts all cells that are not empty.

34. Wang Liang wants to compare whether his performance has improved or regressed in the previous unit tests. Which chart he uses to analyze his performance is more intuitive?
A. Column chart
B. Bar chart
C. Line chart
D. Pie chart
Answer: (C) Line chart
Explanation: Line charts are best for showing trends over time.

35. Which of the following statements about table information processing is incorrect?
A. An Excel workbook can only have one worksheet
B. The Sum function can perform a summation operation
C. B3 represents the cell address in row 3, column B
D. Subtotals may make each group of data paginated after classification
Answer: (A) An Excel workbook can only have one worksheet
Explanation: A workbook can contain multiple worksheets.

36. A circular reference is______
A. Geometric modeling tool
B. A cell that points to a drawing object
C. A formula that either directly or indirectly depends on itself
D. Always erroneous
Answer: (C) A formula that either directly or indirectly depends on itself
Explanation: Circular references occur when a formula refers to its own cell.

37. In the Excel worksheet, the number of cells contained in the cell range D2:E4 is
A. 5
B. 6
C. 7
D. 8
Answer: (B) 6
Explanation: Range D2:E4 spans 3 rows × 2 columns = 6 cells.

38. The survey data shows that 100 primary school students have books for use, 356 foreign books, 879 tutorial books, and 425 classics. To use Excel to make a “primary school book ratio chart”, the type of chart that should be selected is_______
A. Column chart
B. Line chart
C. Pie chart
D. Bar graph
Answer: (C) Pie chart
Explanation: Pie charts are ideal for showing proportional data.

39. If you want to use Excel charts to intuitively analyze the changing trend of English grades, the most suitable type of chart is_________
A. Column chart
B. Line chart
C. Pie chart
D. Bar graph
Answer: (B) Line chart
Explanation: Line charts clearly show performance trends over time.

40. Which of the following descriptions about Excel is correct?
A. An Excel workbook has only 3 worksheets
B. The default extension of the Excel workbook is doc
C. F2 represents the cells in row 6 and column 2
D. The Max function can calculate the maximum value of a set of data
Answer: (D) The Max function can calculate the maximum value of a set of data
Explanation: MAX() returns the highest number in a dataset.

41. Which of the following is not true regarding Conditional Formatting?
A. You can add more than one condition to check
B. You can set conditions to look for Bold and apply Italics to them
C. You can apply Font border and pattern formats that meet the specified conditions
D. You can delete any condition from the Conditional Formatting dialog box if it is not required
Answer: (B) You can set conditions to look for Bold and apply Italics to them
Explanation: Excel conditional formatting doesn’t check for bold formatting directly.

42. In an Excel worksheet, the sales statistics of commodities are stored. I want to use the “filtering” function to select all commodities with a sales volume of not less than 5000 and a sales volume of less than 2000. The filtering conditions should be_______
A. “greater than 5000” and “less than 2000”
B. “greater than or equal to 5000” and “less than 2000 “
C. “greater than or equal to 5000” or “less than 2000”
D. “greater than 5000” or “less than or equal to 2000”
Answer: (C) “greater than or equal to 5000” or “less than 2000”
Explanation: To capture both high and low extremes, OR logic is used.

43. In Excel, if the formula in cell C1 is =A1+B2, and copy it to cell E5, the formula in E5 is_______
A. =C3+A4
B. =C5+D6
C. =C3+D4
D. =A3+B4
Answer: (B) =C5+D6
Explanation: Excel adjusts cell references based on relative positions when copied.

44. How the transcripts of 4 students made by Excel, which have been sorted in descending order, and the applied keywords are_______
A. Mathematics
B. Language
C. English
D. Total score
Answer: (D) Total score
Explanation: Sorting transcripts typically uses total scores to determine ranking.

45. If you want to quickly find out the top 20 students with the best grades in the “Grade Sheet”, a reasonable method is_________
A. Sort the score table
B. Strictly enter the grades according to the high and low points when the grades are required to be entered
C. Can only read one by one
D. To make a classification summary
Answer: (A) Sort the score table
Explanation: Sorting allows quick identification of top performers.