wayground logo

Free Printable Worksheets

NEW

Font size

S
M
L
XL
Worksheets

Play with MS Excel - 1

Total questions: 15

Worksheet time: 7mins

Name
Class
Date
1.
To change the font, font size, color, or style: Select the ________ you want to modify.
a)
Column Headings
b)
Cells
2.
A quick way to include professional formatting for different parts of your workbook, such as titles and headers.
a)
Font Color
b)
Cell Style
c)
Borders
d)
Fill Color
3.
_______ allows you to set a column's width to fit its content automatically.
a)
Auto Fill
b)
Resize
c)
Fill Handle
d)
Auto Fit
4.

What does every formula in MS EXCEL start with?

a)

+

b)

-

c)

=

d)

*

5.

What is a rectangular box in a MS EXCEL Spreadsheet called?

a)

row

b)

column

c)

cell

6.

What is an example of a RANGE in MS Excel.

a)

B2-F5

b)

F5:B2

c)

B2:5F

d)

(B2:F5)

7.

Kenyon would like to convert the cell range A1:F20 to a Medium 18 style. Which formatting style should he select?

a)

Cell Style

b)

Conditional Formatting

c)

Fill Color

d)

Format as Table

8.

Which command on the Home Ribbon do you use to temporarily hide specific values on a worksheet based on a criterion?

a)

Find & Select

b)

Format Cell

c)

Sort & Filter

d)

Organize

9.

Joan has created a spreadsheet that displays sales of her employees. She would like to view only those employees with sales above $25,000 who are from Region 3. What option will allow her to do that?

a)

Ascending

b)

Descending

c)

Filter

d)

Custom Filter

10.

Joan wants to see her sales representatives in numerical order with the sales person who sold the least at the top. Which sorting option should she choose?

a)

Ascending

b)

Customer Filter

c)

Descending

d)

Primary Sort

11.

Cooper is creating a spreadsheet for FBLA and wants to be able to put the spreadsheet in alphabetical order by last name. What should Cooper apply to the spreadsheet?

a)

Filter

b)

Formula

c)

Macro

d)

Sort

12.

What Home Ribbon group contains the command used for quickly converting selected cells to a table by choosing a table style?

a)

Alignment

b)

Editing

c)

Font

d)

Styles

13.

David only wants to view the employees in the Marketing department who earn a salary of more than $25,000. What command should he use to complete this task?

a)

AutoFill

b)

Filter

c)

Find and Replace

d)

Sort

14.

David wants to arrange the employee salaries in Column A of his spreadsheet from lowest to highest. What command should he use to complete this task?

a)

AutoFill

b)

Filter

c)

Find & Replace

d)

Sort

15.
Allows you to create clear and defined boundaries for different sections of your worksheet.
a)
Cell Borders and Fill Colors
b)
Headings
c)
Font Size
d)
Font Color