Excel Functions Quiz

Which option allows you to sort data in Excel?

• a) Right-click and select "Sort"

• b) Use the "Sort" option under the "Insert" tab

• c) Press Ctrl + S

• d) Shift +S

Press _______ to quickly open the "Format Cells" dialog box in Excel.

• a) CTRL+1

• b) CTRL+4

• c) CTRL+F2

• d) Shift+ 1

What is the shortcut key for opening the "Save As" dialog box in Excel?

• a) Ctrl + S

• b) Shift + S

• c) Ctrl + O

• d) Ctrl + Shift + F

To apply a filter to your data in Excel, you can click on the _______ button in the "Data" tab.

• a) Paragraph

• b) Format

• c) Font

• d) Filter

What is the key difference between Filter and Advanced Filter?

• a) Advanced Filter allows complex criteria

• b) Filter only works with text data

• c) Filter is slower than Advanced Filter

• d) There is no difference between Filter and Advanced Filter

To convert a range of cells into a table in Excel, go to the "______" tab and click on "Table."

• a) Layout

• b) View

• c) Insert

• d) Design

What are the benefits of using tables in Excel?

• a) Automatic formatting and resizing

• b) Easy data filtering and sorting

• c) Structured references for formulas

• d) All of the above

Press "______" to quickly insert a new worksheet in Excel.

• a) CTRL+ N

• b) CTRL+SHIFT+N

• c) TAB + N

• d) Fn Key + N

Which option allows you to hide columns or rows in Excel?

• a) Right-click and select "Hide"

• b) Press Ctrl + H

• c) Use the "Hide" option under the "Home" tab

• d) Press Ctrl + Shift + 9 to hide rows and Ctrl + 0 to hide columns

To create a column chart in Excel, select your data and go to the "______" tab, then click on "Column Chart."

• a) Formula Tab

• b) Insert Tab

• c) Home Tab

• d) File Tab