MS Excel MCQ Test

1. What is the file extension for a standard Excel workbook?

• A. .xls
• B. .xlsx
• C. .xlsm
• D. .csv

Answer: .xlsx

2. Which function calculates the sum of a range of cells?

• A. SUM()
• B. ADD()
• C. TOTAL()
• D. SUMMARIZE()

Answer: SUM()

3. What does the VLOOKUP function do?

• A. Searches for a value in a table
• B. Calculates a total
• C. Looks up a cell reference
• D. Formats data

Answer: Searches for a value in a table

4. What shortcut is used to save a workbook?

• A. Ctrl+S
• B. Ctrl+N
• C. Ctrl+O
• D. Ctrl+W

Answer: Ctrl+S

5. How do you insert a new worksheet?

• A. Ctrl+N
• B. Shift+F11
• C. Alt+W
• D. Ctrl+W

Answer: Shift+F11

6. Which symbol is used to start a formula in Excel?

• A. $
• B. #
• C. =
• D. @

Answer: =

7. What function returns the current date?

• A. NOW()
• B. DATE()
• C. TODAY()
• D. CURRENT()

Answer: TODAY()

8. Which function would you use to find the average of a range of cells?

• A. AVERAGE()
• B. MEAN()
• C. AVG()
• D. MEDIAN()

Answer: AVERAGE()

9. How can you format a cell as currency?

• A. Right-click > Format Cells
• B. Home > Number Format
• C. Insert > Currency
• D. Data > Currency

Answer: Home > Number Format

10. What does the CONCATENATE function do?

• A. Combines text from different cells
• B. Calculates total
• C. Finds maximum value
• D. Sorts data

Answer: Combines text from different cells

11. What is the shortcut for opening the 'Format Cells' dialog?

• A. Ctrl+1
• B. Alt+1
• C. Shift+1
• D. Ctrl+Shift+1

Answer: Ctrl+1

12. Which command is used to sort data in Excel?

• A. Data > Sort
• B. Home > Sort
• C. View > Sort
• D. Insert > Sort

Answer: Data > Sort

13. What does the IF function do?

• A. Conditional logic
• B. Calculate averages
• C. Lookup data
• D. Count cells

Answer: Conditional logic

14. How do you create a chart in Excel?

• A. Insert > Chart
• B. Home > Chart
• C. Data > Chart
• D. View > Chart

Answer: Insert > Chart

15. Which file format allows macros to be saved?

• A. .xls
• B. .xlsx
• C. .xlsm
• D. .csv

Answer: .xlsm

16. What is the purpose of the Freeze Panes feature?

• A. Lock rows or columns
• B. Merge cells
• C. Split screen
• D. Sort data

Answer: Lock rows or columns

17. How do you input a formula in a cell?

• A. Start with =
• B. Start with +
• C. Start with @
• D. Start with #

Answer: Start with =

18. What does the COUNT function do?

• A. Counts numeric entries
• B. Counts all entries
• C. Counts text entries
• D. Counts unique entries

Answer: Counts numeric entries

19. In Excel, what does the average formula look like?

• A. AVERAGE(A1:A10)
• B. AVG(A1:A10)
• C. MEAN(A1:A10)
• D. SUM(A1:A10)/10

Answer: AVERAGE(A1:A10)

20. What is the shortcut for creating a new workbook?

• A. Ctrl+N
• B. Ctrl+W
• C. Ctrl+M
• D. Ctrl+Shift+N

Answer: Ctrl+N

21. How many columns are in a worksheet in Excel 2019?

• A. 256
• B. 1024
• C. 16384
• D. 1048576

Answer: 16384

22. Which of the following functions is used to find the maximum number in a range?

• A. MAX()
• B. HIGHEST()
• C. LARGE()
• D. TOP()

Answer: MAX()

23. How do you reference a cell in another sheet?

• A. SheetName!Cell
• B. Cell!SheetName
• C. SheetName:Cell
• D. Cell/SheetName

Answer: SheetName!Cell

24. Which shortcut key is used to go to the next worksheet?

• A. Ctrl+Page Up
• B. Ctrl+Page Down
• C. Alt+Page Up
• D. Shift+Page Down

Answer: Ctrl+Page Down

25. What does the SUMIF function do?

• A. Adds cells based on criteria
• B. Counts based on criteria
• C. Finds maximum based on criteria
• D. Finds average based on criteria

Answer: Adds cells based on criteria

26. How do you remove duplicates from a range?

• A. Data > Remove Duplicates
• B. Home > Remove Duplicates
• C. Insert > Remove Duplicates
• D. View > Remove Duplicates

