DA02: Sheet 1

Q. 

What number should be in E1 (based on the formula)?

• 5

• 9

• 10

• 20

All formulas in Google sheets begin with the following symbol:

• $

• =

• %

• &

What is the name of the selected cells?

• C6

• A1:E15

• E1

• B4:D8

Columns and rows are labeled by ______________.

• Columns: numbers

  Rows: letters

• Columns: letters

  Rows: numbers

• Columns: symbols

  Rows: numbers

• Columns: numbers

  Rows: symbols

What is the little triangle in the top right corner of a cell? It means there is a ________ with that cell.

• black: note

  gold: comment

• black: comment

  gold: note

• black: comment

  gold: error

• black: error

  gold: comment

A ____________ is where a row and a column meet.

• table

• formula

• sheet

• cell

What is shown for the selected column in the red mark?

• B2:B16

• 2:2

• B:B

• B1

1. to add a set of numbers.

2. to find the smallest value in a group.

• 1. SUM

  2. MIN

• 1. ADD

  2. FIND

• 1. ADD

  2. SMALL

• 1. SUM

  2. SMALL

Text wrapping in Sheets means the text will be on more than 1 line within the cell.

• True

• False

What is a Sheet feature to limit choices in a cell or range to do data quality control?

• Data validation

• Filter

• Sort

• Protected sheet and range