Scribd
Upload
64 views1 page

Sem I Excel Practical Exam

The document outlines the end-term examination for BBA-CA Semester I at MES Senior College, scheduled for January 24, 2025. It includes two practical tasks: calculating grades based on student marks using Excel functions and creating a presentation with specified slides. The examination is worth a total of 20 marks.

Uploaded by

Pratibha Patil
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
64 views1 page

Sem I Excel Practical Exam

The document outlines the end-term examination for BBA-CA Semester I at MES Senior College, scheduled for January 24, 2025. It includes two practical tasks: calculating grades based on student marks using Excel functions and creating a presentation with specified slides. The examination is worth a total of 20 marks.

Uploaded by

Pratibha Patil
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 1

Maharashtra Education Society’s

MES SENIOR COLLEGE

END-TERM EXAMINATION BBA-CA


Semester I- 2024
BBACA T0l VSC- Office Automation Tools

Time: 1.00 Hrs Date: 24/01/2025 Marks: 20

EXCEL PRACTICAL -1

Q.1 The following worksheet contains Roll.Nos. & Marks in 5 subject of a student.
Calculate his grades as per the following : 10 Marks

A B C D E F
1 Roll No. ENG HINDI SCIENCE MATHS SO. SCI
2 110 45 56 67 78 60
3
4
5
6
7
8
9
10
11

Enter headings & data as shown in columns A to F

1 Calculate total of marks with function.

Calculate average of marks with function.

2 Use if condition and make Grade column and

write grade if average marks > 70 Distinction,

average marks > 60 first class, average marks > 35

pass.

Q.2 Create a presentation with following specification: 10 Marks

First Slide: Display name and your rollno number and percentage of 12th.
Second Slide: insert a any picture.
Third Slide: Display 'Thank You'

You might also like