Quiz
Ohne Titel
Erstelle ein kostenloses Konto, um dieses Quiz zu beenden
Speichere deinen Fortschritt und sieh dir dein Endergebnis an.
oder mit deiner E-Mail registrieren
Schon ein Konto? Anmelden
Fragen in diesem Quiz (6)
1A label is...
- Aany text in a cell describing the data in a row or column (titles, headings that identify data)
- Bany values (text or numbers) that are entered for the use of calculation
2Cell referencing is when...
- AWhen a formula is copied by 'filling down' the cell references in cells are adjusted as you drag the pointer down the page
- BWhen a cell is used in a formula and the formula is copied to a new reference (address), the cell references (cell address) changes to take account of the formula's new position
3Absolute cell referencing is when...
- AWhen the content of a cell is changed, calculations are performed and other cells are updated if necessary
- BWhere a reference to a cell used in a formula where, when the formula is copied to a new cell reference (cell address), the cell reference (cell address) does not change. It is glued in place by the $ character
4Examples of functions are...
- ASUM, COUNT, AVERAGE, MIN, MAX, IF
- B+ ADD, - SUBTRACT, * MULTIPLY, / DIVIDE
5A workbook is...
- AA single tab in the spreadsheet
- BA spreadsheet application such as Excel can store all its data in a single file (with an .xls extension)
6Data types include...
- AFont style, size, colour, border style, alignment, cell colour
- BCurrency, number, real, integer (whole number), data, text
Informationen
- Beschreibung
- Quiz am Ohne Titel, erstellt von aujlg001 am 08/03/2015.
- Autor
- aujlg001
- Sprache
- English
- Aufrufe
- 0
- Bewertung
- Noch keine Bewertungen Bewerte dieses Quiz