wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

Excel

Total questions: 75

Worksheet time: 43mins

Name
Class
Date
1.
What kind of software is Excel?
a)
Word processing software
b)
Spreadsheet Software
c)
Data Base Software
2.
In Excel rows are labeled by
a)
letters
b)
numbers
c)
rows and numbers
3.
In excel, columns are labeled by
a)
Letters
b)
Numbers
c)
Letters and numbers
4.
What button will add up a group of numbers
a)
Equals button
b)
Plus symbol button
c)
Auto-sum button
5.
Excel refers to files as
a)
Documents
b)
Workbooks
c)
data bases
6.
Where rows and columns meet are referred to as
a)
Blocks
b)
Cells
c)
Boxes
7.
When inserting a formula, always start with
a)
equals symbol
b)
plus symbol
c)
minus symbol
8.
What kind of chart should you use to show the pieces (percentages) of a whole
a)
Bar Chart
b)
Column Chart
c)
Pie Chart
9.
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
10.
Excel is part of
a)
Access
b)
Microsoft Office
c)
PowerPoint
11.
What key should you use to take you to the cell to the right
a)
Tab key
b)
Right arrow key
c)
just click in it
12.
If you see a series of "######" in a cell, that means the following:
a)
You keyed in an incorrect number
b)
The row height is too high
c)
The text is incorrectly spelled
d)
The column width is not wide enough
13.
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
14.
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
15.

A ​ (a)   similar ​ (b)   but with ​ (c)   bars. Useful for comparing data between individual items.

Choose from the below words
bar chart is
to column charts
horizontal
16.

Which chart type is most effective for comparing multiple categories across different groups?

a)

Pie Chart

b)

Line Chart

c)

Bar Chart

d)

Scatter Plot

17.

You number the rows in Excel by

a)

Letters (alphabetical order).

b)

Numbers (numerical order).

18.

You number the columns in Excel by

a)

Letters (alphabetical order).

b)

Numbers (numerical order).

19.

We can merge more than one cell in Excel

a)

True.

b)

False.

20.

What is your favorite school subject?

4 lines
21.

What is your favorite color?

4 lines
22.

Do you prefer traditional learning or online learning or both?

a)

Traditional learning.

b)

Online learning.

c)

Both

23.

Why do you love your Computer class?

4 lines
24.

- is a symbol for:

a)

Multiplication

b)

Addition

c)

Subtraction

d)

Dividing

25.

to merge cells, you need to :

a)

Hilight all cells the merge command

b)

Hilight one cells the merge command

c)

Hilight two cells the merge command

26.

* is a symbol for:

a)

Multiplication

b)

Addition

c)

Subtraction

d)

Dividing

27.

This is a valid simple formula

a)

A2+A4

b)

=AB3+Y5

c)

(a2*t3)/100

d)

=(a2*t3)/100

28.

A simple formula always start with :

a)

+

b)

=

c)

-

d)

*

29.

What is a multiplication formula for MS Excel using the picture ?

a)

=1Ax1B

b)

=B1*G1

c)

=C3xD3

d)

=B4*C4

30.

When is a MS Excel Spreadsheet used?

a)

Making a Drawing

b)

When Reading

c)

For Collecting Information

d)

For Baking a Cake

31.

Which is NOT a term used in Excel?

a)

Workbook

b)

Worksheet

c)

Cell

d)

Document

32.
This is a:
a)
ribbon
b)
group
c)
tab
d)
none of the above
33.
Can be used travel from cell to cell in a spreadsheet:
a)
tab
b)
enter
c)
arrow keys
d)
all of the above
34.

Excel file is saved as a ____________

a)

Document

b)

workbook

c)

worksheets

d)

Presentation

35.

Name of the workbook is displayed in the ___________

a)

Menu bar

b)

Title bar or ribbon

c)

Tool bar

d)

option bar

36.

What does MS Excel look like?

a)
b)
c)
d)
37.

A ...... is a document that stores data in a grid of horizontal rows and vertical columns.

a)

Row

b)

Spreadsheet

c)

Minus

d)

Plus

38.
A box that holds data
a)
Spreadsheet
b)
Cell
c)
Row
d)
Data
39.
Horizontal line of cells
a)
Row
b)
Column
c)
Cell
d)
Spreadsheet
40.

A vertical line of cells

a)

Maximum

b)

Minimum 

c)

Column 

d)

Formulas

41.
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
42.

Which one is a correct cell address?

a)

A1

b)

1A

c)

A

d)

1

43.

When you need to enter a formula into a cell in Excel what is the first thing you type?

(a)  

44.

What is the Sum formula?

a)

Sum( )

b)

Sum( )=

c)

=Sum( )

d)

=( )Sum

45.

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

a)

Maximun

b)

Minimum 

c)

Median

d)

Average

