Coverage

Click the underlined text to jump directly to the challenge.

Challenges with Excel Basic Features

Excel Basics	Challenge
Copy and paste	Address Book, Ratio Challenge, QuickStove Sales Tax, Credit Card Challenge, Business Sales for Weekend Donut Shop, List of Names Challange, Soccer Penalty
Entering Data	QuickStove Basic Model,Forecasting Challenge , Risk and Return Challenge, Capital Budgeting Criteria Challenge, Capital Budgeting Challenge
Fill feature	Address Book
Filter	Address Book, Phone Bill Challenge, Business Sales for Weekend Donut Shop
Group sheets	Finance Statements Challenge, Business Sales for Weekend Donut Shop
Hide column	Address Book
Insert column	Address Book
Insert Worksheet	Business Sales for Weekend Donut Shop
Multi level sort	Address Book, List of Names Challange
Resize columns	Address Book, Finance Statements Challenge, Ratio Challenge
Sort	Phone Bill Challenge

Challenges with Cell Formatting

Format	Challenge
Bold	Address Book, Finance Statements Challenges, Ratio Challenge
Borders	Address Book, Finance Statements Challenges, Ratio Challenge
Center	Address Book, Phone Bill Challenge
Conditional Formatting	Phone Bill Challenge, Sales Weekend Donut Shop
Fill color	Address Book, Finance Statements Challenge, Ratio Challenge, Sales Weekend Donut Shop
Font Face	Phone Bill Challenge
Font Size	Phone Bill Challenge
Format date	Address Book
Format Numbers	Finance Statements Challenge, Ratio Challenge, Phone Bill Challenge, Experiment Time Challenge, Future Dates Challenge
Indent	Finance Statement Challenge
Italics	Address Book, Ratio Challenge
Merge cells	Finance Statements Challenge, Phone Bill Challenge
Wrap text	Address Book

Challenges with Formulas

Formula	Challenge
Formulas	Address Book, , Ratio Challenge, QuickStove Transaction, QuickStove Purchasing and Investing, QuickStove Sales Tax, QuickStove Basic Model, QuickStove Modeling, QuickStove Statistics, Finance Statements Challenges, Ratio Challenge, ForecastingChallenge, Bond Valuation Challenge, Stock Valuation Challenge, Risk and Return Challenge, Cost of Capital Challenge, Leverage Challenge, Capital Budgeting Criteria Challenge, Capital Budgeting Challenge, Firm Valuation Challenge, Gradebook Challenge, Credit Card Challenge, Sales Weekend Donut Shop, Buy vs Lease Challenge, Triple Race, Future Dates Challenge
Absolute references	QuickStove Sales Tax, QuickStove Basic Model, QuickStoveModeling, Finance Statements Challenge, Risk and Return Challenge, Leverage Challenge, Capital Budgeting Challenge, Credit Card Challenge
Boolean formula	QuickStovePromotions
Date aritmatic	QuickStove Shipment Tracker, Project Date Challenge
Named range	Sales Weekend Donut Shop
Reference data on another sheet	Finance Statements Challenges
Time arithmatic	Experiment Time Challenge

Challenges that contain Functions

