Mastering Excel for Students

Front

What is the default file extension for an Excel workbook? Options: .xlsm, .xlsx, .xlsx1, .xls

Back

.xlsx

Front

How do you create a new worksheet in Excel?

Back

Click the '+' icon next to the worksheet tabs or use 'Insert' from the 'Home' tab.

Front

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

Back

AVERAGE

Front

How can you freeze panes in an Excel spreadsheet?

Back

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

Front

What is the purpose of the VLOOKUP function?

Back

To look up and retrieve data from a specific column in a table based on a matching value in the first column.

Front

How do you create a chart from selected data in Excel?

Back

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

Front

What shortcut key is used to save a workbook?

Back

Ctrl + S

Front

How can you apply conditional formatting to a cell?

Back

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

Front

What is the difference between relative and absolute cell references?

Back

Relative references adjust based on the position, absolute references do not change.

Front

How do you sort data in ascending order in Excel?

Back

Select the data range, go to 'Data' tab, click 'Sort A to Z'.