Search
Browse
Create
Log in
Sign up
Log in
Sign up
Upgrade to remove ads
Only $0.99/month
CompSci exam 1 (chap 2)
STUDY
Flashcards
Learn
Write
Spell
Test
PLAY
Match
Gravity
Key Concepts:
Terms in this set (17)
Syntax
a set of rules that governs the structure and components for properly entering a function
TODAY function
displays the current date
Absolute cell reference
Indicates a cell's specific location; the cell reference does not change when you copy the formula
Argument
an input, such as a cell reference or value, needed to complete a function
MAX function
identifies the highest value in a range
COUNT function
tallies the number of cells in a range that contain values
VLOOKUP function
looks up a value in a vertical lookup table and returns a related result from the lookup table
Lookup table
a range that contains data for the basis of the lookup and data to be retrieved
AVERAGE function
calculates the arithmetic mean, or average, of values in a range
MEDIAN function
identifies the midpoint value in a set of values
NOW function
displays current date and time
IF function
evaluates a condition and returns one value if the condition is true and a different value if the condition is false
SUM function
calculates the total of values contained in one or more cells
PMT function
calculates the periodic payment for a loan with a fixed interest rate and fixed term
Relative cell reference
indicates a cell's location from the cell containing the formula; the cell reference changes when the formula is copied
Mixed cell reference
contains both an absolute and a relative cell reference in a formula; the absolute part does not change but the relative part does when you copy the formula
Logical test
an expression that evaluates to true or false
YOU MIGHT ALSO LIKE...
Excel: Chapter 2
22 terms
Chapter 2
28 terms
Excel Chapter 2 Quiz
26 terms
Excel Ch. 2 - KEY TERMS
18 terms
OTHER SETS BY THIS CREATOR
CompSci 203 Exam 1 (chap 1)
20 terms
HPA 332 Exam 4 Interviewing
5 terms
HPA 332 Exam 4 Motivation
9 terms
HPA 332 Exam 4 Staffing/Controlling
33 terms