wayground logo

Free Printable Worksheets

NEW

Font size

S
M
L
XL
Worksheets

9th Excel

Total questions: 65

Worksheet time: 36mins

Name
Class
Date
1.

Excel file is saved as a ____________

a)

Document

b)

workbook

c)

worksheets

d)

Presentation

2.

What is a sheet in Excel?

a)

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

b)

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

c)

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

3.

Name of the workbook is displayed in the ___________

a)

Menu bar

b)

Title bar or ribbon

c)

Tool bar

d)

option bar

4.

The name box or the address bar contains

a)

Formulas

b)

menu options

c)

Cell address

d)

Numbers

5.

Letters in Excel represent

a)

rows

b)

data

c)

columns

d)

functions

6.

Numbers in the worksheet represent

a)

data

b)

columns

c)

rows

d)

functions

7.

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

8.

1. 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

9.

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

a)

&

b)

=

c)

%

d)

+

10.

What is the Sum formula?

a)

Sum( )

b)

Sum( )=

c)

=( )Sum

d)

=Sum( )

11.

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

12.

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

13.

The intersection of a row and a column is called this.

a)

Active Cell

b)

Chart

c)

Column

d)

Row

14.

In Excel, rows are identified by this

a)

Letters

b)

Numbers

15.

Which is NOT a term used in Excel?

a)

Workbook

b)

Worksheet

c)

Cell

d)

Document

16.
Located on the left side or the entry bar, displays the active cell reference:
a)
entry bar
b)
cell reference
c)
name box
d)
none of the above
17.
What is this?
a)
active cell
b)
column
c)
cell
d)
none of the above
18.
Provides easy access to frequently used commands:
a)
group
b)
Quick Access Toolbar
c)
cell
d)
none of the above
19.
This is a:
a)
ribbon
b)
group
c)
tab
d)
none of the above
20.

Microsoft Excel is categorized as a ________________ software.

a)

Database

b)

Spreadsheet

c)

Presentation

d)

Word Processing

21.

The bar where information appears as you input data is called ______________.

a)

file bar

b)

help bar

c)

window bar

d)

formula bar

22.

A program using a table comprising of rows, columns and cells.

a)

MS Word

b)

MS PowerPoint

c)

MS Outlook

d)

MS Excel

23.

The first cell in a worksheet is what?

a)

A1

b)

1A

c)

FX

d)

Cell Name

24.

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

a)

row

b)

column

c)

cell

25.

What does every formula in MS EXCEL start with?

a)

+

b)

-

c)

=

d)

*

26.

What is the name of the cell that is colored blue?

a)

A

b)

B

c)

2B

d)

B2

27.
The Quick Access Toolbar is:
a)
customizable
b)
found at the bottom of the screen
c)
found on the right side of the screen
d)
none of the above
28.
This is the:
a)
tab
b)
title bar
c)
group
d)
none of the above
29.

Excel file is saved as a ____________

a)

Document

b)

workbook

c)

worksheets

d)

Presentation

30.

Name of the workbook is displayed in the ___________

a)

Menu bar

b)

Title bar or ribbon

c)

Tool bar

d)

option bar

31.

1) Which cell is selected in this picture?

a)

B2

b)

B3

c)

C3

d)

m3

32.

?

a)

minimize

b)

maximize

c)

exit/close

33.

A GROUP OF CELLS IN A WORKSHEET IS CALLED A _______________

a)

COLUMN

b)

ROW

c)

RANGE

d)

FORMULA

34.

A SELECTED CELL IS HIGHLIGHTED IN THE SHEET AND IT IS CALLED _________

a)

CELL

b)

SELECTED RANGE

c)

ACTIVE CELL

d)

NONE

