A
What time of program is Excel?
Spreadsheet program
When we open Excel, we start with a brand new
Workbook
Workbooks are made up of
Worksheets/Spreadsheets
Default name for our new workbook until we name it
Book1
Default name for our spreadsheets/worksheets until we name them
Sheet1
Our spreadsheets/worsheets are made up of
columns/rows
Columns go which way and are identified by what
vertical, letters
Rows go which way and are identified by what
horizontal, numbers
These are formed where our columns and rows intercept and where we enter our data
cells
Cells are identified by what (in correct order)
The cell name (such as B5) is known as the
cell reference
The cell ready to receive data and identified by a dark green border
active cell
Shows the name of the active cell
name box
A group of adjacent cells, will list the first cell reference followed by a colon and the second cell reference.
Example: B5:B15
Range
Command on the ribbon that will quickly add or provides another function (count, max, min. average) for selected range of cells
autosum
quickly adds or provides another function (count, max, min. average) for selected range of cells
Small square located in lower right corner of the active cell, It allows us to drag the contents of the (or formula or function) to adjacent cells
Used to create math operations with a limited number of cells. example: =A4 + B4
formula
Used to do math operations with a range (multiple) of cells
Function
Will show the function or formula that is in the cell
A function that allows us to print out something based on whether a condition is met.
Example: Print out the word "Bonus" if sales were greater than $100,000 for that person
an if function
Allows us to select and show specific data
filters
Name the three ways to adjust a columns width
1. Double-clicking on line between column letters
2. Clicking and dragging on line between column letters
3. Right-click on column heading, choose column width, and enter in size
To insert a chart on a separate worksheet, you would create the chart and then click on the what command on the ribbon
Move Chart
In order to insert a new column between columns C and D, I need to
Right-click on the letter D and choose insert
Describe how to hide columns C-H so my spreadsheet only shows columns A,B,I, and J