wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

Spreadsheet for a purpose

Total questions: 97

Worksheet time: 59mins

Name
Class
Date
1.

Excel is a (a)   program that allows you to store, organize, and analyze information.

2.

The (a)   is where you'll find the commands you need to perform common tasks in Excel.

3.

The Ribbon contains multiple (a)   , each with a group of commands.

4.

Excel files are called (a)   .

5.

Each workbook holds one or more (a)   .

6.

To save time, you can create your document from a __________.

a)

file

b)

image

c)

book

d)

template

7.

On which tab would you find the command to create a new workbook?

a)

File

b)

Home

c)

Insert

d)

View

8.

You can format text in Excel by making it bold, italic, etc.

a)

True

b)

False

9.

Worksheets are made up of rows and columns.

a)

True

b)

False

10.

__________ run from left to right and are identified by numbers.

a)

Rows

b)

Columns

c)

Worksheets

d)

Files

11.

Pre-designed and formatted files called ______ help to create new worksheets quickly.

a)

Documents

b)

Templates

c)

Folders

d)

Cell Reference

12.

The electronic spreadsheet made of cells and organized by rows and columns is known as the _____.

a)

Document

b)

Presentaion

c)

Publicaiton

d)

Worksheet

13.

The electronic spreadsheet you work in is contained in a file called a ______________ with the file extension .xlsx.

a)

Binder

b)

Folder

c)

Cabinet

d)

Workbook

14.

This area tells you the name of the project and the name of the program you have open.

a)

Status Bar

b)

Formula Bar

c)

Title Bar

d)

Quick Access Toolbar

15.

Letters of the alphabet going across the top of the spreadsheet.

a)

Title Bar

b)

Column Labels

c)

Row Labels

d)

Status Bar

16.

Numbers down the left side of the spreadsheet.

a)

Status Bar

b)

Formula Bar

c)

Column Labels

d)

Row Labels

17.

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

a)

Four-way Stop

b)

Formula Bar

c)

Cell

d)

Template

18.

A cell that has a dark border around it.

a)

Jail Cell

b)

Sleepy Cell

c)

Active Cell

d)

Stem Cell

19.

The ________ contains a grid of columns and rows, the formula bar and the ribbon.

a)

Worksheet Window

b)

Document Window

c)

Presentation Window

d)

Publication Window

20.

Every cell has its own unique address or _____ _____, which is identified by the specific coordinates of the intersecting column and row.

a)

PO Box

b)

Cell Reference

c)

Status Bar

d)

Formula Bar

21.

The horizontal and vertical lines on the spreadsheet that identify each cell on the spreadsheet are known as the _____.

a)

Cell Blocks

b)

Scroll Bars

c)

Mapping LInes

d)

Grid-lines

22.

These items allow you to move up & down or left & right in a worksheet that is to large to fit on the screen at once.

a)

Scroll Bars

b)

Pry Bar

c)

Scroll Box

d)

Salad Bar

23.

The area is located at the bottom of the Excel window and provides information and options for your worksheet project.

a)

Scroll Bars

b)

Status Bar

c)

Salad Bar

d)

Formula Bar

24.

A selection of two or more cells is known as a ____.

a)

Cluster

b)

Range

c)

Conglomorate

d)

Big mess

25.

A ____ is another name for an equation used in Excel.

a)

Formula

b)

Calculation

c)

Mode Indicator

d)

Template

26.

Every Excel formula/equation must begin with _____.

a)

an equal sign

b)

please and thank you

c)

cell reference

d)

a prayer

27.

The ____ performs the arithmetic calculations in a formula.

a)

Calculator

b)

Grid-lines

c)

Status Bar

d)

Operator

28.

Using the keyboard, you could navigate from one cell to another cell by using the ____ ____.

a)

Enter Keys

b)

Arrow Keys

c)

Piano Keys

d)

Tab Key

29.

Numerical data entered into the spreadsheet cells will appear _____ according to place-value.

a)

Magically

b)

Right Aligned

c)

Left Aligned

d)

Centered

30.

Any data (text or numerical) entered into a cell will appear in the active cell as well as in the ____ ____.

a)

Status Bar

b)

Scroll Bar

c)

Outside Window

d)

Formula Bar

31.

The small dot in the lower-right corner of an active cell. It allows you to copy or duplicate information to other cells.

a)

Scroll Box

b)

Fill Handle

c)

Cell Reference

d)

Ribbon Tab

32.

