Spreadsheet Modeling (Excel) MCQs

1. Which of the following is a spreadsheet application?
(A) MS Word
(B) MS Excel
(C) Adobe Photoshop
(D) Notepad

2. In Excel, a single cell is identified by:
(A) Sheet name
(B) Row number
(C) Column letter
(D) Column letter and row number combination

3. Which symbol is used to start a formula in Excel?
(A) =
(B) +
(C) –
(D) $

4. Which function is used to find the average of numbers in Excel?
(A) SUM()
(B) AVERAGE()
(C) COUNT()
(D) MAX()

5. The shortcut key for creating a new workbook in Excel is:
(A) Ctrl + N
(B) Ctrl + C
(C) Ctrl + P
(D) Ctrl + X

6. Which function is used to count numeric values in Excel?
(A) COUNT()
(B) COUNTA()
(C) COUNTIF()
(D) COUNTBLANK()

7. What does the VLOOKUP() function do in Excel?
(A) Looks vertically in a range for a value
(B) Looks horizontally in a range for a value
(C) Looks for duplicate values
(D) Counts blank cells

8. Which of the following is an absolute reference in Excel?
(A) A1
(B) $A$1
(C) A$1
(D) $A1

9. Which function returns the largest value in a range?
(A) MIN()
(B) LARGE()
(C) MAX()
(D) COUNT()

10. Which chart type is best for showing trends over time?
(A) Pie chart
(B) Bar chart
(C) Line chart
(D) Scatter chart

11. Which function in Excel adds up all numbers in a range?
(A) SUM()
(B) MAX()
(C) AVERAGE()
(D) COUNT()

12. Conditional Formatting in Excel is used to:
(A) Format all text in bold
(B) Change the appearance of cells based on their values
(C) Merge two cells
(D) Filter data

13. The IF() function is used to:
(A) Perform text formatting
(B) Check whether a condition is true or false
(C) Insert dates
(D) Create charts

14. The shortcut key for saving a workbook in Excel is:
(A) Ctrl + S
(B) Ctrl + C
(C) Ctrl + X
(D) Ctrl + Z

15. What does the CONCATENATE() or CONCAT() function do?
(A) Splits text into separate cells
(B) Joins two or more text strings together
(C) Converts text to numbers
(D) Calculates average

16. Pivot Tables are used for:
(A) Formatting worksheets
(B) Summarizing large datasets
(C) Typing text documents
(D) Creating invoices

17. Which function is used to return the current date?
(A) TIME()
(B) DATE()
(C) NOW()
(D) TODAY()

18. Which function in Excel is used to find the smallest number in a range?
(A) MAX()
(B) MIN()
(C) AVERAGE()
(D) COUNT()

19. What is the purpose of the Filter feature in Excel?
(A) Hide all data
(B) Sort data alphabetically
(C) Display specific data that meets certain criteria
(D) Change font size

20. Which formula calculates the number of non-blank cells in a range?
(A) COUNT()
(B) COUNTA()
(C) COUNTBLANK()
(D) SUM()

21. Which error appears when a formula divides by zero?
(A) #VALUE!
(B) #DIV/0!
(C) #REF!
(D) #NUM!

22. Which function is used to round a number to the nearest integer?
(A) ROUND()
(B) CEILING()
(C) FLOOR()
(D) INT()

23. In Excel, a workbook is made up of:
(A) Tables
(B) Worksheets
(C) Charts
(D) Graphs

24. Which of the following file extensions is used for Excel files?
(A) .docx
(B) .xlsx
(C) .pptx
(D) .txt

25. What does the function COUNTIF() do?
(A) Adds numbers conditionally
(B) Counts cells that meet a condition
(C) Converts text to uppercase
(D) Finds errors in a formula

26. Which of the following is a relative reference?
(A) $A$1
(B) A1
(C) A$1
(D) $A1

27. Which function is used to determine the number of rows in a dataset?
(A) COLUMNS()
(B) ROWS()
(C) COUNT()
(D) COUNTA()

28. Which feature allows you to automatically fill cells with data?
(A) Conditional Formatting
(B) AutoFill
(C) Flash Fill
(D) Filter

29. In Excel, the cell range A1:B2 refers to:
(A) A single cell
(B) Four cells in two rows and two columns
(C) Two cells in a row
(D) Two cells in a column

30. To lock a row while scrolling, use:
(A) Freeze Panes
(B) Sort
(C) Filter
(D) Pivot Table

31. Which chart is suitable for comparing parts of a whole?
(A) Pie chart
(B) Bar chart
(C) Line chart
(D) Area chart

32. Which tab is used to insert charts in Excel?
(A) File
(B) Insert
(C) Data
(D) Review

33. Which function is used to look up a value both horizontally and vertically?
(A) VLOOKUP()
(B) HLOOKUP()
(C) INDEX() and MATCH()
(D) CONCAT()

34. What does the Fill Handle do in Excel?
(A) Formats cells
(B) Calculates total
(C) Copies and extends values or formulas
(D) Saves workbook

35. Flash Fill is used for:
(A) Removing duplicates
(B) Automatically filling data based on patterns
(C) Calculating totals
(D) Adding comments

36. Which function returns the current time?
(A) TODAY()
(B) NOW()
(C) TIME()
(D) DATE()

37. Which function would you use to round numbers down?
(A) ROUNDUP()
(B) ROUNDDOWN()
(C) ROUND()
(D) CEILING()

38. Which formula is used to calculate compound interest in Excel?
(A) =P*(1+r)^n
(B) =Prn
(C) =P+n
(D) =P*(r+n)

39. Which key combination is used for the Print Preview in Excel?
(A) Ctrl + P
(B) Ctrl + N
(C) Ctrl + B
(D) Ctrl + S

40. What does the TRIM() function do?
(A) Converts lowercase to uppercase
(B) Removes extra spaces from text
(C) Adds spaces between words
(D) Converts numbers to text

41. Which feature highlights duplicate values in Excel?
(A) Pivot Table
(B) Conditional Formatting
(C) Flash Fill
(D) Data Validation

42. Which function is used to retrieve data from a specific position in a range?
(A) MATCH()
(B) INDEX()
(C) VLOOKUP()
(D) HLOOKUP()

43. Which Excel feature splits data into multiple cells based on a delimiter?
(A) Flash Fill
(B) Text to Columns
(C) Concatenate
(D) Pivot Table

44. What does the SUBSTITUTE() function do?
(A) Replaces specific text within a string
(B) Changes text to uppercase
(C) Combines multiple strings
(D) Adds currency symbols

45. Which function returns the number of characters in a string?
(A) LEN()
(B) LEFT()
(C) RIGHT()
(D) FIND()

46. Which of the following represents a named range in Excel?
(A) A1
(B) DataSet
(C) SUM()
(D) COUNTIF()

47. Which function extracts a portion of text starting from the left?
(A) RIGHT()
(B) LEFT()
(C) MID()
(D) CONCAT()

48. Which function will return the position of a specific character in a text string?
(A) FIND()
(B) LEN()
(C) MID()
(D) RIGHT()

49. Which shortcut key selects the entire worksheet in Excel?
(A) Ctrl + C
(B) Ctrl + A
(C) Ctrl + Z
(D) Ctrl + X

50. Which of the following Excel features allows combining data from different sheets?
(A) Data Consolidate
(B) Text to Columns
(C) Conditional Formatting
(D) Freeze Panes