BeInCareer › Free Certification Courses › Advanced Excel › 150 Q&A Prep
Advanced Excel · Certification & Interview Prep
150 Advanced Excel Questions & Answers — Free Practice Set
Practice the exact topics tested in the BeInCareer Advanced MS Excel certification — formulas, VLOOKUP, pivot tables, charts, data analysis, shortcuts & macros. Perfect for the test and for Excel interviews.
📊 150 QuestionsWith Answers14 Topics100% Free
💡 How to use this: Read each question, try to answer it yourself, then check the ✓ answer below it. Once you can answer most of these confidently, you’re ready to take the free certification test. Questions are grouped by topic so you can revise weak areas.
Topics Covered
1. Excel Basics & Interface2. Formulas & Cell References3. Math & Statistical Functions4. Logical Functions5. Lookup & Reference (VLOOKUP / XLOOKUP)6. Text Functions7. Date & Time Functions8. Conditional Formatting & Data Validation9. Sorting, Filtering & Tables10. Pivot Tables & Slicers11. Charts & Data Visualization12. Data Analysis (SUMIF, COUNTIF & More)13. Shortcuts & Productivity14. Macros & VBA Basics
Excel Basics & Interface
1What is the file extension of a standard Excel workbook (2007 onwards)?
a) .doc
b) .xls
c) .xlsx
d) .csv
✓ Answer: C) .xlsx
2Which extension is used for an Excel file that contains macros?
a) .xlsx
b) .xlsm
c) .xlsb
d) .xltx
✓ Answer: B) .xlsm — Macro-enabled workbooks use .xlsm.
3What is the intersection of a row and a column called?
a) Range
b) Cell
c) Sheet
d) Table
✓ Answer: B) Cell
4Which is a valid cell address?
a) 12A
b) A-12
c) A12
d) 12
✓ Answer: C) A12
5By default, how many worksheets does a new Excel workbook open with (modern Excel)?
a) 1
b) 3
c) 5
d) 16
✓ Answer: A) 1 — Recent versions open with 1 sheet by default.
6The box that shows the address of the active cell is called the:
a) Formula bar
b) Name box
c) Status bar
d) Ribbon
✓ Answer: B) Name box
7Which key combination moves you to cell A1 quickly?
a) Ctrl+A
b) Ctrl+Home
c) Ctrl+End
d) Home
✓ Answer: B) Ctrl+Home
8What does the fill handle do?
a) Deletes cells
b) Copies/continues a series by dragging
c) Merges cells
d) Freezes rows
✓ Answer: B) Copies/continues a series by dragging
9Which feature keeps rows/columns visible while scrolling?
a) Merge Cells
b) Freeze Panes
c) Wrap Text
d) Group
✓ Answer: B) Freeze Panes
10A workbook is a collection of:
a) Cells
b) Rows
c) Worksheets
d) Charts
✓ Answer: C) Worksheets
11Which tab contains PivotTable, Chart and Table commands?
a) Home
b) Insert
c) Data
d) Review
✓ Answer: B) Insert
12What is the maximum number of columns in a modern Excel worksheet?
a) 256
b) 1,024
c) 16,384
d) 65,536
✓ Answer: C) 16,384 — 16,384 columns (A to XFD).
Formulas & Cell References
13Every Excel formula must begin with which symbol?
a) +
b) =
c) @
d) #
✓ Answer: B) =
14In the reference $A$1, what does it represent?
a) Relative
b) Mixed
c) Absolute
d) Circular
✓ Answer: C) Absolute
15A1 (no dollar signs) is a __ reference.
a) Absolute
b) Relative
c) Mixed
d) 3-D
✓ Answer: B) Relative
16Which reference locks the column but not the row?
a) A$1
b) $A1
c) $A$1
d) A1
✓ Answer: B) $A1
17Which key toggles between absolute and relative references while editing?
a) F2
b) F4
c) F9
d) F5
✓ Answer: B) F4
18What does =B2+C2 do?
a) Concatenates B2 and C2
b) Adds B2 and C2
c) Compares them
d) Errors
✓ Answer: B) Adds B2 and C2
19A reference to another sheet uses which separator?
a) Comma
b) Exclamation mark (!)
c) Colon
d) Semicolon
✓ Answer: B) Exclamation mark (!) — e.g. Sheet2!A1
20The colon in A1:A10 represents a:
a) Single cell
b) Range of cells
c) Division
d) Named cell
✓ Answer: B) Range of cells
21What error appears when a formula divides by zero?
a) #NAME?
b) #VALUE!
c) #DIV/0!
d) #REF!
✓ Answer: C) #DIV/0!
22Which error means a cell reference is no longer valid (e.g., deleted)?
a) #REF!
b) #N/A
c) #NULL!
d) #NUM!
✓ Answer: A) #REF!
23What does the #NAME? error usually indicate?
a) Wrong data type
b) Unrecognised text/function name
c) Divide by zero
d) Invalid range
✓ Answer: B) Unrecognised text/function name
24Which is calculated first in =2+3*4?
a) 2+3
b) 3*4
c) Left to right
d) 4-2
✓ Answer: B) 3*4 — Answer is 14 (multiplication first).
Math & Statistical Functions
25Which function adds a range of numbers?
a) COUNT
b) SUM
c) TOTAL
d) ADD
✓ Answer: B) SUM
26=AVERAGE(A1:A10) returns the:
a) Total
b) Count
c) Mean
d) Median
✓ Answer: C) Mean
27Which function counts only cells containing numbers?
a) COUNTA
b) COUNT
c) COUNTBLANK
d) COUNTIF
✓ Answer: B) COUNT
28COUNTA counts:
a) Only numbers
b) Only blanks
c) All non-empty cells
d) Only text
✓ Answer: C) All non-empty cells
29Which returns the largest value in a range?
a) MIN
b) LARGE
c) MAX
d) BIG
✓ Answer: C) MAX
30=MIN(A1:A5) returns the:
a) Smallest value
b) Largest value
c) Average
d) Count
✓ Answer: A) Smallest value
31Which function rounds a number to a set number of digits?
a) TRUNC
b) ROUND
c) INT
d) MOD
✓ Answer: B) ROUND
32=MOD(10,3) returns:
a) 3
b) 1
c) 0
d) 10
✓ Answer: B) 1 — MOD returns the remainder.
33Which returns the 3rd largest value in a range?
a) MAX(range)
b) LARGE(range,3)
c) SMALL(range,3)
d) RANK(3)
✓ Answer: B) LARGE(range,3)
34Which function returns the integer part of a number (rounds down)?
a) ROUND
b) INT
c) ABS
d) SQRT
✓ Answer: B) INT
35=SUMPRODUCT(A1:A3,B1:B3) does what?
a) Sums A only
b) Multiplies arrays then sums the products
c) Divides arrays
d) Counts cells
✓ Answer: B) Multiplies arrays then sums the products
36Which returns the median of a range?
a) AVERAGE
b) MODE
c) MEDIAN
d) MID
✓ Answer: C) MEDIAN
Logical Functions
37Which function returns one value if TRUE and another if FALSE?
a) AND
b) IF
c) OR
d) NOT
✓ Answer: B) IF
38=IF(A1>50,"Pass","Fail") returns "Pass" when:
a) A1 is 50
b) A1 is greater than 50
c) A1 is less than 50
d) Always
✓ Answer: B) A1 is greater than 50
39AND returns TRUE only when:
a) Any condition is true
b) All conditions are true
c) No condition is true
d) One is false
✓ Answer: B) All conditions are true
40OR returns TRUE when:
a) All are false
b) At least one is true
c) All are true only
d) None
✓ Answer: B) At least one is true
41Which function catches errors and returns a custom value?
a) ISERROR
b) IFERROR
c) IFNA
d) ERROR
✓ Answer: B) IFERROR
42=IFERROR(A1/B1,0) returns 0 when:
a) A1 is 0
b) The division causes an error
c) B1>0
d) Never
✓ Answer: B) The division causes an error
43Placing an IF inside another IF is called:
a) Chained IF
b) Nested IF
c) Double IF
d) Array IF
✓ Answer: B) Nested IF
44Which newer function replaces many nested IFs with cleaner logic?
a) LOOKUP
b) IFS
c) CHOOSE
d) SWITCH
✓ Answer: B) IFS
45=NOT(TRUE) returns:
a) TRUE
b) FALSE
c) 1
d) Error
✓ Answer: B) FALSE
46Which function tests a value against a list and returns a matching result?
a) IF
b) SWITCH
c) AND
d) OR
✓ Answer: B) SWITCH
47=IF(AND(A1>0,B1>0),"Yes","No") returns "Yes" when:
a) Either is positive
b) Both are positive
c) Both are zero
d) A1 is negative
✓ Answer: B) Both are positive
48=IFNA(x,"-") shows "-" specifically for which error?
a) #DIV/0!
b) #N/A
c) #VALUE!
d) All errors
✓ Answer: B) #N/A
Lookup & Reference (VLOOKUP / XLOOKUP)
49VLOOKUP searches for a value in the __ column of a table.
a) Last
b) First (leftmost)
c) Any
d) Second
✓ Answer: B) First (leftmost)
50What does the 'V' in VLOOKUP stand for?
a) Value
b) Vertical
c) Variable
d) View
✓ Answer: B) Vertical
51In VLOOKUP, for an exact match the last argument should be:
a) TRUE
b) FALSE
c) 1
d) blank
✓ Answer: B) FALSE — FALSE (or 0) = exact match.
52VLOOKUP cannot look to the __ of the lookup column.
a) Right
b) Left
c) Below
d) Above
✓ Answer: B) Left — It only looks right; use INDEX/MATCH or XLOOKUP to look left.
53Which function looks up values horizontally across a row?
a) VLOOKUP
b) HLOOKUP
c) XLOOKUP
d) MATCH
✓ Answer: B) HLOOKUP
54XLOOKUP improves on VLOOKUP because it can:
a) Only look right
b) Look in any direction (left/right)
c) Not do exact match
d) Only use numbers
✓ Answer: B) Look in any direction (left/right)
55=VLOOKUP(A2,D:F,3,FALSE) returns the value from which column of D:F?
a) D
b) E
c) F
d) A
✓ Answer: C) F — Column index 3 = the 3rd column (F).
56Which combination is a flexible alternative to VLOOKUP?
a) SUM+IF
b) INDEX+MATCH
c) IF+AND
d) LEFT+RIGHT
✓ Answer: B) INDEX+MATCH
57MATCH returns the __ of a value within a range.
a) Value
b) Position/index
c) Sum
d) Average
✓ Answer: B) Position/index
58INDEX returns:
a) A position
b) The value at a given row/column position
c) A count
d) TRUE/FALSE
✓ Answer: B) The value at a given row/column position
59Which error does VLOOKUP return when the value isn't found?
a) #REF!
b) #N/A
c) #NAME?
d) #DIV/0!
✓ Answer: B) #N/A
60XLOOKUP's 'if not found' argument lets you:
a) Return a custom message instead of #N/A
b) Sort data
c) Change the format
d) Merge cells
✓ Answer: A) Return a custom message instead of #N/A
61To do an approximate match in VLOOKUP, the table's first column should be:
a) Random
b) Sorted ascending
c) Sorted descending
d) Text only
✓ Answer: B) Sorted ascending
Text Functions
62Which function joins text from multiple cells?
a) JOIN
b) CONCAT (or CONCATENATE)
c) MERGE
d) ADD
✓ Answer: B) CONCAT (or CONCATENATE)
63=LEFT("Excel",2) returns:
a) "Ex"
b) "el"
c) "xc"
d) "Exc"
✓ Answer: A) "Ex"
64=RIGHT("Career",3) returns:
a) "Car"
b) "eer"
c) "are"
d) "Career"
✓ Answer: B) "eer"
65=MID("BeInCareer",3,2) returns:
a) "eI"
b) "In"
c) "nC"
d) "Be"
✓ Answer: B) "In" — Starts at char 3, length 2.
66Which function removes extra spaces from text?
a) CLEAN
b) TRIM
c) CUT
d) SPACE
✓ Answer: B) TRIM
67=LEN("Data") returns:
a) 3
b) 4
c) 5
d) 1
✓ Answer: B) 4
68=UPPER("excel") returns:
a) "excel"
b) "Excel"
c) "EXCEL"
d) Error
✓ Answer: C) "EXCEL"
69Which function converts text to lowercase?
a) LOWER
b) SMALL
c) PROPER
d) DOWN
✓ Answer: A) LOWER
70=PROPER("john doe") returns:
a) "JOHN DOE"
b) "John Doe"
c) "john doe"
d) Error
✓ Answer: B) "John Doe"
71Which function replaces old text with new text at a position?
a) SUBSTITUTE
b) REPLACE
c) FIND
d) SWAP
✓ Answer: B) REPLACE — REPLACE works by position; SUBSTITUTE by matching text.
72=TEXT(0.25,"0%") returns:
a) 0.25
b) "25%"
c) "0.25%"
d) Error
✓ Answer: B) "25%"
73Which function finds the position of one text string within another?
a) SEARCH/FIND
b) LEN
c) MID
d) TRIM
✓ Answer: A) SEARCH/FIND
Date & Time Functions
74Which function returns the current date only?
a) NOW()
b) TODAY()
c) DATE()
d) TIME()
✓ Answer: B) TODAY()
75=NOW() returns:
a) Current date only
b) Current time only
c) Current date and time
d) Yesterday
✓ Answer: C) Current date and time
76Which extracts the year from a date?
a) DAY
b) MONTH
c) YEAR
d) DATE
✓ Answer: C) YEAR
77=DATEDIF is used to calculate the difference between two dates in:
a) Only days
b) Years/months/days
c) Only months
d) Hours
✓ Answer: B) Years/months/days
78Excel stores dates internally as:
a) Text
b) Serial numbers
c) Images
d) Formulas
✓ Answer: B) Serial numbers
79Which returns the day of the week as a number?
a) DAY
b) WEEKDAY
c) WEEKNUM
d) DAYS
✓ Answer: B) WEEKDAY
80=EOMONTH(date,0) returns the:
a) Start of month
b) End of the current month
c) Next month
d) Today
✓ Answer: B) End of the current month
81Which function adds a number of workdays to a date (skipping weekends)?
a) WORKDAY
b) NETWORKDAYS
c) EDATE
d) DAYS
✓ Answer: A) WORKDAY
82Which builds a date from year, month, day values?
a) DATEVALUE
b) DATE
c) DAY
d) TODAY
✓ Answer: B) DATE
83NETWORKDAYS returns the number of __ between two dates.
a) Total days
b) Working days
c) Weekends
d) Holidays
✓ Answer: B) Working days
Conditional Formatting & Data Validation
84Conditional Formatting is used to:
a) Lock cells
b) Format cells based on their values/rules
c) Sort data
d) Insert charts
✓ Answer: B) Format cells based on their values/rules
85Data bars, colour scales and icon sets are types of:
a) Charts
b) Conditional formatting
c) Pivot tables
d) Filters
✓ Answer: B) Conditional formatting
86Data Validation is mainly used to:
a) Restrict what can be entered in a cell
b) Delete data
c) Merge cells
d) Freeze panes
✓ Answer: A) Restrict what can be entered in a cell
87Which validation type creates a dropdown list?
a) Whole number
b) List
c) Date
d) Text length
✓ Answer: B) List
88To highlight duplicate values you would use:
a) Sort
b) Conditional Formatting
c) Filter
d) Freeze Panes
✓ Answer: B) Conditional Formatting
89Which lets you write your own condition for formatting?
a) 'Use a formula to determine which cells to format'
b) Sort A-Z
c) Wrap text
d) Merge
✓ Answer: A) 'Use a formula to determine which cells to format'
90Conditional formatting rules are managed in the:
a) Name Manager
b) Rules Manager
c) Pivot cache
d) Macro recorder
✓ Answer: B) Rules Manager
91An input message in Data Validation is used to:
a) Block entry
b) Show a helpful tip when the cell is selected
c) Delete data
d) Format text
✓ Answer: B) Show a helpful tip when the cell is selected
92Which Data Validation option limits entries to a number range?
a) List
b) Whole number / Decimal
c) Custom
d) Any value
✓ Answer: B) Whole number / Decimal
93To remove all conditional formatting from a sheet you use:
a) Clear Rules
b) Undo only
c) Delete sheet
d) Freeze panes
✓ Answer: A) Clear Rules
Sorting, Filtering & Tables
94The AutoFilter feature lets you:
a) Delete rows
b) Show only rows meeting criteria
c) Merge cells
d) Add charts
✓ Answer: B) Show only rows meeting criteria
95Sorting A-Z arranges text in __ order.
a) Descending
b) Ascending
c) Random
d) Reverse
✓ Answer: B) Ascending
96Converting a range to a Table gives you:
a) Structured references and auto-filters
b) A chart
c) A macro
d) A pivot cache
✓ Answer: A) Structured references and auto-filters
97Which shortcut applies/removes AutoFilter?
a) Ctrl+T
b) Ctrl+Shift+L
c) Ctrl+F
d) Ctrl+L
✓ Answer: B) Ctrl+Shift+L
98Ctrl+T is used to:
a) Create a Table
b) Open a chart
c) Insert time
d) Sort data
✓ Answer: A) Create a Table
99Remove Duplicates is found on which tab?
a) Home
b) Insert
c) Data
d) View
✓ Answer: C) Data
100Advanced Filter can:
a) Copy filtered results to another location
b) Only hide rows
c) Delete columns
d) Create pivots
✓ Answer: A) Copy filtered results to another location
101A Table's total row can quickly show:
a) SUM, AVERAGE, COUNT etc.
b) Only text
c) Charts
d) Macros
✓ Answer: A) SUM, AVERAGE, COUNT etc.
102Sorting by cell colour is possible in Excel.
a) True
b) False
c) Only for numbers
d) Only in tables
✓ Answer: A) True
103Freeze Top Row is useful when you want to:
a) Delete headers
b) Keep the header visible while scrolling
c) Sort data
d) Filter
✓ Answer: B) Keep the header visible while scrolling
Pivot Tables & Slicers
104A PivotTable is used to:
a) Summarise and analyse large data quickly
b) Draw shapes
c) Write macros
d) Format text
✓ Answer: A) Summarise and analyse large data quickly
105The four areas of a PivotTable are Filters, Columns, Rows and:
a) Charts
b) Values
c) Slicers
d) Fields
✓ Answer: B) Values
106To count/sum data in a PivotTable you drag a field to:
a) Rows
b) Filters
c) Values
d) Columns
✓ Answer: C) Values
107A Slicer is used to:
a) Visually filter a PivotTable
b) Sort text
c) Insert charts
d) Merge cells
✓ Answer: A) Visually filter a PivotTable
108A Timeline slicer filters data by:
a) Text
b) Numbers
c) Dates
d) Colour
✓ Answer: C) Dates
109After changing source data, you should __ the PivotTable.
a) Delete
b) Refresh
c) Sort
d) Merge
✓ Answer: B) Refresh
110Which shows values as a % of the grand total?
a) Show Values As
b) Sort
c) Group
d) Filter
✓ Answer: A) Show Values As
111Grouping in a PivotTable lets you combine dates into:
a) Charts
b) Months/Quarters/Years
c) Macros
d) Colours
✓ Answer: B) Months/Quarters/Years
112A PivotChart is:
a) A chart built from a PivotTable
b) A macro
c) A slicer
d) A filter
✓ Answer: A) A chart built from a PivotTable
113The Values area defaults to __ for numeric fields.
a) Count
b) Sum
c) Average
d) Max
✓ Answer: B) Sum
114Calculated Fields in a PivotTable let you:
a) Create new formulas from existing fields
b) Delete data
c) Add charts
d) Sort
✓ Answer: A) Create new formulas from existing fields
115One slicer can control __ PivotTables (report connections).
a) Only one
b) Multiple
c) None
d) Only charts
✓ Answer: B) Multiple
116To remove the grand total row you use:
a) PivotTable Design options
b) Data validation
c) Freeze panes
d) Filter
✓ Answer: A) PivotTable Design options
Charts & Data Visualization
117Which chart is best to show a trend over time?
a) Pie
b) Line
c) Doughnut
d) Radar
✓ Answer: B) Line
118A pie chart is best used to show:
a) Trends
b) Parts of a whole
c) Correlation
d) Distribution over time
✓ Answer: B) Parts of a whole
119Which chart compares values across categories with bars?
a) Line
b) Column/Bar
c) Scatter
d) Area
✓ Answer: B) Column/Bar
120A scatter (XY) chart is best for showing:
a) Relationship between two numeric variables
b) Parts of a whole
c) A single value
d) Text
✓ Answer: A) Relationship between two numeric variables
121A small chart inside a single cell is called a:
a) Slicer
b) Sparkline
c) Thumbnail
d) Icon
✓ Answer: B) Sparkline
122Chart labels that show the exact value on each point are called:
a) Legends
b) Data labels
c) Axes
d) Gridlines
✓ Answer: B) Data labels
123The key that explains chart colours/series is the:
a) Axis
b) Legend
c) Title
d) Label
✓ Answer: B) Legend
124A combo chart lets you:
a) Combine two chart types (e.g., column + line)
b) Merge cells
c) Add slicers
d) Sort
✓ Answer: A) Combine two chart types (e.g., column + line)
125Which chart is good for showing cumulative totals filled under a line?
a) Area chart
b) Pie
c) Scatter
d) Radar
✓ Answer: A) Area chart
126To quickly recommend a chart for your data, use:
a) Recommended Charts
b) Macro recorder
c) Data validation
d) Freeze panes
✓ Answer: A) Recommended Charts
Data Analysis (SUMIF, COUNTIF & More)
127=SUMIF(A:A,">100") sums values that are:
a) Less than 100
b) Greater than 100
c) Equal to 100
d) All
✓ Answer: B) Greater than 100
128COUNTIF counts cells that:
a) Meet one condition
b) Are blank only
c) Contain numbers only
d) Are coloured
✓ Answer: A) Meet one condition
129Which sums with multiple conditions?
a) SUMIF
b) SUMIFS
c) SUM
d) SUMPRODUCT only
✓ Answer: B) SUMIFS
130=AVERAGEIF(range,">0") averages values that are:
a) Negative
b) Zero
c) Greater than 0
d) All
✓ Answer: C) Greater than 0
131Goal Seek is used to:
a) Find the input needed to reach a target result
b) Sort data
c) Build charts
d) Filter
✓ Answer: A) Find the input needed to reach a target result
132Power Query is mainly used to:
a) Import, clean and transform data
b) Write macros
c) Draw shapes
d) Print
✓ Answer: A) Import, clean and transform data
133A What-If 'Data Table' lets you:
a) See results for different input values
b) Delete data
c) Merge cells
d) Add slicers
✓ Answer: A) See results for different input values
134=COUNTIFS lets you count with:
a) One condition
b) Multiple conditions
c) No conditions
d) Only text
✓ Answer: B) Multiple conditions
Shortcuts & Productivity
135Ctrl+C is used to:
a) Cut
b) Copy
c) Paste
d) Clear
✓ Answer: B) Copy
136Which shortcut pastes?
a) Ctrl+V
b) Ctrl+X
c) Ctrl+P
d) Ctrl+B
✓ Answer: A) Ctrl+V
137Ctrl+Z is used to:
a) Redo
b) Undo
c) Save
d) Zoom
✓ Answer: B) Undo
138Which shortcut saves a workbook?
a) Ctrl+S
b) Ctrl+O
c) Ctrl+N
d) Ctrl+W
✓ Answer: A) Ctrl+S
139Ctrl+Shift+L toggles:
a) Bold
b) Filters
c) Underline
d) Gridlines
✓ Answer: B) Filters
140F2 is used to:
a) Edit the active cell
b) Save
c) Open a file
d) Insert chart
✓ Answer: A) Edit the active cell
141Alt+= inserts:
a) A chart
b) The SUM function (AutoSum)
c) A pivot table
d) Today's date
✓ Answer: B) The SUM function (AutoSum)
142Ctrl+; (semicolon) inserts:
a) Current time
b) Current date
c) A formula
d) A comment
✓ Answer: B) Current date
143Ctrl+Arrow key jumps to:
a) The next sheet
b) The edge of the data region
c) Cell A1
d) The last cell
✓ Answer: B) The edge of the data region
144Which shortcut opens Find & Replace (Replace tab)?
a) Ctrl+F
b) Ctrl+H
c) Ctrl+G
d) Ctrl+R
✓ Answer: B) Ctrl+H
Macros & VBA Basics
145A macro is used to:
a) Automate repetitive tasks
b) Format one cell
c) Draw charts only
d) Print
✓ Answer: A) Automate repetitive tasks
146Macros are written in which language?
a) Python
b) VBA
c) Java
d) SQL
✓ Answer: B) VBA
147VBA stands for:
a) Visual Basic for Applications
b) Very Basic Automation
c) Visual Bar Analysis
d) Value Based Array
✓ Answer: A) Visual Basic for Applications
148To record a macro without coding you use the:
a) Macro Recorder
b) Formula bar
c) Name box
d) Pivot cache
✓ Answer: A) Macro Recorder
149Which shortcut opens the VBA editor?
a) Alt+F11
b) Ctrl+F11
c) F5
d) Alt+F8
✓ Answer: A) Alt+F11
150To run macros, the workbook should be saved as:
a) .xlsx
b) .xlsm
c) .csv
d) .pdf
✓ Answer: B) .xlsm
Ready? Take the Free Advanced Excel Test
Pass the online test and get your free, verifiable Advanced MS Excel certificate.
🚀 Start the Free Test →© BeInCareer 2026 · 150 Advanced Excel Questions & Answers · beincareer.com