Spreadsheets

Beschreibung

Learn about everybody's favorite piece of software - Excel Spreadsheet!
tschaffner
Karteikarten von tschaffner, aktualisiert more than 1 year ago
tschaffner
Erstellt von tschaffner vor mehr als 10 Jahre
39
2

Zusammenfassung der Ressource

Frage Antworten
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...
The autosum button looks like...
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.
Zusammenfassung anzeigen Zusammenfassung ausblenden

ähnlicher Inhalt

Hitler and the Nazi Party (1919-23)
Adam Collinge
GCSE Biology AQA
isabellabeaumont
GCSE Biology B2 (OCR)
Usman Rauf
9 History- The Treaty of Versailles
melgallagher
Ionic Bondic Flashcards.
anjumn10
Forces and their effects
kate.siena
Germany 1918-39
Cam Burke
French -> small but important words for GCSE
georgie_hill
Forces and Acceleration
Adam Collinge
Chemical Symbols
Keera
Biology Unit 1a - GCSE - AQA
RosettaStoneDecoded