Using the tips dataset, first calculate the average tip amount. Then create a new column called Tip Category with the following rules: If a tip amount is less than the average, label it as “Below Average”. If a tip amount is greater than or equal to the average, label it as “Not Below Average”. What number of customers fall into the two categories (i.e., Below Average and Not Below Average?) Categories Count of Tip Category Below Average Not Below Average

Using the tips dataset, create a PivotTable with Sex in the Rows area and Total Bill in the Values area (summarized by Sum). What total amounts should appear for Female and Male?  Row Labels Sum of total_bill 311.84    

In the tips dataset, when cust_id is in its original ascending order and the named range DataRange includes only the data (not the headers), where column 1 is total_bill and column 2 is tip, what result does the following INDEX() formula return? =INDEX(DataRange, 4, 2)

When Calculating Cycle Time, if the result is not an integer (and task times are) should you round it down?

What is not generally true about forecasts?

What is not true about the importance of Productivity Growth?

“The chip famine is starving the global auto industry and putting car buyers on a strict diet. So far this year, seven million cars that were supposed to be produced haven’t been, according to IHS Markit data. Auto companies are shutting down production lines for weeks at a time and furloughing employees as a result of the chip shortage. Toyota has slashed its production 40% in September.” (wsj.com Sept. 22, 2021) According to this excerpt, what is the main factor limiting the auto industry production Capacity?

This is not an exam question and it will not be graded or reviewed. You may use theses textboxes for note-taking or as “scratch-paper”

The diagram below shows an incorrect model of an atom. What best describes a flaw in the model of the atom? (2 points)

A distance of 4,000 meters is equal to (2 points)