How do you write the range of two cells. Give an example
A5:C15
You can insert columns _______ and _________
left and right
How do you always begin a formula
=
The default type of cell reference
Relative reference
What is descending vs ascending
descending is z-a and ascending is a-z
A cells address is made up of a _______ column and a ________ row
letter/number
To add cell borders what does the tool look like?
Looks like a window
What are the order of operations? List them
Parentheses, exponents, multiplication/division, addition/subtraction
Absolute references are creating by using what?
the $ symbol
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
to move a row/column/cell to a new location you can use the _______ and _______ method
Drag and drop
How do you autosize a column or row to fit the content?
Go to the header and double click to two arrows
how many operators does a simple formula have? A complex formula?
simple-1 complex more than 1
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
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.
What is the definition of a spreadsheet?
An application made up of cells that allows you to edit, modify, organize, and analyze data
What does merging cells allow you to do?
Combine a cell with one adjacent to it/next to it
What are mathematical expressions used to calculate information?
formulas
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
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
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
This function will automatically modify a cell's row height, allowing the cell contents to be displayed on multiple lines
Wrapping the text
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.
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.
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).