The column drop down menu is...

The arrow which appears in a column header

What do text functions do?

format and display cell contents

What do mathematical and trigonometric functions do?

Manipulate number based data in a worksheet

What is a relative cell reference?

A cell reference which changes when it is moved/copied.

What is an absolute cell reference?

A cell reference which does not change when it is copied.

What is a fill handle?

small, blue square in the corner of a cell used for filling

What is a cell reference?

The use of a cell coordinate in a formula instead a number

A cell to the left of a row with a number in it

What do logical functions do?

display text or values if certain conditions are met

A group of cells in any direction

A column header is...

A cell at the top of a column with a letter in it

What do date and time functions do?

convert serial numbers to a month, date, day, or year

What is number formatting?

The way numbers will appear in a cell

A mathematical operation entered into a cell.

What is a range reference?

The use of a range of cells in a formula instead a number

A shorthand way of writing a formula

What is a mixed cell reference

A formula containing absolute and relative cell references

studbud

Google Sheets 6

39 termsStudBud Administration30 plays

Reviewing the terms of spreadsheets

Flashcards39 cardsFPractice quizPHost liveL

Questions 39

Answers

1
What is a grouping of cells from top to bottom?
Column
Header
Cell
Row
2
The column drop down menu is...
The arrow which appears in a row header
The menu which reads "Column"
The arrow which appears in a cell
The arrow which appears in a column header
3
What do text functions do?
format and display cell contents
convert serial numbers to a month, date, day, or year
display text or values if certain conditions are met
Describe quantities of data
4
What do financial functions do?
Describe quantities of data
display text or values if certain conditions are met
Manipulate number based data in a worksheet
Analyze loans and investments
5
What do mathematical and trigonometric functions do?
Analyze loans and investments
Manipulate number based data in a worksheet
display text or values if certain conditions are met
Describe quantities of data
6
What is a relative cell reference?
A cell reference which doesn't change when it is copied.
A cell reference which has cousins
A cell reference which changes when it is moved/copied.
A cell reference which has dollar signs in it
7
What is an absolute cell reference?
A formula which will only add up to 0.
A group of cells in a formula
A cell reference which does not change when it is copied.
A cell reference which changes when it is moved/copied
8
What is a fill handle?
small, black square used for selecting
small, blue square in the corner of a cell used for filling
small, blue square in the corner of a cell used for math
small, blue square used for selecting
9
What is the rectangle in the upper left corner of a worksheet where cell contents are edited?
Status bar
Formula bar
Omni bar
Address bar
10
What is a cell which describes the data to its right/left?
Row heading
Column header
Row header
Column heading
11
What is a cell reference?
The use of a cell coordinate in a formula instead a number
The use of a row in a formula instead of a number
The use of a range of cells in a formula instead of a number
The use of a column in a formula instead of a number
12
Which formula uses a range reference?
=A3+A9*D2
=sum(A3:A9)*D2
=A3(A9*D2)
=(A3+A9)*D2
13
A row header is...
A cell to the left of a row with a number in it
A cell at the right of a row with a number in it
A cell at the top of a row with a number in it
A cell at the bottom of a row with a letter in it
14
What do logical functions do?
Describe quantities of data
Manipulate number based data in a worksheet
display text or values if certain conditions are met
Analyze loans and investments
15
Which is an example of a cell reference in a formula?
=D4-1.5
=9*1.5
=44-1.5
=(6-3)/(2-1)
16
What is a range?
A group of cells in a row only
A group of cells in a column only
A cell
A group of cells in any direction
17
What are the operators in this formula =B4*C4+1
B4, C4, and 1
* and +
=, *, and +
1
18
A column header is...
A cell at the bottom of a column with a letter in it
A cell at the top of a column with a letter in it
A cell at the top of a column with a number in it
A cell to the left of a column with a number in it
19
What are the individual rectangles which fill a worksheet?
Cells
Rows
Columns
Fields
20
Which formula contains a relative cell reference?
=$A$2+$A$3
=2+100
=A2+100
=$A$2+100
21
What do date and time functions do?
Describe quantities of data
convert serial numbers to a month, date, day, or year
display text or values if certain conditions are met
format and display cell contents
22
What are the symbols which indicate the type of operation to perform in a formula?
Operdandos
Operands
Operators
Digits
23
Which button makes it easy to enter certain mathematical operations into a cell?
Sum button
Calculator button
Addition button
Math button
24
What do statistical functions do?
Display text or values if certain conditions are met
Analyze loans and investments
Describe quantities of data
Manipulate number based data in a worksheet
25
What is number formatting?
Copying numbers
Changing the appearance of phone numbers
The way numbers will appear in a cell
Adding numbers
26
What are the operands in this formula =A1+45
A1 and 45
45
= and +
+
27
44+9 is an example of a functional formula
True
False
28
What is a formula?
A medicine used when one is sick
A potion created by a wizard
A plus or minus sign added to various numbers
A mathematical operation entered into a cell.
29
Which formula has mixed cell references?
=(45+90)/60
=($A$1+$B$1)/$C$1
=(A1+B1)/$C$1
=(A1+B1)/C1
30
What is the process of quickly moving the contents of cells into adjacent cells?
Filling
Cutting and pasting
Emptying
Dragging
31
Which formula contains an absolute cell reference?
=D4+S9
=$D$4+S9
=D4+S$9
=D4+$S9
32
Which is an example of a functional formula?
=9x8
8*9
9-8
=8+9
33
What is a grouping of cells from left to right?
Row
Column
Cell
Header
34
What is a range reference?
The use of a cell in a formula instead of a number
The use of a range of cells in a formula instead a number
The use of a column in a formula instead of a number
The use of a row in a formula instead of a number
35
What is a function?
A method of producing ranges
A shorthand way of determining operators
A method of omitting operands
A shorthand way of writing a formula
36
What is a mixed cell reference
A formula in which the letters and numbers are mixed up
A formula containing absolute and relative cell references
A formula with numbers and cell references
A formula which doesn't work
37
What is a constant such as a number, cell reference, or range reference in a formula?
Operand
Operator
Quotient
Operandor
38
A3:D8 is an example of a...
Row
Cell
Column
Range
39
What is a cell which describes the data under it?
Column heading
Column header
Row heading
Row header

Google Sheets 6 Flashcards | StudBud