1. What is MS Excel primarily used for?
A) Video Editing
B) Spreadsheet Management
C) Web Browsing
D) Programming
Answer: B) Spreadsheet Management
What is the default file extension of Excel 2007 and later versions?
A) .xls
B) .xlsx
C) .docx
D) .pptx
Answer: B) .xlsx
A workbook in Excel consists of:
A) Slides
B) Documents
C) Worksheets
D) Pages
Answer: C) Worksheets
The intersection of a row and a column is called:
A) Range
B) Cell
C) Box
D) Sheet
Answer: B) Cell
Which symbol is used to start a formula in Excel?
A) @
B) #
C) =
D) &
Answer: C) =
Which function is used to add numbers?
A) COUNT()
B) SUM()
C) MAX()
D) MIN()
Answer: B) SUM()
What is the default number of worksheets in a new Excel workbook?
A) 1
B) 2
C) 3
D) 5
Answer: A) 1
Which key is used to edit the active cell?
A) F1
B) F2
C) F3
D) F4
Answer: B) F2
The horizontal arrangement of cells is called:
A) Row
B) Column
C) Table
D) Range
Answer: A) Row
The vertical arrangement of cells is called:
A) Row
B) Column
C) Sheet
D) Table
Answer: B) Column
Which function returns the largest value in a range?
A) MIN()
B) SUM()
C) MAX()
D) AVG()
Answer: C) MAX()
Which function returns the smallest value in a range?
A) MIN()
B) MAX()
C) COUNT()
D) IF()
Answer: A) MIN()
Which function calculates the average?
A) SUM()
B) AVG()
C) AVERAGE()
D) MEAN()
Answer: C) AVERAGE()
Which tab contains the Copy and Paste commands?
A) Insert
B) Home
C) Review
D) Data
Answer: B) Home
Shortcut key for Save is:
A) Ctrl + C
B) Ctrl + S
C) Ctrl + X
D) Ctrl + P
Answer: B) Ctrl + S
Shortcut key for Copy is:
A) Ctrl + C
B) Ctrl + V
C) Ctrl + X
D) Ctrl + P
Answer: A) Ctrl + C
Shortcut key for Paste is:
A) Ctrl + X
B) Ctrl + P
C) Ctrl + V
D) Ctrl + S
Answer: C) Ctrl + V
Shortcut key for Cut is:
A) Ctrl + C
B) Ctrl + X
C) Ctrl + V
D) Ctrl + A
Answer: B) Ctrl + X
Which chart represents data in circular slices?
A) Bar Chart
B) Pie Chart
C) Line Chart
D) Area Chart
Answer: B) Pie Chart
Which chart is best for showing trends over time?
A) Line Chart
B) Pie Chart
C) Doughnut Chart
D) Radar Chart
Answer: A) Line Chart
Cell A1 refers to:
A) Column A Row 1
B) Row A Column 1
C) Sheet A Cell 1
D) None
Answer: A) Column A Row 1
Which function counts numerical entries?
A) SUM()
B) COUNT()
C) COUNTA()
D) IF()
Answer: B) COUNT()
Which function counts non-empty cells?
A) COUNTA()
B) COUNT()
C) SUM()
D) MAX()
Answer: A) COUNTA()
What is a group of selected cells called?
A) Cluster
B) Range
C) Set
D) Array
Answer: B) Range
Which tab is used to insert charts?
A) Home
B) Data
C) Insert
D) Review
Answer: C) Insert
What is the last column in Excel 2007 and later?
A) IV
B) ZZ
C) XFD
D) AAA
Answer: C) XFD
What is the maximum row number in Excel 2007 and later?
A) 65536
B) 1048576
C) 1000000
D) 500000
Answer: B) 1048576
Which key selects the entire worksheet?
A) Ctrl + A
B) Ctrl + S
C) Ctrl + P
D) Ctrl + N
Answer: A) Ctrl + A
What does the AutoSum button insert?
A) COUNT Formula
B) SUM Formula
C) IF Formula
D) MAX Formula
Answer: B) SUM Formula
Which tab contains Sort and Filter options?
A) Data
B) Insert
C) Home
D) View
Answer: A) Data
What is used to visually represent data?
A) Formula
B) Chart
C) Function
D) Cell
Answer: B) Chart
Which function returns today’s date?
A) DATE()
B) TODAY()
C) NOWDATE()
D) CURRENT()
Answer: B) TODAY()
Which function returns current date and time?
A) NOW()
B) TIME()
C) TODAY()
D) DATE()
Answer: A) NOW()
Formula =5+10 returns:
A) 10
B) 15
C) 20
D) Error
Answer: B) 15
Which option removes duplicate values?
A) Filter
B) Sort
C) Remove Duplicates
D) Merge
Answer: C) Remove Duplicates
Which key starts a new workbook?
A) Ctrl + O
B) Ctrl + N
C) Ctrl + W
D) Ctrl + F
Answer: B) Ctrl + N
Ctrl + P is used for:
A) Paste
B) Print
C) Page Setup
D) Preview
Answer: B) Print
Ctrl + Z is used for:
A) Redo
B) Undo
C) Zoom
D) Close
Answer: B) Undo
Ctrl + Y is used for:
A) Redo
B) Undo
C) Copy
D) Paste
Answer: A) Redo
Which function checks a condition?
A) SUM()
B) IF()
C) MAX()
D) COUNT()
Answer: B) IF()
Which tab contains spelling check?
A) Review
B) Data
C) Insert
D) View
Answer: A) Review
What does Ctrl + F do?
A) Find
B) Format
C) Fill
D) Filter
Answer: A) Find
What does Ctrl + H do?
A) Help
B) Hide
C) Replace
D) Home
Answer: C) Replace
Which command combines cells into one?
A) Merge Cells
B) Join
C) Group
D) Link
Answer: A) Merge Cells
Which Excel feature automatically fills a series?
A) AutoCorrect
B) AutoFill
C) AutoSave
D) AutoFormat
Answer: B) AutoFill
Which symbol is used for multiplication in formulas?
A) x
B) *
C) #
D) %
**Answer: B) ***
Which symbol is used for division?
A) /
B) \
C) %
D) *
Answer: A) /
Which function finds the highest value?
A) MIN()
B) MAX()
C) COUNT()
D) SUM()
Answer: B) MAX()
Which function finds the lowest value?
A) MAX()
B) MIN()
C) IF()
D) COUNT()
Answer: B) MIN()
What does Ctrl + O do?
A) Open File
B) Close File
C) New File
D) Save File
Answer: A) Open File
Which tab is used for page layout settings?
A) Home
B) Insert
C) Page Layout
D) Data
Answer: C) Page Layout
What is the shortcut for bold text?
A) Ctrl + I
B) Ctrl + B
C) Ctrl + U
D) Ctrl + T
Answer: B) Ctrl + B
What is the shortcut for italic text?
A) Ctrl + I
B) Ctrl + B
C) Ctrl + U
D) Ctrl + P
Answer: A) Ctrl + I
What is the shortcut for underline?
A) Ctrl + U
B) Ctrl + I
C) Ctrl + B
D) Ctrl + N
Answer: A) Ctrl + U
Which function rounds a number?
A) ROUND()
B) FIX()
C) INT()
D) TRUNC()
Answer: A) ROUND()
Which tab contains PivotTable?
A) Insert
B) Review
C) View
D) Home
Answer: A) Insert
What is a PivotTable used for?
A) Drawing
B) Data Analysis
C) Printing
D) Formatting
Answer: B) Data Analysis
Which function returns the length of text?
A) LEN()
B) TEXT()
C) MID()
D) LEFT()
Answer: A) LEN()
Which function converts text to uppercase?
A) LOWER()
B) UPPER()
C) PROPER()
D) TEXT()
Answer: B) UPPER()
Which function converts text to lowercase?
A) LOWER()
B) UPPER()
C) PROPER()
D) LEN()
Answer: A) LOWER()
What does Freeze Panes do?
A) Locks formulas
B) Keeps rows/columns visible
C) Hides cells
D) Protects workbook
Answer: B) Keeps rows/columns visible
Which tab contains Freeze Panes?
A) View
B) Data
C) Home
D) Review
Answer: A) View
What is the shortcut key for inserting current date?
A) Ctrl + ;
B) Ctrl + :
C) Ctrl + D
D) Ctrl + T
Answer: A) Ctrl + ;
Which formula calculates percentage?
A) =Part/Total100
B) =Part+Total
C) =Part-Total
D) =PartTotal
Answer: A) =Part/Total*100
What does #DIV/0! indicate?
A) Invalid Name
B) Division by Zero
C) Missing Value
D) Wrong Reference
Answer: B) Division by Zero
What does #NAME? error indicate?
A) Unknown Formula Name
B) Divide Error
C) Empty Cell
D) Overflow
Answer: A) Unknown Formula Name
Which feature arranges data alphabetically?
A) Sort
B) Filter
C) Group
D) Freeze
Answer: A) Sort
Which feature displays only selected records?
A) Sort
B) Filter
C) Merge
D) Split
Answer: B) Filter
What does Ctrl + Home do?
A) Go to Cell A1
B) Save Workbook
C) Open Workbook
D) Close Workbook
Answer: A) Go to Cell A1
What does Ctrl + End do?
A) Last Used Cell
B) Last Worksheet
C) Close Workbook
D) End Formula
Answer: A) Last Used Cell
Which function joins text strings?
A) CONCAT()
B) LEN()
C) LEFT()
D) MID()
Answer: A) CONCAT()
Which function extracts left-side characters?
A) RIGHT()
B) MID()
C) LEFT()
D) LEN()
Answer: C) LEFT()
Which function extracts right-side characters?
A) RIGHT()
B) LEFT()
C) MID()
D) LEN()
Answer: A) RIGHT()
Which function extracts characters from the middle?
A) LEFT()
B) RIGHT()
C) MID()
D) LEN()
Answer: C) MID()
What does Ctrl + Shift + L do?
A) Apply Filter
B) Save File
C) Insert Chart
D) Print File
Answer: A) Apply Filter
Which tab contains Conditional Formatting?
A) Home
B) Insert
C) View
D) Data
Answer: A) Home
Conditional Formatting is used to:
A) Highlight Data
B) Print Data
C) Save Data
D) Delete Data
Answer: A) Highlight Data
Which function returns a random number?
A) RANDOM()
B) RAND()
C) RANDBETWEEN()
D) Both B and C
Answer: D) Both B and C
What is the shortcut for inserting a new worksheet?
A) Shift + F11
B) Ctrl + N
C) Alt + N
D) Ctrl + W
Answer: A) Shift + F11
Which key recalculates formulas?
A) F5
B) F7
C) F9
D) F12
Answer: C) F9
Which function returns the square root?
A) POWER()
B) SQRT()
C) ROOT()
D) SQUARE()
Answer: B) SQRT()
Which function raises a number to a power?
A) EXP()
B) POWER()
C) SQRT()
D) LOG()
Answer: B) POWER()
Which function looks up data vertically?
A) HLOOKUP()
B) VLOOKUP()
C) LOOKUP()
D) FIND()
Answer: B) VLOOKUP()
Which function looks up data horizontally?
A) VLOOKUP()
B) HLOOKUP()
C) MATCH()
D) INDEX()
Answer: B) HLOOKUP()
What is the shortcut for spelling check?
A) F5
B) F7
C) F9
D) F11
Answer: B) F7
What does Ctrl + 1 open?
A) Format Cells Dialog Box
B) Save Window
C) Print Window
D) Help Window
Answer: A) Format Cells Dialog Box
Which option protects worksheet data?
A) Protect Sheet
B) Freeze Pane
C) Sort
D) Filter
Answer: A) Protect Sheet
Which tab contains Protect Sheet?
A) Review
B) Insert
C) Home
D) View
Answer: A) Review
What is the shortcut for creating a chart?
A) F11
B) F5
C) F7
D) F2
Answer: A) F11
Which function counts blank cells?
A) COUNT()
B) COUNTA()
C) COUNTBLANK()
D) COUNTIF()
Answer: C) COUNTBLANK()
Which function counts cells meeting criteria?
A) COUNTIF()
B) SUMIF()
C) IF()
D) COUNTA()
Answer: A) COUNTIF()
Which function sums cells meeting criteria?
A) COUNTIF()
B) SUMIF()
C) IF()
D) SUM()
Answer: B) SUMIF()
Which Excel view shows page breaks?
A) Normal View
B) Page Break Preview
C) Full Screen
D) Reading View
Answer: B) Page Break Preview
What does Ctrl + Page Down do?
A) Next Worksheet
B) Previous Worksheet
C) Save Workbook
D) Print Workbook
Answer: A) Next Worksheet
What does Ctrl + Page Up do?
A) Previous Worksheet
B) Next Worksheet
C) Open Worksheet
D) Close Worksheet
Answer: A) Previous Worksheet
Which function returns the position of text?
A) FIND()
B) LEN()
C) MID()
D) LEFT()
Answer: A) FIND()
Which function combines text from multiple cells?
A) CONCAT()
B) LEN()
C) COUNT()
D) IF()
Answer: A) CONCAT()
Which formula bar displays the contents of the active cell?
A) Status Bar
B) Formula Bar
C) Title Bar
D) Ribbon
Answer: B) Formula Bar
Which tab contains Text to Columns?
A) Data
B) Insert
C) Home
D) View
Answer: A) Data
100. Which feature summarizes large datasets quickly?
A) PivotTable
B) Chart
C) Filter
D) Sort
Answer: A) PivotTable
- Which function returns the current year from a date?
A) YEAR()
B) MONTH()
C) DAY()
D) DATE()
Answer: A) YEAR() - Which function returns the month from a date?
A) YEAR()
B) MONTH()
C) DAY()
D) DATE()
Answer: B) MONTH() - Which function returns the day from a date?
A) YEAR()
B) MONTH()
C) DAY()
D) DATE()
Answer: C) DAY() - Which function combines year, month, and day into a date?
A) DATE()
B) TODAY()
C) NOW()
D) TIME()
Answer: A) DATE() - Which function returns the current date and time?
A) TODAY()
B) NOW()
C) DATE()
D) TIME()
Answer: B) NOW() - Which feature restricts the type of data entered into a cell?
A) Data Validation
B) Conditional Formatting
C) Filter
D) Sort
Answer: A) Data Validation - Which tab contains Data Validation?
A) Home
B) Insert
C) Data
D) View
Answer: C) Data - What is the shortcut key to insert a function?
A) Shift + F3
B) Ctrl + F3
C) Alt + F3
D) F3
Answer: A) Shift + F3 - Which function returns one value if a condition is true and another if false?
A) COUNT()
B) SUM()
C) IF()
D) MAX()
Answer: C) IF() - The Name Box displays:
A) Worksheet Name
B) Workbook Name
C) Active Cell Address
D) Formula
Answer: C) Active Cell Address - Which function returns the number of characters in text?
A) LEFT()
B) RIGHT()
C) MID()
D) LEN()
Answer: D) LEN() - Which formula correctly adds A1 and B1?
A) =A1+B1
B) A1+B1
C) ADD(A1,B1)
D) SUM=A1+B1
Answer: A) =A1+B1 - What is the Fill Handle used for?
A) Deleting Data
B) AutoFill Data and Formulas
C) Formatting Cells
D) Creating Charts
Answer: B) AutoFill Data and Formulas - Which chart is best for comparing categories?
A) Pie Chart
B) Column Chart
C) Doughnut Chart
D) Radar Chart
Answer: B) Column Chart - Which chart shows proportions of a whole?
A) Line Chart
B) Column Chart
C) Pie Chart
D) Scatter Chart
Answer: C) Pie Chart - Which key opens the Go To dialog box?
A) F2
B) F5
C) F7
D) F9
Answer: B) F5 - Ctrl + D is used to:
A) Delete Cells
B) Fill Down
C) Duplicate Workbook
D) Open Data Tab
Answer: B) Fill Down - Ctrl + R is used to:
A) Refresh
B) Replace
C) Fill Right
D) Recalculate
Answer: C) Fill Right - Which function counts cells meeting multiple criteria?
A) COUNTIF()
B) COUNTIFS()
C) SUMIF()
D) SUMIFS()
Answer: B) COUNTIFS() - Which function sums values meeting multiple criteria?
A) SUMIF()
B) SUMIFS()
C) COUNTIF()
D) COUNTIFS()
Answer: B) SUMIFS() - The Ribbon contains:
A) Worksheets
B) Commands and Tools
C) Formulas Only
D) Charts Only
Answer: B) Commands and Tools - Which is the default worksheet view?
A) Page Layout
B) Page Break Preview
C) Normal View
D) Reading View
Answer: C) Normal View - Ctrl + W is used to:
A) Save Workbook
B) Close Workbook
C) Open Workbook
D) Print Workbook
Answer: B) Close Workbook - A graphical representation of data is called:
A) Table
B) Formula
C) Chart
D) Function
Answer: C) Chart - The Status Bar displays:
A) Calculation Results
B) Workbook Name
C) Formula
D) Chart Title
Answer: A) Calculation Results - Which function returns the remainder after division?
A) MOD()
B) DIV()
C) REM()
D) QUOTIENT()
Answer: A) MOD() - Which function returns the integer portion of division?
A) MOD()
B) QUOTIENT()
C) INT()
D) ROUND()
Answer: B) QUOTIENT() - What is the shortcut for AutoSum?
A) Ctrl + =
B) Alt + =
C) Shift + =
D) Ctrl + Shift + =
Answer: B) Alt + = - Which tab contains Themes?
A) Home
B) Data
C) Page Layout
D) Review
Answer: C) Page Layout - Which feature highlights cells based on conditions?
A) Data Validation
B) Conditional Formatting
C) Filter
D) Sort
Answer: B) Conditional Formatting - Which function returns the absolute value of a number?
A) INT()
B) MOD()
C) ABS()
D) ROUND()
Answer: C) ABS() - The #VALUE! error indicates:
A) Invalid Data Type
B) Divide by Zero
C) Invalid Reference
D) Invalid Name
Answer: A) Invalid Data Type - Which is an absolute cell reference?
A) A1
B) $A$1
C) A$1
D) $A1
Answer: B) $A$1 - Which symbol indicates an absolute reference?
A) #
B) @
C) $
D) %
Answer: C) $ - Ctrl + ` (grave accent) displays:
A) Charts
B) Formulas
C) Worksheets
D) Filters
Answer: B) Formulas - Which function searches for a value in a range?
A) LOOKUP()
B) SUM()
C) COUNT()
D) LEN()
Answer: A) LOOKUP() - Which function returns the position of a value?
A) INDEX()
B) MATCH()
C) LOOKUP()
D) FIND()
Answer: B) MATCH() - Which function returns a value from a specified position?
A) INDEX()
B) MATCH()
C) LOOKUP()
D) SEARCH()
Answer: A) INDEX() - Which tab contains Macros?
A) Home
B) Data
C) Review
D) Developer
Answer: D) Developer - A Macro is used to:
A) Create Charts
B) Automate Tasks
C) Insert Tables
D) Format Cells
Answer: B) Automate Tasks - Ctrl + 1 opens:
A) Page Setup
B) Format Cells Dialog Box
C) Print Preview
D) Save As
Answer: B) Format Cells Dialog Box - A workbook is a collection of:
A) Charts
B) Worksheets
C) Formulas
D) Tables
Answer: B) Worksheets - Which shortcut inserts the current time?
A) Ctrl + ;
B) Ctrl + Shift + ;
C) Alt + ;
D) Shift + ;
Answer: B) Ctrl + Shift + ; - Which chart is useful for scientific data comparison?
A) Scatter Chart
B) Pie Chart
C) Doughnut Chart
D) Area Chart
Answer: A) Scatter Chart - Which function rounds a number downward?
A) ROUNDUP()
B) ROUNDDOWN()
C) ROUND()
D) INT()
Answer: B) ROUNDDOWN() - Which function rounds a number upward?
A) ROUNDUP()
B) ROUNDDOWN()
C) ROUND()
D) FLOOR()
Answer: A) ROUNDUP() - Which Excel feature is used for data analysis and summarization?
A) PivotTable
B) Filter
C) Freeze Pane
D) Sort
Answer: A) PivotTable - Numbers are aligned by default to the:
A) Left
B) Right
C) Center
D) Justify
Answer: B) Right - Text is aligned by default to the:
A) Left
B) Right
C) Center
D) Justify
Answer: A) Left - Which command can create a duplicate worksheet?
A) Move or Copy Sheet
B) Duplicate Workbook
C) Clone Worksheet
D) Copy Workbook
Answer: A) Move or Copy Sheet
- Which key is used to enter data into a cell?
A) Esc
B) Enter
C) Shift
D) Ctrl
Answer: B) Enter - Which key cancels cell entry?
A) Esc
B) Enter
C) Tab
D) Shift
Answer: A) Esc - Pressing the Tab key moves the active cell:
A) Left
B) Up
C) Right
D) Down
Answer: C) Right - Shift + Tab moves the active cell:
A) Right
B) Left
C) Up
D) Down
Answer: B) Left - Which function converts text into Proper Case?
A) UPPER()
B) LOWER()
C) PROPER()
D) TEXT()
Answer: C) PROPER() - Which function joins text strings together?
A) CONCAT()
B) COUNT()
C) LEN()
D) SUM()
Answer: A) CONCAT() - Ctrl + Shift + $ applies which format?
A) Percentage
B) Currency
C) Date
D) Time
Answer: B) Currency - Ctrl + Shift + % applies which format?
A) Percentage
B) Currency
C) Date
D) Time
Answer: A) Percentage - Which feature prevents invalid data entry?
A) Data Validation
B) Filter
C) Sort
D) Freeze Panes
Answer: A) Data Validation - What does the #REF! error indicate?
A) Invalid Reference
B) Invalid Number
C) Invalid Formula
D) Invalid Name
Answer: A) Invalid Reference - Which feature protects workbook structure?
A) Protect Workbook
B) Protect Sheet
C) Freeze Panes
D) Sort
Answer: A) Protect Workbook - What is the shortcut key to create a table?
A) Ctrl + T
B) Ctrl + L
C) Both A and B
D) Ctrl + K
Answer: C) Both A and B - Which function calculates exponential values?
A) EXP()
B) LOG()
C) SQRT()
D) POWER()
Answer: A) EXP() - Which function returns a logarithm?
A) LOG()
B) EXP()
C) ABS()
D) ROUND()
Answer: A) LOG() - Which chart displays data in horizontal bars?
A) Pie Chart
B) Column Chart
C) Bar Chart
D) Line Chart
Answer: C) Bar Chart - Freeze Top Row is used to:
A) Hide the top row
B) Lock the top row visible during scrolling
C) Protect the top row
D) Delete the top row
Answer: B) Lock the top row visible during scrolling - Ctrl + H opens:
A) Find
B) Replace
C) Help
D) Hyperlink
Answer: B) Replace - Which command is used to hide rows or columns?
A) Hide
B) Freeze
C) Protect
D) Lock
Answer: A) Hide - Ctrl + Shift + + is used to:
A) Insert Cells
B) Delete Cells
C) Save Workbook
D) Merge Cells
Answer: A) Insert Cells - Ctrl + – is used to:
A) Insert Cells
B) Delete Cells
C) Hide Cells
D) Format Cells
Answer: B) Delete Cells - Which function converts a number into text format?
A) TEXT()
B) VALUE()
C) LEN()
D) CONCAT()
Answer: A) TEXT() - Which function converts text into a numeric value?
A) VALUE()
B) TEXT()
C) LEN()
D) MID()
Answer: A) VALUE() - Which feature automatically creates summaries in a dataset?
A) Subtotal
B) Filter
C) Sort
D) Freeze
Answer: A) Subtotal - The Subtotal command is found on which tab?
A) Home
B) Insert
C) Data
D) Review
Answer: C) Data - What is the file extension of a macro-enabled workbook?
A) .xlsx
B) .xls
C) .xlsm
D) .csv
Answer: C) .xlsm - Which chart displays data in concentric rings?
A) Pie Chart
B) Doughnut Chart
C) Column Chart
D) Area Chart
Answer: B) Doughnut Chart - Which chart is best for comparing multiple variables?
A) Radar Chart
B) Pie Chart
C) Bar Chart
D) Line Chart
Answer: A) Radar Chart - Which function generates a random integer within a specified range?
A) RAND()
B) RANDOM()
C) RANDBETWEEN()
D) INT()
Answer: C) RANDBETWEEN() - Which feature allows users to add remarks to cells?
A) Comments/Notes
B) Filter
C) Validation
D) Sort
Answer: A) Comments/Notes - Comments are available under which tab?
A) Home
B) Review
C) Data
D) Insert
Answer: B) Review - Ctrl + K is used to:
A) Insert Hyperlink
B) Save Workbook
C) Open Workbook
D) Create Chart
Answer: A) Insert Hyperlink - A Hyperlink is used to:
A) Link to websites, files, or locations
B) Format cells
C) Protect worksheets
D) Sort data
Answer: A) Link to websites, files, or locations - Which function extracts characters from the middle of a text string?
A) LEFT()
B) RIGHT()
C) MID()
D) LEN()
Answer: C) MID() - Which key opens the Save As dialog box?
A) F10
B) F11
C) F12
D) F9
Answer: C) F12 - Which key repeats the last action performed?
A) F1
B) F2
C) F3
D) F4
Answer: D) F4 - F1 is used to open:
A) Save As
B) Help
C) Print
D) Find
Answer: B) Help - Which feature enables multiple users to work on a workbook?
A) Shared Workbook
B) PivotTable
C) Filter
D) Sort
Answer: A) Shared Workbook - Which function checks whether a value is an error?
A) ISERROR()
B) IF()
C) ERROR()
D) ISBLANK()
Answer: A) ISERROR() - Which function checks whether a cell is blank?
A) BLANK()
B) EMPTY()
C) ISBLANK()
D) COUNTBLANK()
Answer: C) ISBLANK() - Which chart is suitable for showing cumulative totals over time?
A) Area Chart
B) Pie Chart
C) Radar Chart
D) Doughnut Chart
Answer: A) Area Chart - Which formula returns the square of a number?
A) POWER(number,2)
B) SQRT(number)
C) EXP(number)
D) LOG(number)
Answer: A) POWER(number,2) - Which feature visually analyzes PivotTable data?
A) PivotChart
B) Filter
C) Sort
D) Validation
Answer: A) PivotChart - PivotChart is available under which tab?
A) Home
B) Insert
C) Data
D) Review
Answer: B) Insert - Which shortcut key is commonly used to rename a worksheet?
A) F2
B) F4
C) F7
D) F9
Answer: A) F2 - Which feature displays formulas instead of calculation results?
A) Show Formulas
B) Formula View
C) Formula Display
D) Formula Mode
Answer: A) Show Formulas - Which function can return “Yes” or “No” based on a condition?
A) COUNT()
B) IF()
C) MAX()
D) SUM()
Answer: B) IF() - What is the main purpose of Excel Tables?
A) Structured Data Management
B) Drawing Objects
C) Printing Reports
D) Creating Presentations
Answer: A) Structured Data Management - Which function returns the nearest integer less than or equal to a number?
A) CEILING()
B) FLOOR()
C) INT()
D) ROUND()
Answer: C) INT() - Which function returns the nearest integer greater than or equal to a number?
A) FLOOR()
B) CEILING()
C) ROUND()
D) INT()
Answer: B) CEILING() - MS Excel is a part of:
A) Microsoft Office Suite
B) Adobe Creative Suite
C) Corel Office
D) Google Workspace
Answer: A) Microsoft Office Suite