Blog

Carbohydrates are components of the following ________.

Examine the Fischer projection below. How is this carbohydrate classified?

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?