bitm

Question 1

VLOOKUP function

Answer 1

looks for an accepted value in the left column of a specified table array, and then returns a related value located in the same row

Question 2

xlookup

Answer 2

searches an array and returns the first value matching the specified data

like vlookup XLOOKUP can also return approximate matches if no exact match is found,

it can look up data on either the left or right of table array.

Question 3

syntax

Answer 3

the rules that dictate the structure and components required to perform the necessary calculations.

Question 4

PMT function

Answer 4

calculates payments for a loan with a fixed amount at a fixed periodic rate for a fixed time period.

rate: interest rate per payment period

nper: number of payment periods

pv: present value of the loan (principal)

fv: future value

type: when payments are due

Question 5

IF function

Answer 5

tests specified criteria to see if it is true or false,

then returns one value when a condition is met, and returns another value when the condition is not met

Question 6

What is the difference between column, bar, and line charts

Answer 6

column: displays vertical columns where the height represents the value, used to compares values across categories

bar: same as column but displays category names in an easy-to-read format

line charts: display lines connecting data points to show trends over equal time periods.

Question 7

data point and data series

Answer 7

point: individual value in a cell that is plotted in a chart

series: group of related data points

Question 7

legend

Answer 7

it identifies the color or pattern assigned to each data series

and displays when a multiple series chart is created

Question 8

alt text

Answer 8

a description displayed when the pointer is moved over a chart or image

Question 9

sparkline

Answer 9

A small line, column, or win/loss chart contained in a single cell

Question 10

what is a data table

Answer 10

organizes the results of several what-if analyses within a single table

Question 11

what if analysis

Answer 11

allows you to see how changing variables impacts calculated results

Question 12

goal seek

Answer 12

identifies the necessary input value to obtain a desired goal by changing ONE variable. (backsolve)

Question 13

scenario

Answer 13

a saved set of values in a worksheet allowing you to vary numbers and see potential results