wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

Spreadsheet (Excel)

Total questions: 55

Worksheet time: 46mins

Name
Class
Date
1.

A GROUP OF CELLS IN A WORKSHEET IS CALLED A _______________

a)

COLUMN

b)

ROW

c)

RANGE

d)

FORMULA

2.

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

a)

CELL

b)

SELECTED RANGE

c)

ACTIVE CELL

d)

NONE

3.
Cells that run horizontally on a spreadsheet
a)
Row
b)
Column
c)
Workbook
d)
Range
4.
Cells that run vertically on a spreadsheet
a)
Row
b)
Workbook
c)
Worksheet
d)
Column
5.
All functions and formulas begin with which symbol?
a)
#
b)
/
c)
:
d)
=
6.
The intersection of a column and a row is called a ______.
a)
gridline
b)
cell
c)
value
d)
formula
7.
A single page in Excel is called a:
a)
worksheet
b)
workbook
c)
spreadsheet
8.

Which of the following is a FORMULA that will add cells c9 to c15?

a)

=c9+c15

b)
c9+c10
c)
sum(c9:c10)
d)

=sum(c9:c15)

9.
Click and drag the ___________ tool to apply the same formula to neighboring cells.
a)
auto-fill
b)
alignment
c)
fill
d)
functions
10.
A4 is an example of...
a)
Cell Address
b)
Cell Range
c)
Formula
d)
Function
11.
Which of the following is a formula that will multiply cells A1 and A2?
a)
A1*A2
b)
=A1:A2
c)
=A1*A2
d)
=Multiply(A1:A2)
12.
Which formula gets the biggest value of a range of cells?
a)
MAX
b)
MIN
c)
LARGE
d)
SUM
13.

Which formula would you use to calculate how many sales are over $20 from a series.

a)

sum

b)

sumif

c)

count

d)

countif

14.

to find out how many persons are there in a certain field, the following function is applied

a)

average(--:--)

b)

count(--:--)

c)

counta(--;--)

d)

counta(--:--)

15.

What value would excel return for this formula? =(82-32)5+8*2

a)

30

b)

21

c)

26

d)

37

16.
Which of the following would NOT be stored in a cell?
a)
Formula
b)
Text
c)
Number
d)
Chart
17.
SUM, AVERAGE, MAX and VLOOKUP are examples of what?
a)
Functions
b)
Tables
c)
Formulae
d)
Statistical tools
18.
A1:D4 is an example of a cell...
a)
Range
b)
Selection
c)
Highlight
d)
Choice
19.
What specific format would change 2.5 to £2.50?
a)
Currency
b)
Date
c)
Number
d)
Time
20.
If you don't want a cell reference to change when copied to other cells, use _________ references
a)
Absolute
b)

Relative

c)

Mixed

21.

What does the Average formula return?

a)

Returns the lowest argument.

b)

Returns the middle argument.

c)

Returns the three highest arguments.

d)

Returns the mean of all its arguments.

22.

What does the Countif formula return?

a)

Counts the number of cells within a range that meets the given condition.

b)

Counts the number of words within a range that meets the given condition.

c)

Counts the number of columns within a range that meets the given condition.

d)

Counts the number of letters within a range that meets the given condition.

23.

Formulas can be copied to adjacent cells with the ____________.

a)

Fill handle

b)

PgDn Key

c)

Function key F4

d)

None of the above

24.

Answer =2+3*3-2

a)

9

b)

10

c)

11

d)

12

25.

Multiple arguments must be separated by a ______________.

a)

Space

b)

Comma

c)

Colon

d)

Semicolon

