Wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

Grade 9 Calc

Total questions: 65

Worksheet time: 32mins

Name
Class
Date
1.

Light gray lines that divide each of the cells, rows, and columns in a spreadsheet

a)

Sparkline

b)

Gridlines

c)

Worksheet

d)

Cell Location

2.

To combine into one

a)

Sort

b)

Filter

c)

Import

d)

Merge

3.

A formula or equation used to generate an answer

a)

Cell Reference

b)

Function

c)

Autofill

d)

AutoSum

4.

A tool which fills in a field or cells automatically

a)

AutoSum

b)

Import

c)

Autofill

d)

Merge

5.

The vertical parts of a spreadsheet denoted by capital letters

a)

Cell Location

b)

Columns

c)

Rows

d)

Cell Reference

6.

The horizontal parts of a spreadsheet denoted by numbers

a)

Rows

b)

Columns

c)

Cell

d)

Relative Reference

7.

Referring to a rectangle on a spreadsheet by naming the column and then row in which it lies

a)

Cell Location

b)

Absolute Reference

c)

Cell Reference

d)

Sparkline

8.

The rectangular fields you can type in on a spreadsheet formed when a column and row intersect

a)

Worksheet

b)

Cell

c)

Workbook

d)

Painter

9.

The entire spreadsheet file you are working in. It can contain one or more worksheets

a)

Workbook

b)

Worksheet

c)

Painter

d)

Cell Reference

10.

A spreadsheet cell that does not change regardless of its attributes

a)

Relative Reference

b)

Cell Reference

c)

Absolute Reference

d)

Cell Location

11.

A spreadsheet cell that does change depending on what changes were made to the spreadsheet it is located on

a)

Relative Reference

b)

Cell Reference

c)

Absolute Reference

d)

Cell Location

12.

Refers to a cell or range of cells on a worksheet and can be used in a formula so the program can find the values or data you want a formula to calculate

a)

Relative Reference

b)

Cell Reference

c)

Absolute Reference

d)

Cell Location

13.

Which of the following functions are available in consolidate window?

a)

Max

b)

Min

c)

Count

d)

All of the above

14.

By default ________________ sheets are present in Libre Office Calc Spreadsheet

a)

1

b)

2

c)

3

d)

4

15.

We can rename an existing sheet in Calc by

a)

Double click on one of the existing sheet

b)

Right click on existing sheet and then choose rename

c)

Both of the above

d)

None of the above

16.
Which chart would you use if you had several items in a specific range of values? Example: the number of matches the Panthers Volleyball team has won from each of the last 10 years.
a)
Bar
b)
Line
c)
Column
d)
Pie
17.
Which chart would you use if you wanted to show distribution of of items when there are more than 3 categories?
Example: To show the % of students in 6th grade that drink whole milk, 2% milk, 1% milk, and skim milk. 
a)
Bar
b)
Line
c)
Column
d)
Pie
18.
Which chart would you use to show change (trends) over time?
Example: Your grade in Reading since the beginning of this year. 
a)
Bar
b)
Line
c)
Column
d)
Pie
19.
A11: E:31 is an example of a ___________________. 
a)
Selection
b)
Formula
c)
Range
20.
To go from one cell to the next horizontally (left to right), what key would you press on your keyboard?
a)
Shift
b)
Tab
c)
Space
d)
Enter
21.
To go from one row to the next, what key would you press on your keyboard?
a)
Shift
b)
Tab
c)
Space
d)
Enter
22.

Identify this chart.

a)

Pie

b)

Line

c)

Bar

d)

Column

23.

Identify this chart.

a)

Line

b)

Bar

c)

Column

d)

Pie

24.

Identify this chart.

a)

Column

b)

Bar

c)

Line

d)

Pie

25.

Tells you what each part of the chart represents.

a)

Legend

b)

Vertical axis

c)

Horizontal axis

d)

Chart title

26.

This part of the chart is usually vertical and contains data.

a)

Y axis

b)

X axis

c)

Legend

d)

Chart title

27.

This part of the chart is usually horizontal and contains categories.

a)

X axis

b)

Y axis

c)

Legend

d)

Chart title

28.

According to this chart, in which month are produce sales the highest?

a)

June

b)

March

c)

November

d)

May

29.

According to this chart, which type of pork do people prefer most?

a)

Bacon

b)

Ribs

c)

Ham

d)

Other

30.

According to this chart, which band sold the most albums?

a)

Doug and the Slugs

b)

Gails and the Snails

c)

Sherm and the Worms

d)

Marva and the Larva

