Basic Excel
A(n) _________ cell reference remains constant even if the reference is copied or moved to another cell or worksheet.
Absolute
The ______ function is used to calculate the regularly occurring loan payment amount.
What type of chart would you use to show trends over time?
Line Chart
How many IF statements are needed to solve for five outcomes?
Four IF Statements- take the number of outcomes minus 1
True or False: A PivotTable is a data analysis tool that organizes and summarizes large amounts of data
True
A$2 is a _______ cell reference.
Mixed
The ______ function calculates the current value of either lump sum investments or investments involving equal periodic payments.
PV(rate, nper, pmt, [fv], [type])
When data needed for a chart is noncontiguous, what key do you use to help grab the data?
Control Key, Ctrl
What function adds all the numbers in a range of cells based on a single or multiple criteria.
What are the two contextual tabs that appear for a PivotTable?
PivotTable Analyze and Design
How do you center content across a range of cells without merging the cells?
Center Across Selection (Right-Click, format cells, Alignment tab)
True or False: When calculating a payment period's ending balance for a loan amortization, you subtract the Principle Payment and the Interest Payment from the Beginning Balance.
False: The interest payment is what the banks makes. You only subtract the Principle Payment from the Beginning Balance.
True or False: To move a chart Legend, just click and drag to reposition it within the chart.
False. Use the Chart Elements button next to the chart, select Legend, and then select the appropriate position.
What function returns TRUE when at least one test is true.
OR
A _______ allows the user to easily see the current filtering options being applied to the PivotTable data.
Slicer
What function rounds down to the nearest whole number?
INT()
What does the IMPT function calculate?
The interest payment for a given period in a loan based on a constant interest rate and periodic, constant payments.
To adjust where the number at which the Y Axis starts and the number at which the Y Axis ends, what Axis Option would you change?
The Minimum and Maximum Bounds
When do we have to use an INDEX function? (And other LOOKUP functions will not work).
When the data you want to retrieve from the table is to the left of the lookup column.
Numeric fields are often added to which area in the PivotTable Fields Pane?
Values
What are the three arguments of the DATEDIF function?
Start_date or "early date"
End_date or "later date"
Unit or "M", "D", "Y"
What function would you use to calculate the total number of periods in an investment or loan?
NPER(rate, pmt, pv, [fv], [type])
What type of chart would be appropriate to display that Personal Hygiene products account for over half of all sales revenue?
Pie Chart
What function gives you a relative position of a cell in a range?
Where do you go to format the values in a PivotTable?
Value Field Settings (Click on the field name in the PivotTable Fields Pane and then click on Value Field Settings> Number Format)