Spreadsheets

What spreadsheet techniques allows us to update values in other worksheets automatically?

• Linking cells / worksheets
• Conditional formatting
•  correct formatting of data types

What value will this function produce if cell B3 = 62
=ROUNDUP(B3/40, 0)

• 2
• 1.5
• 1.6
• 1

What function would allow us to display a message on the screen if a particular value was entered in a cell and a different message if that value was not entered

• IF
• SUM
• AVERAGE
• ROUNDUP

A location on a spreadsheet that accepts a single item of data

• Chart
• row
• cell
• column

A group of selected cells is called a

• field
• range
• row
• group

A number format that adds a monetary symbol and decimal places. Appropriate when working with amounts of money.

• currency
• percent
• number
• scientific

What is the name of this cell?

• B10
• 5B
• B5
• you cannot know the name from this picture

Putting cells in order based on their contents is called..

• Sorting
• Filtering
• Numbering
• Identifying

What function should be entered to calculate the total budget?

• =AVERAGE(B3:B6)
• =SUM(B3:B6)
• =SUM(B3-B6)
• =TOTAL(B3:B6)

What is the operator symbol for in this formula?   =E5*A2

• adding
• subtracting
• multiplying
• dividing