Mastering Microsoft Excel 365

What is the shortcut key to save a workbook in Excel 365?

• Shift + S

• Ctrl + S

• Ctrl + P

• Alt + S

Which function is used to calculate the average of a range of cells?

• AVERAGE

• MAX

• COUNT

• SUM

What does the F4 key do when editing a formula?

• Toggles cell reference types in a formula.

• Inserts a new row in the spreadsheet.

• Opens the help menu.

• Saves the current document.

How can you quickly insert the current date in a cell?

• Use the keyboard shortcut Ctrl + D to duplicate the cell content

• Press F5 to refresh the cell

• Use the keyboard shortcut Ctrl + ; (semicolon) to insert the current date.

• Type 'today' and press Enter

What is the shortcut for opening the Format Cells dialog box?

• Ctrl + Shift + C

• Alt + F1

• Ctrl + 1

• Shift + F1

Which feature allows you to automatically fill a series of numbers or dates?

• Smart Fill

• Quick Fill

• AutoFill

• Date Series

What is the purpose of the VLOOKUP function?

• To format cells based on their values.

• To create a chart from a data set.

• To calculate the sum of a range of cells.

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

How can you freeze panes in an Excel worksheet?

• Select the entire worksheet and click 'View' > 'Freeze Panes' > 'Freeze First Column'.

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

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

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

What shortcut key is used to create a new worksheet?

• F12

• Alt + Shift + N

• Shift + F11

• Ctrl + N

What feature would you use to visually represent data trends?

• Scatter plot

• Pie chart

• Line chart

• Bar chart