Excel Shortcuts and Functions Quiz

Which of the following keyboard shortcuts is used to open a new Excel file?

• Ctrl + O

• Ctrl + N

• Ctrl + S

• Ctrl + P

To keep the top row visible while scrolling through the worksheet, which option is used?

• Protect Sheet

• Wrap Text

• Freeze Panes

• Split Window

Which option allows you to lock a worksheet from editing?

• Protect Workbook

• Freeze Cells

• Protect Sheet

• Split Window

Which function is used to insert the current date in a cell?

• =TODAY()

• =NOW()

• =DATE()

• =TIME()

Which shortcut selects the entire dataset including filled adjacent cells?

• Ctrl + A

• Ctrl + Shift + Arrow keys

• Ctrl + C

• Alt + E

What does the "Merge and Center" option do?

• Combines rows only

• Combines multiple cells into one and centers text

• Deletes cells

• Adds comments

What does "Wrap Text" do in a cell?

• Adds borders

• Hides extra text

• Displays content in multiple lines within a cell

• Converts text to bold

Which tool helps to view different parts of the same sheet at once?

• Freeze Pane

• Protect Sheet

• Split Window

• Group

Which of the following is NOT a paste special option?

• Paste Values

• Paste Formatting

• Paste Picture

• Paste Filter

Which function rounds a number up to the nearest integer?

• ROUND

• ROUNDUP

• ROUNDDOWN

• INT