Spreadsheet Basics and Functions

Front

A collection of sheets in which each sheet is a grid comprised of rows and columns.

Back

spreadsheet

Front

Singe grid located at the intersection of a row and column

Back

cell

Front

Column names that are stored in the first row and used as identifiers for the data

Back

heading

Front

Where is Bob's first name located? Options: Row A, Column 6, Cell A6, Cell 6A

Back

Cell A6

Front

How do you add a new sheet to your spreadsheet?

Back

Click the + symbol at the bottom left of the sheet.

Front

How do you type a range of cells?

Back

A2 : A30

Front

This function adds up all the values in a specified range

Back

=SUM

Front

This function shows you how many items you have in a range. Options: =SUM, =count, =mean, =STDEV

Back

=count

Front

This function organizes a range of numbers and shows you the middle number.

Back

=median

Front

How do you type a function for just counting values in a range that are positive?

Back

=countif(A2:A30 , ">0")