MS-Excel MCQs (301-400)

  1. The Evaluate Formula tool helps you:
    A) Step through a formula to see calculation order B) Combine formulas C) Merge cells D) Record macros
    Answer: A) Step through a formula to see calculation order

  2. Trace Precedents shows:
    A) Arrows to cells referenced by the formula B) Formula output C) Dependent cells D) Errors
    Answer: A) Arrows to cells referenced by the formula

  3. Trace Dependents shows:
    A) Arrows to cells depending on the current cell B) All cells in sheet C) Errors only D) Hidden rows
    Answer: A) Arrows to cells depending on the current cell

  4. To remove all arrows in Formula Auditing:
    A) Formulas → Remove Arrows B) Home → Clear C) View → Gridlines D) Data → Remove Duplicates
    Answer: A) Formulas → Remove Arrows

  5. The Watch Window is used to:
    A) Monitor changes in specific cells B) Record macros C) View charts D) Edit links
    Answer: A) Monitor changes in specific cells

  6. Circular references can be found under:
    A) Formulas → Error Checking → Circular References B) Data → Validation C) Review → Protect D) Insert → Functions
    Answer: A) Formulas → Error Checking → Circular References

  7. The Excel function ISERR() returns TRUE for:
    A) All errors except #N/A B) Only #VALUE! C) Only #REF! D) All errors
    Answer: A) All errors except #N/A

  8. The FORMULATEXT() function displays:
    A) The exact formula in a referenced cell B) Formula results C) Formatting D) Font style
    Answer: A) The exact formula in a referenced cell

  9. The INDIRECT() function returns:
    A) Reference specified by a text string B) Value of a formula C) Formula result D) Range name
    Answer: A) Reference specified by a text string

  10. To lock a reference in Excel, you use:
    A) Dollar sign ($) B) Hash sign (#) C) Ampersand (&) D) Exclamation mark (!)
    Answer: A) Dollar sign ($)

  11. An absolute cell reference looks like:
    A) $A$1 B) A1 C) A$1 D) $A1
    Answer: A) $A$1

  12. Relative references change when:
    A) Formula is copied to another cell B) File is saved C) Cell is merged D) Sheet is hidden
    Answer: A) Formula is copied to another cell

  13. To convert a relative reference to absolute quickly:
    A) Press F4 B) Press F2 C) Ctrl + Shift + A D) Alt + Enter
    Answer: A) Press F4

  14. What symbol is used to separate sheet names in a formula?
    A) ! B) # C) : D) /
    Answer: A) !

  15. The CONCATENATE() function can join:
    A) Up to 255 text strings B) Unlimited strings C) 10 strings only D) 500 strings
    Answer: A) Up to 255 text strings

  16. CONCAT() function can combine:
    A) Multiple ranges and strings B) Only one range C) Formulas only D) Numbers only
    Answer: A) Multiple ranges and strings

  17. TEXTJOIN() differs from CONCAT() because it:
    A) Allows a delimiter B) Ignores blank cells C) Both A and B D) Adds formulas
    Answer: C) Both A and B

  18. What does Ctrl + ; insert?
    A) Current date B) Current time C) Cell formula D) Sheet name
    Answer: A) Current date

  19. What does Ctrl + Shift + : insert?
    A) Current time B) Current date C) Formula D) Text format
    Answer: A) Current time

  20. To repeat the last action:
    A) F4 B) Ctrl + Y C) Both A and B D) Ctrl + Shift + Z
    Answer: C) Both A and B

  21. To move to the next worksheet tab:
    A) Ctrl + Page Down B) Ctrl + Page Up C) Alt + Tab D) Ctrl + Right Arrow
    Answer: A) Ctrl + Page Down

  22. To go to the previous worksheet tab:
    A) Ctrl + Page Up B) Ctrl + Left Arrow C) Ctrl + Shift + Tab D) Alt + Page Up
    Answer: A) Ctrl + Page Up

  23. To select the entire worksheet:
    A) Ctrl + A twice B) Ctrl + Shift + A C) Ctrl + / D) Ctrl + Home
    Answer: A) Ctrl + A twice

  24. The shortcut to insert a new worksheet:
    A) Shift + F11 B) Ctrl + N C) Ctrl + Shift + N D) Alt + F11
    Answer: A) Shift + F11

  25. The shortcut to insert a new row:
    A) Ctrl + Shift + + B) Ctrl + Enter C) Ctrl + R D) Ctrl + Shift + R
    Answer: A) Ctrl + Shift + +

  26. The shortcut to delete a row:
    A) Ctrl + - B) Ctrl + D C) Ctrl + Del D) Alt + Delete
    Answer: A) Ctrl + –

  27. To open the Format Cells dialog box:
    A) Ctrl + 1 B) Ctrl + F1 C) Shift + F1 D) Alt + F2
    Answer: A) Ctrl + 1

  28. To hide selected columns:
    A) Ctrl + 0 B) Ctrl + 9 C) Ctrl + Shift + H D) Alt + H
    Answer: A) Ctrl + 0

  29. To hide selected rows:
    A) Ctrl + 9 B) Ctrl + 0 C) Ctrl + Shift + 9 D) Ctrl + Del
    Answer: A) Ctrl + 9

  30. To unhide rows:
    A) Ctrl + Shift + ( B) Ctrl + Shift + 0 C) Ctrl + 9 D) Alt + Shift + (
    Answer: A) Ctrl + Shift + (

  31. To unhide columns:
    A) Ctrl + Shift + ) B) Ctrl + Shift + ( C) Ctrl + 0 D) Alt + Shift + )
    Answer: A) Ctrl + Shift + )

  32. Freeze Panes option is found under:
    A) View tab B) Data tab C) Home tab D) Review tab
    Answer: A) View tab

  33. Freeze Top Row shortcut:
    A) View → Freeze Panes → Freeze Top Row B) Ctrl + F1 C) Data → Freeze D) Alt + R
    Answer: A) View → Freeze Panes → Freeze Top Row

  34. To keep both row and column visible while scrolling:
    A) Use Freeze Panes at intersection B) Use Split C) Use Zoom D) Use Protect
    Answer: A) Use Freeze Panes at intersection

  35. Split Window feature is used to:
    A) Divide worksheet into multiple panes B) Merge data C) Print selected range D) Highlight formulas
    Answer: A) Divide worksheet into multiple panes

  36. Zoom slider is located in:
    A) Status Bar B) View tab C) Ribbon D) Title bar
    Answer: A) Status Bar

  37. To quickly adjust column width:
    A) Double-click boundary B) Right-click and resize C) Use Alt + Enter D) Press Tab
    Answer: A) Double-click boundary

  38. To fit all columns in one page for printing:
    A) Page Layout → Scale to Fit B) View → Fit to Screen C) Data → Fit D) Review → Layout
    Answer: A) Page Layout → Scale to Fit

  39. To print row and column headings:
    A) Page Layout → Print Titles → Sheet Options B) File → Save As C) View → Headings D) Data → Print
    Answer: A) Page Layout → Print Titles → Sheet Options

  40. Print Titles allow:
    A) Repeating specific rows or columns on every printed page B) Printing formulas C) Adding headers D) Scaling pages
    Answer: A) Repeating specific rows or columns on every printed page

  41. To insert a header or footer:
    A) Insert → Text → Header & Footer B) View → Show C) Home → Format D) File → Info
    Answer: A) Insert → Text → Header & Footer

  42. The Page Break Preview is accessed from:
    A) View tab B) File menu C) Home tab D) Data tab
    Answer: A) View tab

  43. To manually insert a page break:
    A) Page Layout → Breaks → Insert Page Break B) Home → Insert C) View → Break D) Data → Insert
    Answer: A) Page Layout → Breaks → Insert Page Break

  44. To remove all manual page breaks:
    A) Page Layout → Breaks → Reset All Page Breaks B) Delete key C) Ctrl + R D) View → Normal
    Answer: A) Page Layout → Breaks → Reset All Page Breaks

  45. Print Area can be set using:
    A) Page Layout → Print Area → Set Print Area B) File → Options C) View → Print Preview D) Data → Print
    Answer: A) Page Layout → Print Area → Set Print Area

  46. To repeat column headers on every printed page:
    A) Page Layout → Print Titles B) Insert → Header/Footer C) Data → Validation D) Home → Format
    Answer: A) Page Layout → Print Titles

  47. To view how a worksheet will print:
    A) File → Print (Print Preview) B) View → Normal C) Home → View D) Data → Sort
    Answer: A) File → Print (Print Preview)

  48. Page Orientation can be changed to:
    A) Portrait or Landscape B) Vertical or Horizontal C) Top or Bottom D) Left or Right
    Answer: A) Portrait or Landscape

  49. To repeat formulas quickly:
    A) Drag the Fill Handle B) Copy and Paste C) Insert Formula D) Format Painter
    Answer: A) Drag the Fill Handle

  50. Flash Fill automatically detects:
    A) Data patterns and fills remaining cells B) Numeric errors C) Empty cells D) Data validation
    Answer: A) Data patterns and fills remaining cells

  51. The AutoFill feature can copy:
    A) Formulas, series, and patterns B) Only text C) Only dates D) Only colors
    Answer: A) Formulas, series, and patterns

  52. Fill Handle is located at:
    A) Bottom-right corner of active cell B) Top-left C) Ribbon D) Status bar
    Answer: A) Bottom-right corner of active cell

  53. The Fill Series option can be found under:
    A) Home → Editing → Fill B) Data → Sort C) View → Zoom D) Insert → Data
    Answer: A) Home → Editing → Fill

  54. To create a custom list for AutoFill:
    A) File → Options → Advanced → Edit Custom Lists B) Data → Validation C) Review → Protect D) View → Macros
    Answer: A) File → Options → Advanced → Edit Custom Lists

  55. The Quick Access Toolbar can be customized from:
    A) File → Options → Quick Access Toolbar B) View → Options C) Data → Tools D) Review → Customize
    Answer: A) File → Options → Quick Access Toolbar

  56. To add commands to the Ribbon:
    A) File → Options → Customize Ribbon B) Insert → Command C) View → Add Tab D) Home → Format
    Answer: A) File → Options → Customize Ribbon

  57. To minimize the Ribbon:
    A) Ctrl + F1 B) Alt + F1 C) Ctrl + R D) F2
    Answer: A) Ctrl + F1

  58. The Formula AutoComplete helps you:
    A) Suggest and complete function names B) Format text C) Align cells D) Merge sheets
    Answer: A) Suggest and complete function names

  59. The Name Manager can be accessed from:
    A) Formulas → Name Manager B) Data → Sort C) Home → Format D) Review → Protect
    Answer: A) Formulas → Name Manager

  60. Named ranges are useful because they:
    A) Make formulas easier to understand B) Protect sheets C) Format data D) Hide rows
    Answer: A) Make formulas easier to understand

  61. To define a new name for a range:
    A) Formulas → Define Name B) Data → Validation C) Home → Format D) Insert → Name
    Answer: A) Formulas → Define Name

  62. Dynamic named ranges use:
    A) OFFSET() and COUNTA() B) SUMIF() C) INDEX() D) IF()
    Answer: A) OFFSET() and COUNTA()

  63. The Evaluate Formula tool helps to:
    A) Debug complex formulas step by step B) Remove formulas C) Merge cells D) Copy data
    Answer: A) Debug complex formulas step by step

  64. To link Excel with other Office apps, use:
    A) OLE (Object Linking and Embedding) B) VLOOKUP() C) Solver D) Flash Fill
    Answer: A) OLE (Object Linking and Embedding)

  65. Which key refreshes linked data from external sources?
    A) F5 B) F9 C) Ctrl + Alt + F5 D) Shift + F9
    Answer: C) Ctrl + Alt + F5

  66. To open Name Box:
    A) Next to formula bar B) Bottom toolbar C) Left of Ribbon D) Right-click menu
    Answer: A) Next to formula bar

  67. The default chart type in Excel is:
    A) Column Chart B) Line Chart C) Pie Chart D) Bar Chart
    Answer: A) Column Chart

  68. To insert a recommended chart:
    A) Insert → Recommended Charts B) Data → Charts C) View → Chart D) Home → Format
    Answer: A) Insert → Recommended Charts

  69. Combo Chart allows:
    A) Two chart types on one chart B) Chart in multiple sheets C) Chart with macros D) Filtered chart
    Answer: A) Two chart types on one chart

  70. The Switch Row/Column button is found in:
    A) Chart Design tab B) View tab C) Data tab D) Insert tab
    Answer: A) Chart Design tab

  71. To add a trendline:
    A) Chart Elements → Trendline B) Data → Sort C) Home → Format D) Review → View
    Answer: A) Chart Elements → Trendline

  72. A secondary axis is used when:
    A) Two data series have different scales B) Multiple sheets exist C) Chart is hidden D) File is encrypted
    Answer: A) Two data series have different scales

  73. To create a chart from data instantly:
    A) Press F11 B) Press Ctrl + C C) Press F2 D) Press Ctrl + Enter
    Answer: A) Press F11

  74. Chart Title can be linked to a cell using:
    A) Formula Bar = reference B) Chart Options C) Data Tools D) Home Tab
    Answer: A) Formula Bar = reference

  75. The Data Labels option shows:
    A) Values on the chart B) Axis titles C) Sheet name D) Cell addresses
    Answer: A) Values on the chart

  76. To create a PivotChart, you must first:
    A) Create a PivotTable B) Insert chart C) Use SUM D) Record macro
    Answer: A) Create a PivotTable

  77. PivotCharts update automatically when:
    A) PivotTable data changes B) Sheet is opened C) File saves D) Filter is applied
    Answer: A) PivotTable data changes

  78. Slicers can be used for:
    A) Filtering PivotTables and PivotCharts B) Creating formulas C) Printing D) Formatting cells
    Answer: A) Filtering PivotTables and PivotCharts

  79. The Timeline control in PivotTables filters:
    A) Date fields B) Text C) Numbers D) All fields
    Answer: A) Date fields

  80. You can create a PivotTable from:
    A) Table, range, or external data source B) Only table C) Only chart D) Only CSV
    Answer: A) Table, range, or external data source

  81. To refresh all PivotTables:
    A) Data → Refresh All B) View → Refresh C) File → Save D) Home → Refresh
    Answer: A) Data → Refresh All

  82. Grouping in PivotTable can be done for:
    A) Dates, numbers, or text B) Only text C) Only numbers D) Only dates
    Answer: A) Dates, numbers, or text

  83. In PivotTable, “Values Field Settings” allows:
    A) Changing calculation type (Sum, Average, etc.) B) Formatting C) Filters D) Color themes
    Answer: A) Changing calculation type (Sum, Average, etc.)

  84. GETPIVOTDATA() function extracts:
    A) Data from a PivotTable B) Chart info C) Text cells D) Filter values
    Answer: A) Data from a PivotTable

  85. The PivotTable option “Show Values As” allows:
    A) Percentage or difference view B) Raw data C) Sorting D) Formatting
    Answer: A) Percentage or difference view

 

  1. A calculated field in a PivotTable is:
    A) A new field created using existing PivotTable data B) An imported field C) A linked cell D) A filtered field
    Answer: A) A new field created using existing PivotTable data

  2. To clear all filters in a PivotTable:
    A) PivotTable → Clear Filters B) Data → Remove Filter C) Home → Clear D) File → Reset
    Answer: A) PivotTable → Clear Filters

  3. PivotTable Field List allows you to:
    A) Drag fields into Rows, Columns, Values, or Filters B) Change sheet view C) Lock data D) Save file
    Answer: A) Drag fields into Rows, Columns, Values, or Filters

  4. To add multiple tables into one PivotTable, you must use:
    A) Data Model B) Power Query C) Flash Fill D) Solver
    Answer: A) Data Model

  5. A PivotTable can summarize data using functions like:
    A) SUM, AVERAGE, COUNT, MAX, MIN B) ADD, SUBTRACT C) MULTIPLY, DIVIDE D) MERGE, CONCAT
    Answer: A) SUM, AVERAGE, COUNT, MAX, MIN

  6. A macro in Excel is:
    A) A recorded sequence of actions B) A formula C) A chart D) A function
    Answer: A) A recorded sequence of actions

  7. Macros are written in:
    A) VBA (Visual Basic for Applications) B) SQL C) HTML D) JavaScript
    Answer: A) VBA (Visual Basic for Applications)

  8. The shortcut to open the VBA editor:
    A) Alt + F11 B) Alt + F8 C) Ctrl + F10 D) Ctrl + Shift + M
    Answer: A) Alt + F11

  9. To record a macro:
    A) View → Macros → Record Macro B) Home → Format C) File → Save As D) Data → Validation
    Answer: A) View → Macros → Record Macro

  10. The file extension for macro-enabled workbooks is:
    A) .xlsm B) .xlsx C) .csv D) .xltx
    Answer: A) .xlsm

  11. To run a macro quickly, you can assign:
    A) A keyboard shortcut B) A color C) A name only D) A password
    Answer: A) A keyboard shortcut

  12. To view all macros in a workbook:
    A) View → Macros → View Macros B) Data → Tools C) Insert → Macro D) File → Info
    Answer: A) View → Macros → View Macros

  13. VBA code is stored in:
    A) Modules B) Sheets C) Tables D) Charts
    Answer: A) Modules

  14. To protect your macro code from editing:
    A) Use VBA Project Password Protection B) Hide sheet C) Lock cell D) Protect workbook
    Answer: A) Use VBA Project Password Protection

  15. To enable macros when opening a workbook:
    A) Click “Enable Content” in the Security Warning bar B) Use Data → Refresh C) Use Ctrl + M D) Save file again
    Answer: A) Click “Enable Content” in the Security Warning bar

Leave a Comment

Your email address will not be published. Required fields are marked *

You cannot copy content of this page

Scroll to Top