Unit 2b - Spreadsheets

Question 1

Excel is a powerful spreadsheet program that will allow you to what?

Answer 1

A) Create Charts
B) Track Personal Finances
C) Balance Cheque Book
D) Create a Budget
E) Track mortgage
F) Prepare Taxes
G) Prepare Financial Reports

Question 2

an Excel file with one or more worksheets is called this

Answer 2

Workbook

Question 3

The work area for entering and calculating data, made up of columns and rows separated by gridlines is this

Answer 3

Worksheet

Question 4

This is located where a column and row meet. The data is entered into these to create a worksheet

Answer 4

cell(s)

Question 5

This is located where the data is being entered. It contains the CELL PONTER and a black border appears around it.

Answer 5

Active Cell

Question 6

As data is entered into a cell, it simultaneously appears in this

Answer 6

Formula Bar

Question 7

The location of a cell in a worksheet is called a

Answer 7

Cell Address/Reference

Question 8

This displays the name of each worksheet

Answer 8

Sheet Tabs

Question 9

How many data types are there?

Answer 9

Three types:

1) Labels
2) Values
3) Numeric Labels

Question 10

This is an instruction Excel uses to calculate a result. What is this called?

Answer 10

A Formula

Question 11

TRUE or FALSE: Whenever you are creating a formula, you need to put the = sign first.

Answer 11

TRUE!

Question 12

What are the two ways we can calculate percentages in excel?

Answer 12

1) decimals OR

2) a percentage sign

Question 13

What is an area of a worksheet called?; This can also be contiguous or non-contiguous in nature

Answer 13

Range

Question 14

A built-in formula that performs a special calculation automatically is called what?

Answer 14

A Function

Question 15

What are the names of the 5 main basic forms of functions located in Excel:

Answer 15

1) SUM (Add)
2) AVERAGE
3) MAX (Maximum)
4) MIN (Minimum)
5) COUNT

Question 16

When a formula is copied, the cell reference changes relative to its new location is is called what?

Answer 16

Relative Referencing

Question 17

When a formula is copied, one value in the formula remains the same, this is called what?

Answer 17

Absolute Referencing

Question 18

When a formula is copied, one part of one value in the formula remains the same, the other part changes, this is called what?

Answer 18

Mixed Referencing

Question 19

What are the major versions of Spreadsheet Software today?

Answer 19

1) Microsoft Excel
2) Google Sheets
3) iWorks Numbers

Question 20

When opening up Excel, the group of cells you look at before entering anything is called a:

Answer 20

Grid

Question 21

Which button do we use to calculate basic formulas in excel (Such as Auto-Sum, Min, Max, Count and Average?_

Answer 21

Auto-Sum

Question 22

What mouse cursor is used to select cells?

Answer 22

“General Select” Mouse Pointer

Question 23

This idicates the cursor position when editing a cell entry.

Answer 23

The “I-beam” Cursor

Question 24

This icon is in the shape of a plus sign that is used for copying formula or extending a data series.

Answer 24

The “fill Data” Pointer

Question 25

This pointer is used to select cells on the worksheet. It selects whole row/column when positioned on the number/ letter heading label.

Answer 25

Select Entire Row/Column Mouse Pointer

Question 26

This shows up at the borders of column/row | headings. You use this to drag or widen a column.

Answer 26

The “Column Resize” / "Row Resize" Mouse Pointers

Question 27

You use this pointer to to click and drag data to another location within worksheet.

Answer 27

The Move Selected Cells Mouse Pointer

Question 28

You use this pointer to select menu or commands in Ribbon Tabs.

Answer 28

The Arrow Mouse Pointer

Question 29

The location of a cell within a spreadsheet (IE: the name of the cell) is called this Ex: D25 (Column D, Row 25)

Answer 29

Cell Address

Question 30

The text information (words in a cell) is called this Ex: title of worksheet, column or row

Answer 30

Label

Question 31

This can be added to data using format menu Ex: currency, percent, date

Answer 31

Signs

Question 32

This graph plots continuous data as points and connects with a line

Answer 32

Line Graph

Question 33

This graph plots discrete data in bars (Bar Graph for horizontal bars OR Column Graph for vertical bars)

Answer 33

Bar or Column Graph

Question 34

This chart plots discrete data, good for percentages

Answer 34

Pie Chart

Question 35

This chart plots continuous data, and determines a trend (line of best fit). It usually places a point between the X and Y axis of data.

Answer 35

X/Y Scatterplot or Bubble Chart

Question 36

This graph is ideal for illustrating the magnitude of change between two or more data points

Answer 36

Area Graph

Question 37

This symbol is used for multiplication formula:

Answer 37

* (star)

Question 38

This symbol is used for division formula:

Answer 38

/ (forward slash)

Question 39

These two symbols can be used for addition formula:

Answer 39

+ (plus sign) or : (colon)

Question 40

This symbol is used for subtraction formula:

Answer 40

- (dash)

Question 41

What do you need at the beginning for EVERY formula for Excel

Answer 41

= (Equals sign)

Question 42

TRUE or FALSE: You can only find the Auto-Sum Icon on the home ribbon screen on Excel

Answer 42

FALSE (Also found in the formula ribbons tab)

Question 43

You use this icon to change any number to 2 decimal places

Answer 43

Comma Style Icon

Question 44

We use this icon to centre our titles among a range of cells

Answer 44

Merge and Centre Icon

Question 45

A statement of the assets, liabilities, and capital of a business, at a particular point in time is called this

Answer 45

Balance Sheet

Question 46

Items that are owned and can easily converted into cash on a balance sheet is called this

Answer 46

Assets

Question 47

Debts that will be paid either in the near future or over a longer period of time on balance sheets are known as this:

Answer 47

Liabilities

Question 48

The amount of the business assets owned by the business owners on a balance sheet is called this:

Answer 48

Owner's Equity

Question 49

How do we calculate Owner's Equity

Answer 49

Assets - Liabilities

Question 50

When a formula is copied, the cell references change relative to their new location is known as this:

Answer 50

Relative Cell Reference

Question 51

When a value in a formula must remain the same when it is copied to other locations on the worksheet is known as this

Answer 51

Absolute Cell Reference

Question 52

When a value in a formula changes only the row OR column of a location on a worksheet, we call it this:

Answer 52

Mixed Cell Reference

Question 53

Which function key (or command on mac) is used to toggle between the various types of cell references.

Answer 53

F4 (PC) or Command-T (Mac)

Question 54

TRUE or FALSE: you must include an equals sign on the outside and the inside of the parentheses of an IF statement.

Answer 54

TRUE

Question 55

What icon is used on the HOME Ribbons Tab where we want to add colours, gradients and symbols in order to show us the highest and lowest values of numbers?

Answer 55

Conditional Format Icon

Question 56

TRUE or FALSE: We only use the shift + enter key when trying to enter in MAX or MIN IF statements

Answer 56

FALSE: You need control + shift + enter

Question 57

We use this [ , ] symbol when adding cells from multiple worksheets in a workbook file.

Answer 57

TRUE

Question 58

TRUE or FALSE: Pop-Ups are common on websites today.

Answer 58

TRUE

Question 59

Google Forms, a type of survey program uses this type of advanced feature we can duplicate in Excel

Answer 59

Drop-Drowns

Question 60

This type of advanced feature allows us to create a list of specific options of possible inputs into certain cells. It is called this

Answer 60

Drop-Drowns