Entries that identify data in a worksheet and not used in a formula are known as ____. (They are usually aligned-left.)

a)

Tags

b)

Labels

c)

Values

d)

Insignificant

33.

Entries in a spreadsheet used in formulas and functions are known as ____. (They are usually aligned-right.)

a)

Values

b)

Numerical Data

c)

Tags

d)

Labels

34.

The contents of a worksheet will print across the length of the page in ____ ____.

a)

Landscape Orientaion

b)

Portrait Orientation

c)

7th grade Orientation

d)

Total Disorientation

35.

The contents of a worksheet will print across the width of the page in ____ ____.

a)

Landscape Orientaion

b)

Portrait Orientation

c)

7th grade Orientation

d)

Total Disorientation

36.

Which of the following will pull out the lowest number?

a)

SUM

b)

MAX

c)

AVERAGE

d)

MIN

37.

What part of a spreadsheet is vertical?

a)

Formula Bar

b)

Row

c)

Column

d)

Cell

38.

Which part of a spreadsheet is horizontal?

a)

formulas bar

b)

column

c)

row

d)

cell

39.

Which of the following is a function?

a)

John Jones

b)

$5.00

c)

=sum(A1:A5)

d)

=A1+A5

40.

When following the Order of Operations, which of the following would be performed FIRST?

a)

Multiplication

b)

Exponentials

c)

Parenthesis

d)

Division

41.

Values are aligned on which side of a cell?

a)

Left

b)

Right

42.

Which of the following will produce a number that is calculated by adding quantities together and then dividing the total by the number of quantities?

a)

SUM

b)

AVERAGE

c)

MAX

d)

MIN

43.

Labels align on which side of a cell?

a)

Right

b)

Left

44.

Which of the following is a correct cell address?

a)

1

b)

A1

c)

1A

d)

A

45.

What part of cell is represented by letters?

a)

row

b)

forumula bar

c)

columns

d)

cell

46.

Which of the following is used to get the highest number?

a)

AVERAGE

b)

SUM

c)

MAX

d)

MIN

47.

Another name for a spreadsheet file is:

a)

Workbook

b)

Spreadbook

c)

Excel

d)

Worksheet

48.

Where do you look to see what is typed within a cell?

a)

Formula Box

b)

Name box

c)

Name bar

d)

Formula bar

49.

A spreadsheet is what type of software?

a)

Application

b)

Operating

c)

It isn't software

d)

System

50.

Which symbol is used for division?

a)

Asterisk

b)

Forward slash

c)

Back slash

d)

Space bar

51.

A cell that has a dark border around it and is the cell you are currently working in is called:

a)

Row

b)

Label

c)

Column

d)

Active Cell

52.

Which of the following is an example of a label?

a)

John Jones

b)

=A1+A5

c)

$5.00

d)

=sum(A1:A5)

53.

Which of the following symbols is used for multiplication?

a)

Back slash

b)

Plus

c)

Asterisk

d)

Forward slash

54.

Which of the following does a spreadsheet NOT do for a user?

a)

calculate a loan payment schedule

b)

balance a checkbook

c)

write a business letter

d)

create household budget

55.

What symbols MUST be typed first to tell a cell it is going to calculate?

a)

Equals

b)

Asterisk

c)

Dollar

d)

Percentage

56.

The name of the program that we use for spreadsheets in our lab this year is:

a)

Publisher

b)

Access

c)

Excel

d)

Word

57.

Which of the following will give you a total?

a)

MIN

b)

MAX

c)

AVERAGE

d)

SUM

58.

Refers to a group or block of adjacent cells next to each other:

a)

cell group

b)

function

c)

range

d)

formula

59.

Which of the following is a value?

a)

$5.00

b)

=A1+A5

c)

=SUM(A1:A5)

d)

John Jones

60.

Which of the following is a formula?

a)

John Jones

b)

$5.00

c)

=SUM(A1:A5)

d)

=A1+A5

61.

The cell address of the highlighted cell is

a)

C

b)

A4

c)

C4

62.
How do you change column width to fit the contents?
a)
Single-click the boundary to the left of the column heading
b)
Double-click the boundary to the right of the column heading
c)
Press ALT and single-click anywhere in the column
63.

A pie graph is a visual representation of what?

a)

Values change over time.

b)

comparison of a piece of data to the whole group

c)

a categorical data with rectangular bars with heights or lengths proportional to the values that they represent.

64.

You accidentally erased a record in the sheet. What command can be used to restore it immediately?

a)

A. Insert

