WorksheetsSpreadsheet for a Purpose
Total questions: 11
Worksheet time: 10mins
What is a spreadsheet used for?
Drawing pictures
Organizing data and performing calculations
Writing letters
Browsing the internet
Which symbol is used to start a formula in most spreadsheet software?
#
!
=
\
In a spreadsheet, what does a formula do?
Adds color to the cells
Adds graphics to the sheet
Performs calculations based on cell values
Arranges text
What function would you use to add up values in a range of cells?
SUM
AVG
MAX
MIN
Which of the following best describes the term "cell reference"?
The name of a spreadsheet file
A function in the spreadsheet
The address of a cell, like B3 or C5
A tool used to format cells
Which tool in a spreadsheet allows you to create visual representations of your data?
Formula tool
Chart tool
Sort tool
Print tool
Imagine you are asked to create a budget for a school event using a spreadsheet. List at least three types of information you would include in your spreadsheet and explain how you would use formulas or functions to calculate total costs.
If cell A1 contains the value 5 and cell B1 contains the value 3, the formula =A1 * B1 + 2 will result in (a) .
Differentiate between rows and columns in a spreadsheet.
Why would you use conditional formatting in a spreadsheet?
What is the purpose of the “AutoSum" feature in a spreadsheet?
