Q1
Q1 What is the default file extension used by Excel 2016 and later versions?
.xls
.xlsx
.xlsm
.xlsb
Q2
Q2 Which area in Excel displays the active cell address?
Formula Bar
Status Bar
Name Box
Ribbon
Q3
Q3 What does a cell's "fill handle" typically look like?
A solid square
A dotted line
A diagonal arrow
A circle
Q4
Q4 Which feature would you use to capture and analyze data from multiple sheets into one sheet?
PivotTable
Data Form
Consolidate
Template
Q5
Q5 What functionality does the 'Freeze Panes' feature provide in Excel?
Securing data
Hiding data
Splitting window
Locking rows/columns
Q6
Q6 How can you quickly select an entire worksheet in Excel?
Click the corner button
Double-click a tab
Right-click a tab
Use a shortcut
Q7
Q7 Which key combination is used to insert a new worksheet in Excel?
Ctrl + N
Ctrl + T
Ctrl + Shift + N
Shift + F11
Q8
Q8 What is the quickest way to resize a column to fit its contents?
Double-click the column header
Drag the header
Right-click and select resize
Use Format options
Q9
Q9 What shortcut performs the 'Paste Special' operation in Excel?
Ctrl + V
Ctrl + Alt + V
Ctrl + Shift + V
Alt + E, S
Q10
Q10 How do you apply a currency format to a cell in Excel?
Right-click and choose Format Cells
Use the $ button on Home tab
Ctrl + Shift + $
All of these
Q11
Q11 How would you quickly find all cells in a worksheet that contain formulas?
Use Find feature
Filter by color
Go to Special
Use Trace Precedents
Q12
Q12 What feature should you use to compare two Excel sheets side by side?
New Window
Arrange All
View Side by Side
Split
Q13
Q13 What symbol is used to start a formula in Excel?
@
#
=
+
Q14
Q14 Which function would you use to calculate the average value of a range of cells?
SUM()
AVERAGE()
MEAN()
TOTAL()
Q15
Q15 In Excel, which function returns the current date and time?
TODAY()
NOW()
DATE()
TIME()
Q16
Q16 What function would you use to find the lowest number in a range of data?
MIN()
MAX()
LOWER()
LEAST()
Q17
Q17 What does the COUNTA function do in Excel?
Counts cells containing any type of data
Counts only cells containing formulas
Counts empty cells
Counts cells containing numbers
Q18
Q18 Which function can be used to conditionally sum values in a range based on a criterion?
SUMIF()
SUM()
IFSUM()
TOTALIF()
Q19
Q19 What is the purpose of using the $ symbol in an Excel formula?
To convert currency
To indicate absolute reference
To highlight the cell
To mark important formulas
Q20
Q20 How do you display the formulas within the cells on an Excel worksheet?
Press Ctrl + `
Press F2
Select from View menu
Right-click and choose display formulas
Q21
Q21 What shortcut adds a new row in Excel?
Ctrl + Shift + "+"
Ctrl + "+"
Alt + Shift + "+"
Shift + "+"
Q22
Q22 To quickly calculate the sum of a column in Excel, which feature would you use?
Quick Analysis Tool
AutoSum
Formula Tab
All of these
Q23
Q23 What is the function to convert text to uppercase in Excel?
UPPERCASE()
UPPER()
CAPS()
TEXTUP()
Q24
Q24 Which function checks for the presence of a text string inside another string?
FIND()
SEARCH()
INSTRING()
TEXTFIND()
Q25
Q25 How can you create a dynamic formula that updates as new data is added?
Use an array formula
Use a volatile function
Use a named range
All of these
Q26
Q26 What Excel feature lets you apply a logical test to a value, then return one value if TRUE, another if FALSE?
IF()
TEST()
CHECK()
DECIDE()
Q27
Q27 You need to track changes made by team members on an Excel workbook. What feature should you use?
Track Changes
Audit Trail
Revision History
Document Inspector
Q28
Q28 How can you protect a worksheet from being edited accidentally?
Use a password
Lock cells
Set as read-only
All of these
Q29
Q29 How do you determine the number of numeric entries in a range?
Use COUNT()
Use NUMCOUNT()
Use COUNTNUM()
Use COUNTA()
Q30
Q30 Which Excel function is used to calculate the internal rate of return for a series of cash flows?
IRR()
ROI()
IRRVAL()
NETRATE()
