Spreadshets-Multilevel Sorting

Instructions:

Download Activity File and follow the following instructions.

Tasks
1	Sort the list in order of sections.
2	Keep only your section's data and delete rest of the data.
3	Add gender column.
4	Enter data (M/F) in gender column.
5	Sort the list in order of Gender.
6	Add appropriate headings.
7	Format the data in a presentable form.
8	Save in your folder in D: drive.
9	Observe demonstration for Multilevel Sorting.

Spreadsheets - Sorting

Objectives:

1. To SORT a given range of data according to various criteria.
2. To save and retrieve files.

SORTING:

To rearrange data in a prescribed sequence is called sorting.

Link to Activity File

List Operations

Link to Sample Program for List Operations with Broadcast.

Link to quiz on Variable and Lists

Link to Quiz

Spreadsheets - Lesson 1

January 6, 2019 to January 10, 2019

Introduction to Spreadsheets

What is a Spreadsheet Application?
A spreadsheet is an application software to save, analyze and manipulate data.

Link to Activity File