23 terms

# MGSC Tutorial 3 (test 1)

###### PLAY
Syntax
Every Function has to follow a set of rules, or ___ which specifies how the function should be written
Autofill
Copies content and formats from a cell or range into an adjacent cell or range
Date Function
A ___ ___ is used to display the current date
Compound Interest
The interest paid is calculated on the principal and any previous interest payments that have been added to that principal
Insert Function Dialog Box
The ___ ___ ___ ___ organizes all of the functions by category and allows you to search for functions that perform particular calculations
F4 Key
Rather than retyping the formula, you can switch the reference in editing mode by selecting the cell reference and pressing the ___ ___
Nested
Functions can also be placed inside another function, or _____
Interest
_____ is the amount charged for lending money
Mode
To calculate the most common value in data
Relative References
When you enter a formula into a cell, Excel interprets cell references in the formula in relation to the cell's location and when you copy the formula into other cells, Excel applies the same interpretation to the formula's new location
Arguments
____ are the numbers, text, or cell references used by the function to return a value
Mixed References
___ ___ contains both relative and absolute references.
Simple Interest
The interest paid is equal to the percentage of principal for each period that the money has been lent
Logical Function
Function that works with values that are either true or false
Optional Arguments
Not all functions have arguments, and some functions have ___ ____
PMT Function
Use to calculate the payments for any type of loan
Comparison Operator
Is a symbol that indicates the relationship between two values
Financial Functions
___ ___ in Excel calculate values from loans and investments
Absolute references
References that are fixed are called ____ ____
Fill handle
The small black square in the lower-right corner of a selected cell or range is called the ___ ___
Principal
____ is the amount of money being loaned
Median
When data includes a few extremely large or extremely small values, it might be best to use the ____ function
If Function
Logical function that returns one value if the statement is true and returns a different value if the statement is false.