wayground logo

Free Printable Worksheets

NEW

Font size

S
M
L
XL
Worksheets

Spreadsheet Basics Quiz

Total questions: 30

Worksheet time: 15mins

Name
Class
Date
1.

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

a)

Cell Location

b)

Worksheet

c)

Gridlines

d)

Sparkline

2.

To combine into one

a)

Merge

b)

Filter

c)

Import

d)

Sort

3.

A formula or equation used to generate an answer

a)

Autofill

b)

Function

c)

Cell Reference

d)

AutoSum

4.

A tool which fills in a field or cells automatically

a)

AutoSum

b)

Import

c)

Merge

d)

Autofill

5.

The vertical parts of a spreadsheet denoted by capital letters

a)

Rows

b)

Cell Reference

c)

Cell Location

d)

Columns

6.

The horizontal parts of a spreadsheet denoted by numbers

a)

Cell

b)

Rows

c)

Relative Reference

d)

Columns

7.

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

a)

Sparkline

b)

Absolute Reference

c)

Cell Reference

d)

Cell Location

8.

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

a)

Painter

b)

Worksheet

c)

Cell

d)

Workbook

9.

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

a)

Workbook

b)

Painter

c)

Cell Reference

d)

Worksheet

10.

A part/page on a spreadsheet file you are working in

a)

Workbook

b)

Sparkline

c)

Cell Location

d)

Worksheet

11.

A small graphic designed to give a quick representation of numerical or statistical information taking the form of a graph without axes

a)

Painter

b)

Sparkline

c)

Workbook

d)

Gridlines

12.

Automatically adds up values in a row or column

a)

Autofill

b)

AutoSum

c)

Export

d)

Import

13.

To put in order

a)

Sort

b)

Filter

c)

Merge

d)

Function

14.

To remove unwanted pieces of data from view in a table

a)

Sort

b)

Merge

c)

Autofill

d)

Filter

15.

A spreadsheet cell that does not change regardless of its attributes

a)

Cell Reference

b)

Relative Reference

c)

Cell Location

d)

Absolute Reference

16.

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

a)

Relative Reference

b)

Absolute Reference

c)

Cell Referenced

d)

Cell Location

17.

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)

Cell Reference

b)

Relative Reference

c)

Cell Location

d)

Absolute Reference

18.

A small graphic designed to give a quick representation of numerical or statistical information taking the form of a graph without axes

a)

Chart

b)

Graphline

c)

Workbook

d)

Gridlines

19.

To automatically adjust the width of a column to fit the longest string in the column

a)

AutoFit

b)

AutoAdjust

c)

AutoWidth

d)

AutoColumn

20.

A feature that allows data to be displayed in a visual representation such as a pie chart or bar graph

a)

Data Visualization

b)

Data Representation

c)

Data Display

d)

Data Graphing

21.

Computer spreadsheet cell that is highlighted with heavy border is :

a)

Active cell

b)

Passive cell

c)

Locked cell

d)

Formatted cell

22.

Rohan selected the 4th row and 3rd column in a spreadsheet. Then what is the cell address?

a)

3C

b)

C3

c)

4C

d)

C4

23.

Data available in other sheets in a workbook , can be consolidate by :

a)

Row label

b)

Column Label

c)

Both a & b 

d)

None of the mentioned

24.

Which of the following is not a type of referencing in a spreadsheet?

a)

Absolute

b)

Physical

c)

Relative

d)

Mixed

25.

Which options is available in Openoffice (Oo) Calc in which tab:

a)

Insert

b)

Data

c)

Tools

d)

Format

26.

In Data consolidate what are the operations we can perform___

 

a)

Sum

b)

Average

c)

Max

d)

All of the above

27.

In a Subtotal function what are the functions can be performed on the group of cells:

a)

Sum

b)

Count

c)

Average

d)

All of the above

28.

To edit a Scenario, right click the name in the Navigator and select________.

a)

Properties

b)

Scenario 

c)

Window

d)

Edit

29.

A_________ is a What if Analysis tool that allows you to substitute set of values automatically in a worksheet.

a)

Goal Seek

b)

Navigator

c)

Scenario 

d)

Subtotal

30.

Goal Seek command is found in_________

a)

Data

b)

Tools 

c)

Format

d)

Edit