Exam III review Flashcards
Which function should you use to count the number of cells in a range that contain numbers?
count
What feature should you use to find the right input when you know the result you want?
Goal Seeking
Which function calculates the payment of a loan based on constant payments and a constant rate?
pmt
Which function should you use to find the mean of a list of values?
average
Which function should you use to find the middle value in a list of values?
median
Which function should you use to count the non-empty cells?
counta
Which function should you use to change the contents of a cell based on a condition or criteria?
if
Which function should you use to find the most frequently occurring number in a list (or range) of numbers?
mode
Which function should you use to have information returned from a table?
vlookup
What feature should you use to change the appearance of a cell based on a criteria?
conditional formatting
Which function should you use to eliminate the decimal portion of a number?
trunc
Which function should you use to display the date and time?
now
Which function should you use to find the lowest number in a range?
min
Which function should you use to find the highest number in a range?
max
Which function should you use to display the date?
today
Which function should you use to count cells based on a criteria?
countif
Which function should you use to return the sum of the products of corresponding ranges or arrays?
sumproduct
Which function should you use to join several text strings into one text string?
concatenate
A cell’s unique address is its ________.
cell reference
The default view in Excel.
Normal View
by default Text is ____ aligned.
left
by default Numbers are _____ aligned.
right
Which feature would you use to join several selected cells into one cell?
merge
A prewritten formula that is built into Excel is a _______.
function
