Blog

Who is entitled to the Social Security lump-sum death benefit?

A group box is primarily used in conjunction with which other form control?

What happens when you insert a check box form control and link it to a cell?

The simple model above is used to calculate a students grade point average (GPA). Which formula in cell B17 would correctly calculate the GPA while using best practices for spreadsheet modeling?

What is the minimum incremental change that can be used in a spin button?

Using the worksheet shown below, what value would be returned by the following formula? =SUM(INDEX(B2:D4,0,MATCH(“Large”,B1:D1,0)))

Recall the Moore Pharmaceuticals example from the lectures. You want to create a data table to evaluate the net present value at different levels of Discount Rate. The parameters of the data table are already set up in the screenshot below. What cell should you select as the Column input cell?

Recall the affordable home purchase example from the Spreadsheet Modeling Lab. You want to create a data table to evaluate the maximum home price at different levels of Down payment (%) and Monthly Installment Debt. The parameters of the data table are already set up in the screenshot below. What cell should you select as the Column input cell?

Recall the Moore Pharmaceuticals example from the lectures. You want to evaluate the Year 4 Cumulative Net Profit at different levels of Year 1 Market Size, Unit revenue, and Unit cost. Which What-If Analysis tool will allow you to do this?

Which of the approaches to diversifying discussed in class best describes Aldi’s move into the sale of Aldi-branded services through its online platform?