Excel First Quiz

Function to add all numbers in a range of cells

• sum

• add

• plus

• product

Cells are referenced by

• Grid position

• Address

• Column and Row

• Location

= A1 + A2 + A3

is the same as

• =sum(A3)

• =sum(A1) + =sum(A3)

• =sum(A1:A3)

• =sum(A1:C3)

function you would use to count how many times "apple" appears in the list

• countif

• sumif

• counta

• count

Function to add numbers that match criteria in a corresponding column.

• sumif

• countif

• count

• sum

A function can reference a cell or a range of cells

• True

• False

A forumula can contain functions

• True

• False

Every forumla starts with a

• f

• =

• formula

• suma

Symbol for multiplication

• x

• *

• &

• #

Symbol for division

• \

• /

• %

• $