Coverage

Click the underlined text to jump directly to the assessment for further details.

Assessments with Excel Basic Features

Excel Basics	Assessment
Copy and paste	Address Book, Financial Ratios, QuickStove Sales Tax, Credit Card, Business Sales for Weekend Donut Shop, List of Names, Soccer Penalty, Calculate Letter Grade
Data Validation	Purchasing a Car
Entering Data	QuickStove Basic Model,Forecasting, Risk and Return, Capital Budgeting Criteria, Capital Budgeting, Amortization with skipped payment, Amortization 30 vs 15, Purchasing a Car, Calculate Letter Grade
Fill feature	Address Book, Amortization with skipped payment, Amortization 30 vs 15, Exponential Projection
Filter	Address Book, Phone Bill, Business Sales for Weekend Donut Shop, Early Semester Report
Group sheets	Finance Statements, Business Sales for Weekend Donut Shop
Hide column	Address Book, LV Firefighter Buybacks, LV Firefighter Overtime
Insert column	Address Book
Insert Worksheet	Business Sales for Weekend Donut Shop
Multi level sort	Address Book, List of Names
Resize columns	Address Book, Finance Statements, Financial Ratios, Early Semester Report
Sort	Phone Bill, Early Semester Report

Assessments with Cell Formatting

Format	Assessment
Bold	Address Book, Finance Statements, Financial Ratios, Early Semester Report
Borders	Address Book, Finance Statements, Financial Ratios, Early Semester Report
Center	Address Book, Phone Bill, Early Semester Report
Conditional Formatting	Phone Bill, Sales Weekend Donut Shop, Course Statistics, Movies (Conditional Formatting)
Fill color	Address Book, Finance Statements, Financial Ratios, Sales Weekend Donut Shop, Early Semester Report
Font Face	Phone Bill
Font Size	Phone Bill
Format date	Address Book
Format Numbers	Finance Statements, Financial Ratios, Phone Bill, Experiment Time, Future Dates, LV Firefighter Buybacks, Early Semester Report
Indent	Finance Statement
Italics	Address Book, Financial Ratios
Merge cells	Finance Statements, Phone Bill, Early Semester Report
Wrap text	Address Book

Assessments with Formulas

Formula	Assessment
Formulas	Address Book, QuickStove Transaction, QuickStove Purchasing and Investing, QuickStove Sales Tax, QuickStove Basic Model, QuickStove Modeling, QuickStove Statistics, Finance Statements, Forecasting, Bond Valuation, Stock Valuation, Risk and Return, Cost of Capital, Leverage, Capital Budgeting Criteria, Capital Budgeting, Firm Valuation, Gradebook, Credit Card, Sales Weekend Donut Shop, Buy vs Lease, Triple Race, Future Dates, LV Firefighter Buybacks, LV Firefighter Overtime, Course Statistics, Fitness Center, Amortization with skipped payment, Amortization 30 vs 15, Stock Gift, Credit Payoff, Purchasing a Car, Exponential Projection, Calculate Letter Grade, Pick a Meal Plan, Small Loan
Absolute references	QuickStove Sales Tax, QuickStove Basic Model, QuickStoveModeling, Finance Statements, Risk and Return, Leverage, Capital Budgeting, Credit Card, LV Firefighter Buybacks, LV Firefighter Overtime, Course Statistics, Amortization with skipped payment, Amortization 30 vs 15, Stock Gift, Credit Payoff
Boolean formula	QuickStovePromotions
Date aritmatic	QuickStove Shipment Tracker, Project Date
Named range	Sales Weekend Donut Shop
Reference data on another sheet	Finance Statements
Time arithmatic	Experiment Time

Assessments that contain Functions

