name box
cell reference of the active cell
formula bar
displays value or formula entered into the active cell
row headings
numbers along the left side of the workbook window that identify the different rows of the worksheet
inactive sheets
not visible in the work window. Their sheet tabs are not underlined and the sheet name is blank
active sheet
underlined and the sheet name is green and bold
column headings
the letters at the top of the column
text data is referred to as
text string (contains a series/string of text characters)
numeric data
any number that can be used in a mathematical calculation
ctrl+z
undo
increase the widths of two columns
click one column, press ctrl and then click the adjacent column, then move the pointer in either direction to make both bigger or smaller
every formula begins with____
an equal sign and followed by an expression describing the operation that returns the value
the 5 options of AutoSum
SUM, AVERAGE, COUNT, MIN, MAX
format painter
paint brush with blue paint next to copy and paste on the home ribbon; copes and pastes formatting from one cell or range to another without duplicating any data
Creating the mean
0
conditional format
applies formatting to a cell when its value meets a specified condition
how to get the median
0
Which function determines how many cells in a range contain numbers, where value1, value2, and so forth are text, numbers, or cell references?
COUNT
In SUM(number1 [, number2, number3, ...]), number 1, number 2, and number 3 may be numbers or __.
cell references
Keyboard __ can help you work faster and more efficiently because you can keep your hands on the keyboard.
shortcuts
AZ" is an example of a __.
column heading
To make A1 the active cell, you should press which of the following keys?
ctrl+home
The characters +, -, *, and / are examples of __.
arithmetic operators
An Excel formula always begins with a(n) __.
equals sign
Put the following five steps in the order in which you would perform them to use the Paste Special function.
1. Select and copy a range.
2. Click the Paste button arrow in the Clipboard group on the HOME Tab.
3. Specify exactly what you want to paste.
4.
1, 5, 2, 4, 3