Spreadsheets

Question 0

What is a cell?

Answer 0

Cell: a storage area on a spreadsheet.

Question 1

What is a spreadsheet?

Answer 1

●Spreadsheet: a worksheet that presents data in a grid of rows and columns.

Question 2

How do u reference a cell ? What is a cell range? What do we call a referenced cell?

Answer 2

●A cell is referenced by its column letter and row number, a.k.a. cell address
●A group of adjacent cells is referred to as a cell range

Question 3

What can a cell contain?

Answer 3

A cell can contain a
●Number value
●Text value
●Formula

Question 4

What do all formulas in a spreadsheet start with?

Answer 4

●All formulas in Excel worksheets start with an equal sign (=)

Question 5

4 reasons to use formulas.

Answer 5

●Less chance of mistakes
●Easier to understand and implement
●Why do the work, if someone can do it for you?
●Reuse!

Question 6

What does the SUM formula do?

Answer 6

Adds cells together

Question 7

What does the VLOOKUP formula do?

Answer 7

●VLOOKUP – look up a value in a list and retrieve the corresponding values

Question 8

What formula is used o get avg if numbers?

Answer 8

=average (b4:b7)

Question 9

What is an example of an if function

Answer 9

=if (b5)

Question 10

Gove an example of countif. What does it do?

Answer 10

Count if counts a a range if it meets a req. =countif(e5;e9,”=yes”)

Question 11

What symbol references an absolute references?

Answer 11

$$$$$$ absolute

Question 12

What does vlookup do?

Answer 12

Allows you to look up a value in a list and retrieve a corresponding value.

Question 13

Vlookup

Answer 13

False means dont take closest to answer if answer isnt bang on

True means take backup

If more than one take first one

If none and false = unidentified