Exhibit:
You are an accountant for an event stadium. You have created a workbook to keep track of the four vendors that are available at the stadium.
Task 5:
Exhibit:
In cell H7 on the “Event 1 -Stand Sales” worksheet, add a formula that uses a single logical function to display TRUE if everyone sold at least on hot dog and FALSE if even one person did not sell any hot dogs.
Exhibit:
Task5:
On the “Quality Control” worksheet change the table name from “Table3” to WeeklyQuality”.
Exhibit:
Task3:
On the “Available Must” worksheet, use a query to load the cells beginning at A1 from the HarvestLog.xlsx workbook in the documents folder. Include only the “Variety”,”Location” and “Litters of must” Columns.
TESTED 01 Feb 2025
