Unit 2b - Spreadsheets Flashcards
Excel is a powerful spreadsheet program that will allow you to what?
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
an Excel file with one or more worksheets is called this
Workbook
The work area for entering and calculating data, made up of columns and rows separated by gridlines is this
Worksheet
This is located where a column and row meet. The data is entered into these to create a worksheet
cell(s)
This is located where the data is being entered. It contains the CELL PONTER and a black border appears around it.
Active Cell
As data is entered into a cell, it simultaneously appears in this
Formula Bar
The location of a cell in a worksheet is called a
Cell Address/Reference
This displays the name of each worksheet
Sheet Tabs
How many data types are there?
Three types:
1) Labels
2) Values
3) Numeric Labels
This is an instruction Excel uses to calculate a result. What is this called?
A Formula
TRUE or FALSE: Whenever you are creating a formula, you need to put the = sign first.
TRUE!
What are the two ways we can calculate percentages in excel?
1) decimals OR
2) a percentage sign
What is an area of a worksheet called?; This can also be contiguous or non-contiguous in nature
Range
A built-in formula that performs a special calculation automatically is called what?
A Function
What are the names of the 5 main basic forms of functions located in Excel:
1) SUM (Add)
2) AVERAGE
3) MAX (Maximum)
4) MIN (Minimum)
5) COUNT
When a formula is copied, the cell reference changes relative to its new location is is called what?
Relative Referencing
When a formula is copied, one value in the formula remains the same, this is called what?
Absolute Referencing
When a formula is copied, one part of one value in the formula remains the same, the other part changes, this is called what?
Mixed Referencing
What are the major versions of Spreadsheet Software today?
1) Microsoft Excel
2) Google Sheets
3) iWorks Numbers
When opening up Excel, the group of cells you look at before entering anything is called a:
Grid
Which button do we use to calculate basic formulas in excel (Such as Auto-Sum, Min, Max, Count and Average?_
Auto-Sum
What mouse cursor is used to select cells?
“General Select” Mouse Pointer
This idicates the cursor position when editing a cell entry.
The “I-beam” Cursor
This icon is in the shape of a plus sign that is used for copying formula or extending a data series.
The “fill Data” Pointer
This pointer is used to select cells on the worksheet. It selects whole row/column when positioned on the number/ letter heading label.
Select Entire Row/Column Mouse Pointer
This shows up at the borders of column/row
headings. You use this to drag or widen a column.
The “Column Resize” / “Row Resize” Mouse Pointers
You use this pointer to to click and drag data to another location within worksheet.
The Move Selected Cells Mouse Pointer
You use this pointer to select menu or commands in Ribbon Tabs.
The Arrow Mouse Pointer
The location of a cell within a spreadsheet (IE: the name of the cell) is called this
Ex: D25 (Column D, Row 25)
Cell Address
The text information (words in a cell) is called this
Ex: title of worksheet, column or row
Label
This can be added to data using format menu
Ex: currency, percent, date
Signs
This graph plots continuous data as points and connects with a line
Line Graph
This graph plots discrete data in bars (Bar Graph for horizontal bars OR Column Graph for vertical bars)
Bar or Column Graph
This chart plots discrete data, good for percentages
Pie Chart
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.
X/Y Scatterplot or Bubble Chart
This graph is ideal for illustrating the magnitude of change between two or more data points
Area Graph
This symbol is used for multiplication formula:
- (star)
This symbol is used for division formula:
/ (forward slash)
These two symbols can be used for addition formula:
+ (plus sign) or : (colon)
This symbol is used for subtraction formula:
- (dash)
What do you need at the beginning for EVERY formula for Excel
= (Equals sign)
TRUE or FALSE: You can only find the Auto-Sum Icon on the home ribbon screen on Excel
FALSE (Also found in the formula ribbons tab)
You use this icon to change any number to 2 decimal places
Comma Style Icon
We use this icon to centre our titles among a range of cells
Merge and Centre Icon
A statement of the assets, liabilities, and capital of a business, at a particular point in time is called this
Balance Sheet
Items that are owned and can easily converted into cash on a balance sheet is called this
Assets
Debts that will be paid either in the near future or over a longer period of time on balance sheets are known as this:
Liabilities
The amount of the business assets owned by the business owners on a balance sheet is called this:
Owner’s Equity
How do we calculate Owner’s Equity
Assets - Liabilities
When a formula is copied, the cell references change relative to their new location is known as this:
Relative Cell Reference
When a value in a formula must remain the same when it is copied to other locations on the worksheet is known as this
Absolute Cell Reference
When a value in a formula changes only the row OR column of a location on a worksheet, we call it this:
Mixed Cell Reference
Which function key (or command on mac) is used to toggle between the various types of cell references.
F4 (PC) or Command-T (Mac)
TRUE or FALSE: you must include an equals sign on the outside and the inside of the parentheses of an IF statement.
TRUE
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?
Conditional Format Icon
TRUE or FALSE: We only use the shift + enter key when trying to enter in MAX or MIN IF statements
FALSE: You need control + shift + enter
We use this [ , ] symbol when adding cells from multiple worksheets in a workbook file.
TRUE
TRUE or FALSE: Pop-Ups are common on websites today.
TRUE
Google Forms, a type of survey program uses this type of advanced feature we can duplicate in Excel
Drop-Drowns
This type of advanced feature allows us to create a list of specific options of possible inputs into certain cells. It is called this
Drop-Drowns
