Managing Data in Excel Microsoft 365 for Windows

¡Supera tus tareas y exámenes ahora con Quizwiz!

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


Conjuntos de estudio relacionados

Silvestri Maternity Practice NCLEX questions

View Set

Mastering Biology: 6 and 7 review

View Set

AEMT QUIZs prt1 chptrs 3,4,5,6,7,8,9,10,11,13,15,17,19,26,27,29,30,32,33,34,36

View Set

Chapter 1.1-1.4 homework answers

View Set

Chapter 13: Using Interpersonal Communication Skills in Conversations and Meetings

View Set

AP Biology Quiz (Chapter 22, 23, 24, 25)

View Set