Spreadsheet Modeling

In this diagram what does the selected area represent?

• a Row
• a Cell
• a Column
• a Chart

What is the cell range in this diagram?

• A1:F1
• A1:A8
• A1:F8
• A1:1A

Which symbol must all formula begin with?

• =

• +

• (

• @

A group of cells is called a ________.

• cell cluster

• multicell

• cell range

• chart

Which formula below is valid?

• =R2*D2

• A3+100

• F2+F3+F4-53

• =5B+6B

to count any fields containing numbers we use:

• countIF function

• counta function

• count function

• countIFs function

What function was used to find the lowest grade?

• average

• sum

• min

• max

A _________ is a prewritten formula that is built into EXCEL.

• function

• problem

• equation

• equal sign

What does the Max formula do?

• Returns the highest three values in a set of values and ignores text.

• Returns the largest value in a set of values and ignores text.

• Returns the text that you are searching for.

• Returns the smallest value in a set of values and ignores text.

Which operator is used to multiply in Excel?

• +

• -

• /

• *