Mastering Microsoft Excel

What function would you use to find the average of a range of cells?

• AVERAGE

• MAX

• SUM

• COUNT

How do you create a chart in Excel?

• Click on 'File' and select 'New'

• Go to 'View' tab and select 'Gridlines'

• Select data, go to 'Insert' tab, choose chart type.

• Right-click on the data and choose 'Copy'

What is the shortcut key for saving a workbook?

• Alt + S

• Ctrl + P

• Shift + S

• Ctrl + S (Windows) / Command + S (Mac)

What does the VLOOKUP function do?

• The VLOOKUP function deletes rows from a table.

• The VLOOKUP function looks up a value in a table and retrieves corresponding data from another column.

• The VLOOKUP function calculates the sum of a range of cells.

• The VLOOKUP function formats cells in a spreadsheet.

How can you freeze panes in an Excel worksheet?

• Select the cell, go to 'View' > 'Freeze Panes' > 'Freeze Panes'.

• Select the cell, go to 'Home' > 'Freeze' > 'Freeze Top Row'.

• Select the cell, go to 'Data' > 'Freeze Panes' > 'Freeze First Column'.

• Right-click the cell and choose 'Freeze Panes' from the context menu.

What is the purpose of the CONCATENATE function?

• To format a string with specific styles.

• To convert a string to uppercase.

• To split a string into multiple parts.

• To join multiple strings into one string.

How do you apply conditional formatting to a cell?

• Use the 'Data' tab to apply filters

• Select the cell, go to 'Home' > 'Conditional Formatting', choose a rule, set conditions, and format.

• Right-click the cell and select 'Format Cells'

• Double-click the cell to change its color

What is the difference between relative and absolute cell references?

• Absolute references adjust based on the position of the cell.

• Relative references adjust based on the position of the cell, whereas absolute references do not change.

• Relative references are fixed and do not change at all.

• Both relative and absolute references are the same in functionality.

How can you sort data in Excel?

• Select data range, go to 'Data' tab, click 'Sort'.

• Highlight cells and press 'Enter'

• Go to 'File' and click 'Save'

• Right-click and select 'Delete'

What is a pivot table and how is it used?

• A pivot table is a database management tool for creating tables.

• A pivot table is a tool used to summarize and analyze data in spreadsheets.

• A pivot table is a type of chart used for visualizing data.

• A pivot table is a programming language used for data analysis.