Test
Sin título
Crea una cuenta gratis para terminar este test
Guarda tu progreso y consulta tu resultado final.
¿Ya tienes cuenta? Inicia sesión
Preguntas del test (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
Información
- Descripción
- Test sobre Sin título, creado por aujlg001 el 08/03/2015.
- Autor
- aujlg001
- Idioma
- English
- Visitas
- 0
- Valoración
- Aún sin valoraciones Valora este test