Free Printable ms Excel

Worksheets

ms Excel

Total questions: 25

Worksheet time: 13mins

Name

Class

Date

What kind of software is Excel?

Spreadsheet software

Word Processing

Drawing

What is the Formula sign for multiply?

In Excel rows are labeled by

Letters

Numbers

In Excel, columns are labeled by?

Numbers

Letters

What button will add up a group of numbers?

Equals button

Auto sum button

Plus symbol button

What is the name of this cell?

B10

2 or more cells that are selected to create a source to be used in a formula

Range

Max

Filter

Colums

What is the Sum formula?

Sum( )

Sum( )=

=Sum( )

=( )Sum

When starting a formula what is the first thing you type in the cell?

10.

Excel spreadsheets that are already created and ready for you to edit are known as?

spreadsheets

templates

data inputs

pages

11.

A function in Excel is represented by what to letters?

f( )

12.

How would you write a cell reference formula for cell A1 subtracted by Cell C3?

A1-C3

A1-C3=

=A1-C3

=C3-A1

13.

the sum of all numbers divided by the amount of numbers.

Maximun

Minimum

Median

Average

14.

The feature to center text across several cells is called:

Wrap Text

Merge and Center

Shrink to Fit

Number Formatting

15.

This icon is called the what?

Arrow

Fill handle

Pointer

16.

What is the formula to find the lowest number in cells C1:C4?

=average(C1:C4)

=max(C1:C4)

=min(C1:C4)

=sum(C1:C4)

17.

What does this symbol do:
/

Multiply

Add

Divide

Minus

18.

_________ allows you to perform calculations on data entered into a spreadsheet?

Formulas

Data

Cell

Cell reference

19.

How do you select an entire column?

Select Edit > Select > Column from the menu

Click the column heading letter

Hold down the shift key as you click anywhere in the column.

Hold down the Ctrl key as you click anywhere in the column

20.

The option that reduces the font size of the data to accommodate it within the column width

Shrink to fit

Columns

Text orientation

Wrap text

21.

The option which accommodates the text in a column by using multiple lines

Text orientation

Wrap text

Merge cells

None of these

22.

What is the formula for =sum(B2:B9)

B1+B2+B3+B4

=B2+B3+B4+B5+B6+B7+B8+B9

B2+B3+B4+B5+B6+B7+B8+B9

=B1+B2+B3+B4

23.

What would I use to combine cells A1:A9?

adjust column width

merge

wrap text

24.

If you see a series of "######" in a cell, that means the following:

Row height is too high

Column width is not wide enough

25.