b)

B. Copy

c)

C. Undo

d)

D. Replace

65.

What is this icon?

a)

Zoom

b)

Sort and Filter

c)

Symbol

d)

Merge and Center

66.

By default the text data is________ aligned in cell.

a)

Left

b)

Center

c)

Right

d)

Bottom

67.

By default the number data is __________ aligned in cell.

a)

Right

b)

Center

c)

Top

d)

Left

68.

Excel allows you to work with?

a)

Sentences

b)

Paragraphs

c)

data

69.
Which tab in Excel has charts and tables?
a)
review
b)
home
c)
file
d)
insert
70.

What type of chart will you use to compare performance of sales of two products ?

a)

Column/ Bar Chart

b)

Line Chart

c)

Pie Chart

71.

It is where you will find the basic commands such as open, save, print, etc

a)

Quick Access Toolbar

b)

Ribbon

c)

File Menu

d)

Tell me

72.

It is designed to help you quickly find the commands that you need to complete a task

a)

Quick Access Toolbar

b)

Ribbon

c)

File Menu

d)

Tell me

73.

To select an entire column in a worksheet, you should press ________.

a)

CTRL+SPACEBAR

b)

SHIFT+SPACEBAR

c)

CTRL+SHIFT+SPACEBAR

d)

SPACEBAR

74.

These are not to be used in calculations which includes numerical information, such as phone numbers and zip codes

a)

Values

b)

Labels

c)

Cell Address

d)

Relative Referencing

75.

These are numerical pieces of information that will be used for calculations.

a)

Labels

b)

Cell Address

c)

Values

d)

Cell Address

76.

A formula starts with an equal sign (=)

a)

True

b)

False

c)

Maybe

d)

Insufficient information

77.

It returns the number of values of the selected cells

a)

SUM

b)

MAX

c)

MIN

d)

COUNT

78.

If you to select non-consecutive cells, then

a)

Press and hold CTRL while clicking column or row headers

b)

Click and drag across column or row headers

c)

Click the first cell in the range. Drag across the cells and release the mouse button

d)

Press and hold CTRL while clicking the celss

79.

If you to select multiple columns, then

a)

Press and hold CTRL while clicking column or row headers

b)

Click and drag across column or row headers

c)

Click the first cell in the range. Drag across the cells and release the mouse button

d)

Press and hold CTRL while clicking the celss

80.

You use this category when you want to enter a text description containing numbers or special characters

a)

Number

b)

General

c)

Text

d)

Accounting

81.

A new Excel file contains _______ worksheets.

a)

1

b)

2

c)

3

d)

4

82.

A collection of worksheets is called a

a)

workbook

b)

file

c)

spreadsheet

d)

column

83.

Which is horizontal (left and right)?

a)

Columns

b)

Rows

c)

Data

d)

Cells

84.

Which is vertical (up and down)?

a)

Cells

b)

Rows

c)

Data

d)

Columns

85.

What do you call the single rectangle that you enter data into?

a)

a box

b)

a cell

c)

a formula bar

d)

a column

86.

What is the top menu in Microsoft Excel called?

a)

The Ribbon

b)

The Arrow

c)

The Menu

d)

The Tab

87.

The file extension of a Microsoft Excel file is

a)

.docx

b)

.pptx

c)

.xlmx

d)

.xlsx

88.

What can be used to add color to a cell?

a)

Cell Borders

b)

Cell Fill

c)

Cell AlignmentT

d)

Text Color

89.

Microsoft Excel was made by Google.

a)

True

b)

False

90.

What company created Excel?

a)

Sony

b)

Google

c)

Microsoft

d)

Apple

91.

Is it possible to create pixel art with a spreadsheet?

a)

True

b)

False

92.

What software could you use to create a spreadsheet?

a)

PowerPoint

b)

Publisher

c)

Word

d)

Excel

93.

What are the boxes on a spreadsheet called?

a)

Squares

b)

Cells

c)

Boxes

d)

Rows

94.

How do you add color to a spreadsheet?

a)

Insert a Picture

b)

Change Column Width

c)

Add a New Tab

d)

Click on the Fill Color button

95.

What program would you use to make a spreadsheet?

a)

PowerPoint

b)

Excel

c)

Publisher

d)

Word

96.

What is a spreadsheet?

a)

An electronic document with rows and columns

b)

A publication

c)

A slideshow

d)

A word processor

97.

What color is the Excel icon?

a)

Blue

b)

Red

c)

Green

d)

Yellow