Writing Lab Coursera Quiz Google Sheets

All formulas in Google Sheets begin with the following symbol: + % = *

=

You can use the IMPORTRANGE function to bring in: A range of cells from a specific sheet. A range of fonts from a stylesheet. A range of formulas from a heat map.

A range of cells from a specific sheet.

The IF function helps to create: A rule that calls out relevant data based on your parameters. An exception that hides certain data. A series of calculation scenarios within one cell.

A rule that calls out relevant data based on your parameters.

Both filters and filter views help you analyze a set of data in a spreadsheet. The difference between filters and filter views: A. Filters can be useful if you want everyone viewing your spreadsheet to see a specific filter when they open it. Filter views only affect 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 public, depending if users have been granted edit, copy or view only.

A. Filters can be useful if you want everyone viewing your spreadsheet to see a specific filter when they open it. Filter views only affect you as the viewer.

You can freeze a row or column in order to: Always keep it stationary and in sight while viewing that sheet. Stop it from being included in your calculations. Include data from that section in a pivot table.

Always keep it stationary and in sight while viewing that sheet.

MACROS help you to: Calculate big trends in your sheet. Calculate small trends in your sheet. Automate tasks in your sheet.

Automate tasks in your sheet.

If you want to restict people from entering invalid data, you could: A. Use the chat function to send an error message. B. Apply data validation to your spreadsheet. C. Check the Activity Dashboard to see who has added invalid data. D. Add a filter view

B. Apply data validation to your spreadsheet.

If you'd like to share a spreadsheet with a collaborator, but don't want them to be able to edit a certin section, you can: A. Record a macro to prevent incorrect data input. B. Protect the sheet as well as specific data ranges. C. Change collaborator access from "comment" to "edit."

B. Protect the sheet as well as specific data ranges.

Which is the only way not to publish your spreadsheet? If you'd like to publish your spreadsheet, you can (select the incorrect answer): A. Make the spreadsheet a standalone link on the web. B. Publish only standalone sheets within the spreadsheet. C. Embed the spreadsheet on the web. D. Publish the entire document or standalone sheets within the spreadsheet.

B. Publish only standalone sheets within the spreadsheet.

With _______, you can run data analysis on billions of rows of data. VLOOKUP Slicers BigQuery The explore tool

BigQuery

The person who owns a spreadsheet your group is using is leaving the team. You want to make sure someone gets notifications when new comments are added to it. What's the best way to do this? A. Give everyone on the team "Edit" access. B. Give everyone on the team " Comment" access. C. Have the person who is leaving transfer ownership of the spreadsheet to someone else.

C. Have the person who is leaving transfer ownership of the spreadsheet to someone else.

The sparkline function allows you to: Sync random data from the Internet with your sheet. Create a mini-bar chart or line graph right within a cell. Remove data in your sheet that is listed twice.

Create a mini-bar chart or line graph right within a cell.

You can calculate a quick sum in your sheet by: Creating a pivot table. Making a bar chart. Highlighting a row or column.

Highlighting a row or column.

A pivot table: Calculates inverse values for all of your data points. Suggests ways to present ranges of data in relation to each other. Takes the average of all data points.

Suggests ways to present ranges of data in relation to each other.

How would you ensure that all numbers in a column are formatted to show as currency? Use the "dates" function. Use the "numbers" function. Use the "paste special" function.

Use the "numbers" function.

If you want text in a cell to show even if the text is longer than the visible space in the cell, which text formatting option would you choose? Overflow. Wrap. Clip.

Wrap.

A tool that allows you to apply formats to a cell or range of cells, and have that formatting change depending on the value of the cell or the value of a formula: Dependent formatting Macro formatting Conditional formatting Value formatting

conditional formatting

To add more data to a sheet, you can: Publish your spreadsheet to the web. Add a filter view. Copy information from another sheet.

copy information from another sheet.

Scales that highlight quantities by using various shades of colors are called: Shader scales. Heat maps. Fusion scales.

heat maps

What is a horizontal section of a spreadsheet? Column Cell Row Formula

row