wayground logo

Free Printable Worksheets

NEW

Font size

S
M
L
XL
Worksheets

Spreadsheets - Quiz 1 - Basics

Total questions: 26

Worksheet time: 13mins

Name
Class
Date
1.
What is a Spreadsheet?
a)
Information stored in a spreadsheet program.
b)
A vertical or horizontal bar commonly located on the far right or bottom of a window that allows you to move the window viewing area, up, down, left, or right.
c)
a single "sheet" or "tab" inside a spreadsheet.
d)
A computer program that is used for storing, organizing and manipulating data.
2.
What is a worksheet?
a)
Information stored in a spreadsheet program.
b)
A vertical or horizontal bar commonly located on the far right or bottom of a window that allows you to move the window viewing area, up, down, left, or right.
c)
a single "sheet" or "tab" inside a spreadsheet.
d)
A computer program that is used for storing, organizing and manipulating data.
3.
An individual box within a worksheet is known as?
a)
square
b)
range
c)
refernce
d)
cell
4.

What is the value of the active cell?

a)

Y

b)

N

c)

Batman

d)

Superman

5.

What is the cell reference of the active cell?

a)

A1

b)

4B

c)

BB8

d)

B4

6.

What has happened to Superheros in cells B2:D2?

a)

Merged

b)

Joined

c)

Fused

d)

Nothing

7.

What is the name for a line of cells that go across the spreadsheet?

a)

Row

b)

Column

c)

Field

d)

Record

8.

If B3:J8 is given, what is it referring to?

a)

range of cells B3 through J8

b)

only cell J8

c)

only cells B3 and J8

d)

only cell B3

9.

What is an excel file that contains individual worksheets called?

a)

spreadsheet

b)

worksheet

c)

active cell

d)

workbook

10.
Cells that run vertically on a spreadsheet
a)
Row
b)
Workbook
c)
Worksheet
d)
Column
11.
What is normally used to perform calculations in a spreadsheet?
a)
Variable
b)
Formula
c)
Conditional formating
d)
Macro
12.
What is the name of this cell?
a)
B10
b)
5B
c)
B5
d)
you cannot know the name from this picture
13.
What is displayed in cell A6?
a)
Monday
b)
Tuesday
c)
Wednesday
d)
Thursday
14.
What is displayed in cell B1?
a)
100
b)
Tickets Sold
c)
Day
d)
B1
15.

Which of the following operators (symbols) represent adding in EXCEL spreadsheets?

a)

+

b)

-

c)

*

d)

/

16.

Which of the following operators (symbols) represent subtracting in EXCEL spreadsheets?

a)

+

b)

-

c)

*

d)

/

17.

Which of the following operators (symbols) represent multiplication in EXCEL spreadsheets?

a)

+

b)

-

c)

*

d)

/

18.

Which of the following operators (symbols) represent division in EXCEL spreadsheets?

a)

+

b)

-

c)

*

d)

/

19.

Addition, subtraction, multiplication and division are examples of what?

a)
Formulas
b)
Conditional Formatting
c)
Functions
d)
Spreadsheet Data
20.

Which of the following format NOT applied to cell A1?

a)

Font color

& fill color

b)

Font size

c)

Merge & center

d)

Border

21.

To format all currency value to dollars, you can select the cells and right click to choose

a)

Conditional formatting

b)

Page Layout

c)

Format cells

d)

Insert $

22.
Which career(s) or places of employment involve the use of a spreadsheet at work?
a)
Accountant
b)
Hospital
c)
All Choices
d)
Shop Keeper
23.
What would you format a cell as when working with amounts of money?
a)
currency
b)
percent
c)
number
d)
scientific
24.
Which of the following is a valid formula?
a)
=C7*C8
b)
=(C7\C8)
c)
=(C7xC8)
d)
=AVERAGE(C7*C8)
25.
Which formula would subtract D12 from D13?
a)
=D13-D12
b)
=D12-D13
c)
=sum(D12-D13)
d)
=sum(D13-D12)
26.
What does cell B6 contain?
a)
23
b)
0.45
c)
0.50
d)
23

Similar Resources on Wayground

IT Quiz

22 questions

IT Quiz

quiz

Worksheet

•

11th Grade - University

Kviz 1 2. polugodište

25 questions

Kviz 1 2. polugodište

quiz

Worksheet

•

9th Grade

Class 9 Computers A Word Processor MCQ

21 questions

Class 9 Computers A Word Processor MCQ

quiz

Worksheet

•

9th Grade

Video Production 2

21 questions

Video Production 2

quiz

Worksheet

•

9th - 12th Grade

Python Beginner

30 questions

Python Beginner

quiz

Worksheet

•

6th - 12th Grade

Alberson: Excel Unit D

22 questions

Alberson: Excel Unit D

quiz

Worksheet

•

KG - University

Recap Spreadsheet EP1

22 questions

Recap Spreadsheet EP1

quiz

Worksheet

•

10th Grade

Pemograman Dasar - RPL X

22 questions

Pemograman Dasar - RPL X

quiz

Worksheet

•

11th Grade