Managing Data in Excel Microsoft 365 for Windows
Which formulas can be combined with the NOT formula in order to determine a logical value?
-IF -OR
Which information is needed to calculate the NPER formula?
-Payment -Loan amount -Rate
Which formula enables you to calculate the average for more than one criteria?
AVERAGEIFS
Which tab contains the import text file tool?
Data
Which formula can be used to find the value in a set of coordinates?
INDEX
Which formula enables you to find the largest value in a range based on one or more criteria?
MAXIFS
Which tab enables you to edit an imported .csv file?
Query
Which formula enables you to show a result with no exact match?
SWITCH