Q2. In EXCEL, if you only want to fix a row (say row 3), we use the following address

A. $C$3 B. $C3 C. C$3 D. None of the above

Q3. Given: AUTHOR (Author_id, Author_name, Book_ID). Assume an author can write many books and a book can be written by many authors (joint). Whats the Primary key (PK) of AUTHOR relation?

A. Author_id

B. Author_name

C. Book_ID

D. Author_ID, BOOK_ID

Q4. If you were thinking of UBER services, which of the following represents the process? A. Dropping passengers. B. Driving them to their location. C. Picking passengers. D. All of the above

Q5. Cheryl Steffan is the operations manager for Nature's Bread Company, which specializes in providing natural products for health-conscious individuals. Cheryl is responsible for compiling, analyzing, and evaluating daily sales numbers to determine the company's profitability and forecast production for the next day. Which of the following is an example of the type of information Cheryl would be using to successfully perform her job?

A. Craig Newmark is customer number 15467. B. Compare the costs of supplies, including energy, over the last five years to determine the best-selling product by month. C. Best-selling product by day. D. Best-selling product changes when Tony, the best baker, is working.

Q6. Anne-Marie Cole runs the sales division for a local auto insurance firm. One of her key duties is to ensure the company has 25 percent market share by the end of the year. When evaluating the current sales numbers she determines that her sales division has total sales of $5 million and the entire industry has total sales of $100 million. What additional sales must Anne-Marie's division meet to ensure they have 25 percent of the market by the end of the year? A. $20 million B. $50 million C. $25 million D. None of the above