NEW
Font size
S
M
L
XL
Worksheets[RB3-Ch3] Working with Spreadsheet
Total questions: 20
Worksheet time: 10mins
Name
Class
Date
1.
To find the square root of 4 using the SQRT function, we follow the syntax __________________.
a)
=SQRT(4)
b)
=Power(5)
c)
=(Square)
d)
=(Exp)
2.
The PRODUCT function can be accessed from the ________________ group on the formulas tab.
a)
Any group
b)
Function Library
c)
Insert
d)
Home
3.
A ________________ chart enables us to view changes in data over time.
a)
Pie
b)
Bar
c)
Line
d)
Graph chart
4.
To calculate 54, we use the _______________ function.
a)
Plus
b)
Minus
c)
Multiply
d)
POWER
5.
A ___________________ chart is useful for showing the properties of monthly expenses.
a)
Pie
b)
Bar
c)
Line
d)
Grey chart
6.
Conditional formatting enables important data to be highlighted.
a)
True
b)
False
7.
In conditional formatting, data can be set off in different colors.
a)
True
b)
False
8.
The POWER function consists of three numbers in the syntax.
a)
True
b)
False
9.
The PRODUCT function can only be used with three numbers.
a)
True
b)
False
10.
The options for charts can be accessed from the home tab.
a)
True
b)
False
11.
A _______________ chart enables us to spot trends.
a)
Column
b)
Bar
c)
Line
d)
Pie
12.
The ___________ function is used to multiply numbers.
a)
PRODUCT
b)
SQRT
c)
POWER
d)
SUM
13.
______________________ is used to highlight unusual data.
a)
Formatting
b)
Highlighting
c)
Conditional Formatting
d)
Alignment
14.
We need to specify a base number and exponent when using the function ______________.
a)
POWER
b)
PRODUCT
c)
IF
d)
SQRT
15.
The cells on which a function is to be applied are called the ______________________
a)
Data set
b)
Data collection
c)
Formula
d)
Data range
16.
Which of these is the correct syntax for the SUM function?
a)
SUM (A1:A10)
b)
SUM(A1+A10)
c)
=SUM (A1:A10)
d)
=SUM (A1:A100)
17.
The if section of the IF function contains a ______________ .
a)
Logical test
b)
Formatting option
c)
Operation
d)
Value
18.
The conditional formatting feature is located on the _____________ tab.
a)
Formulas
b)
Data
c)
Home
d)
Review
19.
Which type of chart is used to compare items in different categories.
a)
Bar
b)
Pie
c)
Column
d)
Line
20.
Which of these charts shows data as sections of a whole.
a)
Line
b)
Bar
c)
Pie
d)
Column
Reset
