Login
Get Advice on Live Video Call
Earn $ Cash $ with
consultations on Bissoy App

SOP : Create a mark list. The mark list should display: Fields as Name, Math, Physics, Chemistry, Biology, Total, Percentage.

Monjur Alahi

SOP : Create a mark list. The mark list should display:

  • Fields as Name, Math, Physics, Chemistry, Biology, Total, Percentage.
  • Below each subject find out the lowest marks and highest marks.
  • Enter a minimum of 10 records.
  • Declare the first three ranker students.
  • Create a chart based on the above data.

0 like 0 dislike
51 views
Share with your friends

1 Answers

Salim Ahmed Kawsar

Call

Step 1: Open LibreOffice Calc and add fields like Name, Math, Physics, Chemistry, Biology, Total, Percentage.

Step 2: Enter 10 records in it.

Step 3: To Calculate Total Click inside the cell where the total has to be calculated.

(Use = SUM(A2:D2) formula) – Type the range of cell.

Step 4: Now click inside the cell where the percentage has to be calculated.

Calculate Percentage using formula = E2* 

100/400, drag the formula for remaining cells.

Step 5: Enter a minimum of 10 records. And calculate the result.

Step 6: Find out the Lowest Marks Calculate Lowest marks using formula = min(A2:A11), drag formula for remaining cells.

Step 7: Find out the Highest Marks Calculate Highest marks using formula = max(A2:A11), drag formula for remaining cells.

Step 8: Now Show the first three ranker students. Use Sort Option for sorting and auto filter.

Step 9: To find the first ranker use formula = large(F2:F11,1)

Step 10: To find the second ranker use formula = large(F2:F11,2)

Step 11: To find the third ranker use formula = large(F2:F11,3)

Step 12: To create a chart Select Complete Table → Click on Insert Menu → Click on Chart Option.

A window will appear, which starts with the chart wizard → Select Chart type.

0 like 0 dislike
49 views
Redox reactins play a pivoted role in chemistry and biology. The values of standard redox potential `(E^(@))` of two half-cell reactions decide which

Correct Answer - B Faraday law equivalents of `H_(2)` produced `=(Ixxt(sec))/(96500)` `0.01xx2=(10xx10^(3)xxt)/(96500)=96500xx2=t` `19.3xx10^(3)sec=t`

2 Answers 1 views
SOP : Create a Resume. The resume should contain the following

Step 1: Click on the LibreOffice Writer icon. Step 2: Create a New File. File Menu → New → Text Document Step 3: Write Title at the center with applicable font size. (Resume). Step...

2 Answers 1 views
SOP : Create an Informative presentation on your college. The presentation should contain a minimum of 8 slides.

Step 1: Preparing an Eight slide for an Informative presentation of your college. Press the Ctrl + N Keys. OR choose Slide → New Slide from Menu bar. OR Click on the...

2 Answers 6 views
Use of Accounting Package to create a company. Create a company with the following particulars. Company Name: B.B Enterprises

Step 1: Open GNUKhata Application. Click on ‘company Setup Wizard’ or (press shift + control + C) Step 2: While creating a company the following details are to be given. Company Name:...

2 Answers 1 views
Write a c program to accept marks of six subject find total and percentage display the results in grade such as distinction first class second class

provide percentage table

2 Answers 1 views
Write a c program to accept marks of six subject find total and percentage display the results in grade such as distinction first class second class 2 Answers 1 views
A student can solve 2 out of 4 problems of mathematics, 3 out of 5 problem of physics, and 4 out of 5 problems of chemistry. There are equal number of

Correct Answer - B Let `P(m),P(c),P(c)` be the probabilaty of selecting a book of maths, physics, and chemistry, respectively. Clearly, `P(m)=P(P)=P(c)=1/3` Again let `P(s_(1))and P(s_(2))` be the probability that he solves...

2 Answers 1 views
Mathematics, Economics, Physics, Chemistry

1. Economics 2. Chemistry 3. J. M. Keynes 4. Sunshine 5. AC – Car 6. Interest 7. Individual Income 8. Investment 9. Book 10. Labour

2 Answers 1 views
Choose the wrong pair: Physics, Chemistry, etc

Wrong Pair:  Prof. Alfred Marshall – Father of Economics

2 Answers 1 views
Two friends Jack and Jill attend IIT entrance test which has three sections, Mathematics, Physics and Chemistry.Each question in Mathematics, Physics

Correct Answer - Marks obtained by Jack = 164 Marks obtained by Jill = 157

2 Answers 2 views

Log in to ask questions, provide answers, or leave comments.


Login

Install the Bissoy app to consult with a doctor.


Download