Instructions: Questions 5-19 use the data table on tab Q5-19 in the Exam Workbook. We strongly recommend you analyze this data with the aid of a pivot table. You may also benefit from adding some extra calculation columns to the dataset. Answers for numerical data should be rounded to the nearest 1 decimal, comma-separating 000s, NOT written in currency format. So if the answer is $10,500.658, you would input 10,500.7. Over the entire analysis period, which sales rep sold the highest cumulative quantity of a single item

Dr. sperry, a biologist, is using excel to track growth rates of different populations of bacteria. she has a very complex formula in one cell. it begins with “round”. dr. sperry would like to see exactly how excel’s calculation reached the final rounded value that she sees in the cell. what could dr. sperry do to best understand how the calculation was made? try different formulas on her own until she reaches the value shown in excel click on the evaluate formula button in the formulas tab and then click “step in” select the cell and then look at the formula in the formula field of the ribbon remove “round” from the formula in order to see the actual value before rounding

The starr theater, owned by meg vargo, will begin operations in march. the starr will be unique in that it will show only triple features of sequential theme movies. as of march 1, the ledger of starr showed: cash $3,150, land $22,000, buildings (concession stand, projection room, ticket booth, and screen) $10,000, equipment $10,000, accounts payable $7,300, and owner’s capital $37,850. during the month of march, the following events and transactions occurred.mar. 2 rented the three indiana jones movies to be shown for the first 3 weeks of march. the film rental was $3,600; $1,600 was paid in cash and $2,000 will be paid on march 10.3 ordered the lord of the rings movies to be shown the last 10 days of march. it will cost $200 per night.9 received $4,500 cash from admissions.10 paid balance due on indiana jones movies rental and $2,200 on march 1 accounts payable.11 starr theater contracted with adam ladd to operate the concession stand. ladd is to pay 15% of gross concession receipts, payable monthly, for the rental of the concession stand.12 paid advertising expenses $900.20 received $5,100 cash from customers for admissions.20 received the lord of the rings movies and paid the rental fee of $2,000.31 paid salaries of $2,900.31 received statement from adam ladd showing gross receipts from concessions of $6,000 and the balance due to starr theater of $900 ($6,000 × 15%) for march. ladd paid one-half the balance due and will remit the remainder on april 5.31 received $9,200 cash from customers for admissions.1.) enter the beginning balances in the ledger.2.) journalize the march transactions. starr records admission revenue as service revenue, rental of the concession stand as rent revenue, and film rental expense as rent expense. (credit account titles are automatically indented when the amount is entered. do not indent manually. record journal entries in the order presented in the problem. if no entry is required, select "no entry" for the account titles and enter 0 for the amounts.)3.) post the march journal entries to the ledger. (post entries in the order of journal entries presented in the previous question.)

3. which of the following occupations relate to a skill category of mathematics and data? select all that apply. (2 correct answers) engineer financial analyst mechanic sales person 4. which of the following occupations relate to a skill category of words and literacy? select all that apply. (2 correct answers) educator lawyer marketing manager psychologist architect