STM 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. PMT function - answer=PMT(rate, nper, pv, [fv], [type]) Calculates the payment for a loan based on constant payments and a constant interest rate PV function - answer=PV(rate, nper, pmt, [fv], [type]) Returns the present value of an investment: the total amount that a series of future payments is worth now. FV function - answer=FV(rate, nper, pmt, [pv], [type]) Returns the future value of an investment based on periodic, constant payments and a constant interest rate. What are the 3 troubleshooting features? (Formula auditing) - answer1. Trace precedents 2. Trace dependence 3. Show formula Trace Precedents feature - answerAllows you to see which cells are referenced in a particular formula or function -what is present in that current cell Trace Dependents feature - answerAllows you to see which other cells are referencing a particular cell -What is dependent on that current cell Show formula feature - answerDisplays the functions and formulas used in each cell of a worksheet instead of formula function results Who developed boolean algebra? - answerGeorge Boole in the 1800's Boolean logic is based on two values 0 and 1, what do these mean in excel? - answerFalse and True respectively What is used to combine boolean expressions? (two) - answerAND operator OR operator AND operator - answerDetermines if ALL combined boolean expressions are TRUE OR operator - answerDetermines if ANY of the combined boolean expressions are True