wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

Revision 2 BUS02004: Create and use basic spreadsheets

Total questions: 20

Worksheet time: 10mins

Name
Class
Date
1.

A ..................is a built-in formula in Excel.

a)

function

b)

Ribbon

c)

Column

d)

Raw

2.

In Excel, a ................. is used to display data in a graphical format.

a)

Chart

b)

Cell

c)

Table

d)

Formula

3.

............................ allows for the horizontal and vertical alignment of text, wrap text, shrink text, merge cells and the direction of the text.

a)

Border tab

b)

Alignment tab

c)

Font tab

d)

Number tab

4.

By choosing ...................................tab you can combine the cells and centers the contents in the new larger cell

a)

Merge & Center

b)

Merge Cells

c)

Unmerge Cells

d)

Merge Across:

5.

The .......................... feature in Excel allows you to automatically fill cells with data based on a pattern.

a)

Data Validation

b)

Flash Fill

c)

Conditional Formatting

d)

AutoFill

6.

Excel offers many types of ......................including Column, Line, Pie, Bar, Area, Scatter and more

a)

Shapes

b)

Tables

c)

Charts

d)

Drawing

7.

By Pressing one of the buttons in Excel we can create

a)

Form

b)

Picture

c)

Chart

d)

Border

8.

The .......................... function in Excel is used to find the highest value in a range of cells.

a)

MAX

b)

AVERAGE

c)

SUM

d)

MIN

9.

To set the page margins Click the Margins button on the ........................tab

a)

Data

b)

Home

c)

Formulas

d)

Page Layout

10.

you can create a header or footer by clicking the Header Footer button on the ........................tab

a)

Data

b)

Home

c)

Insert

d)

Page layout

11.

To align cell contents, click the cell or cells you want to align and click on the options within the Alignment group on the .............tab.

a)

Review

b)

Home

c)

Insert

d)

Data

12.

You can hide a row or column by right click on it and choose Hide or Unhide.

a)

True

b)

False

13.

The ribbon is the panel at the top portion of the document, it has five tabs

a)

True

b)

False

14.

You can start using Microsoft Excel 2010 by click on Start Programs Microsoft

a)

True

b)

False

15.

Once you have created a chart you can't modify it

a)

True

b)

False

16.

You can change the name of a worksheet or change the color of the tabs even if you saved it.

a)

True

b)

False

17.

If you want the same data copied into the other cells, you only need to complete one cell

a)

True

b)

False

18.

The first step to insert cells, rows, and columns in Excel is to place the cursor in the row below where you want the new row

a)

True

b)

False

19.

Common functions in Excel are (Sum-Average-Minimum-Maximum)

a)

True

b)

False

20.

The page orientation in Excel can be portrait Only.

a)

True

b)

False