Chapter 8: Spreadsheets

Question 1

active cell

Answer 1

any cell that you have selected and highlighted in your spreadsheet

Question 2

range

Answer 2

More than one active cell

Question 3

non-continuous range

Answer 3

Range with a break in there somewhere

Question 4

Referencing Data

Answer 4

=Sheet1!A2

Sheet name then cell

Question 5

If Microsoft Excel is not filling the way you’d like click

Answer 5

edit->fill->series

Question 6

A __ in front of the column or row number will keep the column or row reference constant

Answer 6

”$”

Question 7

To reference a range of cells

Answer 7

Use Starting_cell:Ending_cell

ie: A1:B3,B6:C7 (A non-continuous range of cells)

Question 8

How do you write an if statement?

Answer 8

=if(condition,value_if_true,value_if_false)

If the given condition is true, the cell will be set to the “value_if_true.” If the condition is false, the cell will be set to the “value_if_false,” if “value_if_false” is left blank, the cell will be set to “FALSE” by default.
Example:

=if(A2>3,32,”Number too small”)

Reads: If A2>3 is true, then set the cell to 32. Otherwise, set the cell to “Number too small”

Question 9

How do you write a nested IF function?

Answer 9

IF( condition1, value_if_true1, IF( condition2, value_if_true2, value_if_false2 ))

Question 10

How do you write a countif statement?

Answer 10

=countif(range,condition)

The “countif” function will increment the active cell by one each time the condition is true for a cell in the given range.

Example:
You want to know how many universities have “red” as one of their school colors, and have compiled a database of schools and their colors in Excel.

=countif (F1:F230, “=red”)
If a cell in F1:F230 satisfies “=red”, then increment the active cell by one.

Question 11

How do you write sumif functions

Answer 11

=sumif(range,condition,sum_range)

The “sumif” function utilizes a range and a corresponding sum_range of the same size. Each time the condition is true, the active cell will be incremented by the value in the corresponding cell in the sum_range.

Example:
You wish to know how many hours you have spent watching television, from a database of your time spent on various activities.

=sumif (D1:D230,”=television”, H1:H230)

If a cell in D1:D230 satisfies “=television”, then increment the active cell by the corresponding cell from H1:H230. If cell D7 contains the word “television,” the active cell will be incremented from the corresponding cell from H1:H230, or cell H7

Question 12

and or

Answer 12

These should be nested inside of conditional statements.