Digital Literacy Unit 3 Common Assessment (Mid-term Exam)

What would be a correct formula for SUM in excel?

• =SUM(B3:B9)
• =SUMB3+B9
• SUM(B3:B9)
• =ADD(B3:B9)

Which formula gets the biggest value of a range of cells?

• MAX
• MIN
• LARGE
• SUM

Which formula gets the smallest value of a range of cells?

• MAX
• MIN
• SMALL
• SUM

Which symbol must all formula begin with?

• =
• +
• (
• @

Which of the following formulas is not entered correctly?

• =10+50
• =B7+B8
• =B7+14
• 10+50

Which of the following formulas will Excel not be able to calculate?

• =SUM(Sales)-A3
• =SUM(A1:A5)*0.5
• =SUM(A1:A5)/(10-10)
• =SUM(A1:A5)-10

Columns go...

• Across
• Down

Rows go...

• Across
• Down

Which of these symbols is used for divide on a computer?

• \

• *

• /

• |

A cell name contains

• Cell name
• Column numbers and row letters
• Column letters and row numbers
• Cell locator coordinates