Excel Assessment 2

What is the shortcut to save a workbook in Excel?

• Ctrl + S

• Ctrl + C

• Ctrl + V

• Ctrl + X

How do you start a formula in Excel?

• #

• $

• @

• =

Which function is used to find the average of a range of numbers in Excel?

• SUM

• AVERAGE

• MIN

• MAX

What is the result of the formula =SUM(2, 4, 6)?

• 10

• 12

• 8

• 14

Which symbol is used to lock cell references in Excel?

• &

• %

• $

• #

Which feature allows you to quickly fill cells with a series of numbers or dates?

• AutoFill

• Flash Fill

• Series Fill

• Quick Fill

How do you insert a new worksheet in an Excel workbook?

• File > New Worksheet

• Insert > New Worksheet

• Right-click a worksheet tab and select Insert

• Home > New Worksheet

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

• MIN

• MAX

• LARGE

• BIG

What does the CONCATENATE function do?

• Adds numbers

• Joins text strings

• Finds the average

• Subtracts numbers

Which chart type is best for showing trends over time?

• Pie Chart

• Column Chart

• Line Chart

• Bar Chart