46.
A type of chart which displays information as a series of data points called 'markers' connected by straight line segments. 
a)
Pie chart
b)
Line Chart
c)
Bar Graphs
d)
Graphs
47.
A spreadsheet is a document that stores data in a grid of horizontal rows and vertical columns.
a)
Row
b)
Spreadsheet
c)
Minus
d)
Plus
48.
In Excel it means Add
a)
Plus sign
b)
sort 
c)
Forward slash 
d)
asterisk 
49.
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 
50.
Completes previously typed words when you begin to repeat the typing. 
a)
AutoFill
b)
#Name?
c)
Column charts
d)
Pie Charts
51.
Tells excel to include all the cells between the two endpoints. A1:D1
a)
Range
b)
sort
c)
Cell
d)
Colon
52.
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 
53.
Adding two cells
a)
=SUM(A1+A13)
b)
=SUM(__)
c)
A1+A13= SUM
d)
Total
54.
A Graphic representation of data. A circle is divided into sectors which shows a percentage of a whole.
a)
Line Chart
b)
Pie Chart
c)
Bar Chart
d)
Graphs
55.
A Graphic representation of data. The bar can be VERTICAL or Horizontal, but a vertical graph is also known as a column chart.
a)
Bar Chart
b)
Pie Chart
c)
Graphs
d)
Line Chart
56.
the sum of all numbers divided by the amount of numbers. 
a)
Maximun
b)
Minimum 
c)
Median
d)
Average
57.
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
58.
In an excel formula, it means substract
a)
Add sign
b)
Minus sign
c)
Divide sign
d)
Average Sign 
59.
A box that holds data
a)
Spreadsheet
b)
Cell
c)
Row
d)
Data
60.
a vertical line of cells
a)
Maximum
b)
Minimum 
c)
Column 
d)
Formulas
61.

What view in the status bar allows us to access the header?

a)

Normal

b)

Page Break Preview

c)

Worksheet

d)

Page Layout

62.

What is the keyboard shortcut for the formulas page?

a)

Ctrl + #

b)

Ctrl + *

c)

Ctrl + `

d)

Crtl + ^

63.

Which is NOT in the Σ\Sigma  menu?

a)

MIX

b)

SUM

c)

MAX

d)

MIN

64.

Calculate the following formula =2^3/2

a)

2

b)

4

c)

8

d)

12

65.

Which one of the following is an arithmetic operator?

a)

#

b)

<

c)

=

d)

*

66.

All of the following are arithmetic operators expect?

a)

<

b)

^

c)

-

d)

%

67.

What is pressed to get a new line in a cell?

a)

Alt+Shift

b)

Ctrl+Enter

c)

Shift+Enter

d)

Alt+Enter

68.

Identify this chart.

a)

Pie

b)

Line

c)

Bar

d)

Column

69.

Identify this chart.

a)

Line

b)

Bar

c)

Column

d)

Pie

70.

Identify this chart.

a)

Column

b)

Bar

c)

Line

d)

Pie

71.

According to this chart, which type of pork do people prefer most?

a)

Bacon

b)

Ribs

c)

Ham

d)

Other

72.

According to this chart, in which month are produce sales the highest?

a)

June

b)

March

c)

November

d)

May

73.

According to this chart, which band sold the most albums?

a)

Doug and the Slugs

b)

Gails and the Snails

c)

Sherm and the Worms

d)

Marva and the Larva

74.

__________ is a area that holds all the elements of a chart.

a)

Plot Area

b)

Chart Title

c)

Chart Area

d)

Legends

75.

Vertical axis of a chart is _______

a)

X axis

b)

Y axis

c)

X axis

d)

B axis

Similar Resources on Wayground

latihan soal TIK (office)

70 questions

latihan soal TIK (office)

quiz

Worksheet

•

1st Grade - Professio...

Power BI part1+part2+SQL

78 questions

Power BI part1+part2+SQL

quiz

Worksheet

•

9th Grade

ITF+ Practice Exam 5

73 questions

ITF+ Practice Exam 5

quiz

Worksheet

•

9th Grade

MENGENAL INTERNET

80 questions

MENGENAL INTERNET

quiz

Worksheet

•

9th Grade

Christmas Spreadsheets Quiz

70 questions

Christmas Spreadsheets Quiz

quiz

Worksheet

•

9th Grade

KIỂM TRA HỌC KỲ 1 (TIN 9)

70 questions

KIỂM TRA HỌC KỲ 1 (TIN 9)

quiz

Worksheet

•

9th Grade

Aplikasi presentasi

75 questions

Aplikasi presentasi

quiz

Worksheet

•

8th Grade - University

BCS Level 3 Award in Mobile and Operating Systems - Test 1

71 questions

BCS Level 3 Award in Mobile and Operating Systems - Test 1

quiz

Worksheet

•

9th Grade