REVIEW

What is the default cell reference style in Excel?

• R1C1
• A1
• ) B2
• C1

Which symbol is used to start a formula in Excel?

• @
• ) =
• #
• $

Which of the following is a function used to find the sum of a range in Excel?

• =SUM()
• =TOTAL()
• =ADD()
• =SUMMATION()

In Excel, which key combination is used to paste content?

• Ctrl + S
• Ctrl + V
• Ctrl + C
• Ctrl + P

What is a "cell" in Excel?

• A single worksheet
• A single row
• A single column
• A single box where you can enter data

Which tab on the ribbon contains the option to insert a chart?

• Insert
• Home
• Data
• Review

Which of the following cell references is an absolute reference?

• A1
• $A$1
• A$1
• $A1

How do you enter the function to calculate the average of cells A1 through A5?

• =MEAN(A1:A5)
• =AVG(A1:A5)
• =AVERAGE(A1:A5)
• =MEDIAN(A1:A5)

In Excel, which feature automatically fills in values based on a pattern you set?

• AutoFill
• Flash Fill
• Quick Fill
• Pattern Fill

Which function would you use to find the largest number in a set of values?

• =MAX()
• =MIN()
• =LARGEST()
• =BIG()