2498748
Pregunta 1
Pregunta
Which of the following is capable of producing a spreadsheet Tick all that apply?
Respuesta
-
Google Docs
-
Microsoft Office Excel
-
Microsoft Office Word
Pregunta 2
Pregunta
What word is used to describe re-organising the order of data?
Respuesta
-
Search
-
Filter
-
Sort
Pregunta 3
Pregunta
In a cell reference, for example A1, what does the letter refer to?
Respuesta
-
The row the cell is in
-
The column the cell is in
-
The worksheet the cell is in
Pregunta 4
Pregunta
Formulae must always start with which symbol?
Respuesta
-
Equals
-
Add
-
Brackets
Pregunta 5
Pregunta
Which of the following tasks would a spreadsheet be best used for (tick all that apply)?
Respuesta
-
Present promotional information about a new television channel
-
Creating a budget for a party
-
Keep track of money raised at a charity event
-
To write a letter of complaint
Pregunta 6
Pregunta
Which tool is best used to duplicate information from cell to cell?
Respuesta
-
Autosum
-
Fill Handle
-
Filter
Pregunta 7
Pregunta
Why might charts and graphs be a way of making the data in a spreadsheet easier to understand?
Respuesta
-
Because Mr Obhan can use bar charts
-
Because they don't require you to enter any formula.
-
Because you do not need to enter any data
-
Because the data is presented in a more visual way.
Pregunta 8
Pregunta
Wrap text is an option which can be applied to cells in order to do what? (Tick all that apply)
Respuesta
-
Resize a cell to fit the text inside
-
Put a background on a cell containing text
-
Put a border around a cell containing text
-
Put text that is longer than the width of the cell on more than one line within the same cell
Pregunta 9
Pregunta
The software can help guide us through the process of creating a chart. This is called a...?
Respuesta
-
Teacher
-
Wizard
-
Help
-
Magician
Pregunta 10
Pregunta
What term describes changing the horizontal or vertical position of text?
Respuesta
-
Font
-
Alignment
-
Format
Pregunta 11
Pregunta
Getting cells to change colour automatically based on the contents of the cell is called...?
Respuesta
-
Content formating
-
Conditional formatting
-
Cell formatting
Pregunta 12
Pregunta
Which function would we use to calculate the total of a column or a row?
Respuesta
-
SUM
-
ADD
-
PLUS
Pregunta 13
Pregunta
When we select a group of cells together to use in a formula this is called a..?
Respuesta
-
Block
-
Sheet
-
Range
Pregunta 14
Pregunta
What function do we use to join a group of cells together to make a larger cell ?
Respuesta
-
Merge
-
Verge
-
Combine
Pregunta 15
Pregunta
Spreadsheets can (tick all that apply)...?
Respuesta
-
Complete mathmatical calculations
-
Present data in a visual way
-
Produce large written documents
-
Search large amounts of data
¿Quieres crear tus propios Tests gratis con GoConqr? Más información.