Excel Skills Quiz

What is the keyboard shortcut to copy selected cells in Excel?

• Ctrl+C

• Ctrl+X

• Ctrl+V

• Ctrl+Z

How would you freeze the top row of a spreadsheet in Excel?

• Freeze Panes

• Lock Row

• Split Cells

• Row Freeze

Which function is used to add up a range of cells in Excel?

• COUNT

• SUM

• AVERAGE

• MAX

In Excel, what does the term 'cell reference' refer to?

• The address of a cell

• The content of a cell

• The color of a cell

• The formula in a cell

What does the formula =A1+B1 do in Excel?

• Multiplies the values in cells A1 and B1

• Divides the values in cells A1 and B1

• Adds the values in cells A1 and B1

• Subtracts the value in cell B1 from A1

Which Excel function is used to search for a specific value in a range and return its relative position?

• VLOOKUP

• HLOOKUP

• INDEX

• MATCH

How would you create a pie chart in Excel?

• Insert > Chart > Pie Chart

• Data > Pie Chart

• Format > Pie Chart

• Chart > Pie Chart

What is the purpose of the IF function in Excel?

• Count cells

• Perform logical tests

• Sum a range

• Create charts

What does the term 'data validation' refer to in Excel?

• Checking for errors in formulas

• Restricting data entry to a specific type or range

• Sorting data alphabetically

• Merging cells

Which Excel feature allows you to see a preview of how your printed worksheet will look?

• Page Layout View

• Print Preview

• Worksheet View

• Page Break Preview