WorksheetsMicrosoft Excel - Formatting
Total questions: 10
Worksheet time: 10mins
Name
Class
Date
1.
Which feature would allow you to change the formatting of any cells that are less than $100.00?
a)
Cell Formatting
b)
Easy Formatting
c)
Auto Formatting
d)
Conditional Formatting
2.
To sort names in a worksheet, we can use this button.
a)
b)
c)
3.
What is this icon?
a)
Zoom
b)
Sort and Filter
c)
Symbol
d)
Merge and Center
4.
To arrange data in alphabetical or numerical order is what?
a)
coding
b)
sorting
c)
graphing
d)
grouping
5.
To arrange data in ascending order of age we will
a)
Filter it
b)
Sort it
c)
Apply Conditional Formatting
d)
Rearrange data manually
6.
What can you use to organise your data by changing the order it appears in.
a)
Filters
b)
Functions
c)
Sorts
d)
Charts
7.
How do you change column width to fit the contents?
a)
Single-click the boundary to the left of the column heading
b)
Double-click the boundary to the right of the column heading
c)
Press ALT and single-click anywhere in the column
8.
To sort data in Excel, go to the __________ ribbon.
a)
Home
b)
Data
c)
Insert
d)
View
9.
What is this icon?
a)
Zoom
b)
Sort and Filter
c)
Symbol
d)
Merge and Center
10.
State true or false.
You can sort data in only one field.
a)
True
b)
False
c)
Don`t know
100 %
