Question

29.
30.
Hu ey alla Foreign key with example.
Wite down the steps for creating a table in office application or access.
Given the following spreadsheet, write the appro
o spreadsheet, write the appropriate formula s/functions/expressions
Feature to be used for (a) to (e).
В
No
Name
Region
Bonus
Total Sales
Sunil
North
Vijay
East
Monthly
Sales
10,000/-
13,000/-
15,000/-
13,200/-
Sandeep
South
lamin
20001-
30001 -
2400/-
2000/-
2500/-
Sagar
West
Naveen
East
12,000/-
Calculate the total sales as a sum of Montly sales + Bonus as Total in cell F2.
Find the minimum montly sales from the column monthly sales.
Write the feature used for arranging the monthly sales from Highest to Lowest.
To find hte average of Bonus to be written in cell E7
The tab name to change the orientation of the page from Landscape to potrait.​

Answer 1

Answer:

(a) f2=12000

    f3=16000

    f4=17400

    f5=13400

    f6=14500

(b)sort (sort group , data tab)

(c)=AVG(E2:E6)

(d)tab is page layout

hope this helps u :)

n all the best for the examssss