ISTM 210 Exam 2- Excel Questions with 100% Correct Answers

ISTM 210 Exam 2- Excel Questions with 100% Correct Answers Fill Feature - answerAllows you to automatically populate cells in a worksheet Series Feature - answerAllows you to complete a pattern within a range of cells Freeze Pain Feature - answerAllows you to lock rows and columns when you navigate through a data table Sorting Feature - answerAllows information on the table to be presented in an organized fashion Filtering Feature - answerAllows you to display only specific information on a data table Relative cell reference - answercells automatically update when a formula is pasted into those cells Absolute cell reference - answercells reference remains constant when a formula is pasted into a new cell What does the function wizard allow you to do? - answer-Allows you to enter or select inputs -provides a description of the function and each argument -Lists function results (outputs) What are the 6 statistic functions? - answerSum Count CountA Average Max MIn Sum Function - answer=SUM(number1, [number2]) The SUM function adds all data in a range of cells Count function - answer=COUNT(value1, [value2]) Counts the number of cells in range of cells that contain numbers CountA function - answer=COUNTA(value1, [value2]) Counts the number of cells in a rang eof cells that are not blank Average function - answer=AVERAGE(number1, [number2]) Calculates the simple average of a set of numbers Max and Min function - answer=MAX(number1, [number2]) Reports the largest value in set of numbers =MIN(number1, [number2]) Reports the smallest value in a set of numbers Time value of money - answerRecognizes that a dollar earned today is worth more than a dollar earned next year. -Can earn a years worth of interest on money earned today Compounding Interest - answerThe more times per year I am charged interest on a loan, the more money i have to pay What are the 6 financial functions? - answerRate Effect NPER PMT PV FV Rate Function - answer=Rate(nper, pmt, pv, [fv], [type], [guess]) Returns the interest rate per period for a loan or an investment Effect function - answer=EFFECT( nominal_rate, npery) Returns the effective annual interest rate NPER function - answer=NPER(rate, pmt, pv, [fv], [type]) Returns the number of periods for an investment based on periodic, constant payments and a constant interest rate.