CGS 2518 QUESTIONS WITH CORRECT ANSWERS

The function =PMT(C5,C7,-C3) is stored in cell C15. What must be stored in cell C5?


Give this one a try later!


Periodic interest rate




You just copied a range of data containing formulas. However, you want to preserve
the formula results and the original number and text formatting in the pasted range.
Which paste option would you select?


Give this one a try later!


Value and Source formatting

, If cell E15 contains the function =PMT(B$15/12,C7*12,-D8), what type of cell reference
is B$15?


Give this one a try later!


absolute




When you start to type =AV, what feature displays a list of functions and defined
names?


Give this one a try later!


Formula AutoComplete




What function would most efficiently accomplish the same thing as =
(B5+C5+D5+E5+F5)?


Give this one a try later!


=SUM(B5:F5)




You hypothesize that there is a relationship between lack of regular exercise and
illness. To research this theory, you have compiled a sample set of data that contains
numbers of days in which an hour or more of exercise is completed as well as
numbers of days sick within a calendar year. What tool in Excel could you use to
investigate the relationships between the data?


Give this one a try later!