📘 Excel 2021 Basic Quiz

Instructions: Answer all 50 questions. For "Choose two/three" questions, select all that apply. Enter your name and click Submit to see your score. After submission, answers cannot be changed.

1. Which reference describes the first five cells in column A of a worksheet?

  • A. A1:E1
  • B. A1:A5
  • C. A1:E5
  • D. A1:5A

2. What is the default file format for Excel 2021 files?

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

3. What type of reference is A$4 an example of?

  • A. Relative
  • B. Absolute
  • C. Worksheet
  • D. Mixed

4. Which Excel 2021 feature enables you to perform web-based research on specific cell data in your worksheet?

  • A. Smart Lookup task pane
  • B. Research task pane
  • C. Go To dialog box
  • D. Excel Help

5. What differentiates hyperlinks from other typical font formatting?

  • A. Hyperlinks don't alter the look of text.
  • B. Hyperlinks can't be added from the ribbon.
  • C. Hyperlinks affect only numeric values.
  • D. Hyperlinks add functionality to worksheet cells.

6. Which element do themes directly apply to?

  • A. Individual cells
  • B. Cell ranges
  • C. Entire workbooks
  • D. Entire worksheets

7. Which of these print settings affects the magnification level of printed data?

  • A. Collating
  • B. Orientation
  • C. Scaling
  • D. Paper size

8. Which of the following enables you to control which column and row labels appear on printed worksheets?

  • A. Print areas
  • B. Print Titles command
  • C. Margins
  • D. Page breaks

9. True or False? The Quick Access Toolbar is a temporary pop-up window that provides you with quick access to common text editing commands.

  • A. true
  • B. false

10. True or False? You can only use Excel Help when connected to the Internet.

  • A. true
  • B. false

11. True or False? Excel formulas always begin with an equal sign.

  • A. true
  • B. false

12. True or False? Hiding rows and columns affects formulas with references to cells in those rows and columns.

  • A. true
  • B. false

13. True or False? Applying number formatting to cell data can affect the precision of displayed values.

  • A. true
  • B. false

14. True or False? Merging cells can cause data loss.

  • A. true
  • B. false

15. True or False? You can search for Excel templates online, but you cannot create custom templates.

  • A. true
  • B. false

16. True or False? Workbook properties can make it easier for users to search for specific workbook files.

  • A. true
  • B. false

17. Which of the following statements are true regarding cutting data in Excel? (Choose two.)

  • A. Cutting cell data and then pasting it in another cell removes the original data.
  • B. Cutting cell data and then pasting it in another cell leaves the original data intact.
  • C. Cutting cell data temporarily stores that data on the Microsoft Office clipboard.
  • D. You can only cut all of a cell's data at once.

18. Which are elements of Excel functions? (Choose three.)

  • A. Arguments
  • B. Function library
  • C. Equal sign
  • D. Function name

19. Excel enables you to perform which of the following actions using the Find and Replace dialog box? (Choose three.)

  • A. Locate particular content anywhere within a workbook.
  • B. Replace the contents of a single cell with new data.
  • C. Replace two values throughout a workbook with two new values simultaneously.
  • D. Replace all instances of a particular entry with another entry simultaneously.

20. Which of the following statements about conditional formatting are true? (Choose two.)

  • A. It can apply a variety of formatting options to worksheet cells.
  • B. It uses defined criteria to apply formatting.
  • C. By default, it applies to all data in a workbook.
  • D. Cell values do not affect it.

21. Which of the following are header and footer options? (Choose three.)

  • A. Different First Page
  • B. Different Last Page
  • C. Align with Page Margins
  • D. Different Odd & Even Pages

22. Which options are available for managing Excel worksheet tabs? (Choose three.)

  • A. Renaming them
  • B. Rearranging them
  • C. Merging them
  • D. Modifying their colors

23. Which worksheet viewing options or features enable you to view multiple workbooks simultaneously? (Choose two.)

  • A. Split
  • B. Page Break Preview
  • C. Arrange All
  • D. View Side by Side

