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()