Wgu C268 Spreadsheets Formulae Practice Test Correctly Solved A+

LEN function {Ans: LEN (text) - returns the length, in number of characters, of a block of text =LEN(text) The block of text or reference to the cell that contains the block of text}COUNTIF function {Ans: Determine (count) the number of cells within a range of cells that contain a specific value. =COUNTIF(range,criteria) The range of cells within which to count the number of matches, the specific value to match the cells in the specific range}FORECAST function {Ans: Calculates, or predicts, a future value along a linear trend by using existing values. =FORECAST(X, known_y's, known_x's) Independent variable, or the value used to predict the Y variable, the set of values that corresponds to all the values for Y, the set of values that corresponds to a of the values for X.}MID function {Ans: MID(text,start_num,num_chars) - returns a specified number of character from the middle of a block of text =MID(text, start_num, num_chars) The cell reference that contains the block of text, the location of where to begin returning characters from the block of text, this number of characters to return}PMT function {Ans: calculates the periodic payment for a loan with a fixed interest rate and