Question

practice activity #2 - built-in functionality
the outputs of the following functions? note cell e3 has been formatted to show no
laces.

1. =min(c3, c7)

=min(3,2) = 2 (handwritten)

1. how do you name the cell e9 \subtotal\?

Explanation:

Question 6:

Step1: Identify values in C3 and C7

From the table, C3 (Soda quantity) is 3, C7 (Hot Dog quantity) is 2.

Step2: Apply MIN function

The MIN function returns the minimum of the two values. So MIN(3, 2) = 2.

To name cell E9 "Subtotal" in Excel:

1. Select cell E9.
2. Go to the "Formulas" tab (or "Define Name" in some versions) or use the Name Box (the box to the left of the formula bar that shows the cell reference).
3. If using the Name Box: Click on the Name Box, type "Subtotal", and press Enter.
4. If using Define Name: Click "Define Name", enter "Subtotal" as the name, ensure the "Refers to" box has E9 (or the correct reference), then click OK.

Answer:

2

Question 7: