Font size
WorksheetsGoogle Educator Level 1_Sheets Quiz
Total questions: 19
Worksheet time: 15mins
If I wanted to collect data and create a graph for my science fair data, I should use
Google Docs
Google Sheets
Google Slides
Google Forms
Which of the following can you do in a spreadsheet?
Sort in alphabetical order
Sort in number order
Sort in reverse alphabetical order
Sort in reverse number order
All of these can be done using spreadsheets
The structure of a Google spreadsheet consists of vertical _______________ and horizontal _________________.
Columns; rows
Charts; images
Forms; equations
Formulas; links
Using Google Drive, the sharing settings are the same in Docs, Sheets and Slides
TRUE
FALSE
Where would you go if you wanted to add a theme, border, font or change a number type in a sheet?
Insert
Format
Data
None of the above.
Using this picture, what would the formula be to find the average in B16 for the given set of data?
+AVERAGE(B2:B13)
=AVERAGE(B2:B13)
=AVERAGE(A2:A13)
+AVERAGE(A2:A13)
How can one sort items in a sheet?
Right click on the column, choose the way in which you want to sort
Choose the drop down arrow on a column, choose the way you want to sort
Highlight the area to sort, go to Data at the top of the page and choose the way you want to sort
One method for creating a chart is to:
Highlight appropriate data ranges,click the chart button, and choose the specific options
Highlight appropriate data ranges and click, export chart
Highlight appropriate data ranges, go to File, save as a chart
Go to Insert, chart and choose specific options
True or False: You can add a trendline to data without having the chart created first.
True
False
How do you copy a chart to other applications?
Click on the chart, control C or Edit>Copy, pull up other application, control V or Edit>paste
click on the sheet, control C or Edit>Copy, pull up other application, control V or Edit>paste
Both A and B
None of the above.
True or False: You can publish a sheet to the web.
True
False
True or False: You share Google Sheets the same way you share Docs.
True
False