Function	Assessment
ABS	Bond Valuation, Capital Budgeting Criteria
AND	Soccer Penalty
AND and OR same expression	QuickStovePromotions
AVERAGE	QuickStoveTransaction, QuickStove Statistics, QuickStove Employee Performance, Risk and Return, Phone Bill, Salary by Major, LV Firefighter Buybacks, LV Firefighter Overtime, Course Statistics
AVERAGEIF	QuickStoveEmployeePerformance, Instructor Experience
CONCAT	QuickStoveShippingCosts, Phone Bill, List of Names, Fitness Center
CONFIDENCE.NORM	QuickStove Statistics, Course Statistics
CORREL	QuickStove Statistics, Risk and Return, Course Statistics
COUNT	QuickStove Transaction, QuickStove Statistics, Salary by Major, Course Statistics
COUNTA	QuickStove Transaction, Fitness Center
COUNTIF	Production Estimation, Phone Bill, Gradebook, Fitness Center, Instructor Experience
COVARIANCE.S	Risk and Return
DAYS	QuickStoveShipmentTracker, Project Date
EFFECT	QuickStove Purchasing And Investing, Time Value of Money, Saving Money
FORECAST.LINEAR	QuickStoveStatistics, Course Statistics
FV	QuickStove Purchasing And Investing, Time Value of Money, Saving Money
HLOOKUP	QuickStove Shipping Costs, QuickStove Employee Performance, Instructor Experience
HOUR	QuickStove Shipping Log, Experiment Time
IF	QuickStove Sales Tax, QuickStove Basic Model, Cost of Capital, Phone Bill, Credit Card, Triple Race, Future Dates, Fitness Center, Purchasing a Car
INDEX	Fire 42
IRR	Capital Budgeting Criteria, Capital Budgeting
LEFT	QuickStove Shipping Log, Phone Bill, List of Names, Fire 42
LEN	QuickStove Shipping Log, List of Names
MATCH	Fire 42
MAX	QuickStove Transaction, Credit Card, Salary by Major, Fire 42
MEDIAN	Salary by Major
MID	QuickStove Shipping Log
MIN	QuickStove Transaction, QuickStove Basic Model, QuickStoveModeling, Salary by Major, Fire 42, LV Firefighter Overtime, Credit Payoff
MINUTE	QuickStove Shipping Log, Experiment Time
MONTH	QuickStove Shipment Tracker, Project Date
NETWORKDAYS	Project Date
NOT	QuickStove Promotions
NOW	QuickStove Shipment Tracker, Soccer Penalty
NPER	Time Value of Money, Credit Card, Saving Money
NPV	Time Value of Money, Capital Budgeting Criteria, Capital Budgeting
OR	QuickStove Promotions, Phone Bill, Soccer Penalty
PMT	QuickStove Purchasing And Investing, Time Value of Money, Capital Budgeting Criteria, Buy vs Lease, Amortization with skipped payment, Amortization 30 vs 15, Purchasing a Car, Saving Money
PRODUCT	Leverage
PV	QuickStove Purchasing And Investing, Time Value of Money, Not Found, Bond Valuation, Stock Valuation, Saving Money
RATE	QuickStove Purchasing And Investing, Time Value of Money, Cost of Capital, Capital Budgeting Criteria, Saving Money
RIGHT	QuickStove Shipping Log, Phone Bill, List of Names, Fire 42
SEARCH	QuickStove Shipping Log, List of Names
SECOND	Experiment Time
SQRT	Risk and Return
STDEV.P	QuickStove Statistics
STDEV.S	Risk and Return, Course Statistics
SUM	QuickStove Transaction, QuickStove Sales Tax, QuickStove Employee Performance, QuickStove Modeling, Finance Statements, Forecasting, Capital Budgeting, Phone Bill, Gradebook, Credit Card, Sales Weekend Donut Shop, Triple Race, LV Firefighter Buybacks, LV Firefighter Overtime, Amortization with skipped payment, Amortization 30 vs 15, Stock Gift, Credit Payoff, Pick a Meal Plan
SUMIF	QuickStove Employee Performance, Phone Bill, Sales Weekend Donut Shop, Instructor Experience
SUMIFS	Fitness Center
TODAY	QuickStove Shipment Tracker, Project Date, Fitness Center
VLOOKUP	QuickStove Shipping Costs, QuickStoveEmployeePerformance, QuickStove Modeling, Gradebook, Sales Weekend Donut Shop, Triple Race, Calculate Letter Grade, Instructor Experience
WEEKDAY	Future Dates, Project Date
WEEKNUM	Project Date
YEAR	QuickStove Shipment Tracker, Project Date

Assessments that Contain Charts

Chart	Assessment
Area Chart	Fire 42
Column chart	QuickStoveCharts, Sales Weekend Donut Shop, Hudson Class Offerings
Doughnut chart (variation of a pie)	Sales Weekend Donut Shop
Edit an existing chart	QuickStove DataTables
Line chart	QuickStoveCharts, Bond Valuation, Cost of Capital, Leverage, Capital Budgeting Criteria, Credit Card, Fire 42, Hudson Class Offerings, Pick a Meal Plan
Pie chart	QuickStoveCharts, Gradebook, LV Firefighter Buybacks, Hudson Class Offerings
Scatter chart	Risk and Return, Experiment Time
Stacked column chart	QuickStoveCharts, Hudson Class Offerings

Assessments that Use Tables

Feature	Assessment
Calculated Column	Sales Weekend Donut Shop
Convert to Table	Sales Weekend Donut Shop
Total Row	Sales Weekend Donut Shop
PivotTables	QuickStove PivotTables, Sales Weekend Donut Shop, Instructor Experience

Assessments that Use What-If Analysis Tools

Tool	Assessment
Data tables	QuickStove Data Tables, Leverage, Capital Budgeting Criteria, Gradebook, Credit Card, Credit Payoff, Pick a Meal Plan
Goal seek	Production Estimation, Gradebook, Credit Payoff, Calculate Letter Grade
Scenarios	Forecasting Sales and Income,Credit Payoff
Solver	QuickStove Inventory, Risk and Return, Spirit Week Fundraiser

Previous Next