Formulas in Google Sheets

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

• 1
• 2
• 5
• 9

What is the result of the line command below?

=A1*B1

• 2
• 3
• 4
• Error

Select ______________ from the functions drop-down menu to add a set of numbers. 

• average
• count
• max
• sum

You can have multiple sheets within the same Google Sheet document.

• True
• False

It is possible to insert images in Google Sheets

• True
• False

If "initial cost" is defined as the "cost per item" times the "minimum order," using cell references, select the correct formula for calculating the initial cost of goldfish.

• =B9*C9

• B9*C9

• B9/C9

• =B9/C9

In a Google Spreadsheet, you can manually type the function/formula in a cell if the operation is not available in the function drop-down list.

• True
• False

When using the Count() function, it is important to remember this (more than one answer is correct).

• Select all of the cells you want the program to count.

• The cells you are using MUST contain data that IS NOT NUMERIC.

• If there are values that are NOT NUMERIC, thet will not be included in the count.

• The cells you are using MUST contain data that IS NUMERIC.

In Google Sheets, the Max formula is used:

• only by anyone who is named Max

• when you want to determine the LARGEST NUMBER in a range of cells

• when you want to determine the SMALLEST NUMBER in a range of cells

• when you want to determine which cells are full

In Google Sheets, the Min formula is used:

• only by anyone who is named Minnie

• when you want to determine the LARGEST NUMBER in a range of cells

• when you want to determine the SMALLEST NUMBER in a range of cells

• when you want to determine which cells are empty