26.
Rows on a spreadsheet are identified by a ...
a)
number
b)
letter
c)
symbol
d)
smiley face
27.
Double-clicking between two columns will ____________ the column.
a)
delete
b)
copy
c)
resize
d)
fill
28.
Which of the following is a valid formula?
a)
=sum(A1:A6)
b)
sum=(A1:A6)
c)
=sum[A1:A6]
d)
=sum(A1,A6)
29.
Putting cells into A-Z order is called?
a)
Sort Ascending
b)
Sort Descending
c)
Filter Ascending
d)
Filter Descending
30.
A feature to make data fit inside a cell?
a)
Wrap Text
b)
Warp Text
c)
Conditional Formatting
d)
Filter Text
31.
To show the quantities in particular categories use a?
a)
Column Chart
b)
Line Graph
c)
Scatter Graph
d)
Sort Chart
32.
Which chart should you use to show changes over time?
a)
Line
b)
Scatter
c)
Pie
d)
Bar
33.
To join several cells together to make one cell use... 
a)
Merge & Center
b)
Fill & Center
c)
Link & Center
d)
Split & Center
34.
What is the name of this cell?
a)
B10
b)
5B
c)
B5
d)
A5
35.
In Excel, what is this button used for? 
a)
To change the color of the background 
b)
To change the font color
c)
That button is not used in Excel
d)
To fill the cell with a color
36.
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
37.
What is the name of a computer program used for organising information in rows and columns?
a)
Spreadsheet
b)
Presentation
c)
Publisher
d)
Browser
38.
What is displayed in cell B1?
a)
100
b)
Tickets Sold
c)
Day
d)
B1
39.
A ___________________ is a visual representation of data
a)
a. spreadsheet
b)
b. border
c)
c. chart
d)
d. table
40.

Option to print the document so that the height of the page is less than its width

a)

Portrait

b)

Landscape

41.

What is the column header name for the 18th Column?

a)

M

b)

Q

c)

R

d)

N

42.

_____________displays the contents of active cell.

a)

Tool bar

b)

Address bar

c)

Formula bar

d)

Alignment bar

43.

What is the file extension for MS Excel worksheet file ?

a)

.doc

b)

.html

c)

.exl

d)

.xlsx

44.

A __________ is a collection of multiple worksheets.

a)

Workbook

b)

Interface

c)

Cell

45.

What will be the cell address of the cell formed by the intersection of the 10th Column and 10th Row

a)

F10

b)

J10

c)

D10

d)

A10

46.

To count only numerical data's, _________ function is used.

a)

COUNTIF

b)

COUNTA

c)

COUNTBLANK

d)

COUNT

47.

What is the column header name for 28th Column

a)

Z

b)

AB

c)

AA

d)

BA

48.

In a Spreadsheet(MS Excel), Column next to column "AZ" is ___________

a)

AA

b)

BB

c)

BA

d)

A

49.

Write the formula to calculate the mean for cell range A2 to A102.

(a)  

50.

Option used for removing (hiding) unwanted data.

(a)  

51.

Chart used for representing proportions using single series.

(a)  

52.

Absolute references are created by using

a)

$

b)

#

c)

@

d)

%

53.

Which function is used for calculating the number of characters in a cell?

(a)  

54.

What is the cell address of 27th Column and 2nd Row?

(a)  

55.

Which option would be used for formatting cells on basis of criteria?

(a)  

Similar Resources on Wayground

Python

53 questions

Python

quiz

Worksheet

•

11th Grade

Data Security and Excel

50 questions

Data Security and Excel

quiz

Worksheet

•

9th - 10th Grade

Year11Revision

58 questions

Year11Revision

quiz

Worksheet

•

10th - 12th Grade

CS: Python Unit 1 Review

57 questions

CS: Python Unit 1 Review

quiz

Worksheet

•

9th - 12th Grade

Ujian Sekolah TIK estise

52 questions

Ujian Sekolah TIK estise

quiz

Worksheet

•

9th Grade

Syed: Chapter 4.1: Software

60 questions

Syed: Chapter 4.1: Software

quiz

Worksheet

•

9th - 12th Grade

week 5 review

53 questions

week 5 review

quiz

Worksheet

•

10th Grade

#3 CIW Data Analyst - Certification Prep

54 questions

#3 CIW Data Analyst - Certification Prep

quiz

Worksheet

•

9th Grade - University