NEW
Font size
Worksheets2021 Semester Review Game Part 2
Total questions: 26
Worksheet time: 13mins
____________ 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.
Word processing
Presentation
Spreadsheet
All of the Above
When working in Microsoft Excel on a spreadsheet, _________ run up and down and ____________ go across.
rows, columns
columns, cells
cells, rows
columns, rows
_________ __________ lock certain rows and columns and allow you to scroll through the content of your file while still seeing the frozen cells.
Frozen cells
Hidden ribbons
Freeze panes
All of the Above
None of the Above
The _________________ displays the name or location of the active cell.
cell name
name box
formula bar
all of the above
Including a _________ or __________ in your spreadsheet is a
great way to identify printed work without having to interfere with spreadsheet data.
grid-lines, headings
header, shoulders
knees, toes
header, footer
_____________ is a widely used spreadsheet software designed by Microsoft.
Sheets
Numbers
Excel
Slides
Google __________ is a free web-based application in which spreadsheets can be created, edited, and stored online. Files can be accessed from any
Slides
Docs
Sheets
Forms
The ________ in a spreadsheet cell can be formatted to have various horizontal alignments.
story
data
sentences
cells
What tab do you click on in the ribbon using Microsoft Word when creating a Table of Contents page?
Layout
References
Design
Mailings
What computer key do you hold down to select non adjacent (rows/columns/cells)?
Control
Shift
Alt
Command
When you sort information in ___________________ order you are placing information in order from smallest to largest.
descending
ascending
numerical
all of the above
Basic math functions, such as addition or subtraction, are a breeze and Excel will calculate the totals when data is used in __________.
documents
equations
formulas
all of the above
One of the most commonly used functions is the _____ function, which will add a range of adjacent cells.
SUM
AVERAGE
MAX
MIN
One of the most commonly used functions is the _____ function, which will add a range of adjacent cells.
SUM
AVERAGE
MAX
MIN
When many employees are involved in the payroll register, ____________ software makes calculating payroll easy because formulas can be copied and pasted to adjoining rows.
document
presentation
spreadsheet
database
_________________ is the process of changing the values in cells to see how those changes will affect the outcome of formulas on the worksheet.
Absolute Cell Reference
What If Analysis
Statistics
All of the Above
To calculate the ____________, Excel adds the numbers together and divides by the total number of numbers.
maximum
minimum
average
sum
A ___________ _____ ___________ is a cell reference in a spreadsheet application that remains constant. (Hint: the value does not change).
relative cell reference
absolute cell reference
red blood cell
white blood cell
The ________ function is a reliable way to count the number of items in a range of cells that contain data.
MAX
MIN
AVERAGE
COUNT
Based on an entered criterion and result, the ________ _____ function will determine what is entered in a cell.
Count If
Count A
Count Blank
Count Dracula
The __________ function will do the job of calculating the monthly payment based on a loan amount, interest rate, and 30 years of monthly payments.
SUM
AVERAGE
PMT
All of the Above
The _______ function in your spreadsheet software can help you see just how much monthly investment will yield after a period of time.
PV (Present Value)
FV (Future Value)
PMT (Payment)
All of the Above
The _______ function doesn't just increase or decrease the decimal place but actually changes the value of the number.
SUM
AVERAGE
MAX
ROUND
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.
tabs
sheets
paper
all of the above
Which of the following is not a type of Pie Chart?
Bar of Pie
Pie of Pie
Doughnut
Apple Pie
3-D Pie
__________ ___________ are used for comparing a single category of information, such as profit analysis, sales projections, and expenditures.
Column Charts
Bar Graphs
Bar Chart
Pie Chart
