QUIZ TIME!!
A Range!
How would you write a formula to add the contents of cell A6 and D9?
=A6+D9
What is Rule #14?
Proofread the Spreadsheet!
What are Columns identified by?
Letters!
What is the Control Key to go to the beginning of the document?
Ctrl + Home
To Erase all contents of a cell from the keyboard press..
Delete
Formulas always start with???
An Equals Sign!
= = = = = =
What Rows Get 'Merged &Centered'?
Rows 1-4
Numbers in Excel align to which direction?
ALWAYS Left!
What Control Key is used to Print a Document?
Ctrl + P
Microsoft 2010
Where do you type formulas?
The fx Bar!
What is the ONLY Job excluded from adding $$$$$$ ?
Job 44
Where should numbers in your spread sheet need a dollar sign ($) ?
*Hint 3 places*
-FIRST number in each column
-FIRST Row of numbers under each section heading
-EVERY Column total
What is the Control Key used to Undo?
Ctrl + Z
What do you call a formula that changes when copied?
A Relative formula
How do you make a formula Absolute?
F4 Key or add $ to cell
(Example: A$5$)
Where do Bottom Double Borders go?
(2 spots)
Final Column totals OR under the Net Income
Can Numbers be Labels?
YES!! If they do not follow the "How much/How many rule"?
(Ex: 1st Quarter)
Whats the Control Key used to write the Current Date on a Document?
Ctrl + ;
What is Carlos's Dogs name?
(5 artists name)
Otis Vaughan Hendrix of Lennon Berry
Name the mathematical calculation performed on a rang of cells to total the values.
FORMULA
Not all Values Need Decimal Places; Whether or not you remove them depends on...
-Column Headings OR currency Values
(Any cents in the amounts?)
What is the Function of Freeze Panes?
(What does it do?)
Keeps a portion of sheet visible while the rest of the sheet scrolls
What is the Control Key used to Redo an action in a document?
Ctrl + Y