The problem is based on a spreadsheet showing the sales of various food items in a school cafeteria. There are four questions, each requiring the selection of the correct formula to be entered in a specific cell of the spreadsheet. I. Find the formula to calculate the sales amount (H3) using the selling price and the number of items sold. II. Find the formula to determine the price evaluation (F3) by comparing the cost price and selling price. If the selling price is 200 yen or more higher than the cost price, display "O", otherwise display "x". III. Find the formula to determine the profit evaluation (J3). If the profit is 50,000 yen or more, display "A". If it is 20,000 yen or more, display "B". Otherwise, display "C". IV. Find the formula to calculate the sales ranking (K3) based on the profit.

1. Problem Description

The problem is based on a spreadsheet showing the sales of various food items in a school cafeteria. There are four questions, each requiring the selection of the correct formula to be entered in a specific cell of the spreadsheet.

I. Find the formula to calculate the sales amount (H3) using the selling price and the number of items sold.

II. Find the formula to determine the price evaluation (F3) by comparing the cost price and selling price. If the selling price is 200 yen or more higher than the cost price, display "O", otherwise display "x".

III. Find the formula to determine the profit evaluation (J3). If the profit is 50,000 yen or more, display "A". If it is 20,000 yen or more, display "B". Otherwise, display "C".

IV. Find the formula to calculate the sales ranking (K3) based on the profit.

2. Solution Steps

I. Calculation of Sales Amount (H3)

The sales amount is calculated by multiplying the selling price (E3) and the number of items sold (G3).

The correct formula is:

$H3 = E3 * G3$

Therefore, the answer is ウ.

II. Price Evaluation (F3)

The price evaluation is determined by comparing the selling price (E3) and the cost price (B3). If the difference between the selling price and the cost price is 200 yen or more, it should display "O". Otherwise, it should display "x". The formula should be:

$IF (E3 - B3 >= 200, "O", "x")$

Therefore, the answer is ア.

III. Profit Evaluation (J3)

The profit evaluation is based on the profit amount (I3). The evaluation criteria are:

- If I3 >= 50000, display "A"

- If I3 >= 20000, display "B"

- Otherwise, display "C"

This can be expressed using nested IF statements.

The correct formula is:

$IF(I3>=50000, "A", IF(I3>=20000, "B", "C"))$

Therefore, the answer is イ.

IV. Sales Ranking (K3)

The sales ranking is determined using the RANK.EQ function. The ranking is based on the profit amount (I3) compared to the range of profit amounts (I3:I12). To ensure the range remains constant when the formula is copied using autofill, absolute references ($) should be used for the range.

The correct formula is:

$RANK.EQ(I3, I$3:I$12, 0)$

Therefore, the answer is ウ.

3. Final Answer

I. ウ

II. ア

III. イ

IV. ウ