wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

Excel Mania

Total questions: 68

Worksheet time: 39mins

Name
Class
Date
1.
Columns in a spreadsheet are:
a)
Vertical
b)
Horizontal
c)
Upside down
d)
right side
2.
Rows in a spreadsheet are:
a)
Vertical
b)
Horizontal
c)
Upside Down
d)
Right Side
3.
What is the term used where a column and row intersect?
a)
Toolbar
b)
Cell
c)
Name Box
d)
Formula Bar
4.
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
5.
Microsoft Excel is what type of software?
a)
Word Processing
b)
Spreadsheet
c)
Presentation
d)
Drawing
6.
the largest number =MAX(the first cell address:then the second cell address) For Example: =MAX(C1:C33)
a)
Average
b)
Minimum 
c)
Filter
d)
Maximum 
7.
Tells excel to include all the cells between the two endpoints. A1:D1
a)
Range
b)
sort
c)
Cell
d)
Colon
8.
2 or more cells that are selected to create a source to be used in a formula
a)
Range
b)
Max
c)
Filter
d)
Colums 
9.
Adding two cells
a)
=SUM(A1+A13)
b)
=SUM(__)
c)
A1+A13= SUM
d)
Total
10.
the sum of all numbers divided by the amount of numbers. 
a)
Maximun
b)
Minimum 
c)
Median
d)
Average
11.
What does this mean "######'?
a)
column is not wide enough
b)
column is missing numbers
c)
column is showing an error
d)
column is too narrow
12.
In an excel forumula it means divide
a)
Forwardslash 
b)
Backwards
c)
Skip
d)
Multiply 
13.
In an excel formula, it means substract
a)
Add sign
b)
Minus sign
c)
Divide sign
d)
Average Sign 
14.
In Excel it means Add
a)
Plus sign
b)
sort 
c)
Forward slash 
d)
asterisk 
15.
Horizontal line of cells
a)
Row
b)
Column
c)
Cell
d)
Spreadsheet
16.
A box that holds data
a)
Spreadsheet
b)
Cell
c)
Row
d)
Data
17.
a vertical line of cells
a)
Maximum
b)
Minimum 
c)
Column 
d)
Formulas
18.
Which of the following operators do you use to begin typing a formula?
a)
*
b)
+
c)
=
d)
/
19.
When numbers are added together the answer is called the
a)
Product
b)
Sum
c)
Quotient
20.
When numbers are multiplied the answer is called
a)
Sum
b)
Product
c)
Quotient
21.
This icon is called the what?
a)
Arrow
b)
Fill handle
c)
Pointer
22.
For which of the following tasks would you use the fill handle?
a)
to apply shading 
b)
to apply a border
c)
to copy a formula from cell A2 to cell A3
23.
The name of the cell located at the intersection of column F and row 223 is:
a)
223F
b)
F223
c)
F222
d)
22F3
24.
Cell C1 contains the formula =A1+B1. If you copy the formula in C1 to cell C2, which of the following formulas will appear in cell C2?
a)
=A1+B1
b)
=C1+C2
c)
=A2+B2
d)
=B2+B3
25.

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.

26.

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.

27.

Define Formula Bar?

a)

I don't know

b)

I don't care

c)

Don't miss this one!

d)

An element in Excel that appears below the Ribbon and to the right of the Insert command that shows the contents of the active cell so that you edit the text, value, date, formula, or function.

28.

What is a sheet in Excel?

a)

A single document that typically contains labels, values, formulas, functions, and graphical representations of data.

b)

A single spreadsheet that typically contains labels, values, formulas, functions, and graphical representations of data.

c)

A single template that typically contains labels, values, formulas, functions, and graphical representations of data.

d)

A single file that typically contains labels, values, formulas, functions, and graphical representations of data.

29.

What is the Sum formula?

a)

Sum( )

b)

Sum( )=

c)

=Sum( )

d)

=( )Sum

30.

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

a)

+

b)

-

c)

%

d)

=

31.

To quickly add a set of number you can use the ____ feature?

a)

Plus Sum Button

b)

Add Sum Button

c)

Quick Add Button

d)

Auto Sum Button

32.

The letters in Excel represent the _______?

a)

columns

b)

rows

c)

data

d)

functions

33.

The numbers in Excel represent the _____?

a)

columns

b)

rows

