wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

Functions and Formulas in an Electronic Spreadsheet

Total questions: 25

Worksheet time: 19mins

Name
Class
Date
1.

What is an application software that helps you to store and analyse data?

a)

PowerPoint

b)

Word

c)

Pad

d)

Excel

2.

What are built-in formulas used for calculation?

a)

Functions

b)

Theorems

c)

Logics

d)

Concepts

3.

What is an application software that organises data in the form of rows and columns?

a)

PowerPoint

b)

Word

c)

Pad

d)

Excel

4.

What are used for performing simple and complex calculation?

a)

Formulas

b)

Theorems

c)

Logics

d)

Concepts

5.

Which feature allows automatic recalculation in case of any change made in a single cell?

a)

Calculate

b)

Calculation

c)

Formulation

d)

Auto-Calculation

6.

What is the first electronic spreadsheet software named? When was it?

a)

Spreadsheet

b)

Lotus

c)

G-Sheet

d)

Visicalc

7.

What helps to understand, analyse and compare data in an effective manner?

a)

Presentation

b)

Chart

c)

Slide

d)

Show

8.

What is the by-default name for an Excel-File?

a)

Sheet 1

b)

Worksheet 1

c)

Book 1

d)

Workbook 1

9.

What is located at the top of the window that shows the name of current workbook?

a)

Tool Bar

b)

Menu Bar

c)

Scroll Bar

d)

Title Bar

10.

What is present on the title bar. It displays frequently used tools?

a)

Name of Application

b)

Name of File

c)

Window Options

d)

Quick Access Toolbar

11.
What do all formulas begin with?
a)
%
b)
[ ]
c)
=
d)
:
12.
What symbol do we use for multiplication in a Spreadsheet program? 
a)
/
b)
=
c)
^
d)
*
13.
What symbol do we use for addition in a Spreadsheet program? 
a)
/
b)
+
c)
=
d)
*
14.
What symbol do we use for subtraction in a Spreadsheet program? 
a)
/
b)
*
c)
+
d)
-
15.
What symbol do we use for division in a Spreadsheet program? 
a)
/
b)
*
c)
+
d)
=
16.
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
17.
Which of the following tells a Spreadsheet to Divide the value in cell A3 by 27?
a)
=27/A3
b)
= A3/27
c)
= 27^A3
d)
=A3*27
18.
Which of the following formulas will add cells A1 thru A5?
a)
=SUM(A2+A5)
b)
=A1+A2+A3+A4+A5
c)
=A1:A5
d)
=A1-A2-A3-A4-A5
19.
Which of the following is a formula that will add cells C9 and C10?
a)
=C9+C10
b)
C9+C10
c)
=C9:C10
d)
=C9*C10
20.
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)
21.
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
22.
Which of the following is a formula that will subtract cell B4 from cell B3?
a)
=3-4
b)
=B3-B4
c)
=B3*B4
d)
B3-B4
23.
Which of the following is a formula that will divide cell A10 by cell A1?
a)
=A10/A1
b)
=A1/A10
c)
=A10*A1
d)
=Divide(A10:A1)
24.
Which of the following is a correct example using the AUTOSUM function?
a)
sum(D14:D19)
b)
=D14:d19
c)
=sum(D14:D19)
d)
=D14+D15+D16+D17+D18+D19
25.
Which of the following is a correct example using the AUTOSUM function?
a)
=Sum(A1-A10)
b)
=Sum(A1:A10)
c)
=A1+A2+A3+...+A10
d)
=Sum(A1+A2+A3+...+A10)