Scribd
Upload
80 views3 pages

Exercise 1

This document provides instructions for completing several Excel exercises: 1. Design a table using formatting facilities in Excel. 2. Design a table using Fill Series facilities in Excel. 3. Design a table using Flash Fill and Fill Series facilities in Excel. 4. Create a spreadsheet to calculate marks and rankings for a student, using relevant formulas and formatting. 5. Enter student information into a worksheet and use functions to extract initials, surnames, titles, names with titles, and registration numbers from the data.

Uploaded by

Inoka Rasanjalee
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
80 views3 pages

Exercise 1

This document provides instructions for completing several Excel exercises: 1. Design a table using formatting facilities in Excel. 2. Design a table using Fill Series facilities in Excel. 3. Design a table using Flash Fill and Fill Series facilities in Excel. 4. Create a spreadsheet to calculate marks and rankings for a student, using relevant formulas and formatting. 5. Enter student information into a worksheet and use functions to extract initials, surnames, titles, names with titles, and registration numbers from the data.

Uploaded by

Inoka Rasanjalee
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/ 3

EXERCISE 1

1. Design the following table using the formatting facilities in Excel.

2. Design the following table using the Fill-Series facilities in Excel.

1
3. Design the following table using the Flash fills and fill series facilities in Excel.

4. Create a spreadsheet using MS Excel 2013, by the following instructions given


below:

2
a) Use the relevant formula to calculate the total marks of 'Kavindu' (Index No.-
MO/101) and copy the formula to the relevant cells.
b) Use the relevant formula to calculate the average marks of 'Kavindu' (Index
No.- MO/101) and copy the formula to the relevant cells.
c) Format the "Average" column with two decimal places.
d) Use the relevant formula to find the rank of 'Kavindu' (Index No.- MO/101)
and copy the formula to the relevant cells.
e) Calculate the number of students who have got the average marks greater than
75 using the COUNTIF function.

5. Enter the following information in a worksheet.


Full Name

With Title
Surname

Reg No
Course
Status

Name
Initial

Title
SNo

Age
Sex

S01 Aswin Arun M Single 24 MsOffice A Arun Mr Mr.A.Arun MsO/24/S01


S02 Silva Muru M Married 25 MsOffice
S03 Ramanan Seetha F Single 21 DTP
S04 Kogul Varun M Married 33 DTP
S05 Banda Sharmili F Married 27 DCP
S06 Shykan Sharmi F Single 19 DCP
S07 Suthan Abiram M Married 29 PCA
S08 Zulfur Rishvi M Single 27 PCA
S09 Geethan Milan M Married 31 MsOffice
S10 Jeevan Suruthi F Married 32 DTP

Write suitable Function for the following:


a. Initial of the person
b. Surname of the person
c. Create the Title using the following conditions:
If the person is to be Male and Married/Single then Title----”Mr”
Female and Married then Title---”Mrs”
Female and Single then Title ----”Miss”
d. Fill the Name with Title Column
e. Create the Reg No using Course , Age & SNo
(Reg No format : First 3 characters of the Course/Age/SNo)

You might also like