Question

decimal places. following functions? note cell e3 has been formatted to show no
excel table image

1. =min(c3, c7)

=min(3,2)=②

1. how do you name the cell e9 “subtotal”?

left of formula bar, enter sub, set a

1. naming a cell is like naming your dog, you really don’t want to change the name! how do you un - name cell e9?

Explanation:

Question 6

Step1: Identify values in C3 and C7

From the table, C3 (Quantity for Tuna) is 4, C7 (Quantity for Hot Dog) is 3.

Step2: Apply MIN function

The MIN function returns the minimum of the two values. So MIN(4, 3) = 3? Wait, wait, the handwritten part says =min(3,2)=2. Wait, maybe I misread the table. Wait, looking at the table: C3 (Tuna Quantity) – let's check the cells. Wait, the user's handwritten note for 6 is =min(3,2)=2. Maybe in the table, C3 is 3 and C7 is 2? Let's go with the handwritten approach. If C3 is 3 and C7 is 2, then MIN(3,2) is 2.

To name cell E9 "Subtotal", select cell E9. Then, in the Name Box (left of the formula bar), type "Subtotal" and press Enter. This assigns the name "Subtotal" to cell E9.

To un - name (remove the name) of cell E9, go to the Formulas tab (in Excel), click on "Name Manager". In the Name Manager dialog box, find the name associated with cell E9 (e.g., "Subtotal" if that's the name), select it, and click "Delete". Confirm the deletion. Alternatively, if using the Name Box, select the named range (by typing the name in the Name Box and pressing Enter to select cell E9), then in the Name Box, delete the name and press Enter (this works for simple cases, but Name Manager is more reliable for managing names).

Answer:

2

Question 7