c)

data

d)

functions

34.

A function in Excel is represented by what to letters?

a)

f( )

b)

xF

c)

xf

d)

fx

35.

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

a)

A1-C3

b)

A1-C3=

c)

=A1-C3

d)

=C3-A1

36.
What kind of software is Excel?
a)
Spreadsheet software
b)
Word Processing
c)
Drawing
37.
Excel is part of?
a)
Power Point
b)
Microsoft Office Suite
c)
Access
d)
Google
38.
What do you call the rectangles on a spreadsheet?
a)
Cell
b)
Button
c)
Sentence
39.

Excel allows you to work with?

a)

Sentences

b)

Paragraphs

c)

data

40.
A combination of numbers and symbols used to express a calculation. Always begins with an = sign.
a)
Cell Address
b)
Worksheet
c)
Formula
41.
What is the Formula sign for multiply? 
a)
\
b)
*
42.

In Excel rows are labeled by

a)

Letters

b)

Numbers

43.

In Excel, columns are labeled by?

a)

Numbers

b)

Letters

44.

What button will add up a group of numbers?

a)

Equals button

b)

Auto sum button

c)

Plus symbol button

45.

You can use the auto-sum key to subtract numbers.

a)

True

b)

False

46.
How do you make a cell the active cell?
a)
Click the ACTIVE button
b)
Click INSERT CELL
c)
Click on the cell
d)
Cells are always active
47.
What is the name of this cell?
a)
B10
b)
5B
c)
B5
d)
A5
48.
Which tab in Excel has charts and tables?
a)
review
b)
home
c)
file
d)
insert
49.
Which of the following is a selected cell?
a)
current command
b)
default option
c)
active Cell
d)
default cell
50.
What is an intersection of a row and a column?
a)
range
b)
tab
c)
bar chart
d)
cell
51.
 The columns in a worksheet are identified by numbers.
a)
true
b)
false
52.
The active cell in a worksheet is outlined by a bold rectangle.
a)
true
b)
false
53.
What kind of software is Excel?
a)
Word processing software
b)
Spreadsheet Software
c)
Data Base Software
54.
In Excel rows are labeled by
a)
letters
b)
numbers
c)
rows and numbers
55.
What button will add up a group of numbers
a)
Equals button
b)
Plus symbol button
c)
Auto-sum button
56.
Excel refers to files as
a)
Documents
b)
Workbooks
c)
data bases
57.
Where rows and columns meet are referred to as
a)
Blocks
b)
Cells
c)
Boxes
58.
When inserting a formula, always start with
a)
equals symbol
b)
plus symbol
c)
minus symbol
59.
To see what math formulas are used in a cell, click on the
a)
Show formulas button
b)
Show the math button
c)
the auto sum button
60.
You can only work in one cell at a time. The actual cell that you are working in is called what?
a)
Column
b)
Name Box
c)
Active Cell
d)
Row
61.
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
62.

How do you insert ^ in Excel ?

(a)  

63.

A is one or more cells that have been given a name.

(a)  

64.

=A2&" "&B2 is used to (a)   text from cells A2 and B2.

65.

A1 is type of (a)   cell reference.

66.

$A$1 is type of (a)   cell reference.

67.

A$1 or $A1 are types of (a)   cell reference.

68.

In cell reference $ is used before column & row to (a)   the cell.

Similar Resources on Wayground

PoBMF - Ch 9 - Human Resources Management Test

65 questions

PoBMF - Ch 9 - Human Resources Management Test

quiz

Worksheet

•

8th - 12th Grade

Logo 11.4.2020

65 questions

Logo 11.4.2020

quiz

Worksheet

•

4th - 12th Grade

Textiles

68 questions

Textiles

quiz

Worksheet

•

8th Grade

How Well Do You Know Team 6-1?

71 questions

How Well Do You Know Team 6-1?

quiz

Worksheet

•

6th - 8th Grade

Logos 5.5.2020

67 questions

Logos 5.5.2020

quiz

Worksheet

•

4th - 12th Grade

ITZY

68 questions

ITZY

quiz

Worksheet

•

3rd Grade - University

8th Grade Final Review

64 questions

8th Grade Final Review

quiz

Worksheet

•

8th Grade

Unit 7 Review

65 questions

Unit 7 Review

quiz

Worksheet

•

8th Grade