wayground logo

Free Printable Worksheets

NEW

Font size

S
M
L
XL
Worksheets

Intro to Excel Quiz

Total questions: 28

Worksheet time: 15mins

Name
Class
Date
1.
In Excel, rows 
a)
are horizontal and represented by a letter
b)
are horizontal and represented by a number
c)
are vertical and represented by a number
d)
are vertical and represented by a letter
2.
What is the active cell?
a)
A10
b)
A11
c)
A12
d)
A13
3.
What is circled?
a)
function button
b)
name box
c)
cell reference
d)
formula bar
4.
What does the name box display?
a)
The function
b)
The formula
c)
The active cell
d)
The cell contents
5.
What is circled?
a)
function button
b)
name box
c)
cell reference
d)
formula bar
6.
Cursors in Excel are important. What is the little square at the bottom of the active cell called and used for?
a)
Fill handle, to copy exactly what is in other adjacent cells
b)
fill handle, to copy patterns/formulas of adjacent cells
c)
Move handle, allows you to move a cell to a different location
d)
Square, allows you to move a cell to a different location.
7.
In order to make a cell calculate what is entered, what must be entered first?
a)
=
b)
+
c)
calculate
d)
add
8.
When you enter =SUM(B3+C7), what are B3 and C7? 
a)
formulas
b)
cell references
c)
values
d)
battleship calls
9.
To change information in a cell without retyping everything use the
a)
cell reference
b)
formula bar
c)
name box
d)
sheet tab
10.
What is a boundary in Excel?
a)
The active cell
b)
The formula
c)
The bar separating columns
d)
Information
11.

What would be a correct formula for SUM in Excel?

a)

=SUM(B3:B9)

b)

=SUMB3+B9

c)

SUM(B3:B9)

d)

=ADD(B3:B9)

12.
Which button can you click to add up a series of numbers?
a)
The autosum button
b)
The Formula button
c)
The quicktotal button
d)
The total button
13.
To copy formatting from one area in a worksheet and apply it to another area you would use:
a)
The Edit>Copy Format and Edit>Paste Format commands form the menu.
b)
The Copy and Apply Formatting dialog box, located under the Format>Copy and Apply menu.
c)
There is no way to copy and apply formatting in Excel � You have to do it manually
d)
The Format Painter button on the standard toolbar
14.
If the cell contains hashtags (#), what do you need to do?
a)
Expand the column
b)
Expand the row
c)
Change the formula
15.
Each Excel file is called a workbook because
a)
It can contain text and data
b)
It can be modified
c)
It can contain many sheets including worksheets and chart sheets
d)
You have to work hard to create it
16.
What kind of software is Excel?
a)
Word processing software
b)
Spreadsheet Software
c)
Data Base Software
17.

In Excel, columns are labeled by

a)

Letters

b)

Numbers

c)

Letters and numbers

18.
Excel refers to files as
a)
Documents
b)
Workbooks
c)
data bases
19.

What is a spreadsheet?

a)

An electronic file that contains a grid of columns and rows to organize related data and to display results of calculations.

b)

An electronic file that contains a grid of negatives and positives to organize related data and to display results of calculations.

c)

An electronic file that contains a grid of numbers and data to organize related data and to display results of calculations.

d)

An electronic file that contains a grid of pages and sheets to organize related data and to display results of calculations.

20.

What is the "Active Cell" in Excel?

a)

The Bottom cell in a worksheet. It is indicated by a dark border onscreen.

b)

The current cell in a worksheet. It is indicated by a dark border onscreen.

c)

The top cell in a worksheet. It is indicated by a dark border onscreen.

d)

The past cell in a worksheet. It is indicated by a dark border onscreen.

21.
When entering text in Excel, it is automatically (by default):
a)
Left Justified
b)
Right Justified
c)
Center Justified
d)
Full Justified
22.
Columns in a spreadsheet are:
a)
Vertical
b)
Horizontal
c)
Upside down
d)
right side
23.
Rows in a spreadsheet are:
a)
Vertical
b)
Horizontal
c)
Upside Down
d)
Right Side
24.
When entering numbers in  Excel, they are automatically (by default):
a)
Left Justified
b)
Right Justified
c)
Center Justified
d)
Full Justified
25.

A Graphic representation of data. A circle is divided into sectors which shows a percentage of a whole.

a)

Proportional chart

b)

Pie chart

c)

Bar chart

d)

Circular chart

26.

What type of chart is this?

a)

Bar

b)

Pie

c)

Column

d)

Line

27.

A type of chart which displays information as a series of data points called 'markers' connected by straight line segments.

a)

Segment

b)

Line

c)

Pixel

d)

Straight

28.

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

a)

+

b)

-

c)

%

d)

=

Similar Resources on Wayground

Latihan Soal UTS Statistika Sosial

24 questions

Latihan Soal UTS Statistika Sosial

quiz

Worksheet

•

University

Mind Exercise

24 questions

Mind Exercise

quiz

Worksheet

•

University

Tổng quan kế toán

23 questions

Tổng quan kế toán

quiz

Worksheet

•

University

Cubic equation

24 questions

Cubic equation

quiz

Worksheet

•

University

Teoría de Conjuntos

24 questions

Teoría de Conjuntos

quiz

Worksheet

•

University

Math One

24 questions

Math One

quiz

Worksheet

•

University

Acionamentos de Motores

26 questions

Acionamentos de Motores

quiz

Worksheet

•

1st Grade - Professio...

Math 9

25 questions

Math 9

quiz

Worksheet

•

University