Function	Challenge
ABS	Bond Valuation Challenge, Capital Budgeting Criteria Challenge
AND	Soccer Penalty
AND and OR same expression	QuickStovePromotions
AVERAGE	QuickStoveTransaction, QuickStove Statistics, QuickStove Employee Performance, Risk and Return Challenge, Phone Bill Challenge, Salary by Major Challenge
AVERAGEIF	QuickStoveEmployeePerformance
CONCAT	QuickStoveShippingCosts, Phone Bill Challenge, List of Names Challange
CONFIDENCE.NORM	QuickStove Statistics
CORREL	QuickStove Statistics, Risk and Return Challenge
COUNT	QuickStove Transaction, QuickStove Statistics, Salary by Major Challenge
COUNTA	QuickStove Transaction
COUNTIF	Production Estimation, Phone Bill Challenge, Gradebook Challenge
COVARIANCE.S	Risk and Return Challenge
DAYS	QuickStoveShipmentTracker, Project Date Challenge
EFFECT	QuickStove Purchasing And Investing, Time Value of Money Challenge
FORECAST.LINEAR	QuickStoveStatistics
FV	QuickStove Purchasing And Investing, Time Value of Money Challenge
HLOOKUP	QuickStove Shipping Costs, QuickStove Employee Performance
HOUR	QuickStove Shipping Log, Experiment Time Challenge
IF	QuickStove Sales Tax, QuickStove Basic Model, Cost of Capital Challenge, Phone Bill Challenge, Credit Card Challenge, Triple Race, Future Dates Challenge
IRR	Capital Budgeting Criteria Challenge, Capital Budgeting Challenge
LEFT	QuickStove Shipping Log, Phone Bill Challenge, List of Names Challange
LEN	QuickStove Shipping Log, List of Names Challange
MAX	QuickStove Transaction, Credit Card Challenge, Salary by Major Challenge
MEDIAN	Salary by Major Challenge
MID	QuickStove Shipping Log
MIN	QuickStove Transaction, QuickStove Basic Model, QuickStoveModeling, Salary by Major Challenge
MINUTE	QuickStove Shipping Log, Experiment Time Challenge
MONTH	QuickStove Shipment Tracker, Project Date Challenge
NETWORKDAYS	Project Date Challenge
NOT	QuickStove Promotions
NOW	QuickStove Shipment Tracker, Soccer Penalty
NPER	Time Value of Money Challenge, Credit Card Challenge
NPV	Time Value of Money Challenge, Capital Budgeting Criteria Challenge, Capital Budgeting Challenge
OR	QuickStove Promotions, Phone Bill Challenge, Soccer Penalty
PMT	QuickStove Purchasing And Investing, Time Value of Money Challenge, Capital Budgeting Criteria Challenge, Buy vs Lease Challenge
PRODUCT	Leverage Challenge
PV	QuickStove Purchasing And Investing, Time Value of Money Challenge, Not Found, Bond Valuation Challenge, Stock Valuation Challenge
RATE	QuickStove Purchasing And Investing, Time Value of Money Challenge, Cost of Capital Challenge, Capital Budgeting Criteria Challenge
RIGHT	QuickStove Shipping Log, Phone Bill Challenge, List of Names Challange
ROUNDUP	Not Found
SEARCH	QuickStove Shipping Log, List of Names Challange
SECOND	Experiment Time Challenge
SQRT	Risk and Return Challenge
STDEV.P	QuickStove Statistics
STDEV.S	Risk and Return Challenge
SUM	QuickStove Transaction, QuickStove Sales Tax, QuickStove Employee Performance, QuickStove Modeling, Finance Statements Challenges, ForecastingChallenge, Capital Budgeting Challenge, Phone Bill Challenge, Gradebook Challenge, Credit Card Challenge, Sales Weekend Donut Shop, Triple Race
SUMIF	QuickStove Employee Performance, Phone Bill Challenge, Sales Weekend Donut Shop
TODAY	QuickStove Shipment Tracker, Project Date Challenge
VLOOKUP	QuickStove Shipping Costs, QuickStoveEmployeePerformance, QuickStove Modeling, Gradebook Challenge, Sales Weekend Donut Shop, Triple Race
WEEKDAY	Future Dates Challenge, Project Date Challenge
WEEKNUM	Project Date Challenge
YEAR	QuickStove Shipment Tracker, Project Date Challenge

Challenges that Contain Charts

Chart	Challenge
Column chart	QuickStoveCharts, Sales Weekend Donut Shop
Doughnut chart (variation of a pie)	Sales Weekend Donut Shop
Edit an existing chart	QuickStove DataTables
Line chart	QuickStoveCharts, Bond Valuation Challenge, Cost of Capital Challenge, Leverage Challenge, Capital Budgeting Criteria Challenge, Credit Card Challenge
Pie chart	QuickStoveCharts, Gradebook Challenge
Scatter chart	Risk and Return Challenge, Experiment Time Challenge
Stacked column chart	QuickStoveCharts

Challenges that Use Tables

Feature	Challenge
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

Challenges that Use What-If Analysis Tools

Tool	Challenge
Data tables	QuickStove Data Tables, Leverage Challenge, Capital Budgeting Criteria Challenge, Gradebook Challenge, Credit Card Challenge
Goal seek	Production Estimation, Gradebook Challenge
Scenarios	Forecasting Sales and Income
Solver	QuickStove Inventory Challenge, Risk and Return Challenge

Previous Next