WorksheetsQuarter 1 Review
Total questions: 25
Worksheet time: 13mins
How do you change a form theme?
Click on the paint palette
Click on the settings icon
Click on the eye icon
Click on the three dots
What is the advantage of a dropdown list compared to a multiple choice question?
The checkboxes allow more than one selection
The multiple choice question allows more than one selection
The dropdown list allows more than one selection
the dropdown list saves space on the form
Which answer type is the best for creating a chart or graph?
ten seconds
10 s
10
10 sec
What sort of question type would you use when asking for a person's name?
Paragraph
Linear Scale
Multiple Choice
Short Answer
Is it possible to add an image into a form?
Yes
No
Only if you have a camera
When would you use a checkbox type question?
When you have a yes/no question
When you want to rate something
When you want more than one response
When you want one response only
How do you make a question "required"
Put it first in the list of questions
Write "REQUIRED" in the name of the question
Click the button that says "Required"
Make the title of the question BOLD
What does the icon underneath the red arrow do?
It deletes the question
It changes the type of question
It deletes the form
It is a chef's hat and leads to a secret kitchen
The red arrow points to an icon. What does that icon do?
It adds a sandwich to the form
It creates a new question
It adds a new section
It copies the form for others to use
The red arrow points to another icon. What does this icon do?
It copies the question
It duplicates the question
It erases the question
It deleted the question
Google Sheets is what sort of program?
A document program
A spreadsheet program
A presentation program
A television program
What does a formula do in Google Sheets?
It automates a process
It creates a chemical
It answers a question
It finds mistakes
What does the =COUNTIF formula do?
Counts things
Counts how often something occurs
Counts how many different things are there
Counts how many things are in a list
=SPLIT(A2,"/")
In the above formula, what does the "/" tell the formula to do?
Put a "/" on the end of the A2 cell
Split the A and the 2
Divide A2 in half
Split the data in the cell each time there is a "/".
How do you add a new column?
Click on the "Edit" menu and choose "Insert Column"
Click on the "Insert" menu and choose "Column Left" or "Column Right".
Right-click on the top label of the column and choose "Insert a new column"
Click on the "Edit" menu and choose "Give me a new column please!"
Which formula below would you use to break a person's full name into a first name and a second name?
The "BREAK" formula
The "SPLIT" formula
The "SEPARATE" formula
The "CUT" formula
If you want to create a Pie Chart in a spreadsheet, what would be the best type pf question to ask in a form?
A paragraph question
A short answer question where the answer must be written as a number
A multiple choice question with numerical answers
A checkbox answer with numbers written in words
What does this tool do?
It filters the data
It helps create a formula
It highlights text
It aligns the contents of the cell into the center.
What does this tool do?
It adds data to the next cell
It helps create a row
It allows text to wrap within the cell
It aligns the contents of the cell into the right.
What is the highlighted section called?
A cell
A row
A column
A range
What is the highlighted section called?
A row
A cell
A range
A column
What is the selected area called?
A row
A cell
A range
A column
What does this tool allow you to do?
Change the colour of the text
Change the colour of the borders of the cell
Change the colour of the cell
Change the colour of the chart
What is the name of the shaded area?
A row
A column
A cell
A range
What does the small green icon in the top right corner allow you to do?
Open the spreadsheet containing the form data
Create a new spreadsheet
Open Google Sheets
Change the colour of the form to green