31.
Edward would like to create a chart that uses vertical rectangles to compare iPod and iPad sales. Which chart type would he create?
a)
Bar
b)
Column
c)
Line
d)
Pie
32.
A visual representation of worksheet data.
a)
Column
b)
Data
c)
Chart
d)
Legend
33.
Data graphed as slices of a circular area is a 
a)
bar chart
b)
scatter plot
c)
pie chart
d)
column chart
34.
The part of the chart area that displays data.
a)
legend
b)
axis
c)
series
d)
plot area
35.
_______________ are numbers displayed by a column, bar, pie slice, or other marker on a chart.
a)
Series
b)
Data Labels
c)
Markers
36.
Leigh Ann designed a bar chart and would like to add an element above the chart to make the data more meaningful. Which chart feature would she need to include?
a)
Axis
b)
Chart Title
c)
Data Label
d)
Legend
37.
This describes what is charted. It can be placed above or below the chart.
a)
Chart title
b)
chart area
c)
bar chart
d)
pie chart
38.
A chart can be moved to a separate sheet.
a)
True
b)
False
39.
Once a type of graph is chosen, it can not be changed.
a)
True
b)
False
40.
Dorothy designed a column chart and would like to change the background color to yellow. Which chart feature would she modify?
a)
Axis Title
b)
Chart Title
c)
Gridlines
d)
Plot Area
41.
Leigh Ann designed a bar chart and would like to add an element above the chart to make the data more meaningful. Which chart feature would she need to include?
a)
Axis
b)
Chart Title
c)
Data Label
d)
Legend
42.

What symbol does a formula have to start with in order for it to work?

a)

#

b)

$

c)

=

d)

@

43.

Which is NOT a type of chart?

a)

pie

b)

column

c)

bar

d)

axis

44.

Which is NOT a formula?

a)

b2+b3+b4

b)

=b1+b2+b3

c)

=b4*c4

d)

=b5/b7

45.

What is the first thing you have to do in a spreadsheet before you can create a chart/graph?

a)

click insert charts/graphs

b)

go to file, print

c)

highlight the data with your mouse

d)

bold all the information

46.

These lines in charts serve as basis for more accurate analysis.

a)

gridlines

b)

drop lines

c)

draw lines

d)

all of these

47.
Once you have created a chart you cannot add another data series.
a)
True
b)
False
48.

Sum, average, count, and maximum value are examples of what?

a)

Formulas

b)

Functions

c)

Calculations

d)

Spreadsheet Data

49.

Which of the following formulas show the correct use of the SUM function?

a)

-SUM(H3-H10)

b)

=SUM(H3:H10)

c)

=SUM(H3...H10)

d)

+SUM(H3:H10)

50.

See the following formula. Which of the following formula is the another method of the given formula?

=(B2+C2+D2+E2)/4

a)

= SUM (B2,C2,D2,E2)

b)

= MAX(B2:E2)

c)

= SUM(B2,E2/4)

d)

= AVERAGE (B2:E2)

51.

If you type =2*(6-4) in cell A1, what will be the display value?

a)

2

b)

4

c)

6

d)

8

52.

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

a)

Active Cell

b)

Chart

c)

Column

d)

Row

53.

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

a)

file bar

b)

help bar

c)

window bar

d)

formula bar

54.
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
55.

A cell's location is expressed by its column letter and row number such as A1.

a)

name box

b)

formula bar

c)

cell address

56.

The function that lets you add up a range of cells or values

a)

SUM

b)

AVERAGE

c)

MIN

d)

MAX

57.

What function was used to find the lowest grade?

a)

average

b)

sum

c)

min

d)

max

58.

What function was used to find the highest grade?

a)

average

b)

min

c)

sum

d)

max

59.

The function COUNT is specific for ___________

a)

counting cells

b)

counting numbers

c)

counting text

d)

counting tables

60.

Cell orientation allows you to :

a)

change cell contents from number to text

b)

color the text under condition

c)

change the direction of the text

d)

change the appearance of the cell

61.
By default, all cell references are _________ references. 
a)
Absolute
b)
Relative
62.
If you don't want a cell reference to change when copied to other cells, use _________ references
a)
Absolute
b)
relative
63.

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.

64.

What does the Max function 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.

65.

What does the Min function return?

a)

Returns the smallest three numbers form a set and ignores text.

b)

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

c)

Returns the largest three numbers form a set and ignores text.

d)

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

Similar Resources on Wayground

Latihan Soal Microsoft Word

68 questions

Latihan Soal Microsoft Word

quiz

Worksheet

•

KG - 12th Grade

PTS Informatika 2 (analisa data, algoritma dan pemrograman)

65 questions

PTS Informatika 2 (analisa data, algoritma dan pemrograman)

quiz

Worksheet

•

9th - 12th Grade

Unit 2 Test Review - The Internet

61 questions

Unit 2 Test Review - The Internet

quiz

Worksheet

•

9th - 12th Grade

HTML Assessment

60 questions

HTML Assessment

quiz

Worksheet

•

9th Grade

Final Review Activity

70 questions

Final Review Activity

quiz

Worksheet

•

9th - 12th Grade

CIS Microsoft Excel (Review)

62 questions

CIS Microsoft Excel (Review)

quiz

Worksheet

•

9th Grade - Professio...

Computer Systems Quiz

60 questions

Computer Systems Quiz

quiz

Worksheet

•

9th - 12th Grade

PIT Final

64 questions

PIT Final

quiz

Worksheet

•

9th - 10th Grade