Excel Basics

What is the file extension for an Excel workbook?

• .docx

• .xls

• .pdf

• .xlsx

How can you freeze panes in Excel?

• Right-click on the row you want to freeze, select 'Freeze Panes' from the context menu.

• Select row below and column to the right of cells to freeze, go to 'View' tab, click 'Freeze Panes' in 'Window' group, select 'Freeze Panes'.

• Use the 'Format' tab, choose 'Freeze Panes' from the dropdown menu.

• Select entire sheet, go to 'Insert' tab, click 'Freeze Panes' in 'Window' group, select 'Freeze Panes'.

What function would you use to find the highest value in a range of cells?

• SUM

• AVERAGE

• MAX

• MIN

Explain the difference between a relative reference and an absolute reference in Excel.

• A relative reference is always visible, while an absolute reference is hidden.

• A relative reference remains fixed, while an absolute reference changes its position.

• A relative reference is used for text, while an absolute reference is used for numbers.

• A relative reference changes its position, while an absolute reference remains fixed.

What is the shortcut key to insert a new worksheet in Excel?

• Ctrl + N

• Shift + A

• Shift + F11

• Alt + W

How can you apply a filter to a range of data in Excel?

• Manually type in the filter criteria for each cell in the range

• Select the range, go to 'Data' tab, click on 'Filter' button, use filter arrows to sort and filter data.

• Right-click on the range and select 'Apply Filter'

• Use the 'Format' tab to filter the data

What is the purpose of conditional formatting in Excel?

• To insert new rows and columns

• To highlight specific data based on certain conditions

• To calculate formulas automatically

• To change the font style of all cells

Explain the VLOOKUP function in Excel.

• The VLOOKUP function in Excel searches for a value in the first column of a range and returns a value in the same row from another column.

• VLOOKUP function in Excel can only be used with numerical values.

• VLOOKUP function in Excel is used to calculate the sum of values in a range.

• The VLOOKUP function in Excel searches for a value in the last column of a range and returns a value in the same row from another column.

How can you create a chart in Excel?

• Click on the 'Help' tab

• Type the chart manually

• Select data -> Go to 'Insert' tab -> Choose chart type

• Use a different software

What is the function of the CONCATENATE function in Excel?

• To create pivot tables

• To calculate the sum of numbers in a range

• To format cells based on specific conditions

• To combine multiple strings into one single string.