Computer Apps Spreadsheet Recap

Question 1

Google Sheets & Microsoft Excel are both________.

Answer 1

Spreadsheets

Question 2

The ____________ format allows you to copy attributes of selected text and apply them to another selection.

Answer 2

Paint

Question 3

When you are all done with a project and are ready to turn in your project, you upload it as a _________ file.

Answer 3

PDF

Question 4

_________ is the part of the spreadsheet that runs vertically and is labeled with letters.

Answer 4

Colums

Question 5

The _________ key moves your cursor to the right cell.

Answer 5

Tab

Question 6

When highlighting a column and adding another, to what direction would the column be added, by default? _____________

Answer 6

Right

Question 7

When highlighting a row and adding another, to what direction would the row be added, by default? _____________

Answer 7

Above/Top

Question 8

The ________ feature is used to organize information in either ascending or descending order?

Answer 8

Sort

Question 9

A _____ is the part of the spreadsheet that runs horizontally and is labeled with numbers.

Answer 9

Row

Question 10

The _________ key moves your cursor down one cell.

Answer 10

Enter

Question 11

_____________ are the boxes within a spreadsheet.

Answer 11

Cells

Question 12

What spreadsheet feature is used to combine multiple cells into a single cell? _________

Answer 12

Merge

Question 13

The ________ formula is used to add a group of data together?

Answer 13

Sum

Question 14

The _________ formula is used to find the average of a group of numbers?

Answer 14

Average

Question 15

The _________ formula is used to display a value based upon a True or False scenario?

Answer 15

If

Question 16

The __________ formula is used to display a value based upon more than two possible criteria by comparing a value to a cell range and returning a value from that range?

Answer 16

V- Lookup

Question 17

The ________ ___________ feature is used to display colors or icons to help analyze data that meets various criteria?

Answer 17

CONDITIONAL FORMATTING

Question 18

To make every other row a different color I would turn on ____________ ____ ________.

Answer 18

Alternating Row Color

Question 19

This symbol tells a spreadsheet you are using a formula.

Answer 19

=

Question 20

This symbol tells a spreadsheet you are going to multiply.

Answer 20

*

Question 21

This symbol tells a spreadsheet you are going to divide.

Answer 21

/

Question 22

This symbol tells a spreadsheet you are using an absolute cell reference.

Answer 22

$

Question 23

What type of cell reference changes when you fill a formula down (or across)?

Answer 23

Relative

Question 24

What type of cell reference remains the same when you fill a formula down (or across)?

Answer 24

Absolute

Question 25

What types of graphs are useful for comparing data?

Answer 25

Bar or a column graph

Question 26

What type of graph is best for showcasing growth/decline?

Answer 26

Line

Question 27

What type of graph is useful for showcasing parts of a whole?

Answer 27

Pie

Question 28

What spreadsheet feature allows you to “lock” a row or column so that it doesn’t scroll off the screen?

Answer 28

Freeze

Question 29

True or False: V look up formulas use a range of cells to analyze data and return a value, like what we did with the grading scale on the Semester Grade Calculator file.

Answer 29

False

Question 30

True or False: If I entered in the number .05 in a cell and then formatted the cell for %, it would display the value 5%

Answer 30

False

Question 31

True or False: I can autofill numbers down using the autofill handle.

Answer 31

True

Question 32

True or False: Google Sheets saves your work automatically.

Answer 32

True

Question 33

True or False: A group of cells is called a range

Answer 33

False

Question 34

True or False: To be able to see a singular row for the entire sheet, I would freeze the row.

Answer 34

Freeze

Question 35

True or False: To add cells R2 and D2, I would write =R2+D2

Answer 35

False

Question 36

True or False: A single Google Sheet is called a Workbook/worksheet

Answer 36

False

Question 37

True or False: I can autofill numbers, months, and days of the week in cells.

Answer 37

True

Question 38

True or False: This is how you write an absolute cell reference, $B$4.

Answer 38

False

Question 39

True or False: All formulas should begin with a =.

Answer 39

False

Question 40

True or False: A chart with bars is called a column chart in Google Sheets.

Answer 40

False

Question 41

True or False: If I wanted to make all cells that have any number over 10 blue, I would use > symbol in conditional formatting.

Answer 41

True

Question 42

True or False: If I wanted to make all cells that have any number over 10 blue, I would use > symbol in conditional formatting.

Answer 42

True

Question 43

What does the plus button at the bottom left mean?

Answer 43

To add sheet or a new sheet

Question 44

What does the paintbrush mean?

Answer 44

Paint format

Question 45

What does the money sign mean?

Answer 45

Format as currency

Question 46

What does the percent sign mean?

Answer 46

Format as percentage

Question 47

What does the bucket dumping paint mean?

Answer 47

Fill Color

Question 48

What does the Square box with lines through the middle mean?

Answer 48

Border