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.
Attachments:
Answers
Answered by
0
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
Similar questions