QUIZ TIME!!
A Selection of 2 or more cells is called ?
A Range!
How would you write a formula to add the contents of cell A6 and D9?
=A6+D9
What are the lines around a cell called?
Border
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 do you call a group of worksheets?
Workbook
Where a column and row meet is called a?
CELL
What Control Key is used to Print a Document?
Ctrl + P
What are three types of numbers that you can format your cell for?
- General
- Number
- Currency
- Accounting
=AVERAGE(A1:B1) is an example of a?
Formula
What information does the NAME box show?
A workbook can contain multiple...
Worksheets
What is the Control Key used to Undo?
Ctrl + Z
What type of charts or graphs can you use in Excel?
- Pie
- Bar
- Line
- Scatter
A Function that adds up values in cells.
Auto Sum
Where do you type formulas?
The Formula (fx) bar
What does it mean if a cell shows #### signs instead of your data?
Cell is not wide enough to fit the data.
Whats the Control Key used to write the Current Date on a Document?
Ctrl + ;
_______________ allows us to see our data alphabetically or in numerical order.
Sort and Filter
Name the mathematical calculation performed on a rang of cells.
FORMULA
Selecting a cell and copying the formula to other cells is called?
Cell Fill
What three pieces of information does Excel give you (at the bottom of your workbook) when you select a range of cells?
- Average
- Count
- Sum
What is the Control Key used to Redo an action in a document?
Ctrl + Y