Finding the maximum,minimum,and average values for a range of cells are all part of the category of functions called ________ functions.
A) logical
B) statistical
C) math & trig
D) financial
Correct Answer:
Verified
Q24: All cell references MUST include a $
Q25: Cell references improve efficiency and flexibility,and allow
Q26: The cells associated with a named range
Q27: SUM,MIN,and MAX are examples of Excel functions.
Q28: The formula below contains a named range.
=SUM($J$5:J$7)
Q30: Arguments are required for all functions.
Q31: The formula below contains a hard-coded value.
=B3*8.85
Q32: Hard-coding values,like sales tax in a formula,is
Q33: Named ranges make formulas easier to read.
Q34: A cell reference allows users to refer
Unlock this Answer For Free Now!
View this answer and more for free by performing one of the following actions
Scan the QR code to install the App and get 2 free unlocks
Unlock quizzes for free by uploading documents