Google Spreadsheets

Question 1

Autosize will narrow your results when sorting

Accepted Answer

False

Question 2

Before you begin the sort you would first want to freeze header rows so that it is not included in the sort.

Accepted Answer

True

Question 3

By default every row and every column is set to

Accepted Answer

the same height and width

Question 4

When a cell address is used in a cell formula it is referred to a _____?

Accepted Answer

cell reference

Question 5

Mathematical expressions to calculate information are called

Accepted Answer

formulas

Question 6

If you change a value in a cell and the cell reference is used in a formula, the formula will automatically recalculate

Accepted Answer

True

Question 7

An Absolute reference is created when a _________ is inserted before the column or row to remain the same.

Accepted Answer

dollar sign ($)

Question 8

To enter a complex formula you don't use the order of operations

Accepted Answer

False

Question 9

How many mathematical operators are used in a simple formula?

Accepted Answer

One

Question 10

Cell references are _____ by default.

Accepted Answer

relative

Question 11

What does the SUM function allow you to do?

Accepted Answer

add a column or row of numbers

Question 12

The small square located at the bottom right corner of a cell to copy information to other rows/columns is known as the

Accepted Answer

fill handle

Question 13

Sorting is done by

Accepted Answer

columns

Question 14

What is always the first function to be performed according to the order of operations?

Accepted Answer

perform operations within the parentheses

Question 15

A row is a group of cells that runs vertically

Accepted Answer

True

Questions 15