Siksha Sarovar

Siksha Sarovar (sikshasarovar.com) is a free educational web application that helps students in India learn programming and prepare for academic and competitive exams. The platform offers structured coding courses (C, C++, Python, Java, HTML, CSS, PHP, Power BI, AI, Machine Learning, Data Science), complete university curriculum notes for BCA/MCA students with previous year question papers, Class 10 and Class 12 CBSE/HBSE school notes, and dedicated preparation material for SSC, UPSC, Banking, Railway and other government exams. Browsing the site is completely free and requires no account. Users may optionally sign in with Google solely to save their learning progress, quiz scores and personal preferences across devices.

Privacy Policy | Terms of Service | Contact Siksha Sarovar | About Siksha Sarovar

v4.0.9 · PWA
Siksha Sarovar logo
Siksha Sarovar
Your Learning Universe

Siksha Sarovar is a free e-learning platform for coding courses, BCA university notes and competitive exam preparation. Optional Google sign-in saves your learning progress across devices.

Initializing knowledge base…
Compiling modules 0%

Practical 2: Excel Basics & Student Academic Record Formatting

Lesson 2 of 14 in the free Statistical Analysis using Excel Lab notes on Siksha Sarovar, written by Rohit Jangra.

Theoretical Questions

a) Basic Components of an Excel Window

ComponentDescription
Title BarDisplays the workbook name and application name
RibbonContains all Excel commands organized in tabs (Home, Insert, Formulas, Data, etc.)
Formula BarShows the content or formula of the active cell
Name BoxDisplays the address of the currently selected cell (e.g., A1)
Worksheet AreaThe grid of rows and columns where data is entered
Sheet TabsAllow navigation between multiple worksheets
Scroll BarsHorizontal and vertical bars to navigate through the sheet
Status BarShows quick statistics (Sum, Average, Count) for selected cells
Quick Access ToolbarProvides shortcuts to frequently used commands

b) Workbook vs Worksheet

FeatureWorkbookWorksheet
DefinitionThe entire Excel file (.xlsx)A single spreadsheet tab inside a file
ContainsOne or more worksheetsRows, columns, and cells
AnalogyLike a physical notebookLike a single page inside the notebook
DefaultOpens with 1 sheet by defaultNamed Sheet1, Sheet2, etc.
LimitLimited by system memoryUp to 1,048,576 rows × 16,384 columns

c) AutoFill Feature in Excel AutoFill allows Excel to automatically fill a series of data (numbers, dates, weekdays, months, custom lists) by dragging the Fill Handle (small green square at the bottom-right of a selected cell).

  • Number series: Enter 1, 2 → drag down → fills 3, 4, 5…
  • Date series: Enter 01-Jan-2026 → drag → fills 02-Jan-2026, 03-Jan-2026…
  • Months: January → drag → February, March…
  • Formulas: Drag a formula cell to apply it to adjacent cells

---

Practical Task: Student Academic Record

Dataset (15 Students)

S.NoStudent NameCollege NameClassSub 1Sub 2Sub 3Sub 4
1Aman SharmaGovt College ShimlaBCA-II78859270
2Priya SinghHP University ShimlaBCA-I65728088
3Rohit VermaDAV College ChandigarhBCA-III90887682
4Neha GuptaGovt College ShimlaBCA-II55607065
5Vikas YadavHP University ShimlaBCA-I95918793
6Riya JainDAV College ChandigarhBCA-III72687477
7Karan MehtaGovt College MandiBCA-II83798581
8Anjali TiwariHP University ShimlaBCA-I48556258
9Sanjay PatelGovt College ShimlaBCA-III76807884
10Pooja RawatDAV College ChandigarhBCA-I88849086
11Amit KumarGovt College MandiBCA-II62706873
12Sunita RaniHP University ShimlaBCA-III91899496
13Dev SharmaGovt College ShimlaBCA-I74777279
14Kavita NegiDAV College ChandigarhBCA-II58636761
15Rahul ThakurGovt College MandiBCA-III85828887

---

Formatting Steps

  1. Merge & Center title "Student Academic Record" across all columns → Home → Merge & Center
  2. Title: Bold, Font Size 16, Background color (e.g., Light Blue)
  3. Column Headings: Bold all headers
  4. Column Width & Row Height: Double-click column border to auto-fit
  5. Borders: Select entire table → Home → Borders → All Borders
  6. Center-align: S.No, Class, and all Marks columns
  7. Wrap Text: College Name column → Home → Wrap Text
  8. Highlight marks > 75: Select marks range → Conditional Formatting → Highlight Cell Rules → Greater Than → 75 → Yellow Fill
  9. Number formatting: Select marks → Format Cells → Number → 0 decimal places