Basics
Modifying/Formatting
Simple/Complex Formulas
Types of Cell References
Sorting/Filtering
100

How do you write the range of two cells. Give an example

A5:C15

100

You can insert columns _______ and _________

left and right

100

How do you always begin a formula

=

100

The default type of cell reference

Relative reference

100

What is descending vs ascending 

descending is z-a and ascending is a-z 

200

A cells address is made up of a _______ column and a ________ row

letter/number

200

To add cell borders what does the tool look like?

 Looks like a window

200

What are the order of operations? List them

Parentheses, exponents, multiplication/division, addition/subtraction

200

Absolute references are creating by using what?

the $ symbol

200

What are the 2 ways you can sort a spreadsheet

Sheet-sorts data by one columns and Range sorts data by a range of cells

300

to move a row/column/cell to a new location you can use the _______ and _______ method

Drag and drop

300

How do you autosize a column or row to fit the content?

Go to the header and double click to two arrows

300

how many operators does a simple formula have? A complex formula?

simple-1 complex more than 1

300

If you are using an absolute reference and you want a specific cell address to remain a constant, where do you put the $?

In front of the column letter and in front of the row number. i.e. $A$14

300

What is a filter and how does it help you find information?

A filter is a way of organizing and viewing information in a spreadsheet.  You can filter info/data so only specific content can be viewed.  it can make finding specific info easier.

400

What is the definition of a spreadsheet?

An application made up of cells that allows you to edit, modify, organize, and analyze data

400

What does merging cells allow you to do?

Combine a cell with one adjacent to it/next to it

400

What are mathematical expressions used to calculate information?

formulas

400

What does the SUM function allow you to do

Add a column or row of numbers. i.e. we added the range of numbers using the SUM function

400

What is the first thing you do in the spreadsheet before you sort?

When sorting data, it's important to first decide if you would like the sort to apply to the entire sheet or to a selection of cells

500

The small square located at the bottom right hand corner of a cell that copies information to other cells is known as the 

Fill Handle

500

This function will automatically modify a cell's row height, allowing the cell contents to be displayed on multiple lines

Wrapping the text

500

Explain the point and click method

When you do not want to manually type in the cell address, you can click on the cell reference when inputting it into your formula.

500

Explain the difference between relative and absolute cell references

Relative references change when copied across multiple cells based on relative positions of rows and columns. Absolute references, there will be a cell reference that remains a constant when the formula is copied to other cells.

500

what are the steps to sorting a range of data

Select a range of data... (A14:G20) ... go to the data tool drop down menu.....go to "sort range".... choose which column you wish to sort by... choose either descending (z-a) or ascending(a-z).

M
e
n
u