Chapter 2 Formatting Data in Excel 2013

OBJECTIVE TYPE QUESTIONS

1. a. iv. Left b. iv. all of these c. ii. Wrap Text
d. iv. All of these e. ii. 54,612.000
DESCRIPTIVE TYPE QUESTIONS
1. a. Wrap Text: You can make the text wrap within the same cell. The data is
confined to the cell but is
displayed in multiple lines.
Merge & Centre: You can merge adjacent cells into one large cell. The text will be
centre-aligned in the
single merged cell.
b. Number group of the HOME tab shows the various formatting type options for
numbers in the Number
Format drop down list. To add the Rupee symbol do the following:
i. Click the arrow next to Accounting Number Format and select More Accounting
Formats. The
Format Cells dialog box appears.
ii. Select the Symbol as PKR English (UK) and click OK. The Rupee symbol appears
before the number
in cell.
c. Select the cells A1:E5 and click the arrow next to Fill Color to choose a colour. The
colour will be set as
the background of the selected cells.
d. The buttons in the lower row of the Number group of the HOME tab are:
Accounting Number format, Percent Style, Comma Style, Increase Decimal, and
Decrease Decimal.
e. To format the data to 25 0:
i. Type the number in the cell. Select the cell.
ii. Click the drop down menu arrow of the Orientation button in the Alignment group
on the HOME
tab.
iii. The drop down menu appears.
iv. Click Format Cell Alignment option.
v. The Format Cells dialog box appears with the Alignment tab selected.
vi. Under Orientation, using the mouse, drag the pointer to 250 angle.
vii. The text in the selected cell will appear at this angle.
f. Formatting allows the user to change the way the content of a cell appears in Excel
but not change the
exact cell value. Excel allows the user to format both text and numbers. This is
important because it
allows for differentiation between different types of data. The user can highlight the
important parts of
the worksheet using background colours, different styling of font, or increasing the
font size, or even
using different fonts. In the same way; since Excel was primarily created to deal with
large calculations;
number formatting provides the user with a selection of options to make the Excel
sheet more presentable
and useful. For example, the user can assign the number of decimal places required
when dealing with
large numbers. The user can also access percentages, scientific notations, fractions,
and give symbols
for different currencies, etc. All this allows the finished worksheet to look more
presentable and easier
to understand.
So the advantages derived from the formatting options include ease of readability,
better organisation,
a more professional look, and a better understanding of large and complex numerical
data.
2T E A C H E R ’ S R E S O U R C E
1g. A student might choose to use font formatting because it allows for more
creativity and customisation,
i.e. applying only those formatting commands which they really want. At the end of
the day, though,
they will only be formatting fonts which is just a small part of the formatting tools
available.
The students who choose cell styling are more correct, as not only does it save time
in formatting the
contents of a cell, the fact that it deals with all aspects of formatting such as font,
alignment, type of
numbers to use, type of border, cell fill, etc., makes it a more complete solution. Also,
Excel allows the
user to define their cell style.
h. Presentations will vary. What you should look for is an application of most of the
commands that were
taught in the chapter. Check to see if the student has used:
a. Font formatting (size, bold, italic, underline, colour, type, alignment)
b. Cell borders and colours
c. Number formatting

Chapter 2 Formatting Data in Excel 2013 Test Paper

1. Fill in the Blanks (5)
a. . Alignment. refers to the position in which data is placed, within the boundary of
a cell.
b. Fonts can be selected from a Font group on the ........home................. tab.
c. There are 72 points in an inch when we talk about .....font size.................... .
d. You can mix your colours to get the desired colour on the .....custom...............
tab.
e. Ctrl + B key is used to make any text .........bold................ .

2. Write T for the true statement and F for the false one. (5)
a. Ctrl + I is used to make any text bold. f
b. Horizontal alignment can be left, right or centre.
c. Left, right or centre are vertical alignments. f
d. The Currency command is part of the Number group.
e. Excel 2013 has pre-designed cell styles.

3. Very Short Answer Questions (4)

a. Name the two different types of date formats.
Short Date and Long Date are the two different date formats available.

b. Which tab has the Cell Styles command?

The Cell Styles command is present on the HOME tab.

c. Name the different types of vertical alignment.

Top, middle, and bottom are the different types of vertical alignment.

d. What is the use of the Wrap Text command?

Wrap text helps the text to be placed in the same cell in multiple rows. It does
not allow
text to spill over to other cells.

4. Short Answer Questions (6)

a. What is a font?
A font is a set of letters of the alphabet and numbers written in a particular
style.

b. Explain the process of merging data in cells.

Select cells to be merged, click on Format cell, go to the Alignment tab and
click on merge
cells.

c. What is the difference between horizontal and vertical alignment?

Vertical alignment is top, middle, or bottom whereas horizontal alignment is
right, left
or centre within a cell.
Name Marks
Aleena 425
Bobby 310
Dawood 460
Farooq 299
Ibrahim 475
Ismail 340
Jaweria 320
Hamid 300
Abid 409
Sara 416
5. Lab Exercise (5)
Observe the given information about the marks of a
group of students in class X. Now do the following
a. Replicate the data in a [Link] file.
b. The first cell “Class X” has to be constructed by
merging cells.
c. Give the cell with the title a green background
colour and yellow to all the other cells.
d. The text should have horizontally centred alignment.
e. Change the font to Verdana, size 12.

3. a. Short Date and Long Date are the two different date formats available.
b.
c.
d.
4. a.
b.
c. Vertical alignment is top, middle, or bottom whereas horizontal alignment is right,
left
or centre within a cell.
5. a. Open and save an Excel 2013 file called [Link]
b. Take the two cells A1 and B1 and merge it. Insert data “Class X” inside the
merged cell.
c. Place data “Name” and “Marks” in cells B1 and B2.
d. Insert marks data (names and marks) for each student starting from C1:C2, D1:D2
and so
on according to the table provided.
e. Select all the data, click the Borders drop-down menu arrow and select All Borders
in
the menu.
f. Select A1:A2 (merged cells), click the Fill Colour option and fill the merged area in
orange.
g. Similarly, select all the cells in the table from B1:B2 downwards and fill it with
yellow
colour.
h. Select the area of the data (A3:B12) and choose Centre in the Alignment group.
i. Select the full table. Click the drop-down menu arrow of the Font command in the
Font
group and select Verdana in the list. Click the drop-down menu arrow of the Font
Size
command in the Font group and select 12 as the size.