USING MICROSOFT EXCEL
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
What is the formula to find the lowest number in cells C1:C4?
|
|
=average(C1:C4)
|
|
|
=max(C1:C4)
|
|
|
=min(C1:C4)
|
|
|
=sum(C1:C4)
|
Explanation:
Detailed explanation-1: -Formulas calculate values in a specific order. A formula always begins with an equal sign (=). Excel for the web interprets the characters that follow the equal sign as a formula. Following the equal sign are the elements to be calculated (the operands), such as constants or cell references.
Detailed explanation-2: -Using a formula like: =SUM(A1, A2, A3, B1, B2, B3)
There is 1 question to complete.