NEW
Font size
WorksheetsExcel Challenge
Total questions: 12
Worksheet time: 4mins
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
What function is used to count the number of cells that contain numbers in Excel?
COUNT
SUM
AVERAGE
MAX
How can you freeze the top row in Excel?
Use the 'Freeze Panes' feature under the 'View' tab
Use the 'Lock Cells' feature under the 'Review' tab
Use the 'Hide' feature under the 'Home' tab
Use the 'Merge & Center' feature under the 'Home' tab
