1. What is the file extension for an Excel workbook?
A) .xls
B) .xlx
C) .xlsx
D) .excel
Answer: C
2.
How are rows labeled in Excel?
A) Letters (A, B, C)
B) Numbers (1, 2, 3)
C) Symbols (#, $, %)
D) Roman numerals
Answer: B
3.
Which shortcut selects the entire worksheet?
A) Ctrl + A
B) Ctrl + S
C) Ctrl + W
D) Alt + F4
Answer: A
4.
What does the "Merge & Center"
button do?
A) Adds cells
B) Combines cells into one and centers text
C) Deletes cells
D) Splits cells
Answer: B
5.
Which tab contains the "Print"
command?
A) Home
B) Insert
C) Page Layout
D) File
Answer: D
6.
What is the maximum number of rows in a
modern Excel worksheet?
A) 65,536
B) 1,048,576
C) 16,384
D) 10,000
Answer: B
7.
To enter data into a cell, you can:
A) Type directly
B) Use the formula bar
C) Copy-paste
D) All of the above
Answer: D
8.
The intersection of a row and column is
called a:
A) Box
B) Cell
C) Table
D) Range
Answer: B
9.
What does the "AutoFill" handle
(small square at the bottom-right of a cell) do?
A) Deletes data
B) Copies data or extends a series
C) Merges cells
D) Changes font size
Answer: B
10.
Which key is used to edit the active cell?
A) F2
B) F1
C) F5
D) F12
Answer: A
11.
Which formula calculates the sum of cells A1
to A5?
A) =SUM(A1:A5)
B) =ADD(A1:A5)
C) =TOTAL(A1:A5)
D) =A1+A5
Answer: A
12.
What does the AVERAGE function do?
A) Adds numbers
B) Finds the middle value
C) Calculates the mean
D) Counts cells
Answer: C
13.
Which symbol starts every Excel formula?
A) =
B) +
C) #
D) $
Answer: A
14.
What does $A$1 represent?
A) Relative reference
B) Absolute reference
C) Mixed reference
D) Invalid reference
Answer: B
15.
Which function returns the current date?
A) =NOW()
B) =DATE()
C) =TODAY()
D) =CURRENT()
Answer: C
16.
The IF function requires how many
arguments?
A) 1
B) 2
C) 3
D) 4
Answer: C
17.
What does VLOOKUP do?
A) Searches vertically for a value
B) Searches horizontally for a value
C) Counts cells
D) Merges tables
Answer: A
18.
Which function concatenates text from
multiple cells?
A) =JOIN()
B) =COMBINE()
C) =CONCAT()
D) &
Answer: C or D (Both are correct in newer Excel versions.)
19.
What is the result of =SUM(5, 3, 2)?
A) 10
B) 8
C) 15
D) 5
Answer: A
20.
Which function checks if a condition is met
and returns one value if true and another if false?
A) AND()
B) OR()
C) IF()
D) CHOOSE()
Answer: C
21.
What does the "Sort A to Z" button
do?
A) Deletes duplicates
B) Arranges data in ascending order
C) Hides rows
D) Filters data
Answer: B
22.
Which tool removes duplicate values?
A) Data Validation
B) Remove Duplicates
C) Advanced Filter
D) Consolidate
Answer: B
23.
The "Text to Columns" feature is
used to:
A) Split text into multiple columns
B) Merge columns
C) Change font style
D) Insert shapes
Answer: A
24.
What does "Freeze Panes" do?
A) Locks rows/columns while scrolling
B) Deletes rows
C) Adds borders
D) Prints headers
Answer: A
25.
Which feature predicts and auto-completes
data entry?
A) Flash Fill
B) Quick Analysis
C) AutoSum
D) Goal Seek
Answer: A
26.
What is the purpose of "Data
Validation"?
A) Restrict data entry to specific criteria
B) Delete invalid data
C) Format cells
D) Encrypt data
Answer: A
27.
Which tool performs "What-If
Analysis"?
A) Goal Seek
B) PivotTable
C) Conditional Formatting
D) Sparklines
Answer: A
28.
The "Subtotal" command is found
under which tab?
A) Home
B) Data
C) Formulas
D) Insert
Answer: B
29.
Which shortcut opens the "Format
Cells" dialog?
A) Ctrl + 1
B) Ctrl + B
C) Alt + F1
D) F12
Answer: A
30.
Which feature groups rows or columns?
A) Group/Ungroup
B) Hide
C) Split
D) Merge
Answer: A
31.
Which chart type is best for trends over
time?
A) Pie Chart
B) Line Chart
C) Bar Chart
D) Scatter Plot
Answer: B
32.
What does a PivotChart summarize?
A) Formulas
B) Data from a PivotTable
C) Macros
D) Conditional formatting
Answer: B
33.
The vertical axis in a chart is called the:
A) X-axis
B) Y-axis
C) Z-axis
D) Category axis
Answer: B
34.
Which chart type shows parts of a whole?
A) Line Chart
B) Pie Chart
C) Bar Chart
D) Histogram
Answer: B
35.
To add a chart title, go to:
A) Chart Design > Add Chart Element
B) Page Layout > Themes
C) Data > Sort
D) Formulas > Name Manager
Answer: A
36.
What is a PivotTable used for?
A) Writing formulas
B) Summarizing and analyzing data
C) Drawing charts
D) Protecting sheets
Answer: B
37.
Which field is used to add categories to rows
or columns in a PivotTable?
A) Values
B) Filters
C) Rows/Columns
D) Slicers
Answer: C
38.
To update a PivotTable after source data
changes, use:
A) Refresh
B) Rebuild
C) Delete
D) Sort
Answer: A
39.
What does Ctrl + C do?
A) Copy
B) Cut
C) Paste
D) Close
Answer: A
40.
Which shortcut opens the "Save As"
dialog?
A) Ctrl + S
B) F12
C) Ctrl + P
D) Alt + F4
Answer: B
41.
To protect a worksheet, go to:
A) Review > Protect Sheet
B) Data > Protect Workbook
C) Home > Format
D) File > Info
Answer: A
42.
What does a macro do?
A) Automates repetitive tasks
B) Inserts formulas
C) Creates charts
D) Sorts data
Answer: A
43.
To change Excel’s default settings, use:
A) File > Options
B) Home > Styles
C) Insert > Table
D) Data > Queries
Answer: A
44.
A #DIV/0! error indicates:
A) Division by zero
B) Invalid cell reference
C) Missing function
D) Text in a formula
Answer: A
45.
What does the COUNTIF function do?
A) Counts cells based on a condition
B) Adds numbers
C) Finds the average
D) Concatenates text
Answer: A
46.
Which function returns the largest value in a
range?
A) MAX()
B) MIN()
C) LARGE()
D) SUM()
Answer: A
47.
What does the ROUND function do?
A) Rounds a number to a specified number of digits
B) Adds numbers
C) Multiplies numbers
D) Counts cells
Answer: A
48.
Which function checks if all conditions are
true?
A) AND()
B) OR()
C) IF()
D) NOT()
Answer: A
49.
What does the LEN function return?
A) The number of characters in a text string
B) The length of a cell
C) The sum of numbers
D) The average of numbers
Answer: A
50.
Which function extracts a substring from a
text string?
A) MID()
B) LEFT()
C) RIGHT()
D) All of the above
Answer: D
51.
What is the purpose of the "Goal
Seek" tool?
A) To find the input needed to achieve a specific result
B) To create charts
C) To sort data
D) To filter data
Answer: A
52.
Which tool is used to create scenarios for
"What-If Analysis"?
A) Scenario Manager
B) Solver
C) Data Table
D) Goal Seek
Answer: A
53.
What does the "Solver" tool do?
A) Finds optimal solutions for problems with constraints
B) Creates PivotTables
C) Filters data
D) Sorts data
Answer: A
54.
Which feature is used to highlight cells that
meet specific criteria?
A) Conditional Formatting
B) Data Validation
C) Filter
D) Sort
Answer: A
55.
What does the "Quick Analysis" tool
do?
A) Provides instant data analysis options
B) Deletes data
C) Inserts charts
D) Sorts data
Answer: A
56.
Which field in a PivotTable is used to
perform calculations?
A) Values
B) Rows
C) Columns
D) Filters
Answer: A
57.
What is a slicer in a PivotTable?
A) A visual filter
B) A calculation tool
C) A chart type
D) A formula
Answer: A
58.
Which option allows you to group dates in a
PivotTable?
A) Group Field
B) Ungroup Field
C) Sort
D) Filter
Answer: A
59.
What does the "Refresh" option do
in a PivotTable?
A) Updates the PivotTable with new data
B) Deletes the PivotTable
C) Sorts the PivotTable
D) Filters the PivotTable
Answer: A
60.
Which tab is used to create a PivotTable?
A) Insert
B) Home
C) Data
D) Formulas
Answer: A
61.
Which chart type is best for comparing parts
of a whole?
A) Pie Chart
B) Line Chart
C) Bar Chart
D) Scatter Plot
Answer: A
62.
What does a combo chart combine?
A) Two or more chart types
B) Two or more PivotTables
C) Two or more worksheets
D) Two or more formulas
Answer: A
63.
Which chart element displays data values on
top of bars or columns?
A) Data Labels
B) Legend
C) Axis Titles
D) Gridlines
Answer: A
64.
What is a sparkline?
A) A small chart within a cell
B) A type of formula
C) A PivotTable tool
D) A data validation feature
Answer: A
65.
Which chart type is used to show
relationships between variables?
A) Scatter Plot
B) Pie Chart
C) Bar Chart
D) Line Chart
Answer: A
66.
What does the INDEX function do?
A) Returns a value from a specific position in a range
B) Adds numbers
C) Counts cells
D) Filters data
Answer: A
67.
Which function is used to perform a lookup
with multiple criteria?
A) INDEX-MATCH
B) VLOOKUP
C) HLOOKUP
D) LOOKUP
Answer: A
68.
What does the XLOOKUP function do?
A) Searches for a value in a range and returns a corresponding value
B) Adds numbers
C) Counts cells
D) Filters data
Answer: A
69.
Which function calculates the payment for a
loan?
A) PMT()
B) FV()
C) PV()
D) RATE()
Answer: A
70.
What does the TEXT function do?
A) Converts a number to text in a specific format
B) Adds text
C) Counts text
D) Filters text
Answer: A
71.
Which file format is commonly used to export
Excel data?
A) .csv
B) .txt
C) .pdf
D) All of the above
Answer: D
72.
What does the "Get & Transform
Data" feature do?
A) Imports and transforms data from external sources
B) Exports data
C) Deletes data
D) Sorts data
Answer: A
73.
Which tool is used to connect Excel to a
database?
A) Power Query
B) PivotTable
C) Solver
D) Goal Seek
Answer: A
74.
What is the purpose of the "Text Import
Wizard"?
A) To import text files into Excel
B) To export text files
C) To delete text files
D) To sort text files
Answer: A
75.
Which file format preserves Excel formulas
and formatting?
A) .xlsx
B) .csv
C) .txt
D) .pdf
Answer: A
76.
What is a macro in Excel?
A) A set of instructions to automate tasks
B) A type of chart
C) A formula
D) A filter
Answer: A
77.
Which language is used to write Excel macros?
A) VBA (Visual Basic for Applications)
B) Python
C) Java
D) C++
Answer: A
78.
What does the "Record Macro"
feature do?
A) Records a series of actions to create a macro
B) Deletes a macro
C) Runs a macro
D) Edits a macro
Answer: A
79.
Which shortcut opens the VBA editor?
A) Alt + F11
B) Ctrl + M
C) F5
D) Ctrl + S
Answer: A
80.
What is the purpose of the "Personal
Macro Workbook"?
A) To store macros for use in all workbooks
B) To delete macros
C) To run macros
D) To edit macros
Answer: A
81.
What does the #VALUE! error
indicate?
A) Invalid data type in a formula
B) Division by zero
C) Missing function
D) Circular reference
Answer: A
82.
What does the #REF! error indicate?
A) Invalid cell reference
B) Division by zero
C) Missing function
D) Circular reference
Answer: A
83.
What does the #NAME? error
indicate?
A) Unrecognized text in a formula
B) Division by zero
C) Missing function
D) Circular reference
Answer: A
84.
What does the #N/A error indicate?
A) Value not available
B) Division by zero
C) Missing function
D) Circular reference
Answer: A
85.
What does the #NUM! error indicate?
A) Invalid numeric value
B) Division by zero
C) Missing function
D) Circular reference
Answer: A
86.
Where can you change the default font in
Excel?
A) File > Options > General
B) Home > Font
C) Insert > Text
D) Data > Queries
Answer: A
87.
Which option allows you to customize the Quick
Access Toolbar?
A) File > Options > Quick Access Toolbar
B) Home > Styles
C) Insert > Table
D) Data > Sort
Answer: A
88.
What does the "Auto Recover"
feature do?
A) Saves a backup of your workbook at regular intervals
B) Deletes old files
C) Runs macros
D) Filters data
Answer: A
89.
Which option allows you to protect a workbook
with a password?
A) File > Info > Protect Workbook
B) Home > Format
C) Insert > Table
D) Data > Sort
Answer: A
90.
Where can you enable "Developer"
tab in Excel?
A) File > Options > Customize Ribbon
B) Home > Styles
C) Insert > Table
D) Data > Sort
Answer: A
91.
What does the F4 key do in Excel?
A) Repeats the last action
B) Toggles between absolute and relative references
C) Both A and B
D) None of the above
Answer: C
92.
Which function returns the current date and
time?
A) NOW()
B) TODAY()
C) DATE()
D) TIME()
Answer: A
93.
What does the TRANSPOSE function
do?
A) Switches rows and columns
B) Adds numbers
C) Counts cells
D) Filters data
Answer: A
94.
Which function returns the smallest value in
a range?
A) MIN()
B) MAX()
C) SMALL()
D) LARGE()
Answer: A
95.
What does the SUBTOTAL function do?
A) Performs calculations on filtered data
B) Adds numbers
C) Counts cells
D) Filters data
Answer: A
96.
Which function returns the number of cells
that contain numbers?
A) COUNT()
B) COUNTA()
C) COUNTBLANK()
D) COUNTIF()
Answer: A
97.
What does the HYPERLINK function
do?
A) Creates a clickable link
B) Adds numbers
C) Counts cells
D) Filters data
Answer: A
98.
Which function returns the current user's
name?
A) USER()
B) USERNAME()
C) ENVIRON("USERNAME")
D) None of the above
Answer: C
99.
What does the RAND function do?
A) Generates a random number between 0 and 1
B) Adds numbers
C) Counts cells
D) Filters data
Answer: A
100. Which function returns the number of
characters in a text string?
A) LEN()
B) LEFT()
C) RIGHT()
D) MID()
Answer: A
