1) a _______ is a grid of rows and columns containing numbers, text, and formulas a) database b) worksheet c) template 2) a _______ appears vertically an is identified by a letter at the top of the worksheet window a) row b) range c) column 3) To let sheets determine the best width of a column you should a) choose column width from file b) place your cursor on the line between the two letters and double click c) click on the line and drag to the proper width 4) ________ will keep row or column tiles on the screen no matter where you scroll on the worksheet a) freeze tiles b) no scroll c) column stop 5) which of the following may be contained in worksheet cells a) text b) formulas c) numbers d) all of the choices 6) the intersection of a row and a column is called a a) cell reference b) cell c) range 7) the formula =B4*B3 will multiply the value in B4 by the value in B3 a) true b) false 8) a selected group of cells is a range a) true b) false 9) in a formula, the contents within parenthesis are evaluated first a) always b) sometimes 10) a cell that is highlighted or outlined by a bold black rectangle is called an active cell a) true b) false 11) a tool bar that gives you fast and easy access to the tools you use most often in sheets is called the  a) quick access toolbar b) ribbon c) menu 12) cells that run from side to side (horizontally) in a worksheet and are identified by numbers are called a) columns b) cells c) rows 13) =B19-12 a) will subtract the number in cell B19 by 12 b) will add the number in cell B19 by the number in cell B12 14) when a column is not wide enough to display the data, _______ will post in the cell a) ###### b) more space needed c) empty 15) the color, size, and font can all be changed on text in sheets a) true b) false

Google Sheets Post Test Review

by
Print
Embed

Leaderboard

Visual style

Options

Switch template

Continue editing: ?