2498748
Frage 1
Frage
Which of the following is capable of producing a spreadsheet Tick all that apply?
Antworten
-
Google Docs
-
Microsoft Office Excel
-
Microsoft Office Word
Frage 2
Frage
What word is used to describe re-organising the order of data?
Antworten
-
Search
-
Filter
-
Sort
Frage 3
Frage
In a cell reference, for example A1, what does the letter refer to?
Antworten
-
The row the cell is in
-
The column the cell is in
-
The worksheet the cell is in
Frage 4
Frage
Formulae must always start with which symbol?
Antworten
-
Equals
-
Add
-
Brackets
Frage 5
Frage
Which of the following tasks would a spreadsheet be best used for (tick all that apply)?
Antworten
-
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
Frage 6
Frage
Which tool is best used to duplicate information from cell to cell?
Antworten
-
Autosum
-
Fill Handle
-
Filter
Frage 7
Frage
Why might charts and graphs be a way of making the data in a spreadsheet easier to understand?
Antworten
-
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.
Frage 8
Frage
Wrap text is an option which can be applied to cells in order to do what? (Tick all that apply)
Antworten
-
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
Frage 9
Frage
The software can help guide us through the process of creating a chart. This is called a...?
Antworten
-
Teacher
-
Wizard
-
Help
-
Magician
Frage 10
Frage
What term describes changing the horizontal or vertical position of text?
Antworten
-
Font
-
Alignment
-
Format
Frage 11
Frage
Getting cells to change colour automatically based on the contents of the cell is called...?
Antworten
-
Content formating
-
Conditional formatting
-
Cell formatting
Frage 12
Frage
Which function would we use to calculate the total of a column or a row?
Antworten
-
SUM
-
ADD
-
PLUS
Frage 13
Frage
When we select a group of cells together to use in a formula this is called a..?
Antworten
-
Block
-
Sheet
-
Range
Frage 14
Frage
What function do we use to join a group of cells together to make a larger cell ?
Antworten
-
Merge
-
Verge
-
Combine
Frage 15
Frage
Spreadsheets can (tick all that apply)...?
Antworten
-
Complete mathmatical calculations
-
Present data in a visual way
-
Produce large written documents
-
Search large amounts of data
Möchten Sie mit GoConqr kostenlos Ihre eigenen Quiz erstellen? eigenen Mehr erfahren.