Vacation days are based on status. Using the information in the lower table below, do a lookup in the upper table determine the amount of vacation time earned by each employee. Status Vacation Time Earned Full TIme 10 Part Time 7 Contract 0 Employees Status Vacation TIme Earned John Contract Jane Part Time Al Full TIme

Vacation days are based on status. Using the information in the lower table below, do a lookup in the upper table determine the amount of vacation time earned by each employee. Status Vacation Time Earned Full TIme 10 Part Time 7 Contract 0 Employees Status Vacation TIme Earned John Contract Jane Part Time Al Full TIme

Np Ms Office 365/Excel 2016 I Ntermed

1st Edition

ISBN:9781337508841

Author:Carey

Publisher:Carey

Chapter8: Working With Advanced Functions

Section: Chapter Questions

Problem 11RA

See similar textbooks

Similar questions

The following shows a training company’s workshops, the number of days of each, and their registration fees. Workshop # of Days Registration FeeHandling Stress 3 $ 1,000Time Management 2 $ 800Supervision Skills 3 $ 1,200Negotiation 6 $ 1,500Interview Skills 1 $ 300The training company conducts its workplace in the six locations shown in the following table. The table also shows the lodging fees per day at each location. Location Lodging Fees per DayAustin $ 151Chicago $ 225Dallas $ 179Orlando $ 322Phoenix $ 175Raleigh $ 165When a customer registers for a workshop, he or she must pay the registration fee plus the lodging fees for the selected location. For example, here are the charges to attend the Supervision Skills workshop in Orlando. Registration: $1,200Lodging: $322 * 3 days = $966Total: $2,166Create an application that lets the user input a workshop and location from the lists. The application should display the workshop and lodging prices, calculate and display the registration…
C) Which employees earn less salary than the average salary for the consultants who perform the same job? Show the employees first and last names, job id, salary, department name, and manager's last name. Sort the result by the employees’ employee id. D) For each department, find the manager who pays out the most in salaries. Show the department number, the manager's last name, and the total she/he pays each month. Sort by the department number. Here are the tables and the columns within the table Here are the tables and the columns within the table CONSULTANTS - CONSULTANT_ID- FIRST_NAME- LAST_NAME- EMAIL- PHONE_NUMBER- HIRE_DATE- JOB_ID- SALARY- COMMISSION_PCT- MANAGER_ID- DEPARTMENT_ID . COUNTRIES - COUNTRY_ID- COUNTRY_NAME-REGION_ID . CUSTOMERS - CUST_IDCUST_EMAILCUST_FNAMECUST_LNAMECUST_ADDRESSCUST_CITYCUST_STATE_PROVINCECUST_POSTAL_CODECUST_COUNTRYCUST_PHONECUST_CREDIT_LIMIT . DEPARTMENTS - DEPARTMENT_IDDEPARTMENT_NAMEMANAGER_IDLOCATION_ID . EMPLOYEES -…
. Based on the ERD below, display Employee first name, middle initial and last name so it displays in one column called Employee Name for the employees that worked on job number 501. Sort alphabetically by first name. 2. Based on the ERD below, for each project calculate the difference between the project value and the project balance. Display the result in a new column name “Remaining Balance”. Include the project number and project name in the result output. 3. Based on the ERD below, display the assignment number, employee number and assigned hours for either assign job 501 or 502 with assigned hours more than 3.
draw ERD for these tabels The system must contain tables such as category(catNo,catogeryName) ,Items(itemNo,ItemName,Price,total_quantity, catNo),Items_stor_entry(entry_no number primary key,itemNo,entry_date ,quantity), Employee (employeeNo,employeeName,job) ,branch(No,Name), Customer(customerNo,costomerName,gender) , ,Invoice (employeeNo,customerNo,total price ,invoiceNo,InvoiceDate,branchNo ) InvoiceDeatail contain List Of Purchase Items contain detail information related to the invoice (invoiceNo,ItemNo, paidPrice, quantity)
When we choose to display only a partial set of the fields from a single table, we are using the relational operation known as a ________________ . Question 47 options: 1) join 2) project (projection) 3) product 4) difference 5) select (selection)
Look up the average evaluation score earned by instructor Egan for the Emergency Care course: In cell E14, begin to enter a formula using the XLOOKUP Use the instructor name in cell E12 as the value to look up. Use a structured reference to the header row of the Evaluations table as the table to search. Return the value in the range E4:I4. I need help with the sttructured reference refered in #3
Given the employees of medium-sized semi-conductor firm, find the employee that joined November 8, 2020 using INDEX and MATCH function. (Attach an excel file) NAME GENDER DEPARTMENT DATE JOINED SALARY Andy Gomez Lito Cruz Michelle Sy Luis Cortez SHEILA CO PAMELA DY SARAH MORAL PATRICK ONG CLAIRE HONG JAYSON MEDINA MALE MALE FEMALE MALE FEMALE FEMALE FEMALE MALE FEMALE MALE MARKETING R&D ACCOUNTING OPERATIONS PURCHASING OPERATIONS MARKETING OPERATIONS PURCHASING OPERATIONS 16-OC-19 3-MAR-10 5-SEP-18 18-DEC-19 4-SEP-19 4-MAY-19 8-NOV-20 12-AUG-18 30-JUL-18 19-OCT-18 50,000 28,000 65,000 70,500 62,000 35,000 80,100 39,000 42,700 44,700
Topic 1: The 5 JoinsRun each of the following statements in APEX. Explain the differences in results.SELECTE.Last_Name,J.Job_TitleFROM HOL_EMPLOYEES EINNER JOIN HOL_JOBS J ON E.Job_ID=J.Job_ID;SELECTE.Last_Name,J.Job_TitleFROM HOL_EMPLOYEES ELEFT OUTER JOIN HOL_JOBS J ON E.Job_ID=J.Job_ID;SELECTE.Last_Name,J.Job_TitleFROM HOL_EMPLOYEES ERIGHT OUTER JOIN HOL_JOBS J ON E.Job_ID=J.Job_ID;SELECTE.Last_Name,J.Job_TitleFROM HOL_EMPLOYEES EFULL OUTER JOIN HOL_JOBS J ON E.Job_ID=J.Job_ID;SELECTE.Last_Name,J.Job_TitleFROM HOL_EMPLOYEES ECROSS JOIN HOL_JOBS J; DBMS 130 Worksheet: JOINS and SET Operations2Topic 2: Write an SQL cartesian product between Regions and Countries.Copy your APEX here.How many rows are in the result set?How could you have calculated the number of rows in the result set BEFORE running yourquery?Topic 3: Briefly explain how set operators handle NULL values.Run the following 3 SQL queries in APEX which use set operators over these…
Using the “Quarterly Revenue – 2018” worksheet provides the relevant formulas to complete the worksheet. Apply appropriate formatting. In the same worksheet in part (c) dynamically apply the following formats for Qtr1and Qtr4 for all related revenue types:i. Values over $140,000 should be yellow. [2]ii. Values under or equals to $80,000 should be read and bolded Thom-Pierre Consultants (TPC) Quarterly Schedule of Revenue For the year December 31, 2018 QTR1 QTR2 QTR3 QTR4 2018 Sales 290000 320000 320000 490000 Interest 102500 175000 180000 54000 Investment Income 13000 9500 10000 20000 Other 16000 25000 19500 29000 Total
Based on the ERD below, display all fields in the JOB table sorted by the largest hourly charges for the job first.
Using Tableau create a variable for following situation student classification Graduate undergraduate HONOR (based on classification) for graduate GPA>90 then "GOLD" for undergraduate GPA>80 then "gold ribbon"
Q) In a contingency table, the number of rows and columns must always be 2 . must always be the same. must add to 100% None of the above.