Vocabulary
True or False
Advanced Functions I
Advanced Functions II
Random
100
File that contains one or more spreadsheets.
What is a workbook?
100
A teacher would use the Average function to keep track of test scores and lab work for their students.
What is TRUE?
100
Format applied to 45.78?
What is decimal?
100
Which function would an accounting department use at the top of their spreadsheet that will result in the current date each time the spreadsheet is opened?
What is Now(part of DATE Advanced Function)?
100
Alignment of a main heading usually in Row 1 of a spreadsheet is called this?
What is merge cells?
200
Define fill series.
What is when the computer automatically inserts data into a spreadsheet for you. i.e. employee numbers or dates
200
In the formula =F10*$J$4, F10 is an example of an absolute reference.
What is FALSE (Relative)?
200
If you arrange a spreadsheet so you can view the cell range A1:A10 and Row 3 while you worked on cells in Row158 --- you would apply what function?
What is Freeze?
200
A spreadsheet is created with drop down items that a user can select from -- this is an example of which function?
What is List?
200
What operation would you use to keep rows and columns visible so that they don't scroll off the screen as you move around the worksheet?
What is freeze?
300
Define Relative vs. Absolute cell reference
What is cell value changes as the formula is copied (relative) and the cell value remains static or the same when copied (absolute)?
300
If you were a manager of Walmart and wanted to go over the data for just your department -- You would use the LIST advanced function on your spreadsheet?
What is True?
300
If Walmart wants to maintain inventory and wants to use a formula that will automatically reorder items when they reach a certain quantity -- which spreadsheet function should they use?
What is IF?
300
What function will display the word "Yes" when the value in Cell A1 is greater than the value in Cell B1 and "No" otherwise?
What is IF?
300
Quantity times Unit Price is an example of what?
What is formula?
400
Define Linking and Embedding as is relates to a spreadsheet.
What is when the spreadsheet is updated it will change the document (link) and when the spreadsheet does not change to reflect edits (embed).
400
As a sales manager, you would use the count function to indicated whether a salesperson met the goal of $3,000 in sales for the month.
What is FALSE (IF)?
400
What spreadsheet function should a credit card company use to determine the time that had elapsed since a customer's payment was received?
What is Days360?
400
In the formula =$A1 + B1, $A1 is an example of what?
What is mixed reference?
400
Cells meet a condition set forth in a formula is what advanced function?
What is COUNTIF?
500
Limits data entry to specific choices programmed into a function.
What is a validated list?
500
Purchase discounts are awarded as follows: 3% for sales of $300, 5% for sales of $500 and 9% for sales of $900 or more. You would use the COUNT function to determine which discount is allowed based on the purchase price.
What is FALSE (Lookup)?
500
Which function will result in the total number of entries in the cell range B1:B45?
What is Count?
500
Coach Holtsford sorted the student athletes in order by GPA, last name, first name and IMPACT class. GPA is an example of which part of the sort operation?
What is primary sort?
500
What are formulas, functions, labels and values as they relate to spreadsheets?
What are equations with symbols for math operations (formulas), a shortcut formula (functions), text, symbols, or numbers NOT used in calculations (labels) and numbers used for calculations (values)?
M
e
n
u