Scribd
Upload
3 views2 pages

Year-End Practical Record for IT Tools

This document outlines the Year-End Lab Practical Record for the Basic IT Tools course, detailing theory and practical exercises across four units. It covers topics such as spreadsheets, data analysis, word processing, and databases, with practical examples including an expense tracker and cell referencing exercises. The document serves as a comprehensive guide for demonstrating proficiency in essential IT tools.

Uploaded by

devanshuchaudhary20
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
3 views2 pages

Year-End Practical Record for IT Tools

This document outlines the Year-End Lab Practical Record for the Basic IT Tools course, detailing theory and practical exercises across four units. It covers topics such as spreadsheets, data analysis, word processing, and databases, with practical examples including an expense tracker and cell referencing exercises. The document serves as a comprehensive guide for demonstrating proficiency in essential IT tools.

Uploaded by

devanshuchaudhary20
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

Basic IT Tools

Year-End Lab Practical Record


Name: [Your Name]

Examination Roll No.: [Your Roll Number]

Course: B.M.S.

Subject (SEC): Basic IT Tools

Session: 2024-25

Preface
This document presents comprehensive theory and completed practical exercises for Units
1–4 of the Basic IT Tools syllabus, demonstrating proficiency through actual Excel tables,
charts, Word formatting, mail merge, and database tasks.

Table of Contents
Unit 1: Introduction to Spreadsheets

Unit 2: Data Analysis in Spreadsheets

Unit 3: Word Processing

Unit 4: Databases

Unit 1: Introduction to Spreadsheets

1.1 Worksheet Fundamentals


Worksheets provide a flexible grid for storing and organizing diverse data types in rows and
columns. Cells support data validation to restrict input formats (e.g., whole numbers, drop-
down lists). Named ranges simplify complex formulas and enhance readability. Conditional
formatting allows dynamic visual cues based on cell values.
Practical: Create an expense tracker table in Excel.

1.2 Cell Referencing


NAME OF THE EXERCISE: Understanding absolute, relative and mixed cell referencing;
performing the required functions

1. 1) Relative Cell Referencing

Student Name Marks In English Marks In History Total Marks

Riya 85 78 163

Ankit 88 84 172
Sanya 91 80 171

Kunal 87 85 172

Steps: -
1) Make table and insert the required data
2) Use the relative cell reference to calculate total, e.g., =B2+C2
3) Insert a graph by selecting the most appropriate one from the Charts group in the Insert
tab

You might also like