SLIDE OF TODAY’S WORK
SUB: COMPUTER
STD:VI
Topic: Formatting Data in Excel 2016
Taught By : Ms. Pratiksha Virkud
Objective: Students will be able to know the steps to
format data in Ms-Excel.
Formatting
https://quizizz.com/join?gc=267194
data in
Spreadsheet
Online Session Conducted By:
Pratiksha Ms.
PAGE 2
▪Font Formatting
▪Alignment and
CONTENTS Orientation of Data
▪Number Formatting
▪Cell Styles
PAGE 3
▪The presentation of data
and its appearance on a
printed page is called
Formatting.
Formatting ▪Formatting changes the
appearance of data but
does not affect the actual
cell value.
PAGE 4
▪A font is a set of letters of
the alphabet and numbers
Font written in a particular
Formatting style.
▪For ex. Calibri is a font and
so is Times New Roman.
PAGE 5
▪Changing Font, Font Size,
Font Color
▪Bold, Italics and Underline
Font option
Formatting ▪Background colors and
Borders
▪Alignment and Orientation
of Data
PAGE 6
Alignment
▪Alignment refers to the position where data is placed
within the boundary of a cell.
▪By default, Excel applies appropriate horizontal
alignment to each data type, for example, numbers
are always right-aligned and text left-aligned.
PAGE 7
Alignment
▪Vertical Alignment can be top, middle or bottom.
▪Horizontal alignment can be left, center or right.
PAGE 8
Orientation
▪It refers to the relative physical position or direction of
text.
▪The usual orientation is horizontal.
▪You can change the orientation as you like.
PAGE 9
Number Formatting
PAGE 10
Orientation
PAGE 11
Orientation
PAGE 12
Excel Sheet
PAGE 13
Cell Styles
▪ You can use Excel 2016’s pre-designed cell styles rather than
formatting cells manually.
▪ Cell Styles are used to quickly add professional-level
formatting to different parts of a worksheet such as titles
and headers.
PAGE 14
Cell Styles
PAGE 15
Q1. The ________ button aligns the data in the
center of the merged cells.
A. Merge & Center
B. Center
C. Alignment
D. None of the above
Q2. ______ prefers to the relative physical position or
direction of text.
A. Alignment
B. Orientation
C. Merging
D. None of the above
Q3. How are numbers aligned in the cell by default?
A. Middle
B. Center
C. Right
D. Left
Q4. Which button is used to color the text or number
you entered in a cell?
A. Bold
B. Fill Color
C. Font
D. Font Color
RULES OF THE TEST
▪ Link will be provided by the teacher in the chat box option,
click on it and start with your test.
▪ All the Questions are compulsory.
▪ Complete All the details correctly.
▪ Read the questions properly and then answer.
▪ You will be provided 15 minutes to complete the test.
▪ Your video should be switch on and mikes off the whole
time.
▪ Do not copy.
▪ All The Best.
Orientation
PAGE 21
