wayground logo

Free Printable Worksheets

NEW

Font size

S
M
L
XL
Worksheets

2021 Semester Review Game Part 2

Total questions: 26

Worksheet time: 13mins

Name
Class
Date
1.

____________ programs and applications are powerful tools that allow a user to enter data, perform calculations, analyze results, and display information in a variety of ways.

a)

Word processing

b)

Presentation

c)

Spreadsheet

d)

All of the Above

2.

When working in Microsoft Excel on a spreadsheet, _________ run up and down and ____________ go across.

a)

rows, columns

b)

columns, cells

c)

cells, rows

d)

columns, rows

3.

_________ __________ lock certain rows and columns and allow you to scroll through the content of your file while still seeing the frozen cells.

a)

Frozen cells

b)

Hidden ribbons

c)

Freeze panes

d)

All of the Above

e)

None of the Above

4.

The _________________ displays the name or location of the active cell.

a)

cell name

b)

name box

c)

formula bar

d)

all of the above

5.

Including a _________ or __________ in your spreadsheet is a

great way to identify printed work without having to interfere with spreadsheet data.

a)

grid-lines, headings

b)

header, shoulders

c)

knees, toes

d)

header, footer

6.

_____________ is a widely used spreadsheet software designed by Microsoft.

a)

Sheets

b)

Numbers

c)

Excel

d)

Slides

7.

Google __________ is a free web-based application in which spreadsheets can be created, edited, and stored online. Files can be accessed from any

a)

Slides

b)

Docs

c)

Sheets

d)

Forms

8.

The ________ in a spreadsheet cell can be formatted to have various horizontal alignments.

a)

story

b)

data

c)

sentences

d)

cells

9.

What tab do you click on in the ribbon using Microsoft Word when creating a Table of Contents page?

a)

Layout

b)

References

c)

Design

d)

Mailings

10.

What computer key do you hold down to select non adjacent (rows/columns/cells)?

a)

Control

b)

Shift

c)

Alt

d)

Command

11.

When you sort information in ___________________ order you are placing information in order from smallest to largest.

a)

descending

b)

ascending

c)

numerical

d)

all of the above

12.

Basic math functions, such as addition or subtraction, are a breeze and Excel will calculate the totals when data is used in __________.

a)

documents

b)

equations

c)

formulas

d)

all of the above

13.

One of the most commonly used functions is the _____ function, which will add a range of adjacent cells.

a)

SUM

b)

AVERAGE

c)

MAX

d)

MIN

14.

One of the most commonly used functions is the _____ function, which will add a range of adjacent cells.

a)

SUM

b)

AVERAGE

c)

MAX

d)

MIN

15.

When many employees are involved in the payroll register, ____________ software makes calculating payroll easy because formulas can be copied and pasted to adjoining rows.

a)

document

b)

presentation

c)

spreadsheet

d)

database

16.

_________________ is the process of changing the values in cells to see how those changes will affect the outcome of formulas on the worksheet.

a)

Absolute Cell Reference

b)

What If Analysis

c)

Statistics

d)

All of the Above

17.

To calculate the ____________, Excel adds the numbers together and divides by the total number of numbers.

a)

maximum

b)

minimum

c)

average

d)

sum

18.

A ___________ _____ ___________ is a cell reference in a spreadsheet application that remains constant. (Hint: the value does not change).

a)

relative cell reference

b)

absolute cell reference

c)

red blood cell

d)

white blood cell

19.

The ________ function is a reliable way to count the number of items in a range of cells that contain data.

a)

MAX

b)

MIN

c)

AVERAGE

d)

COUNT

20.

Based on an entered criterion and result, the ________ _____ function will determine what is entered in a cell.

a)

Count If

b)

Count A

c)

Count Blank

d)

Count Dracula

21.

The __________ function will do the job of calculating the monthly payment based on a loan amount, interest rate, and 30 years of monthly payments.

a)

SUM

b)

AVERAGE

c)

PMT

d)

All of the Above

22.

The _______ function in your spreadsheet software can help you see just how much monthly investment will yield after a period of time.

a)

PV (Present Value)

b)

FV (Future Value)

c)

PMT (Payment)

d)

All of the Above

23.

The _______ function doesn't just increase or decrease the decimal place but actually changes the value of the number.

a)

SUM

b)

AVERAGE

c)

MAX

d)

ROUND

24.

Along the bottom of your screen, you will find tabs with default names such as Sheet1 and Sheet2. You can rename the ________ with a name that makes sense based on the data you are working with.

a)

tabs

b)

sheets

c)

paper

d)

all of the above

25.

Which of the following is not a type of Pie Chart?

a)

Bar of Pie

b)

Pie of Pie

c)

Doughnut

d)

Apple Pie

e)

3-D Pie

26.

__________ ___________ are used for comparing a single category of information, such as profit analysis, sales projections, and expenditures.

a)

Column Charts

b)

Bar Graphs

c)

Bar Chart

d)

Pie Chart