TEACHER’S RESOURCE 1
Chapter 2 Formatting Data in Excel 2013 Worksheet
1. Unjumble the letters to form words using the hints given: (5)
a. MTINGAENL .........................................................................
Hint: It is the position where data is placed within the boundary of a cell.
b. PRAW EXTT .........................................................................
Hint: The option by which the data is confined to the cell but is displayed in multiple
lines.
c. OTNF . .......................................................................
Hint: A set of letters of the alphabet and numbers written in a particular style.
d. NNIERTATIOO . .......................................................................
Hint: It is the relative physical position or direction of text.
e. INREDLUNE . .......................................................................
Hint: It is a type of text formatting.
2. Who Am I? (5)
a. I am the keyboard shortcut for formatting text in Italics. ......................................
b. I am the default vertical alignment for any text entered in the worksheet.
.....................................
c. I am the group on the HOME tab where the Cell Styles button can be found.
.....................................
d. I am the default font in Excel 2013. ......................................
e. I am the combination of keys used to write data in multiple lines in the same cell.
.....................................
3. Identify the components A to E in the following figure of the Font group on the
HOME tab. (5)
B
E D
C A
A. . .................................................. B. ....................................................
C. . .................................................. D. ....................................................
E. . ..................................................
© Oxford University Press. All rights reserved. For exclusive use of teachers using KEYBOARD 6 © 2015.
2 TEACHER’S RESOURCE
Chapter 2 Formatting Data in Excel 2013 Worksheet Answers
1. a. ALIGNMENT
b. WRAP TEXT
c. FONT
d. ORIENTATION
e. UNDERLINE
2. a. Ctrl + I
b. Bottom
c. Styles
d. Calibri
e. Alt + Enter
3. A. Fill Color
B. Decrease Font Size
C. Borders
D. Font Color
E. Bold
© Oxford University Press. All rights reserved. For exclusive use of teachers using KEYBOARD 6 © 2015.