Excel 5 Flashcards Preview

Data Management 1 > Excel 5 > Flashcards

Flashcards in Excel 5 Deck (17):
0

What does the function PROPER do

Capitalizes the first letter of text strings

1

What does the function CONCATENATE do

Joins two or more text strings

2

What is the function that converts all text to uppercase? The one for lowercase?

UPPER uppercase
LOWER lowercase

3

What does the function SUBSTITUTE do

Replaces text in a text string

4

What is a delimiter

A separator that should separate your data

5

What function totals cells in a range meeting a given criteria

SUMIF

6

What does COUNTIF do

Counts cells Ina range based on a specified condition

7

What does AVERAGEIF function do

Averages cells In a range based On a specified condition

8

What is a 3D reference

Referencing other sheets in a workbook

9

What function simplifies error checking. Hint: users specify message or value for error display

IFERROR

10

A cell with a circular reference contains a formula that refers to ______

It's own cell location

11

What are the three parts to an IF function

1. Logical test or condition
2. Result if test is true
3. Result if test is false

12

What will the OR function return as if the arguments are true

TRUE

13

What does the NOT logical function do

Reverses the value of its argument

14

What does PMT do

Calculates periodic payment amount for money borrowed

15

What are the main parts of the PMT function

1. Interest rate; rate
2. Term or number of payments; nper
3. Loan value: pv

16

What does the FV (future value) function do

Determines the amount of money a given monthly investment will amount to, at a given interest rate, after a given number of payments

FV(rate, nper, pmt, ph, type)