Which of the following is a complex formula?
A) =SUM(B4:B8)
B) =(B4/B8) *10
C) =AVERAGE(C6:D6)
D) =MIN(D5:D7)
Correct Answer:
Verified
Q28: When cells are copied using Excel's copy
Q29: You can create an absolute cell reference
Q30: The COUNTA function is used to count
Q32: Once the Office Clipboard reaches its maximum
Q35: After you use the fill handle to
Q36: To insert cells, click the Insert list
Q328: Which formula contains a mixed cell reference?
A)
Q341: An Excel user should use a relative
Q342: Which function key on the keyboard allows
Q344: How can the order of precedence in
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