CSC EXAM 3| 50 questions| with complete solutions
Which function calculates the payment of a loan based on constant payments and a constant rate? correct answer: PMT Function Parameters: =PMT(rate, nper, pv) Example: =PMT(D32/12,D33*12,-D34) Which function should you use to find the mean of a list of values? correct answer: Average Function Parameters: =AVERAGE(range) Example: =AVERAGE(A1:A150) Which function should you use to find the middle value in a list of values? correct answer: Median Function Parameters: =MEDIAN(range) Example: =MEDIA(A1:A150) Which function should you use to count the number of non-empty cells? correct answer: CountA Function Parameters: =COUNTA(range) Example: =COUNTA(A1:A150) Which function should you use to find the most frequently occurring number in a list (or range) of numbers? correct answer: Mode Function Parameters: =MODE(range) Example: =MODE(A1:A150) Which function should you use to change the contents of a cell based on a condition or criteria? correct answer: If =IF(logical test, [true value], [false value])
Written for
- Institution
-
Liberty University
- Course
-
CSC
Document information
- Uploaded on
- February 3, 2023
- Number of pages
- 5
- Written in
- 2022/2023
- Type
- Exam (elaborations)
- Contains
- Questions & answers
Subjects
-
csc exam 3| 50 questions| with complete solutions