Question

Consider the following data :

I. Write the formula to find the sum of all subjects of Kerry and Risha.

II. Write the formula to find the average of marks of John.

III. Write the formula to find total marks in science by all the students.​

Answer 1

Answer:

Identify the primary key field.

Write a query to display patient’s information who suffers from Pneumonia.

Identify the fields that have the same data types.

2) What are the different views in power point? Explain the purpose of each view.

Section D 5m x 4 = 20 m

1) Write the steps to calculate the data across worksheets. How do you link the cells from different worksheets? (2m + 3m)

2) How do you group objects? What are its advantages? Write any six points on reviewing content in the presentation software. (2+ 1+3)

3) What are the two ways of scheduling an appointment? State the procedure to create a new appointment and also categorise it?(1 + 3+ 1)

4) What is RDBMS? In open office base, write the full syntax and an example for each of the following commands.

i) create ii) update iii) delete iv) select v) insert

Answer 2

$\huge {\underline {\underline \pink{ƛƝƧƜЄƦ}}}$

I. Write the formula to find the sum of all subjects of Kerry and Risha.

➡ = sum (C4 : E4) for Kerry

= sum (C6 : E6) for Risha

II. Write the formula to find the average of marks of John.

➡ = sum (C3 : E3) / 3

III. Write the formula to find total marks in science by all the students.

➡ = sum (E2 : E6)