B 1 Student name 2 Brianna Buel 3 Cher Mayton 4 Louis Lohman 5 Bette Spradlin study year level exam score senior 81 number of student each year level freshman sophomore junior senior 58 junior sophomore 94 freshman 61 6 Rossie Mccaskill Senior 67 7 Luba Mccardle 8 Leland Lingerfelt 9 Sharita Twitchell 10 Cara Perfecto Senior 81 freshman 81 freshman 72 sophomore 91 11 The correct formula to count student based on their study year level in cell F7 is: COUNTIF($B$2:$B$10,E7) O -COUNTIFS($B$2:$B$10,E7) O -COUNTIFS($B$2:$B$10,E7-"Senior") O -COUNTIF($C$2:$C$10, Senior")

Q: Assignment: Carefully read the instructions and write a program that reads the following information…

A: The following program is compiled in replit and also Eclipse.Pseudo code:Get the inputs from the…

Q: Two Sample Run: Enter employee's name: Smith Enter number of hours worked in a week: 10 Enter hourly…

A: According to the information given;- We have to create a payroll program named moustasa_Prog5 it has…

Q: For this program you need to use Eclipse. Carefully read the instructions and write a program that…

A: Program plan:Class name: EmpPayrollImport the required header files.Define the class…

Q: For this program you need to use Eclipse. Carefully read the instructions and write a program that…

A: The program has the following algorithm: Step 1: Create object for “Scanner” class to read the user…

Q: For this program you need to use Eclipse. Carefully read the instructions and write a program that…

A: The program has the following algorithm: In the main method do the following operations,Get the…

Q: 1. Using Printf , \t & \n and get the ouput as shown below *** **** **** CIMS Student Result Report…

A: Sample Response: //C programming language#include <stdio.h>//main function definitionint…

Q: TABLE FOR EMPLOYEE SALARY EMP ID EMP NAME TOTAL SALARY TAX1 TAX2 NET SALARY notes 1 TAYSEER 850 tax1…

A: The given problem is to be solved in Excel using suitable formulas to find the output value for each…

Q: Table below shows the number of students enrolled in public university for the study field of…

A: In a binary search tree the values been inserted are accordingly: The smaller one a inserted to the…

Q: Table EMP Column name Column type Integer Up to 10 characters Integer Integer Example entry 7369…

A: Given: -

Q: Table EMP Column name Example entry Description 7369 Column type Integer Up to 10 characters Integer…

A: Given: -  The solution as per the given information

Q: Employee's first name: Kim Employee's last name: Smith Number of shifts: 25 Number of transactions:…

A: #include<iostream> #include<string> using namespace std; int main(){      // Declare and…

Q: Fare (Pound) Description Individual Membership (IM) Туре 64.00 (Additional 10.00 by credit card)…

A: The table for fair, charges and discount is given-   Each new application for membership is to be…

Q: Table EMP Column name Column type Integer Up to 10 characters Integer Integer Example entry…

A: Given : -

Q: 20. Write down the excel formulas for below table to calculate student total marks and find the…

A: =SUM(E3:I3) =SUM(E4:I4) =SUM(E5:I5) =SUM(E6:I6) =SUM(E7:I7) =SUM(E8:I8) =SUM(E9:I9)…

Q: Table EMP Column type Integer Up to 10 characters Example entry 7369 Column name Description…

A: create table EMP( emp_no int(10) not null primary key, ename varchar( 10), job_no int, mgr int,…

Q: Sample output: Enter number of records 3 Records of STUDENT :1 Id is: 1 Name is: Juan dela Cruz…

A: In c Language ,Structure is a user-defined datatype. It allows  to combine…

Q: ind your group number • The remainder after division of second to last digit of your student id by 3…

A: Required: Find your group number• The remainder after division of second to last digit of your…

Q: 20. Write down the excel formulas for below table to calculate student total marks and find the…

A: To find sum of students marks use the following steps:=  write in the cell =sum(         and within…

Q: Up to 10 characters Integer Integer SMITH Employee surname Employee's job title No ID no. of…

A: Given:

Q: 20. Write down the excel formulas for below table to calculate student total marks and find the…

A: Excel is a software application from Microsoft. It is used to creating tables and organizing large…

Q: Table EMP Column name EMPNO ENAME Column type Integer Up to 10 characters Example entry 7369…

A: Given: -   The solution as per the given information

Q: Table EMP Column name EMPNO Column type Integer Up to 10 Example entry Description Employee ID…

A: CREATE TABLE TABLE_NAME (       COLUMN_NAME1 DATE_TYpe CONSTRAINT,      COLUMN_NAME2 DATE_TYPE,…

Q: ID Student Number Surname Name Test 1 Test 2 Test 3 Test 4 Final mark PASS/FAIL 1 217545455 Johaness…

A: Given Use student 2017 table to create a query that will display Student Number, Surname, Name and…

Q: (Fall 2020) (Given 11/24/20 Homework #4 Due: 12/10/20) Following is a data description of a library:…

A: Actually, database is used to stores the data.

Q: 36. Using the product and sales order detail table, find the products with total units sold greater…

A: Solution !!

Q: Use the table below to answer A D Driver's Name Item 10001 8/1/2019 Renz Joshua Electric Fan Washing…

A: Microsoft Excel is can be understood as a spreadsheet that was developed by Microsoft basically for…

Q: Using the information given in the table below, calculate the total amount payable by the company to…

A:

Q: 1. List all book titles titles published between 2012 to 2020. 2. List all copies of the book titled…

A: Q.1. List all book titles titles published between 2012 to 2020.  Answer :-  select title from book…

Q: Table EMP Column name EMPNO Column type Integer Up to 10 characters Example entry 7369 Description…

A: Given: -   The solution as per the given information

Q: Table EMP Column name Column type Integer Up to 10 characters Integer Integer Example entry 7369…

A: Dear Student, The SQL queries for your question is given below along with appropriate primary key…

Q: Table EMP Column name Column type Integer Up to 10 characters Integer Integer Example entry…

A: Given: -  The solution according to the given information

Q: Panda EST 2. Monthly Sales Report - July 4 Emp. No. Name Ahmed Hassan Ali Waleed Mohammed Samir…

A: Required: to fill missing value in given excel table:

Q: Write a program that allows the user to set the loan amount, loan period, and interest rate, and…

A: Program code:     //Import java files import java.awt.*; import java.text.*; import javax.swing.*;…

Q: Question 1 Sort the data on the basis of the length of the name (descending order). Nime City…

A: Note: As per our guidelines we can able to solve only three subdivisions. So, please repost the…

Q: 9. Find the name of the medicine(s) that have the lowest price 10. Find the name(s) of patient(s)…

A: As per our guidelines we are supposed to answer 3-subparts of a question. Kindly repost other…

Q: 1. Read the marks of a students for 5 courses. Calculate the average marks for the student. Check…

A: As per our company guidelines, we are not supposed to answer more than one question per post and…

Q: Employee's Working Overtime Promoted Hourly rate Salary Net Salary name Hours Amount Employee Rami…

A: Salary = working hours * hourly rate  Net salary= Salary+ overtime  Promoted if Netsalary>15000…

Q: DB - Normalization   Question # 1 Patient Medication Form   Patient Number:  P10034 Full name:…

A: Actually, Normalization is a process used to remove redundancy from the table.

Q: DG Pg_Number 1 Dog Name Rex Pete |Shirley Dog Age Dog Br Poodle Lab Pit Bull 11 3 WNER wner Number…

A: Union will return number of columns equal to one of the relation. This option (D) is correct option.…

Q: SALES Customer ID (primary key) Date of purchase Item code(foreign key) 001 2/05/2021 A-1 002…

A: Logical view : represents the functionality of the particular database to users.

Q: A) Find the total number of copies of the book titled Harry Potter and the Deathly Hallows B) List…

A: A. Find the total number of copies of the book titled Harry Potter and the Deathly Hallows Select…

Q: Get the GPA of a student as input. Calculate the CGPA according to the following table. GPA CGPA…

A: Required:

Q: Table EMP Column name Column type Integer Up to 10 characters Integer Integer Example entry…

A: Given: -

Q: 500 inclusive. (2) Find the first and the last names of all drivers who are on leave. (3) Find the…

A: the answer is :

Q: 1. List the library members who are expected to return their books that are due on -30-Apr-2021'. 2.…

A: SELECT B.BORROWERNO, B.BORROWERNAME, BL.DATEDUE FROM BORROWER B, BOOKLOAN BL , BOOKCOPY BC WHERE…

Q: Cafe Customer name: john Customer Table number: 8 Please enter order [1]: maggie Please enter…

A: C Program for above :   #include <stdio.h> int main()  {     char name[20], order[3][20];…

Q: Excel: Create a totalizer (function or formula in Excel) of the quantities of “ON” shares traded.…

A: For finding out the first part of some string text , find and left function is used. For error…

Q: Create the given table and implement the queries: OrderNo PurchaseAmt OrderDate…

A: Create the given table and implement the queries: table creation : CREATE TABLE Sales(  OrderNo int…

Q: Create the given table and implement the queries: OrderNo PurchaseAmt OrderDate Customer_ID…

A: Create the given table and implement the queries: table creation : create table syntax:-  create…

Q: ect the constraint (if any) that is violated by each the following operations in questions. Use ples…

A: Here table Student_Course refers to table Course.  So when we delete an entry from Course table we…