USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Where can you find the command for Excel to calculate the MAX value into cell G2?
|
|
by selecting the AutoSum button (∑) at the top left of the ribbon
|
|
|
by selecting the Insert function (ꝭꭓ) at the top right of the ribbon
|
|
|
by right-clicking in cell G2 beneath Max in cell G1
|
|
|
by selecting the arrow under the AutoSum button (∑) at the top left of the ribbon
|
Explanation:
Detailed explanation-1: -Excel MIN and MAX Functions. Find lowest and highest numbers with Excel MIN and MAX functions. For minimum and maximum with criteria, use with IF function, to create MIN IF and MAX IF formulas, or use MINIFS and MAXIFS in Excel 365.
Detailed explanation-2: -If you need to sum a column or row of numbers, let Excel do the math for you. Select a cell next to the numbers you want to sum, click AutoSum on the Home tab, press Enter, and you’re done. When you click AutoSum, Excel automatically enters a formula (that uses the SUM function) to sum the numbers.
There is 1 question to complete.