What three things, other than math operators (+, -, / *), can you include in a formula? HINT: N, C, F
What is a Numeric constant (numbers), Cell reference (A4), or a Function (AVERAGE).
100
What is the keyboard shortcut to EDIT data that you have already entered into a cell? HINT: A Function key.
What is F2 (EDIT).
100
If you are ready to print the workbook file, where would you go to print it?
What is the File, Print.
100
A spreadsheet is divided into what?
What is rows and columns.
200
Which key, the backslash \ key or slash / key is a valid Excel math operator for division?
What is the slash key / .
200
How can you change the active cell?
What is click in a different cell OR use the arrow keys to move to a different cell.
200
If you wanted to open a workbook file that you created and saved yesterday, how would you open this file?
What is click on File, Open, select the file from the correct location.
200
A spreadsheet is a computerized version of a?
What is an accountant's ledger.
300
=SUM and =AVERAGE are two examples of "predefined computational tasks" and are simply referred to as what?
What are FUNCTIONS.
300
What does an absolute cell reference look like?
What is a cell reference with dollar signs in front of each column letter and row number. e.g.) $E$5
This means if this is copied, the cell reference does NOT change, it remains fixed at the contents of cell E5.
300
All Commands are carried out on a rectangular group of cells called? Hint: R
What is a RANGE.
300
What is the intersection of a row and column called?
What is a cell.
400
The contents of cell C15 is =AVERAGE(C3:C14).
AVERAGE(C3:C14) is known as what? HINT: F
What is a FUNCTION.
400
How can you tell which cell in the entire worksheet, is the "active" cell?
What is the heavy border/outline around the cell, means it is the active cell.
400
When you copy a group of cells, the cells you are copying FROM are called the "source" or "destination" range?
What is the source range.
400
How would I write in a formula to add a range of cells using a function that includes: cell A1, A2, A3, A4 and A5?
What is =SUM(A1:A5).
The range is identified with a colon :
500
List the four commonly used math Excel "operators"?
What is * (multiplication) / (division)
+ (addition) - (subtraction)
500
The cell reference at the intersection of the 5th row and the 7th column is?
What is G5.
500
What type of software is EXCEL?
What is "spreadsheet" software. NOT Word Processing Software! That's Microsoft Word!
500
An Excel workbook contains how many worksheets by default?
What is three for Microsoft Office v.2010 but one for Microsoft Office v.2013. You can add as many sheets as you want to workbook Excel file.