Quiz
Sem título
Crie uma conta grátis para terminar este quiz
Salve seu progresso e veja sua nota final.
Já tem uma conta? Inicie sessão
Perguntas do 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
Informações
- Descrição
- Quiz sobre Sem título, criado por aujlg001 em 08-03-2015.
- Autor
- aujlg001
- Idioma
- English
- Visualizações
- 0
- Avaliação
- Ainda sem avaliações Avalie este quiz