Quiz - MS Excel and MS PPT

What is the keyboard shortcut for opening a new workbook in Excel?

• Ctrl+N

• Ctrl+O

• Ctrl+S

• Ctrl+C

In Excel, what function would you use to find the highest value in a range of cells?

• MAX()

• SUM()

• AVG()

• MIN()

Which tab on the Excel ribbon contains the options for formatting cells?

• Home

• Insert

• Format

• Page Layout

To freeze the top row in Excel, which option would you use?

• Freeze Panes

• Split

• Row Lock

• Top Row

What does the formula "=A1+B1" in a cell represent in Excel?

• Multiply A1 and B1

• Subtract B1 from A1

• Add A1 and B1

• Divide A1 by B1

In Excel, which chart type is best suited for showing the relationship between two variables?

• Line Chart

• Pie Chart

• Bar Chart

• Scatter Plot

How can you protect a sheet in Excel from being edited?

• Lock Cells

• Hide Rows

• Freeze Panes

• Merge Cells

Which Excel function is used to count the number of cells containing numbers within a range?

• COUNT()

• SUM()

• AVERAGE()

• MAX()

What does the term "VLOOKUP" stand for in Excel?

• Vertical Lookup

• Value Lookup

• Variable Lookup

• View Lookup

Which keyboard shortcut is used to autofill data in a selected range in Excel?

• Ctrl+C

• Ctrl+V

• Ctrl+R

• Ctrl+E