MS EXCEL REVIEW

What is the cell reference located at column D and row 8?

• D8

• 8D

• Row8ColD

• D_8

Which function adds up all numbers in a range of cells?

• SUM

• COUNT

• ADD

• TOTAL

If cell A1 contains 10 and B1 contains 20, what is the result of =A1+B1?

• 30

• 10

• 20

• 200

Which of the following refers to a single box where a row and column intersect?

• Cell

• Column

• Row

• Range

Which formula correctly finds the average of cells A1 to A5?

• =AVERAGE(A1:A5)

• =AVG(A1:A5)

• =SUM(A1:A5)/A5

• =AVERAGE(A5:A1)

What will the formula =IF(A1>50, "Pass", "Fail") return if A1 = 60?

• Pass

• Fail

• 60

• TRUE

What is the column letter of the cell located before column D?

• C

• E

• B

• F

What is the main purpose of a formula in Excel?

• To calculate data automatically

• To store images

• To change font styles

• To sort text alphabetically

If you type =SUM(A1:A3)*2, which operation happens first?

• SUM

• Multiplication

• Division

The first cell in a worksheet is located at:

• A. A1

• B. 1A

• C. A0

• D. 0A