Start Excel. Open the downloaded file named Excel_Ch10_PS2_Float.xlsx. Grader has automatically added your last name to the beginning of the filename. Save the file to the location where you are storing your files. 0 2 The company would like to determine the number of customers it should book per day in order to break even. They would like to analyze this using a break-even analysis. On the Break-Even Analysis worksheet, enter the correct formula to calculate the Gross Revenue in cell D7. 5 3 Enter the correct formula to calculate the Total Fixed Costs in D13. 5 4 In cell D17 enter the correct formula to calculate the Total Variable Costs based upon the average number of guests per day and the days of operations per year. 5 5 Enter the correct formula to calculate the Net Income in D18. 5 6 Management thinks an average of 85 guests a day would be a realistic average. Use Goal Seek to find out what the price would need to be to come out exactly even with 85 guests per day and $0 in Net Income.   Yes, I need help on these steps, specifically finding the formulas to use for each step. Everything I've tried doesn't feel right. Please help and not just dialogue explaining the solution, but the formulas included as that will help me complete what I need to. Thank you.

Q: Which of the following will select the Id and Status fields for records whose Status field contains…

A: The attribute which are to be present in output should be present in SELECT clause.  The condition…

Q: Which of the following is not a valid format argument for displaying the current time? (refer to the…

A: Valid format argument for displaying current time The TO_CHAR function is used to convert the given…

Q: CREATE TABLESPACE user_tbspace DATAFILE 'user.dbf' SIZE 2m; create user mary identified by mary;…

A: Given that, CREATE TABLESPACE user_tbspace DATAFILE 'user.dbf' SIZE 2m; create user mary identified…

Q: Which of the following columns in the vaccine uptake table contains erroneous values in this…

A: The option 2 and  5 :state code and state name are the wrong answers . The state code  and state…

Q: Which attribute pair in a form allows data to be uploaded? o value="file" o type="file" o…

A: A form attributes allows data to be uploaded through attributes pair.

Q: On Microsoft Access: Using an update query, update the field values in the StateMinInc field in the…

A: I dont have table so cannot show the work,  The steps are shown below to run the update query in Ms…

Q: Country TLD Name Code .pe Peru 604 .cy 65 .ch Switzerland 756 Cyprus 196 Complete the UPDATE…

A: The question requires us to update a row in a database table. Specifically, we need to change the…

Q: Write and execute the command to retrieve all information for a property for every property in the…

A: Syntax:-create view viewname as select column name from tableName where condition;

Q: TABLEA and TABLEB have identical formats/layouts. To select records from TABLEA that are NOT in…

A: UNION operator-                           UNION operator is used for combining the records of two or…

Q: For the dataset, adultsData.csv (in the assignment folder), it is required to analyze the dataset to…

A: Data Loading and Exploration Let's start by loading the dataset and exploring it. We will start by…

Q: Please provide answers with code.  Following, please provide coding for these questions   A.  How…

A: Here we have given solution for the questions that you have asked. You can find the solution in step…

Q: what would you be looking for with the following query? filetype:txt administrator:500:

A: A query is a request for data or information from a database or search engine. It is a command used…

Q: 7. Create the following table : EMP_MASTER Empid Empname 4 digits Deptid Mgr 4. characters digits…

A: The SQL CREATE TABLE Statement: The CREATE TABLE statement is used to create a new table in a…

Q: 1. Open and examine the following ERR design file people.mwb a. Each person is described by their…

A: Answer is as follows : According to Guidelines we are allowed to answer only first  questions  but i…

Q: Task 7: Create a view named MONTHLY_RENTS. It consists of three columns: the first is the number of…

A: Views in SQL correspond to a virtual table consisting of rows and columns. It represents result set…

Q: Input: :ENTER_STUDENT_NO 1000 : ENTER_SECTION_ID 10001 Output: Student Grade: Friday, May 7, 2025…

A:

Q: Task 9: Create the DISP_PROPERTYS procedure to retrieve and output the office number, address,…

A: Given Procedure name is DISP_PROPERTYS Suppose the relation name is PROPERTY and the attribute…

Q: The CREDIT_LIMIT field must be stored with a decimal datatype and a default value between 0 and…

A: In the realm of databases, specific repositories store metadata and constraints about database…

Q: Exercise 04 - Other Excel Functions a) Create a new sheet in Excel and name it Exercise 04. b) Click…

A: Setting up the Sheet:Open Excel.Create a new sheet and name it "Exercise 04".Creating the…

Q: Open the start file EX2019-ChallengeYourself-6-3. The file will be renamed automatically to include…

A: Solution a) Go to cell C10 enter the following formula =AVERAGE(C8:C9)

Q: Task 7: Create a view named MONTHLY_RENTS. It consists of three columns: the first is the number of…

A: We need to Create a view named MONTHLY_RENTS  from PROPERTY table CREATE VIEW MONTHY_RENTS AS…

Q: Employee Department Contacts KPT Enterprises Quarterly Schedule of Revenue For the year December 31,…

A: logic:-  =SUM(range of cell ) is used to find summation of values present in cell.  Here values in…

Q: Which view is used to filter and look at the data in a table, without changing the structure of the…

A: DATA view is used to filter and look at the data in a tale , without changing the structure of the…

Q: Alter the PROPERTY table by changing the OWNER_NUM field to refer to the OWNER table. Retrieve the…

A: In this question we have been given some database task related to SQL database Let's query out the…

Q: Referring to the Set Operations image above - To validly perform a union, intersect, or difference…

A: To perform Union or Intersect or Difference operator, you need to have: The same number of columns…

Q: Write and execute the command to retrieve the customer ID, first name, and last name of each…

A: In SQL, A view is a virtual table based on the result-set of an SQL statement. A view contains rows…

SQL

SQL stands for Structured Query Language, is a form of communication that uses queries structured in a specific format to store, manage & retrieve data from a relational database.  

Queries

A query is a type of computer programming language that is used to retrieve data from a database. Databases are useful in a variety of ways. They enable the retrieval of records or parts of records, as well as the performance of various calculations prior to displaying the results. A search query is one type of query that many people perform several times per day. A search query is executed every time you use a search engine to find something. When you press the Enter key, the keywords are sent to the search engine, where they are processed by an algorithm that retrieves related results from the search index. Your query's results are displayed on a search engine results page, or SER.