wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

Spreadsheet Modeling

Total questions: 40

Worksheet time: 27mins

Name
Class
Date
1.
In this diagram what does the selected area represent?
a)
a Row
b)
a Cell
c)
a Column
d)
a Chart
2.
What is the cell range in this diagram?
a)
A1:F1
b)
A1:A8
c)
A1:F8
d)
A1:1A
3.

Which symbol must all formula begin with?

a)

=

b)

+

c)

(

d)

@

4.

A group of cells is called a ________.

a)

cell cluster

b)

multicell

c)

cell range

d)

chart

5.

Which formula below is valid?

a)

=R2*D2

b)

A3+100

c)

F2+F3+F4-53

d)

=5B+6B

6.

to count any fields containing numbers we use:

a)

countIF function

b)

counta function

c)

count function

d)

countIFs function

7.

What function was used to find the lowest grade?

a)

average

b)

sum

c)

min

d)

max

8.

A _________ is a prewritten formula that is built into EXCEL.

a)

function

b)

problem

c)

equation

d)

equal sign

9.

What does the Max formula do?

a)

Returns the highest three values in a set of values and ignores text.

b)

Returns the largest value in a set of values and ignores text.

c)

Returns the text that you are searching for.

d)

Returns the smallest value in a set of values and ignores text.

10.

Which operator is used to multiply in Excel?

a)

+

b)

-

c)

/

d)

*

11.

Excel will display _______________________ if the cell is not wide enough.

a)

******

b)

^^^^^

c)

######

d)

>>>>>

12.

__________________is an alphanumeric value used to identify a specific cell in a spreadsheet.

a)

Formula

b)

Calculation

c)

Cell address

d)

None of the above

13.

Which of these symbols is used to do a division on a computer?

a)

\

b)

*

c)

/

d)

|

14.
In Excel rows are labeled by
a)
letters
b)
numbers
c)
rows and numbers
15.
In excel, columns are labeled by
a)
Letters
b)
Numbers
c)
Letters and numbers
16.
Excel refers to files as
a)
Documents
b)
Workbooks
c)
data bases
17.
A single page in Excel is called a:
a)
worksheet
b)
workbook
c)
spreadsheet
18.
Which of the following is an example of a cell reference or cell address?
a)
C
b)
9
c)
B4
d)
=A1+A2
19.

What is the file extension for MS Excel worksheet file ?

a)

.doc

b)

.html

c)

.exl

d)

.xlsx

20.

Which of the following is a Spreadsheet package?

a)

Apple Safari

b)

Google sheets

c)

Google Drawings

d)

Microsoft Publisher

21.

Which of the following is a function of a spreadsheet package?

a)

Performing accounting calculations

b)

Designing websites

c)

Creating presentations

d)

Creating posters and newsletters

22.

The formula to add data from cell B12 to cell B20 is

a)

=SUM(B12, B20)

b)

=SUM(B12+B20)

c)

=SUM(B12:B20)

d)

=SUM(B12 - B20)

23.

What can be used to uniquely identify each cell in a spreadsheet?

a)

Cell reference

b)

Column heading

c)

Row number

d)

Cell locator

24.
What is displayed in cell A6?
a)
Monday
b)
Tuesday
c)
Wednesday
d)
Thursday
25.
What is displayed in cell B1?
a)
100
b)
Tickets Sold
c)
Day
d)
B1
26.
Gerilynn wanted to find the total amount of vanilla cakes ordered. Which of the following formulas should she use?
a)
=(C3+C5+C9)/3
b)
=SUM(C2:C10)
c)
=AVERAGE(C2:C10)
d)

=C3+C5+C9

27.

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

a)

CELL

b)

SELECTED RANGE

c)

ACTIVE CELL

d)

NONE

28.
Is this a formula or a function:
=D7 * E9
a)
Formula
b)
Function
29.
Is this a formula or a function:
=Sum(B3:B30)
a)
Formula
b)
Function
30.
A1:A10 is an example of...
a)
Cell Address
b)
Cell Range
c)
Formula
d)
Function
31.
This function adds the range of cells
a)
=SUM( )
b)
=AVERAGE( )
c)
=MAX( )
d)
=MIN( )
32.
This function finds the highest number in the range of cells
a)
=SUM( )
b)
=AVERAGE( )
c)
=MAX( )
d)
=MIN( )
33.
This function finds the lowest number in the range of cells.
a)
=SUM( )
b)
=AVERAGE( )
c)
=MAX( )
d)
=MIN( )
34.
Format cells as ______________ when working with amounts of money.
a)
currency
b)
percent
c)
number
d)
scientific
35.
Which of the following tells a Spreadsheet to subtract the value in cell A4 from the value in cell A3?
a)
A4-A3=
b)
A3-A4=
c)
=A4-A3
d)
=A3-A4
36.
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)
37.
Which of the following is a formula that will divide cell D10 by 2?
a)
=D10/A2
b)
10/2
c)
=D10*2
d)
=D10/2
38.

_____________displays the contents of active cell.

a)

Tool bar

b)

Address bar

c)

Formula bar

d)

Alignment bar

39.

A __________ is a collection of multiple worksheets.

a)

Workbook

b)

Interface

c)

Cell

40.

Which of the following can be done using Microsoft Excel?

a)

Creating a Magazine article

b)

Creating graphs and charts

c)

Drawing pictures

d)

Creating websites

Similar Resources on Wayground

Informatyka

40 questions

Informatyka

quiz

Worksheet

•

8th Grade

แบบทดสอบก่อน-หลังเรียน เรื่อง โปรแกรมภาษา

40 questions

แบบทดสอบก่อน-หลังเรียน เรื่อง โปรแกรมภาษา

quiz

Worksheet

•

9th Grade

1.1 Architecture of CPU

38 questions

1.1 Architecture of CPU

quiz

Worksheet

•

9th - 12th Grade

TIK Kelas 2

40 questions

TIK Kelas 2

quiz

Worksheet

•

8th Grade

สอบกลางภาควิชาเทคโนโลยี 2

40 questions

สอบกลางภาควิชาเทคโนโลยี 2

quiz

Worksheet

•

8th Grade

Term 1- Intro to Ag Test Review

35 questions

Term 1- Intro to Ag Test Review

quiz

Worksheet

•

9th Grade

KS3 Y8 Baseline Test

40 questions

KS3 Y8 Baseline Test

quiz

Worksheet

•

8th Grade

Python

35 questions

Python

quiz

Worksheet

•

KG - Professional Dev...