Module 5

Ace your homework & exams now with Quizwiz!

What symbols is used in an absolute formula?

$

When following the order of operations, which calculation will the spreadsheet calculate first in this formula: 4+(15*2)-10/2?

(15*2)

Google Sheets is most similar to what Microsoft program?

Excel

A relative cell reference does NOT change when copied to another cell.

False

Google Sheets, like most G Suite apps, do not use an auto-save feature and must be saved manually.

False

You cannot limit people to submitting only one response in a Google Form.

False

You have to download special software to run Google Forms on your computer.

False

If you want an easier way to sort through you form responses, Google Forms allows you to see your form responses in:

Google Sheets

If you want each person to only take your survey once, which setting should you check?

Limit to 1 response

To begin seeing who has completed your form, what tab on Google Forms should be selected?

Responses

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

Sum

A form can be used to create a quiz.

True

Cells are named based on where they intersect a row and column.

True

Functions and formulas can be inserted into the Google Sheet that your form responses are on.

True

In a Google Sheet, the equal sign for an equation comes before the formula.

True

The main purpose of Google Forms is to collect information.

True

When creating a formula using multiplication, you must use an asterisk (*) for the multiplication symbol, NOT an x.

True

If you want to add a formula that uses exponents, what symbol would you use to indicate an exponent?

^

To change your Google Form's color, you should click:

color palette icon

Formatting commands that can be added to a Google sheet include: Select all that apply.

date percentage signs dollar signs time

In Google Sheets, what is the default reference?

relative

What are the two difference cell references? Select all that apply.

relative absolute

Which of the following types of questions can be used when creating a question in a Google form? Select all that apply.

short answer checkboxes multiple choice long answer dropdown

To combine cells together, you would use:

the merge option


Related study sets

Audio Processing Techniques MIDTERM

View Set

Macroeconomics (ECON 2120) Chapter 9 Employment and Unemployment

View Set

patho chapter 41 disorders of endocrine system

View Set

Investigating Identify and Access Management chapter 3

View Set

FINANCE QUIZ 4 (10-12), Finance Quiz 5

View Set

Quiz: Life Insurance /settlement Options

View Set

physics u4 multiple choice review

View Set