Google Sheets Quiz

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

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

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

Apply data validation to your spreadsheet

You can add the following to your sheet (select all that apply): Images. Audio files. Checkboxes Hyperlinks.

Audio Files

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

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

BigQuery

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

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

Which is the only way not to publish your spreadsheet?: Make the spreadsheet a standalone link on the web. Publish only standalone sheets within the spreadsheet. Embed the spreadsheet on the web. Publish the entire document or standalone sheets within the spreadsheet.

Embed the spreadsheet on the web

Both filters and filter views help you analyze a set of data in a spreadsheet. The difference between filters and filter views: 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. Filters and filter views are private and cannot be shared. Filters and filter views can be both private and public, depending if users have been granted edit, copy or view only.

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.

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? Give everyone on the team "Edit" access. Give everyone on the team " Comment" access. Have the person who is leaving transfer ownership of the spreadsheet to someone else.

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

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

Heat maps

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

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

Protect the sheet as well as specific data ranges

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

Row

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

Select which of the following information you can find in the Activity Dashboard (select all that apply): a. Who looked at the sheet most recently. b. Who made the most recent edits to the sheet. c. Who has made the most changes to a sheet. d. Who made comments on the sheet.

a. b. d.

If you want to share a spreadsheet with anyone, you can (select all that apply): a. Send them a link to the spreadsheet. b. Add their name directly in a cell. c. Share from within the sheet. d. Add a comment with their email address.

a. c. d.

To import data into your sheet, you can (select all that apply): a. Upload a file from your desktop. b. Use the data function to import the desired information. c. Copy from another spreadsheet. d. Upload data from the Web.

a. c. d.

To start a new spreadsheet you can: (Select all that can apply) a. Type sheets.new in your browser. b. Use a template from the gallery at sheets.google.com. c. Download a public dataset. d. Create one at drive.google.com.

a., b., d.