Answer: Data > Remove Duplicates

27. What does the PMT function calculate?

• A. Payment for a loan
• B. Total amount
• C. Interest rate
• D. Monthly savings

Answer: Payment for a loan

28. Which of the following is not a valid Excel function?

• A. AVERAGEIF()
• B. SUMPRODUCT()
• C. COUNTIF()
• D. ADDIF()

Answer: ADDIF()

29. Which task is accomplished using the Data Validation feature?

• A. Restrict cell entries
• B. Sort data
• C. Format cells
• D. Create formulas

Answer: Restrict cell entries

30. In Excel, what does F4 do?

• A. Repeat last action
• B. Open Format Cells
• C. Insert column
• D. Delete cell

Answer: Repeat last action

31. How do you start a new line within the same cell?

• A. Alt+Enter
• B. Ctrl+Enter
• C. Shift+Enter
• D. Enter

Answer: Alt+Enter

32. What does the function TODAY() return?

• A. Current date
• B. Current time
• C. Total days
• D. End of month

Answer: Current date

33. Which tab would you use to access PivotTables?

• A. Insert
• B. Home
• C. Data
• D. View

Answer: Insert

34. What is the default alignment for text in Excel cells?

• A. Left
• B. Right
• C. Center
• D. Justified

Answer: Left

35. Which of the following would you use to find a specific text in a cell?

• A. SEARCH()
• B. FIND()
• C. LOOKUP()
• D. MATCH()

Answer: FIND()

36. What does the function LEN() return?

• A. Length of text
• B. Sum of numbers
• C. Random number
• D. Date of entry

Answer: Length of text

37. How do you protect a worksheet?

• A. Review > Protect Sheet
• B. Home > Lock Sheet
• C. File > Protect
• D. View > Protect

Answer: Review > Protect Sheet

38. Which function can return a value based on a logical test?

• A. IF()
• B. SELECT()
• C. CHOOSE()
• D. FILTER()

Answer: IF()

39. To switch between two open workbooks, which shortcut is used?

• A. Ctrl+Tab
• B. Ctrl+F6
• C. Alt+Tab
• D. Shift+F10

Answer: Ctrl+F6

40. What function would you use to round a number to a specified number of digits?

• A. ROUND()
• B. ROUNDDOWN()
• C. ROUNDUP()
• D. ALLROUND()

Answer: ROUND()

41. Which feature helps create a visual representation of data?

• A. Charts
• B. Formulas
• C. Tables
• D. Cells

Answer: Charts

42. What is the shortcut key for inserting a function?

• A. Shift+F3
• B. Ctrl+F3
• C. Alt+F3
• D. Ctrl+Shift+F3

Answer: Shift+F3

43. How do you hide a worksheet?

• A. Right-click > Hide
• B. Insert > Hide
• C. Data > Hide
• D. Home > Hide

Answer: Right-click > Hide

44. What does the F1 key do in Excel?

• A. Open Help
• B. Cancel operation
• C. Insert new sheet
• D. Open options

Answer: Open Help

45. In Excel, what does the term 'cell reference' mean?

• A. Address of a cell
• B. Data in a cell
• C. Formula in a cell
• D. Formatting of a cell

Answer: Address of a cell

46. Which of the following is the correct syntax for a COUNTIF formula?

• A. COUNTIF(range, criteria)
• B. COUNTIF(criteria, range)
• C. COUNTIF(range; criteria)
• D. COUNTIF(criteria; range)

Answer: COUNTIF(range, criteria)

47. How can you quickly fill a series of numbers?

• A. Drag the fill handle
• B. Press Enter
• C. Right-click > Fill Series
• D. Use the Fill Series command

Answer: Drag the fill handle

48. What does the ROUNDUP function do?

• A. Rounds up to the nearest value
• B. Rounds down to the nearest value
• C. Rounds to the nearest whole number
• D. No rounding

Answer: Rounds up to the nearest value

49. How do you add comments to a cell?

• A. Right-click > Insert Comment
• B. Insert > Comment
• C. Review > New Comment
• D. Data > Comment

Answer: Review > New Comment

50. What does the function NOW() return?

• A. Current date and time
• B. Current date
• C. Current time
• D. Random time

Answer: Current date and time

51. How do you create a drop-down list in a cell?

• A. Data > Data Validation
• B. Home > List
• C. Insert > List
• D. View > List

Answer: Data > Data Validation

52. Which tab allows you to change the style of a table?

• A. Table Design
• B. Home
• C. Insert
• D. Data

Answer: Table Design

