Save
Year 8
Computer Science
Spreadsheets
Save
Share
Learn
Content
Leaderboard
Learn
Created by
Niyah N-N
Visit profile
Cards (17)
Cell
The individual
boxes
that make up the spreadsheet. Each cell contains a
value
,
formula
, or
function.
SUM
Adds up a range of
cells.
AVERAGE
Calculates
the average of a range of
cells.
IF
Tests a
condition
and performs an
action
if true.
COPY
Copies
cells
or
ranges
to other locations.
PASTE
Pastes
cells
or
ranges
from the clipboard.
UNDO
Reverts
changes made to the spreadsheet.
COUNT
Counts the number of cells that contain
numbers.
REDO
Reverses the
undo
command.
BOLD
Increases
font weight for emphasis.
ITALIC
Changes font style to italics.
ALIGN
Justifies text
horizontally
or
vertically.
FONT
Changes the font
style
,
size
, and
color.
CHARTS
Creates visual representations of data.
Conditional Formatting
Harnesses cells based on conditions.
Buttons
Creates interactive buttons.
external file
Links to external files, such as databases or websites.