Spreadsheets - C268 Exam Questions
with Solutions
IPMT - -The formula that returns the interest payment for a given period for
an investment based on periodic, constant payments and a constant interest
rate.
- PMT - -One of the financial function formulas which calculate the payment
for a loan based on constant payments and a constant interest rate.
- =IF(AND(E17<=C17,H16>1),"Good Job", - -#1
Use the IF function to complete the "Comments" column of table 1. Display
"Good Job" if both the "Hours Worked" are less than or equal to the
"Estimated Hours" for a project and the assessed "Quality" of that project is
greater than 1. Display "Too Much Time" if the "Hours Worked" on a project
exceed the "Estimated Hours" for that project; otherwise, display "Poor
Quality."
- IF(E17>C17,"Too Much Time","Poor Quality")) - -#2
Use the IF function to complete the "Comments" column of table 1. Display
"Good Job" if both the "Hours Worked" are less than or equal to the
"Estimated Hours" for a project and the assessed "Quality" of that project is
greater than 1. Display "Too Much Time" if the "Hours Worked" on a project
exceed the "Estimated Hours" for that project; otherwise, display "Poor
Quality."
- HLOOKUP - -Searches for a value in the top row of a table or an array of
values, and then returns a value in the same column from a row you specify
in the table or array. Used when your comparison values are located in a row
across the top of a table of data, and you want to look down a specified
number of rows.
- CONCATENATE - -Used to join two or more text strings into one string.
- CORREL - -Returns the correlation coefficient of the Array1 and Array2 cell
ranges. Use the correlation coefficient to determine the relationship between
two properties.
- STDEV - -Estimates standard deviation based on a sample. The standard
deviation is a measure of how widely values are dispersed from the average
value (the mean).
with Solutions
IPMT - -The formula that returns the interest payment for a given period for
an investment based on periodic, constant payments and a constant interest
rate.
- PMT - -One of the financial function formulas which calculate the payment
for a loan based on constant payments and a constant interest rate.
- =IF(AND(E17<=C17,H16>1),"Good Job", - -#1
Use the IF function to complete the "Comments" column of table 1. Display
"Good Job" if both the "Hours Worked" are less than or equal to the
"Estimated Hours" for a project and the assessed "Quality" of that project is
greater than 1. Display "Too Much Time" if the "Hours Worked" on a project
exceed the "Estimated Hours" for that project; otherwise, display "Poor
Quality."
- IF(E17>C17,"Too Much Time","Poor Quality")) - -#2
Use the IF function to complete the "Comments" column of table 1. Display
"Good Job" if both the "Hours Worked" are less than or equal to the
"Estimated Hours" for a project and the assessed "Quality" of that project is
greater than 1. Display "Too Much Time" if the "Hours Worked" on a project
exceed the "Estimated Hours" for that project; otherwise, display "Poor
Quality."
- HLOOKUP - -Searches for a value in the top row of a table or an array of
values, and then returns a value in the same column from a row you specify
in the table or array. Used when your comparison values are located in a row
across the top of a table of data, and you want to look down a specified
number of rows.
- CONCATENATE - -Used to join two or more text strings into one string.
- CORREL - -Returns the correlation coefficient of the Array1 and Array2 cell
ranges. Use the correlation coefficient to determine the relationship between
two properties.
- STDEV - -Estimates standard deviation based on a sample. The standard
deviation is a measure of how widely values are dispersed from the average
value (the mean).
