Create worksheet using excel having different columns

Assignment Help Basic Computer Science

Reference no: EM1364372

1) Create a worksheet using excel having different columns depicting the Serial Number, Name of the Student, Marks obtained in various subjects i.e. English, Maths, and Science. Put in the required data for the respective columns in 20 rows. Your worksheet should contain the following:

i) Formulas that automatically calculate the grand total, average and the percentage of each student presuming that the marks in each subject are given out of 100

ii) Automatically find the highest and lowest number obtained in each subject.

Reference no: EM1364372

Questions Cloud

Determine features of ram to include in web server : Determine the features and capacities (RAM, disk storage, processor speed) that Amy should include in the Web server computer that she will need for her site.

What is the electric flux through the surface : A flat surface with area 1.6 m2 is in a uniform electric field of 560 N/C. What is an electric flux through the surface when it is oriented as follows.

Compute a range of possible values for total gain : Compute a range of possible values for total gain with a Illustrate what is meant by the term 'utility,' and how does it relate to purposeful behavior.

How strong is the electric field between the plates : A speedboat moving at 30 m/s approaches a no-wake buoy marker 100 m ahead. The pilot slows the boat with a constant acceleration of negative 3.5 m/s^2 by reducing the throttle. How long does it take boat to reach the buoy.

Create worksheet using excel having different columns : Create a worksheet using excel having different columns depicting the Serial Number, Name of the Student, Marks obtained in various subjects i.e. English, Maths, and Science.

Compute the year-to-year growth rates of real gdp : Compute the year-to-year growth rates of real GDP. Can you identify the recession that occurred during this period?

Why experiment show the same wave front simultaneously : A third listener is positioned along the positive y-axis. What is her y-coordinate if same wave front reaches her at the same instant it does the first two listeners.

Ruben corporation-breakeven point : Corresponds to CLO 2(c) Ruben Corporation manufactures and sells T-shirts imprinted with college names and slogans. Last year, the shirts sold for $7.50 each, and the variable cost to manufacture them was $2.25 per unit.

What is the speed of the train at the end of distance : After collision, the component of the total momentum parallel to the floor must remain zero, since the net external force acting on the plate has no component parallel to floor.find out the masses of pieces 1 and 2.

User Account

All Pages