Spreadsheet For A Purpose

Question 1

What is a spreadsheet?

Answer 1

A document that has columns and rows which are used to calculate numbers and organise information.

Question 2

What are the two spreadsheet applications?

Answer 2

Google Sheets and MS Excel.

Question 3

What is a worksheet?

Answer 3

The page of a spreadsheet you are working on.

Question 4

What is a row?

Answer 4

Cells that go across the spreadsheet.

Question 5

What is a column?

Answer 5

Cells that go down the spreadsheet.

Question 6

What is a cell?

Answer 6

An individual spreadsheet box where you enter data.

Question 7

What is an active cell?

Answer 7

The cell you are currently using.

Question 8

What is a label?

Answer 8

Text used to describe certain values, the text in an individual cell, data.

Question 9

What is a value?

Answer 9

Numbers that are entered into an individual cell.

Question 10

What is a formula?

Answer 10

An equation that makes calculations based on your data.

Question 11

What is a function?

Answer 11

Predefined formulas that preform calculations using data from your spreadsheet. They need keywords such as sum, average, min, max.

Question 12

What is a function?

Answer 12

Predefined formulas that preform calculations using data from your spreadsheet. They need keywords such as sum, average, min, max.

Question 13

What is a fill handle?

Answer 13

A feature to extend and fill a series of numbers, dates, and text to a desired number of cells.

Question 14

What is an absolute reference?

Answer 14

It refers to a reference that is locked so that rows and columns won’t change when copied.

Question 15

What is a model?

Answer 15

A system where you can change data to see what happens.

Question 16

Effects used to move from one slide to another.

Answer 16

Transition.

Question 17

A tool that displays the list of animated objects on your slide.

Answer 17

Animation pane.

Question 18

What is the formula if you want to get the data today

Answer 18

=Today( )

Question 19

A row that is named by a number.

Answer 19

Row heading.

Question 20

It is a feature to extend (and fill) a series of numbers, dates, or even text to a desired number of cells.

Answer 20

Fill handle.

Question 21

a name of an individual cell.

Answer 21

Cell reference.

Question 22

Allows you to move to another worksheet.

Answer 22

Navigation button.

Question 23

Use of mathematical symbols to calculate numbers in a spreadsheet.

Answer 23

Formulas.

Question 24

It refers to a reference that is “locked” so that rows and columns won’t change when copied.

Answer 24

Absolute reference.

Question 25

Automatically enters the appropriate formula or function into your spreadsheet.

Answer 25

Autosum.

Question 26

A computer program that calculates numbers and organises information in columns and rows.

Answer 26

Spreadsheet.

Question 27

it always begin with = sign, it is used to calculate numbers.

Answer 27

Formula.

Question 28

Is the cell which you have currently selected.

Answer 28

Active cell.

Question 29

Which bar allows us to view the unseen part of the MS Excel window

Answer 29

Scroll bar.

Question 30

An expression which calculates the value of a cell.

Answer 30

Formula.

Question 31

A number enter in an individual cell.

Answer 31

Value.

Question 32

What is the shortcut in putting absolute reference?

Answer 32

Fnf4.

Question 33

Lines that run horizontally.

Answer 33

Rows.

Question 34

Lines that run vertically.

Answer 34

Columns.