Excel Challenge

What is the shortcut key to open the 'Paste Special' dialog box in Excel?

• Ctrl + Shift + V

• Ctrl + Alt + V

• Alt + V

• Ctrl + V

What function is used to find the highest value in a range in Excel?

• SUM

• MIN

• AVERAGE

• MAX

What does the '$' symbol in a cell reference indicate in Excel?

• Division

• Multiplication

• Addition

• Absolute reference

How can you navigate to the last cell in a worksheet in Excel?

• Ctrl + Shift + End

• Shift + End

• Ctrl + End

• Alt + End

What is the purpose of using tables in Excel?

• To create artistic designs

• To send emails

• To organize and analyze data in a structured format.

• To play games

How can you sort data in Excel in descending order?

• Filter A-Z

• Rearrange

• Sort ZA

• Sort 123

What is the keyboard shortcut to insert a new worksheet in Excel?

• Ctrl + N

• Ctrl + I

• Shift + Insert

• Ctrl + Alt + N

What is the function of the VLOOKUP formula in Excel?

• To search for a value in the first column of a table and return a value in the same row from another column.

• To calculate the sum of a range of cells

• To change the font style of a cell

• To insert a new row in the spreadsheet

What feature in Excel allows you to narrow down data based on specific criteria?

• Use the 'Sort' feature under the 'Home' tab

• Use the 'Filter' feature under the 'Data' tab

• Use the 'Calculate' feature under the 'Formulas' tab

• Use the 'Format' feature under the 'Data' tab

What is the keyboard shortcut to select an entire row in Excel?

• Ctrl + R

• Shift + Space

• Ctrl + Space

• Alt + Space