53. What does the function CONCAT() do?

• A. Combines text strings
• B. Calculates total
• C. Formats numbers
• D. Finds maximum value

Answer: Combines text strings

54. What is the maximum number of rows in Excel?

• A. 1048576
• B. 65536
• C. 32768
• D. 16384

Answer: 1048576

55. How can you access the 'Name Box' in Excel?

• A. Select a cell
• B. Click on the box above row 1
• C. Use Alt+N
• D. Dashboard options

Answer: Click on the box above row 1

56. Which function would you use to calculate the standard deviation?

• A. STDEV.S()
• B. AVG()
• C. DEVIATE()
• D. VAR()

Answer: STDEV.S()

57. What does the function ISBLANK() check for?

• A. Empty cells
• B. Error values
• C. Text values
• D. Numeric values

Answer: Empty cells

58. How do you change the theme of an Excel workbook?

• A. Page Layout > Themes
• B. Insert > Theme
• C. View > Themes
• D. Home > Themes

Answer: Page Layout > Themes

59. Which tool would you use to explore relationships in data visually?

• A. PivotTable
• B. Filter
• C. Sort
• D. Data Validation

Answer: PivotTable

60. Which Excel feature allows you to analyze data with interactive tables?

• A. PivotTable
• B. Data Table
• C. Table
• D. Chart

Answer: PivotTable

61. Which command removes all formats from a cell?

• A. Clear Formats
• B. Delete
• C. Remove Styles
• D. Default Format

Answer: Clear Formats

62. How do you transpose rows and columns?

• A. Copy > Paste Special > Transpose
• B. Data > Transpose
• C. Home > Transpose
• D. Insert > Transpose

Answer: Copy > Paste Special > Transpose

63. Which of the following is not a valid data type in Excel?

• A. Text
• B. Number
• C. Currency
• D. Symbol

Answer: Symbol

64. What is the purpose of a data table?

• A. Display relationships
• B. Show data summary
• C. Analyze data impact
• D. All of the above

Answer: All of the above

65. What can be used to create dashboards in Excel?

• A. Charts
• B. Tables
• C. Slicers
• D. All of the above

Answer: All of the above

66. How do you insert a hyperlink?

• A. Insert > Link
• B. Insert > Hyperlink
• C. Home > Hyperlink
• D. Data > Link

Answer: Insert > Hyperlink

67. Which function can be used to check if a value exists in a range?

• A. MATCH()
• B. LOOKUP()
• C. SEARCH()
• D. CHOOSE()

Answer: MATCH()

68. What does the SUMPRODUCT function do?

• A. Multiplies ranges and returns sum
• B. Counts products
• C. Calculates average of products
• D. None of the above

Answer: Multiplies ranges and returns sum

69. To quickly add a border to selected cells, you would use:

• A. Home > Borders
• B. Insert > Borders
• C. Page Layout > Borders
• D. Data > Borders

Answer: Home > Borders

70. How do you display formulas instead of values in cells?

• A. Ctrl+`
• B. Ctrl+F
• C. Shift+F
• D. Alt+F

Answer: Ctrl+`

71. What is the maximum number of characters in a cell?

• A. 256
• B. 1024
• C. 32768
• D. 65536

Answer: 32768

72. How do you format a cell to be bold?

• A. Ctrl+B
• B. Shift+B
• C. Alt+B
• D. Format > Bold

Answer: Ctrl+B

73. Which option allows for quick calculations in the status bar?

• A. Average
• B. Count
• C. Sum
• D. All of the above

Answer: All of the above

74. How do you quickly navigate to the beginning of a worksheet?

• A. Ctrl+Home
• B. Home
• C. Alt+Home
• D. Shift+Home

Answer: Ctrl+Home

75. Which of the following is a logical function?

• A. SUM()
• B. IF()
• C. AVERAGE()
• D. COUNT()

Answer: IF()

76. How do you change the orientation of a printed spreadsheet?

• A. Page Layout > Orientation
• B. Insert > Orientation
• C. View > Orientation
• D. Home > Orientation

Answer: Page Layout > Orientation

77. What does the function TEXT() do?

• A. Formats a number to text
• B. Calculates text length
• C. Transposes text
• D. All of the above

Answer: Formats a number to text

78. Which function can determine the number of days between two dates?

• A. DATEDIF()
• B. DAYS()
• C. DATEDAYS()
• D. DATE()

Answer: DAYS()

79. To bring up a context menu (right-click menu) in Excel, you use:

• A. Right-click
• B. Shift+F10
• C. Ctrl+M
• D. Alt+M

Answer: Shift+F10