Practice Question On EXCEL

Data Analysis
,
#1

1. create a spreadsheet of a mark sheet using following fields

1.Rollno,Name,ur sem all subjects in each column, computer practical

2 Total,Percentage,Result(Pass/Fail),Grade

3 Apply formatting to the worksheet

4 apply condition to Grades as follows:

i) “A” Grade if Percentage>=70

ii) “B” Grade if Percentage >=60 & <70

iii) “C” Grade if Percentage >=50 & <60

iv) “D” Grade if Percentage <50

Enter 10 records (all theory subject marks entered out of 100 & practical out of 50)

a. calculate TOTAL marks using Sum function.

b. calculate PERCENTAGE using AVERAGE function.

c. In Result column display “PASS” if all subject >=35 otherwise “FAIL”.

d. Display all <35 marks in Red color.

2. create an Excel Spreadsheet, which contains a information of EMPLOYEE’s of private Ltd co

  1. Fields:- EMPNO,EMP NAME, BASIC SALARY, DA, HRA, TA , PF, PT & NET SALARY
    (DA=3%Basic Salary,HRA=5% Basic Salary,TA=2% Basic
    Salary,PF=2%of Basic Salary & PT=2% if Basic Salary >10000)

  2. All the calculation should performed by FORMULA
    Apply appropriate format to the worksheet.

  3. Enter 10records.

  4. Give the main Heading to the spreadsheet like “BRAINSOFT INFOSYS Pvt Ltd.,”

1 Like