Excel Quiz

What is the feature in Excel that makes data entry more efficient?

• Autoformat

• Autofill

• Autoinsert

• Autocorrect

What is the intersection of a column and row in Excel known as?

• Cell

• Block

• Box

• Grid

Which tab on the Excel ribbon contains the number, styles, and cells groups?

• Data

• Formulas

• Insert

• Home

What is the keyboard shortcut for saving in Excel?

• Ctrl + C

• Ctrl + X

• Ctrl + S

• Ctrl + P

What is the method used to enter multiple numbers in Excel without selecting each cell?

• Drag and Drop

• Copy and Paste

• Select and Enter

• Fill Handle

What is the keyboard shortcut for sorting data in Excel?

• Ctrl + S

• Ctrl + Shift + Z

• Ctrl + Shift + S

• Ctrl + Alt + S

How many levels can you sort by in Excel?

• Up to 50 levels

• Up to 99 levels

• Up to 200 levels

• Up to 100 levels

What is the keyboard shortcut for undo in Excel?

• Ctrl + Z

• Ctrl + Y

• Ctrl + X

• Ctrl + U

Which function is used to find the largest number in a range in Excel?

• MAX

• LARGE

• MAXIMUM

• HIGHEST

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

• Ctrl + N

• Ctrl + W

• Ctrl + I

• Ctrl + Shift + N