USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Amanda has created a spreadsheet containing test grades for the first nine weeks. Which function would she use to find the highest test grade?
|
|
MIN
|
|
|
AVERAGE
|
|
|
MAX
|
|
|
SUM
|
Explanation:
Detailed explanation-1: -Another option is to simply type out the formula using the IFS function syntax, =IFS(Logical test1, Value if true, [logical test2, value if true2]…). In the example above, the final formula comes out to IFS(A3>89.99, ”A”, A3>79.99, ”B”, A3>69.99, ”C”, A3>59.99, ”D”, A3>0, ”F”).
Detailed explanation-2: -SUM functions. Probably the most frequently used function in Excel (or any other spreadsheet program), =SUM does just that: It sums a column, row, or range of numbers-but it doesn’t just sum. It also subtracts, multiplies, divides, and uses any of the comparison operators to return a result of 1 (true) or 0 (false).
There is 1 question to complete.