☑ Highlight the marks of each subject >75 and change the cell and font colour. Activity – 7: Create a MACRO to prepare a marksheet of 10 students for 5 subjects (Marks out of 100 for each subject): Activity – 6: Using SOLVER option in OpenOffice Calc, project the simple interest amount by changing principal amount and rate of interest while calculating simple interest. (Use GOAL SEEK in OpenOffice Calc) Find out how many marks should she obtain in 4 th semester to secure distinction. Assuming that the examination of each subject is for 100 marks, her marks of the previous semesters are given as under. ☑ Interest for different amounts and years (two variables) Activity – 5: A student is planning her goals about the marks she should attain in the forthcoming Semester 4 examinations in order to achieve a distinction (75%). Activity – 4: Calculate simple interest using one variable and two variables using MULTIPLE OPERATIONS in OpenOffice Calc: Activity – 3: Prepare a SCENARIO to calculate Simple Interest for different principal amount, rate of interest and year. Calculate the area wise distribution of products using SUBTOTALS in OpenOffice Calc. Activity – 2: APS Distributers distributes products in different areas. Help them to prepare a CONSOLIDATED DATA for the above year using OpenOffice Calc. Unit 2: Electronic Spreadsheet (Minimum Five) Practical Activities Activity – 1: XYZ BANK has its deposit and withdrawal detail of customers for 3 months. Class 10 English Language and Literature 184 Sample Papers.10+ Sample Papers Class 10 Comp Application.Class 9 to 12 Artificial Intelligence Sample Papers.Class 9 Artificial Intelligence MCQs & Que n Ans.Class 10 Artificial Intelligence CBSE Question Bank.
Class 10 Artificial Intelligence MCQs & Que n Ans.Class 10 Info Tech Term 2 CBSE Board QP Solution.Unit 5 Green Skills 50+ Question Answer.Unit 4 – Entrepreneurship Skills 100+ Question Answer.Unit 2 Self Management Skills 50+ Questions and Answer.Unit 1 Communication Skill 50+ Questions and Answer.Unit 2 Self Management Skills 150+ MCQ’s.Class 12 Informatics Practices Sample Paper.Class 11 Informatics Practices Sample Paper.200+ Data Visualization using Python MCQ’s.200+ Data Handling Using Pandas-I MCQ’s.Class 12 IP Term 1 CBSE 2021 QP with Answer.Python Functions – Working with Functions.
0 kommentar(er)
