Writing Lab Coursera Quiz Google Sheets UPDATED ACTUAL
Questions and CORRECT Answers
1. What is a horizontal section of a spreadsheet? row
Column
Cell
Row
Formula
2. How would you ensure that all numbers in a column Use the "numbers" func-
are formatted to show as currency? tion.
Use the "dates" function.
Use the "numbers" function.
Use the "paste special" function.
3. To add more data to a sheet, you can: copy information from an-
Publish your spreadsheet to the web. other sheet.
Add a filter view.
Copy information from another sheet.
4. Which is the only way not to publish your spreadsheet? B. Publish only standalone
If you'd like to publish your spreadsheet, you can (se- sheets within the spread-
lect the incorrect answer): sheet.
A. Make the spreadsheet a standalone link on the web.
B. Publish only standalone sheets within the spread-
sheet.
C. Embed the spreadsheet on the web.
D. Publish the entire document or standalone sheets
within the spreadsheet.
5. All formulas in Google Sheets begin with the following =
symbol:
+
%
1/5
, Writing Lab Coursera Quiz Google Sheets UPDATED ACTUAL
Questions and CORRECT Answers
=
*
6. You can calculate a quick sum in your sheet by: Highlighting a row or col-
Creating a pivot table. umn.
Making a bar chart.
Highlighting a row or column.
7. Both filters and filter views help you analyze a set of A. Filters can be useful if
data in a spreadsheet. The difference between filters you want everyone viewing
and filter views: your spreadsheet to see
A. Filters can be useful if you want everyone viewing a specific filter when they
your spreadsheet to see a specific filter when they open it. Filter views only af-
open it. Filter views only affect you as the viewer. fect you as the viewer.
B. Filters and filter views are private and cannot be
shared.
C. Filters and filter views can be both private and pub-
lic, depending if users have been granted edit, copy or
view only.
8. The IF function helps to create: A rule that calls out rele-
A rule that calls out relevant data based on your para- vant data based on your
meters. parameters.
An exception that hides certain data.
A series of calculation scenarios within one cell.
9. You can freeze a row or column in order to: Always keep it stationary
Always keep it stationary and in sight while viewing and in sight while viewing
that sheet. that sheet.
Stop it from being included in your calculations.
Include data from that section in a pivot table.
10. heat maps
2/5
Questions and CORRECT Answers
1. What is a horizontal section of a spreadsheet? row
Column
Cell
Row
Formula
2. How would you ensure that all numbers in a column Use the "numbers" func-
are formatted to show as currency? tion.
Use the "dates" function.
Use the "numbers" function.
Use the "paste special" function.
3. To add more data to a sheet, you can: copy information from an-
Publish your spreadsheet to the web. other sheet.
Add a filter view.
Copy information from another sheet.
4. Which is the only way not to publish your spreadsheet? B. Publish only standalone
If you'd like to publish your spreadsheet, you can (se- sheets within the spread-
lect the incorrect answer): sheet.
A. Make the spreadsheet a standalone link on the web.
B. Publish only standalone sheets within the spread-
sheet.
C. Embed the spreadsheet on the web.
D. Publish the entire document or standalone sheets
within the spreadsheet.
5. All formulas in Google Sheets begin with the following =
symbol:
+
%
1/5
, Writing Lab Coursera Quiz Google Sheets UPDATED ACTUAL
Questions and CORRECT Answers
=
*
6. You can calculate a quick sum in your sheet by: Highlighting a row or col-
Creating a pivot table. umn.
Making a bar chart.
Highlighting a row or column.
7. Both filters and filter views help you analyze a set of A. Filters can be useful if
data in a spreadsheet. The difference between filters you want everyone viewing
and filter views: your spreadsheet to see
A. Filters can be useful if you want everyone viewing a specific filter when they
your spreadsheet to see a specific filter when they open it. Filter views only af-
open it. Filter views only affect you as the viewer. fect you as the viewer.
B. Filters and filter views are private and cannot be
shared.
C. Filters and filter views can be both private and pub-
lic, depending if users have been granted edit, copy or
view only.
8. The IF function helps to create: A rule that calls out rele-
A rule that calls out relevant data based on your para- vant data based on your
meters. parameters.
An exception that hides certain data.
A series of calculation scenarios within one cell.
9. You can freeze a row or column in order to: Always keep it stationary
Always keep it stationary and in sight while viewing and in sight while viewing
that sheet. that sheet.
Stop it from being included in your calculations.
Include data from that section in a pivot table.
10. heat maps
2/5
