Excel Flashcards

0.0(0)
Studied by 0 people
linked notesNote
call kaiCall Kai
learnLearn
examPractice Test
spaced repetitionSpaced Repetition
heart puzzleMatch
flashcardsFlashcards
GameKnowt Play
Card Sorting

1/9

encourage image

There's no tags or description

Looks like no tags are added yet.

10 Terms

1
New cards

What does the SUM() function do in Excel?

Adds numbers.

2
New cards

How do you use the AVERAGE() function in Excel?

=AVERAGE(B1:B5) calculates the average of values from B1 to B5.

3
New cards

What is the purpose of the IF() function in Excel?

Returns one value if a specified condition is true, and another if false.

4
New cards

What does the TODAY() function return?

Returns today’s date.

5
New cards

How does the CONCATENATE() function work in Excel?

Joins multiple text strings into one.

6
New cards

Explain the VLOOKUP() function.

Finds a value in a table and returns a corresponding value from a specified column.

7
New cards

What is the combination of INDEX() and MATCH() used for?

More flexible lookups than traditional functions.

8
New cards

What is the function of SUMIF() in Excel?

Adds numbers based on a specified condition.

9
New cards

What does XLOOKUP() do?

Easier replacement for VLOOKUP, allowing for searches across data.

10
New cards

What are PivotTables used for in Excel?

To summarize data quickly by dragging and dropping fields to calculate totals and averages.