Computer Applications Final

Front

Which of the following is NOT a name for the cell shown: Cell Reference, Active cell, B5, Location?

Back

Location

Front

Which of the following is a correct cell reference? 6N, 22-X, Y:10, AB1

Back

AB1

Front

Which range is correctly formatted? A2:A18, B1-C1, A5-D1, A16 to J14

Back

A2:A18

Front

Which of the following is a properly formatted FORMULA?
Options:
=SUM(A3:45),
=MAX(A3:A98),
=(A4-G4)/J5,
A1-5

Back

=(A4-G4)/J5

Front

Which of the following is a properly formatted FUNCTION? Options: =(A1+J1)/4, MIN(A16+B12), =A1*B2, =MAX(A5:AA5)

Back

=MAX(A5:AA5)

Front

If I wanted to add A3 and B3, then add A4 and B4, and then divide the two results, how would I type that in Excel?

Back

=(A3+B3)/(A4+B4)

Front

What would you enter into C5 to add all the numbers together, using a FUNCTION?

Back

=SUM(A1:A5)

Front

Which feature was NOT used to make Figure A look like Figure B? Options: Wrap Text, Gradient Fill, Align Right, Merge & Center

Back

Merge & Center

Front

Looking at the figure, what column was the information sort by first, then second, then third? Options:

# of F's, Name, Grade

, Grade, # of F's, Home Room, Home Room, Grade, Name, Name, # of F's, Home Room, Home Room, Name, Grade

Back

Home Room, Grade, Name

Front

What is the name of this? Options: Autofill, Fill Handle, Drag Handle, Pull Down

Back

Fill Handle