Wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

MS Excel: Formatting Data & Worksheets [G4]

Total questions: 10

Worksheet time: 50mins

Name
Class
Date
1.

TRUE or FALSE

A style is a set of formatting attributes such as font name, size, alignment, and text color.

(a)  

2.

Which command allows you to apply styles for your selected cell or cell range?

a)
b)
c)
d)
3.

Which command allows you to apply table styles?

a)
b)
c)
d)
4.

Which CLEAR command allows you to remove table styles?

a)
b)
c)
5.

TRUE or FALSE

A table style is a set of formatting choices such as colors, fonts, and effects that you can apply on your worksheet data or other items.

(a)  

6.

In which tab can you find the Themes group?

a)

Home

b)

Insert

c)

Page Layout

d)

View

7.

All the given commands are found in the Themes group, EXCEPT _____.

a)

Colors

b)

Fonts

c)

Effects

d)

Styles

8.

Which command are you going to click to remove all borders in your worksheet?

a)
b)
c)
d)
9.

Which number format is used to display currency sign, set the number of decimal places, and set how negative numbers will be displayed.

a)

General

b)

Currency

c)

Percentage

d)

Number

10.

When you have a long line of text, part of the text might not be visible.

To fix this without changing the column width, click _____.

a)
b)
c)
d)