wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

Excel Getting Started

Total questions: 50

Worksheet time: 49mins

Name
Class
Date
1.

Which of the following is not a correct cell address?

a)

2D

b)

A27

c)

B15

d)

C2

2.

A row is identified by which of the following?

a)

Number

b)

Letter

c)

Symbol

d)

None of the above

3.

What is the function of the mouse pointer in the image?

a)

It allows you to move the contents of the cell

b)

It allows you to select more than one cell

c)

It copies what is in the cell

d)

It allows you to widen the column

4.
The area within the red box is called
a)
Active Cell
b)
Fill Handle
c)
Cell
d)
Row
5.

Define Cell?

a)

The dark bordered box in excel.

b)

A box in Excel that has formulas.

c)

The intersection of a column or row in a worksheet or table.

d)

Fx Bar where you input data

6.
Provides easy access to frequently used commands:
a)
group
b)
Quick Access Toolbar
c)
cell
d)
none of the above
7.

This is a_____________?

a)

Row

b)

Column

c)

Cell

d)

Range

8.

A Cell is___________________?

a)

Where a row and column intersect

b)

Cell running vertically

c)

Cell running horizontally

d)

All of above

9.

Name the active cell______?

a)

C5

b)

B4

c)

C6

d)

D6

10.

The first cell in a worksheet is what?

a)

A1

b)

1A

c)

FX

11.

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

a)

row

b)

column

c)

cell

12.
This is a:
a)
tab
b)
ribbon
c)
group
d)
none of the above
13.

In Excel, rows are identified by

a)

Letters

b)

Numbers

14.

In Excel, Columns are labelled as ___

a)

A, B, C, etc

b)

1,2,3 etc

c)

A1, A2, etc

d)

$A$1, $A$2, etc.

15.
In a cell reference, for example A1, what does the letter refer to?
a)
The column
b)
The cell
c)
The row
16.

What is the cell reference of the active cell?

a)

A1

b)

4B

c)

BB8

d)

B4

17.

1) Which cell is selected in this picture?

a)

B2

b)

B3

c)

C3

d)

m3

18.

1) A Row goes…

a)

across

b)

down

c)

up

19.

A Column goes…

a)

across

b)

down

c)

cross

20.

What version of Excel are we using in class?

a)

Excel 2016

b)

Excel 2017

c)

Excel 2018

d)

Excel 2015

21.
The default file extension for an Excel 2016 workbook is ____.
a)
.xlts
b)
.xslx
c)
.xltx
d)
.xlsx
22.
a vertical line of cells
a)
Maximum
b)
Minimum 
c)
Column 
d)
Formulas
23.
Horizontal line of cells
a)
Row
b)
Column
c)
Cell
d)
Spreadsheet
24.
Columns in a spreadsheet are:
a)
Vertical
b)
Horizontal
c)
Upside down
d)
right side
25.
Rows in a spreadsheet are:
a)
Vertical
b)
Horizontal
c)
Upside Down
d)
Right Side
26.

Identify the Excel Icon.

a)
b)
c)
d)
27.
Excel is part of
a)

Word

b)
Microsoft Office
c)
PowerPoint
28.
The name of the cell located at the intersection of column F and row 223 is:
a)
223F
b)
F223
c)
F222
d)
22F3
29.

Identify the MS Excel Window...

a)
b)
c)
d)
30.

There are 3 ways to display the ribbon.

a)

True

b)

False

31.

"Ribbon Display Options" is situated on

a)

the top right of the spreadsheet

b)

the bottom left of the spreadsheet

c)

the top left of the spreadsheet

d)

the bottom right of the spreadsheet

32.

It contains the most used commands such as save, undo and redo. This tool is customizable and can be placed above or below the ribbon.

a)

Ribbon Tabs

b)

Groups

c)

Dialog Box Launcher

d)

Quick Access Toolbar

33.
____ below the worksheet grid let you switch from sheet to sheet in a workbook.
a)
Sheet tabs
b)
Cell pointers
c)
Mode indicators
d)
Scroll bars
34.
In Excel, a worksheet is contained in a file called a ____.
a)
datapad
b)
notebook
c)
workpad
d)
workbook
35.

The "boxes" in Microsoft Excel are called...

a)

Griddies

b)

Boxes

c)

Cells

d)

Spreadsheets

36.
Cells are identified by the following:
a)
Column Letter followed by their Row Number
b)
Row Number followed by their Column Letter
c)
Row Number Only
d)
Column Letter Only
37.

Displays the name or location of the active cell

a)

Formula bar

b)

Name box

c)

Column

d)

Row

38.
Excel allows you to
a)
read stories
b)
work with data
c)
invent ideas
39.
When making a chart, you always highlight the entire spreadsheet.
a)
True
b)
False
40.

When would you use Excel for a task?

a)

When writing an article about a new product

b)

when creating a presentation to give to a team

c)

when writing an instruction guide for a team

d)

when creating a list of employees with their ID numbers

41.

What is Excel primarily used for?

a)

Designing websites

b)

Storing, organizing, and analyzing information

c)

Creating presentations

d)

Editing photos

42.

When a label is too long to fit within a worksheet cell, you typically must

a)

a. Shorten the label

b)

b. Increase the column width

c)

c. Decrease the column width

d)

d. Adjust the row height

43.

You can format text in Excel by making it bold, italic, etc.

a)

True

b)

False

44.

What is Microsoft Excel used for?

a)

Data entry and storage

b)

Creating schedules and calendars

c)

Financial record keeping and calculations

d)

All of the above

45.

The name of a cell is given by the ___________.

a)

Letter + Number

b)

Number + Letter

c)

Letter only

d)

Number only

46.
How do you select an entire column?
a)
Select Edit > Select > Column from the menu
b)
Click the column heading letter
c)
Hold down the shift key as you click anywhere in the column.
d)
Hold down the Ctrl key as you click anywhere in the column
47.

What does the indicated icon do in the red box?

a)

Apply underline

b)

Apply italic

c)

Make text bigger

d)

Apply bold

48.
What are lines that can be applied around worksheet cells or objects?
a)
Gridlines
b)
Borders
c)
Underlines
d)
Boundaries
49.
If cell A1 contained 10, cell A2 contained 2 and cell A3 contained =A1/A2, what would cell A3 show on the worksheet?
a)
=5
b)
5
c)
=10/2
d)
=A1/A2
50.
The entry in cell B15 is =SUM(B5:B14) which is a ____.
a)
formula
b)
label
c)
value
d)
calculation