Functions
Function that adds a group of cells together and then divides by how many cells were in the range
What is Average
In Excel, to combine data on multiple worksheets and display the result on another worksheet
What is Consolidation
The amount you make before deductions are taken out
What is Gross Pay
What was the first company that used Santa Claus in advertising
What is The Coca-Cola Company.
God bless us, every one!
What is a Christmas Carol
function that returns only the current date, which updates each time a worksheet is opened
What is the Today Function
In Excel, a feature that lets you enter a number in the same cell through all selected worksheets
What is Drilling an Entry
The amount you make after deductions are taken out
What is Net Pay
What is the highest grossing Christmas movie of all time?
What is Home Alone
Merry Christmas you filthy animal.
What is Home Alone 2
Name the 3 functions in the IF function
What is Logical Statement, True, False
A range that spans two or more worksheets in a workbook
What is a 3-D Range
The amount the borrower still has left to pay on the loan
What is principal
What toy does Buddy the Elf not like?
What is a Jack in the Box
You have such a pretty face, you should be on a Christmas card.
What is Elf
financial function that calculates the payment schedule required to repay a loan based on constant payments and a constant interest rate.
What is the PMT Function
A series of symbols used to describe exactly how Excel should display a number, date, time, or text string
What is Format Code
The percentage that the bank charges to borrow money
What is the interest rate
What were Frosty the Snowman's last words?
What is "I'll be back again someday!"
I want my house to be seen from space!
What is Deck the Halls
In the PMT Function, the PV argument stands for what
What is Present Value
Schedule that shows the beginning and ending balances of a loan and the amount of payment that is applied to the principal and interest during each payment period
What is an amortization schedule
A cell reference that does not change when being copied throughout a sheet
What is an absolute reference
In Home Alone, where are the McCallisters going on vacation when they leave Kevin behind?
Where is Paris
Seeing isn't believing. Believing is seeing.
What is the Santa Clause