Google Sheets

Quiz

Question 1

When you store files "in the cloud," you are ________.

A. storing them in an e-file

B. storing them online

C. storing them in the cloud folder on your hard drive

D. storing them in a temporary location to be deleted later

Question 2

Google Docs are similar to the files you can create with ________.

A. Microsoft Outlook

B. Microsoft Office

C. Microsoft Silverlight

D. Adobe Creative Suite

Question 3

True or False: You will need a Google account to use Google Drive.

A. True

B. False

Question 4

Dragging files to your Google Drive folder will ________ the files to your Google Drive.

A. copy and upload

B. move, upload, and sync

C. copy but not sync

D. download

Question 5

Whenever you create a new Google Document, it will open in ________.

A. the view pane

B. Microsoft Word

C. a new browser tab

D. the left-navigation pane

Question 6

________ allow you to group and label your docs.

A. Groups

B. Folders

C. Collections

D. Stickers

Question 7

If you want to display specific files while hiding others, you can ________.

A. switch to Grid view

B. choose a color for a folder

C. sync your files

D. apply a filter

Question 8

True or False: When you share a Google Doc with someone else, that person can always edit the file.

A. True

B. False

Question 9

The easiest way to share a file on your Google Drive with a large group of people is with ________.

A. a USB drive

B. a download

C. an email attachment

D. a stable link

Question 10

To preview your Google Spreadsheet before printing it, you will need to ________.

A. download a PDF of the spreadsheet

B. click the Print button

C. change the spreadsheet settings

D. publish it to the Web

Question 11

The name of a cell (for example, A1) is its cell ________.

A. heading

B. address

C. content

D. range

Question 12

To copy text in Google Spreadsheets, ________.

A. use the Make a copy ... option

B. use the Functions button

C. use the keyboard shortcut Ctrl+C or Command+C

D. use the Copy shortcut button

Question 13

To combine two or more cells, use the ________ button.

A. More formats

B. Borders

C. Merge cells

D. Wrap text

Question 14

Freezing rows allows you to ________.

A. scroll through the spreadsheet while continuing to see the frozen rows

B. limit the data that can be entered in the frozen row

C. control the rows from being modified by collaborators

D. modify only the frozen rows

Question 15

If you want the values in your cells to have dollar signs in front of them, ________.

A. use the All formulas option

B. use the Spreadsheet settings option

C. use the Functions button

D. use the Number Formatting button

Question 16

When you need to rename a sheet, the first step is to ________.

A. click the All Sheets button

B. click the sheet's tab

C. click the Rename ... option

D. click the Find and Replace ... option

Question 17

Which of the following is NOT recognized as a mathematical operator by Google Spreadsheets?

A. x (multiplication)

B. ^ (exponents)

C. + (addition)

D. / (division)

Question 18

When a formula contains the address of a cell, it is called a(n) ________.

A. cell reference

B. operator

C. function

D. simple formula

Question 19

When a formula contains more than one operator, Google Spreadsheets will ________ to determine the answer.

A. find the largest result possible by rearranging the operations

B. always calculate the operations from left to right

C. follow the order of operations

D. calculate addition or subtraction, then multiplication or division

Question 20

When following the order of operations, which calculation comes first in this formula: 3^2/5+(12-3)?

A. 3^2

B. 12-3

C. 5+12

D. 2/5

Question 21

A(n) ________ cell reference does NOT change when copied to another cell.

A. relative

B. absolute

C. fixed

D. constant

Question 22

A(n) ________ cell reference changes when copied to another cell.

A. reliable

B. concrete

C. relative

D. absolute

Question 23

When writing a function that contains a range of cells in the argument, a ________ is used to create the range.

A. dash

B. semicolon

C. colon

D. comma

Question 24

Which function would you use to add the values of several cells?

A. TOTAL

B. AVERAGE

C. SUM

D. MAX

Question 25

You can ________ to narrow down the data in your worksheet.

A. use the Web clipboard

B. use sorting

C. merge cells

D. apply filters

Answers:

1) B. storing them online
2) B. Microsoft Office
3) A. True
4) B. move, upload, and sync
5) C. a new browser tab
6) B. Folders
7) D. apply a filter
8) B. False
9) D. a stable link
10) B. click the Print button
11) B. address
12) C. use the keyboard shortcut Ctrl+C or Command+C
13) C. Merge cells
14) A. scroll through the spreadsheet while continuing to see the frozen rows
15) D. use the Number Formatting button
16) B. click the sheet's tab
17) A. x (multiplication)
18) A. cell reference
19) C. follow the order of operations
20) B. 12-3
21) B. absolute
22) C. relative
23) C. colon
24) C. SUM
25) D. apply filters