Spreadsheets

tschaffner
Flashcards by tschaffner, updated more than 1 year ago More Less
tschaffner
Created by tschaffner almost 6 years ago
30
2
2

Description

Learn about everybody's favorite piece of software - Excel Spreadsheet!
Tags

Resource summary

Question Answer
What does the sum function do? Returns the total of cells you put in the brackets.
What symbol does every function begin with? =
Name a use of conditional formatting... To check whether a cell is equal to, more than or less than another value or cell.
The button that automatically turns numbers into currency looks like... excel07currency.jpg (image/jpg)
The autosum button looks like... slide0015_image048.jpg (image/jpg)
The letter in the cell reference refers to the row or column? Column
The number in the cell reference refers to the row or column? Row
What does the autosum button do? Automatically selects the nearest column or row of data and adds it up.
What symbol is used for multiplication? *
What symbol is used for division? /
What symbol is used for absolute cell referencing? $
What is absolute cell referencing? If you copy formulas along a row or down a column, the cell references will not be adjusted.
How would we find the average of cells C4 and A6 in Excel? =AVERAGE(C4, A6)
What button is used to filter data? Sort and Filter
What button can insert functions? fX button.
Show full summary Hide full summary

Similar

Acids and Bases quiz
Derek Cumberbatch
French -> small but important words for GCSE
georgie_hill
GCSE Combined Science
Derek Cumberbatch
Enzymes and Respiration
I Turner
Using GoConqr to learn French
Sarah Egan
Using GoConqr to teach French
Sarah Egan
FREQUENCY TABLES: MODE, MEDIAN AND MEAN
Elliot O'Leary
GCSE Maths: Geometry & Measures
Andrea Leyden
Weimar Revision
Tom Mitchell
Geography Coastal Zones Flashcards
Zakiya Tabassum
GCSE AQA Biology 1 Quiz
Lilac Potato