X-Q3XCEL

What is the file extension for an Excel workbook that supports macros?

• .xlsx

• .xlsm

• .docx

• .pptm

Which function is used to add a range of numbers in Excel?

• COUNT

• SUM

• AVERAGE

• MAX

What is the function of the "Ctrl + P" shortcut key in Excel?

• Print the workbook

• Paste copied cells

• Open a new workbook

• Undo the last action

Which symbol is used to start a formula in Excel?

• =

• +

• #

• @

What does "Merge & Center" do in Excel?

• Combines and centers content of selected cells

• Copies content to adjacent cells

• Deletes duplicate cells

• Splits cells into multiple parts

Which Excel feature allows you to automatically fill data series?

• Conditional Formatting

• Data Validation

• AutoFill

• Goal Seek

What is the purpose of the VLOOKUP function?

• To count the number of cells in a range

• To find and retrieve data from a specific column

• To create charts

• To calculate averages

Which component in Excel displays the name of the active cell?

• Formula Bar

• Name Box

• Status Bar

• Ribbon

What is a macro in Excel?

• A formula for advanced calculations

• A set of instructions to automate tasks

• A chart type

• A font style

Which tab contains the option to record macros?

• Home

• View

• Developer

• Insert