Write an algorithm and draw a flowchart to solve the following problems: 1. Read the marks of 2 students for 5 courses. Calculate the average marks for both the students. Check the average with the below table and calculate the CGPA according to the formula [CGPA=(Average * Grade point)/100]. Display the CGPA of both the students. Averag Grade point e 8-10 3.5 6-7.9 3 4.5-5.9 2.5 <4 2

Write an algorithm and draw a flowchart to solve the following problems: 1. Read the marks of 2 students for 5 courses. Calculate the average marks for both the students. Check the average with the below table and calculate the CGPA according to the formula [CGPA=(Average * Grade point)/100]. Display the CGPA of both the students. Averag Grade point e 8-10 3.5 6-7.9 3 4.5-5.9 2.5 <4 2

COMPREHENSIVE MICROSOFT OFFICE 365 EXCE

1st Edition

ISBN:9780357392676

Author:FREUND, Steven

Publisher:FREUND, Steven

Chapter5: Working With Multiple Worksheets And Workbooks

Section: Chapter Questions

Problem 4AYK

See similar textbooks

Similar questions

A company has 45 employers, 25 work as system developers (D) and (N) work as sales representer while (M) of them work as IT technicians. This company deals with 450 products. In the products table, each product has a name, price, size, and weight. Draw a flowchart on exel to find how many numbers of the products have a Small size(s), where there are 3 product sizes (S, M, L).
Display the following CALCULATION OF VOLUMES [CHOICE] [SHAPE]1 Cuboid2 Sphere3 Cylinder4 ExitEnter your choice-> b. The user has to input the choice. Display the appropriate message when the user enters invalid input. c. Based on the choice entered, get the data required from the user and display the volume of the shape chosen. d. The program will loop again start from step 1. The process will only stop when theuser enters choice 4 (The program will remain to loop if the enter choice is not 4) e. After the program exit from the loop, display the total_volume and average for all the shapes that have been calculated in the program. f. End the program by giving a closing message to the user.
Create a flowchart for the problem below.
Q3. A company has 45 employers, 25 work as system developers (D) and (N) work as sales representer while (M) of them work as IT technicians. This company deals with 450 products. In the products table, each product has a name, price, size, and weight. A. Draw a flowchart to find the product that has very heavy weight. B. Draw a flowchart to find how many numbers of the products have a Small size(s), where there are 3 product sizes (S, M, L). ':
Access the Australian Taxation Office website and find the current tax tables for individuals. Write a Python program that asks the user to enter their tax file number (using a 'string' data type) and then to enter their taxable income for the current financial year. If the user does not have an Australian tax file number, they should enter '0' instead. Then, based on the taxable income, the program should return the tax payable on their taxable income. After you finish your program, draw a simple flowchart for it. Please explain step by step
In column J, you want to display Early Admission, Early Rejection, Admit, or Reject, respectively, to indicate the final decision. In cell J11, enter the IFS function. If Admit Early is Yes, display the text Early Admission. If Reject Early is Yes, display the text Early Rejection. If the score is greater than the threshold score in cell B6, display Admit. If the score is less than or equal to the threshold score in cell B6, display Reject. Use mixed reference to cell B6.
Part 1 of 4 Compute the least-squares regression line for predicting the diastolic pressure from the systolic pressure. Round the sope and y-intercept to at least four decimal places. Regression line equation: y =
Q12.docx → Q/ The following table shows the order of five students degrees in mathmeties , physics and english lessons write an algorithm and draw the flowchart in basic language to read each student's degrees and caleulate average each student. No of student Math physics English 65 68 80 40 50 75 45 52 65 60 55 55 70 65 85 II
draw flowchart to read names and ages of people terminated by 9999 and print the name of the oldest person. assume that there is no person of the same age
Lael is always on the lookout for students who might be interested in running for office in student groups.In cell M2, enter a formula using a nested IF function and structured references as follows to determine first if a student has already been elected to office in a student group, and if not, whether that student meets the qualifications to run in the future: If the value in the Elected column is equal to the text "Yes", the formula should display Elected as the text. Otherwise, the formula should determine if the value in the Finance Certified column is equal to the text "Yes" and return the text Yes if true And No if false. what is the formula to enter into excel?
The number of bacteria measured at different times t is given in the following table. By Python code, determine a function that best fits the data (built-in function allowed). Use the equation to estimate the number of bacteria after 3.5h (built-in function not allowed). Make a plot of the points and the equation.
Lael is always on the lookout for students who might be interested in running for office in student groups.In cell M2, enter a formula using a nested IF function and structured references as follows to determine first if a student has already been elected to office in a student group, and if not, whether that student meets the qualifications to run in the future:a. If the value in the Elected column is equal to the text "Yes", the formula should display Elected as the text.