Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

Intro to Business (BTT 1O) > Unit 2b - Spreadsheets > Flashcards

Unit 2b - Spreadsheets Flashcards

1
Q

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

A 
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
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

an Excel file with one or more worksheets is called this

A

Workbook

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

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

A

Worksheet

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

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

A

cell(s)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

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

A

Active Cell

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

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

A

Formula Bar

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

The location of a cell in a worksheet is called a

A

Cell Address/Reference

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

This displays the name of each worksheet

A

Sheet Tabs

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

How many data types are there?

A

Three types:

1) Labels
2) Values
3) Numeric Labels

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

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

A

A Formula

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

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

A

TRUE!

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

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

A

1) decimals OR

2) a percentage sign

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

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

A

Range

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

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

A

A Function

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

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

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

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

A

Relative Referencing

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

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

A

Absolute Referencing

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
18
Q

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

A

Mixed Referencing

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
19
Q

What are the major versions of Spreadsheet Software today?

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
20
Q

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

A

Grid

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
21
Q

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

A

Auto-Sum

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
22
Q

What mouse cursor is used to select cells?

A

“General Select” Mouse Pointer

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
23
Q

This idicates the cursor position when editing a cell entry.

A

The “I-beam” Cursor

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
24
Q

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

A

The “fill Data” Pointer

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
25
Q

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

A

Select Entire Row/Column Mouse Pointer

26
Q

This shows up at the borders of column/row

headings. You use this to drag or widen a column.

A

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

27
Q

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

A

The Move Selected Cells Mouse Pointer

28
Q

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

A

The Arrow Mouse Pointer

29
Q

The location of a cell within a spreadsheet (IE: the name of the cell) is called this

Ex: D25 (Column D, Row 25)

A

Cell Address

30
Q

The text information (words in a cell) is called this

Ex: title of worksheet, column or row

A

Label

31
Q

This can be added to data using format menu

Ex: currency, percent, date

A

Signs

32
Q

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

A

Line Graph

33
Q

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

A

Bar or Column Graph

34
Q

This chart plots discrete data, good for percentages

A

Pie Chart

35
Q

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.

A

X/Y Scatterplot or Bubble Chart

36
Q

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

A

Area Graph

37
Q

This symbol is used for multiplication formula:

A
  • (star)
38
Q

This symbol is used for division formula:

A

/ (forward slash)

39
Q

These two symbols can be used for addition formula:

A

+ (plus sign) or : (colon)

40
Q

This symbol is used for subtraction formula:

A
  • (dash)
41
Q

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

A

= (Equals sign)

42
Q

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

A

FALSE (Also found in the formula ribbons tab)

43
Q

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

A

Comma Style Icon

44
Q

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

A

Merge and Centre Icon

45
Q

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

A

Balance Sheet

46
Q

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

A

Assets

47
Q

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

A

Liabilities

48
Q

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

A

Owner’s Equity

49
Q

How do we calculate Owner’s Equity

A

Assets - Liabilities

50
Q

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

A

Relative Cell Reference

51
Q

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

A

Absolute Cell Reference

52
Q

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

A

Mixed Cell Reference

53
Q

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

A

F4 (PC) or Command-T (Mac)

54
Q

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

A

TRUE

55
Q

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?

A

Conditional Format Icon

56
Q

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

A

FALSE: You need control + shift + enter

57
Q

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

A

TRUE

58
Q

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

A

TRUE

59
Q

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

A

Drop-Drowns

60
Q

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

A

Drop-Drowns

Intro to Business (BTT 1O) (9 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2024 Bold Learning Solutions. Terms and Conditions