8. Spreadsheets for Beginners using Google Sheets

Spreadsheets for Beginners using Google Sheets

by Coursera Project Network

Final Assignment Answers :

1.Question 1

What is the order of operations in Google Sheets?

1 / 1 point

Parenthesis, Exponential, Multiplication/Division, Addition/Subtraction (PEMDAS)

Addition/Subtraction, Parenthesis, Exponential, Multiplication/Division, (ASPEMD)

Multiplication/Division, Exponential, Parenthesis, Addition/Subtraction (MDEPAS)

Parenthesis, Addition/Subtraction , Multiplications/Divisions, Exponential (PASMDE)

2.Question 2

Cell A1 has the following formula:

What will be the formula in cell A2 when copying the content from A1 to A2?

1 / 1 point

3.Question 3

What Function should you use to join multiple strings?

1 / 1 point

= AND ( )

= SPLIT ( )

= COUNTA ( )

= CONCATENATE ( )

4.Question 4

Which of the following are error messages in Google Sheets? Select all that apply.

1 / 1 point

#NUM!

#CELL!

#NAME?

#VALUE!

5.Question 5

You are looking to identify Beverly Landry's marital status using the vlookup function below. With what index value should you replace the [?] with?

1 / 1 point

26

3

$F$26

2

6.Question 6

Which of the below icons should you use to create a filter and sort data in a table?

1 / 1 point

7.Question 7

What tool would you use to create a list of items, like the one we created for our expense model?

1 / 1 point

The function: =LIST( )

Data Validation

Filter Views

Conditional Formatting

8.Question 8

What is the name of this chart type?

1 / 1 point

Line chart

Stacked column chart

Bar chart

Column chart