Question

28.

Given the following Spreadsheet, write the appropriate Formula/Expression/Function
to be used for (a) to (e) :
PlayerID Name Points Bonus Rank Total
1 Akash Gohel 1300 200 4
2 Binay 1800 150 1
3 Tanish 1600 100 3
4 Daniel 1200 100 5
5 Sandeep Patel 1700 200 2

(a)Write formula to calculate the Total points (Sum of Points + Bonus) of each player in
cell F2 – F6.
(b)Write the feature used for arranging the Rank from Highest to Lowest.
(c)To find the Player with Maximum TOTAL to be written to Cell F7.
(d)To find the Average of Points to be written in cell C7.
(e)To change the Orientation of the Page from Landscape to Portrait.​

Answer 1

Answer:

consider the following table and answer the following :

ID Department OPD_DAYS Doctor_Name

H201 ENT MWF Akaash Arora

H308 Oncology TTS Dharma Sharma

H907 Paediatrics MWF Sanjay Singh

(a)

Identify suitable Primary Key from the above table.

(b)

Add a new record with the following data :

(‘H608’, ‘Cardiology’, ‘TTS’, ‘Vinita Wahi’)

(c)

Write a select query to display records of those Doctors whose OPD_DAYS are

‘MWF’.

Explanation:

consider the following table and answer the following :

ID Department OPD_DAYS Doctor_Name

H201 ENT MWF Akaash Arora

H308 Oncology TTS Dharma Sharma

H907 Paediatrics MWF Sanjay Singh

(a)

Identify suitable Primary Key from the above table.

(b)

Add a new record with the following data :

(‘H608’, ‘Cardiology’, ‘TTS’, ‘Vinita Wahi’)

(c)

Write a select query to display records of those Doctors whose OPD_DAYS are

‘MWF’.