24. What is the maximum number of columns in an Excel 2021 worksheet?

  • A. 16,384
  • B. 10,000
  • C. 65,536
  • D. 1,048,576

25. Which element of the Excel UI displays the cell reference of the active cell?

  • A. Formula Bar
  • B. Name Box
  • C. Status Bar
  • D. Title Bar

26. What file extension is used for an Excel macro‑enabled workbook?

  • A. .xlsx
  • B. .xlsm
  • C. .xlsb
  • D. .xltx

27. In a custom number format, what does a zero (0) represent?

  • A. An optional digit
  • B. A required digit that always displays
  • C. A placeholder for a space
  • D. A negative sign

28. True or False? The # symbol in a custom number format makes a digit appear only if it is significant.

  • A. True
  • B. False

29. Which function returns the smallest numeric value in a range?

  • A. MAX
  • B. COUNT
  • C. MIN
  • D. AVERAGE

30. What is the keyboard shortcut to open the Go To dialog box?

  • A. Ctrl + G
  • B. F5
  • C. Ctrl + H
  • D. Shift + F5

31. Which reference type is $A$1 an example of?

  • A. Relative
  • B. Absolute
  • C. Mixed
  • D. Worksheet

32. True or False? Excel’s AutoFill feature can only copy cells, not fill in a pattern.

  • A. True
  • B. False

33. Which ribbon tab contains commands for inserting charts, tables, and hyperlinks?

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

34. What does the #### error in a cell typically indicate?

  • A. The formula divides by zero
  • B. The column is too narrow to display the content
  • C. An invalid cell reference
  • D. Text where a number was expected

35. True or False? By default, Excel aligns text to the left and numbers to the right.

  • A. True
  • B. False

36. Which command allows you to keep row and column labels visible while scrolling through a large worksheet?

  • A. Split
  • B. Freeze Panes
  • C. New Window
  • D. Arrange All

37. In the Page Setup dialog box, which tab lets you define a print area and specify rows to repeat at the top?

  • A. Page
  • B. Margins
  • C. Header/Footer
  • D. Sheet

38. True or False? Headers and footers are visible in Normal view.

  • A. True
  • B. False

39. What is the default file format for an Excel 2021 template?

  • A. .xltm
  • B. .xlsx
  • C. .xltx
  • D. .xls

40. True or False? Custom views can save print settings and hidden row/column settings.

  • A. True
  • B. False

41. Which function counts only cells that contain numeric entries?

  • A. COUNTA
  • B. COUNT
  • C. COUNTBLANK
  • D. COUNTIF

42. True or False? The Format Painter can copy both formatting and cell content.

  • A. True
  • B. False

43. What does the Merge & Center command do?

  • A. Combines selected cells and centers the content
  • B. Centers the text without merging cells
  • C. Merges cells without centering
  • D. Splits a merged cell

44. Which key toggles between Enter and Edit mode in a cell?

  • A. F1
  • B. F2
  • C. F3
  • D. F4

45. What is the maximum number of rows in an Excel 2021 worksheet?

  • A. 16,384
  • B. 65,536
  • C. 1,048,576
  • D. 10,000

46. Which of the following is a valid reference operator in Excel?

  • A. &
  • B. :
  • C. $
  • D. !

47. True or False? The COUNT function includes cells with text in its count.

  • A. True
  • B. False

48. What is the purpose of the Watch Window in Excel?

  • A. To view the time
  • B. To monitor the values of selected cells even when they are not visible
  • C. To display the current date
  • D. To record macros

49. Which feature allows you to see how a worksheet will look when printed, including headers and footers?

  • A. Page Break Preview
  • B. Normal view
  • C. Page Layout view
  • D. Print Preview

50. What does the `#VALUE!` error indicate?

  • A. A formula tries to divide by zero
  • B. A formula uses an invalid data type
  • C. A cell reference is invalid
  • D. The column is too narrow
↺ Reset / Try Again