COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
1st Edition
ISBN: 9780357392676
Author: FREUND, Steven
Publisher: CENGAGE L
expand_more
expand_more
format_list_bulleted
Question
error_outline
This textbook solution is under construction.
Students have asked these similar questions
Need help with this:
Answer each of the following questions using the KimTay Pet Supplies data shown in Figure 1-2. No computer work is required.
1. List the first and last names of all customers that have a credit limit above, but not including, $500.
2. List the invoice numbers for invoices placed by customer ID 435 on November 18, 2021.
3. List the item ID, item description, and on-hand value for each item in category HOR. (Hint: On-hand value is the result of multiplying the number of units on hand by the price.)
4. List the item ID and item description of all items that are in category DOG.
5. How many customers have a balance that exceeds their credit limit?
6. What is the item ID, description, and price of the least expensive item in the database?
7. For each invoice, list the invoice number, invoice date, customer ID, and customer first and last names.
8. For each invoice placed on November 16, 2021, list the invoice number, customer ID, and customer first and last names.
9.…
Is it possible that stock data for your preferred publicly traded firms might include errors?
A rising number of organizations are using big data. What can you say about its use by the organization?
Knowledge Booster
Similar questions
- When you examine the stock data for your favourite publicly traded company, what types of data discrepancies might you anticipate to find?arrow_forwardNot deleting correct information about a former employee from the list of employees (once the employee retires), indicates which data quality problem? Group of answer choices Accuracy Timeliness Uniqueness Completeness thanks for the helparrow_forwardQUESTION 27 A weighted average assigns equal importance to all periods of data. True Falsearrow_forward
- When looking at stock data for your favorite publicly traded firms, what kind of data discrepancies can you anticipate seeing?arrow_forwardCompanies are using big data in growing numbers. According to you, what type of use does the organization make of it?arrow_forwardPlease complete all work in excel. Use excel to make any necessary calculations and be sure to identify the answer, including units (if necessary). Answers that need formulas must have them within the answer cell. City wants to further develop the model to include the weather conditions of rainy, cloudy, or sunny. Pool Attendance Temperature (°F) Weather Condition 150 89 Sunny 100 82 Rainy 125 81 Cloudy 130 86 Cloudy 155 93 Cloudy 170 98 Sunny 200 99 Sunny 180 87 Sunny 190 88 Sunny 140 83 Sunny 120 82 Cloudy 90 81 Rainy 130 87 Rainy 120 93 Rainy Should you keep weather condition in the model?arrow_forward
- Using SQL, insert (random but meaningful) data records in the above tables. • Create at least four different courses that include Operating Systems (3 credit hours), Data Bases (4 credit hours), and Marketing (5 credit hours) courses – consider one more course. • Create three departments that include a Computer Science department and a Business department –consider one more department. • Add at least 15 students (divided on the three departments – 5 students for each department). Randomly distribute the value of the “First year” between 2016 and 2022. • Each student has at least three different enrollments(each student is registered for three different courses).The enrollments should be between January 2020 and December 2020.arrow_forwardstudent(sid, sname, sex, age, year, gpa) dept(dname, numphds) prof(pname, dname) course(cno, cname, dname) major(dname, sid) section(dname, cno, sectno, pname) enroll(sid, grade, dname, cno, sectno) For the following mysql schema above, create a mysql query for the following question: For each department that has one or more majors with a GPA under 1.0, print the name of the department and the average GPA of its majors.arrow_forwardHow can I create a table with these being the columns? Vehicle ID ,State ,Repair, Reason, YEAR , Make, Body Type. An example of the data that would fill this table goes as follows; 0000015241383936, AL, Battery replacment, Dead battery, 2016, RAM , "1500 4WD Quad Cab 140.5"" SLT" MYSQLarrow_forward
- What kinds of data inconsistencies might you expect to see when looking at stock data for your favorite publicly listed companies?arrow_forward#SQL Question Use TopBabyNamesbyState.csv1 and write queries to extract the following information: 4) How many unique names are there in this dataset? 5) Which name in which state and in which year had the highest number of occurrences. 6) What is the average occurrence of “Jessica” as a top name in the state of CA? 7) How many years was “Mary” the top name in California? Name the computed column as “Mary_topinCA”. 8) The three most popular female names in WA state since 2000. Popularity is based on the total number of occurrences. Report the names along with the total number of occurrences. 9) Make a list of names that have an average occurrence greater than 1000. Order the result table by name in an ascending alphabetical order.arrow_forwardstudent(sid, sname, sex, age, year, gpa) dept(dname, numphds) prof(pname, dname) course(cno, cname, dname) major(dname, sid) section(dname, cno, sectno, pname) enroll(sid, grade, dname, cno, sectno) For the following mysql schema above, create a mysql query for the following question: For those departments that have no majors taking the College Geometry 1 or College Geometry 2 course, print the department name and the number of PhD students in the department.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- COMPREHENSIVE MICROSOFT OFFICE 365 EXCEComputer ScienceISBN:9780357392676Author:FREUND, StevenPublisher:CENGAGE LNp Ms Office 365/Excel 2016 I NtermedComputer ScienceISBN:9781337508841Author:CareyPublisher:Cengage
COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
Computer Science
ISBN:9780357392676
Author:FREUND, Steven
Publisher:CENGAGE L
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:9781337508841
Author:Carey
Publisher:Cengage