35.
Cells that run horizontally on a spreadsheet
a)
Row
b)
Column
c)
Workbook
d)
Range
36.
A single page in Excel is called a:
a)
worksheet
b)
workbook
c)
spreadsheet
37.
Which of the following is a FORMULA that will add cells c9 and c10?
a)
=c9+c10
b)
c9+c10
c)
sum(c9:c10)
d)
=sum(c9:c10)
38.
Rows on a spreadsheet are identified by a ...
a)
number
b)
letter
c)
symbol
d)
smiley face
39.
Columns on a spreadsheet are identified by a ...
a)
number
b)
letter
c)
space
d)
smiley face
40.
Click and drag the ___________ tool to apply the same formula to neighboring cells.
a)
auto-fill
b)
alignment
c)
fill
d)
functions
41.
A4 is an example of...
a)
Cell Address
b)
Cell Range
c)
Formula
d)
Function
42.
Double-clicking between two columns will ____________ the column.
a)
delete
b)
copy
c)
resize
d)
fill
43.
Select ___________________ from the functions menu to find the smallest value in a group.
a)
max
b)
min
c)
sum
d)
average
44.
SUM, AVERAGE, MAX and MIN are preset formulas on the _______________ menu.
a)
filter
b)
functions
c)
border
d)
fill color
45.
A row is a vertical reference in a spreadsheet.
a)
True
b)
False
46.
A mathematical operation is called a _____.
a)
formula
b)
range
c)
label
d)
graph
47.
A graph is a visual representation of data within a spreadsheet.
a)
True
b)
False
48.
Horizontal and vertical lines in a spreadsheet are called ____.
a)
rows
b)
graphs
c)
labels
d)
gridlines
49.
a file which contains one or more spreadsheets.
a)
Workbook
b)
Spreadsheet
c)
Cells
d)
Entry
50.
an arrangement of cells in columns and rows used to organize, analyze, calculate, and report information
a)
Workbook
b)
Spreadsheet
c)
Cell
d)
Entry
51.
individual locations on a spreadsheet.
a)
Workbook
b)
Spreadsheet
c)
Cell
d)
Entry
52.
Individual pieces of information typed into the spreadsheet.
a)
Workbook
b)
Spreadsheet
c)
Cell
d)
Entry
53.
A4 is an example of...
a)
Cell Address
b)
Cell Range
c)
Formula
d)
Function
54.
A1:A10 is an example of...
a)
Cell Address
b)
Cell Range
c)
Formula
d)
Function
55.
Classification used for cells that contain text or for numbers that will not be used in calculations
a)
Label
b)
Value
c)
Formula
d)
Function
56.
This classification indicates that the data has the potential to be used in calculations.
a)
Label
b)
Value
c)
Formula
d)
Function
57.
Instructs the software to perform a calculation.
a)
Label
b)
Value
c)
Formula
d)
Function
58.
All formulas and functions begin with...
a)
=
b)
SUM
c)
Labels
d)
Text
59.
Cell value changes as the formula is copied
a)
Relative Reference
b)
Absolute Reference
c)
Mixed Reference
60.
Cell value remains static when copied to other locations
a)
Relative Reference
b)
Absolute Reference
c)
Mixed Reference
61.
Combination of an absolute and a relative cell
a)
Relative Reference
b)
Absolute Reference
c)
Mixed Reference
62.
This function adds the range of cells
a)
=SUM( )
b)
=AVERAGE( )
c)
=MAX( )
d)
=MIN( )
63.
This function determines the average of the range of cells 
a)
=SUM( )
b)
=AVERAGE( )
c)
=MAX( )
d)
=MIN( )
64.
This function finds the highest number in the range of cells
a)
=SUM( )
b)
=AVERAGE( )
c)
=MAX( )
d)
=MIN( )
65.
This function finds the lowest number in the range of cells.
a)
=SUM( )
b)
=AVERAGE( )
c)
=MAX( )
d)
=MIN( )

Similar Resources on Wayground

Adobe Illustrator CC question bank

64 questions

Adobe Illustrator CC question bank

quiz

Worksheet

•

9th - 12th Grade

UHS End of year KS3 assessment (year 9)

70 questions

UHS End of year KS3 assessment (year 9)

quiz

Worksheet

•

9th Grade

Prueba Diagnóstica Nivel Superior

61 questions

Prueba Diagnóstica Nivel Superior

quiz

Worksheet

•

9th - 12th Grade

R081 - Revision Quiz

68 questions

R081 - Revision Quiz

quiz

Worksheet

•

9th - 10th Grade

Doors

60 questions

Doors

quiz

Worksheet

•

1st Grade - Professio...

AQA GCSE Algorithms

60 questions

AQA GCSE Algorithms

quiz

Worksheet

•

9th - 11th Grade

ICT Applications()

60 questions

ICT Applications()

quiz

Worksheet

•

9th Grade

Advanced Personal Finance Final Exam Review

63 questions

Advanced Personal Finance Final Exam Review

quiz

Worksheet

•

9th - 12th Grade