Excel Lesson 4- Using Basic Formulas
An absolute cell reference requires what symbol?
$
A value is usually a number or what?
Cell address
In order to display all formulas in your worksheet, what do you do?
Click the show Formulas command button on the Formulas tab.
In order to view the formula in the active cell, what do you do?
Double-click the active cell.
During formula modifications, you can revert back to the original formula by pressing what key?
Esc
In order to enter the editing mode and edit your function, what key do you press?
F2
TRUE OR FALSE Excel recognizes a construct like 3+4= as a legitimate formula.
False
TRUE OR FALSE You cannot use a named range in a formula that references another worksheet.
False
TRUE OR FALSE Range names may begin with the caret(^) character.
False
The name Manager, where named cell ranges can be edited, is on which tab?
Formulas
What is the correlation between named cell ranges and formulas?
Named cell ranges cannot be included in a formula.
Per order of operations, what calculation comes first?
Negative numbers (-)
Calculation operator
Operators that specify the calculations to be performed.
Nested parentheses
Parentheses inside of parentheses within a formula.
in the Paste Name dialog box, in order to add all of the named ranges and address data, click ________.
Paste List
When referencing data in another workbook, you must use what under what conditions?
Square brackets([]) and both workbooks must be open.
TRUE OR FALSE The order of operations determines which parts of a formula are calculated before other parts of the formula.
TRUE
Scope
The location within which Excel recognizes a named range, which is either a specific worksheet or the entire workbook. If you set the scope of a named range to Workbook, you can reference the named range on any sheet in the workbook.
When copying a formula, what is applied?
The relative reference automatically adjusts and the absolute reference does not adjust.
Order of operations
The rules Excel follows to calculate any formula that contains two or more operators. 1. Negative number (-) 2. Percent (%) 3. Exponentiation (^) 4. Multiplication (*_ and division (/) (Left to right) 5. Addition (+) or subtraction (-) (Left to right)
TRUE OR FALSE Once you name a range, you can change the size of the range using the Name Manager.
True
TRUE OR FALSE Range names cannot be the same as a cell reference, such as C10 or $D$8.
True
TRUE OR FALSE Regarding a named range, the scope of a name is the location within which Excel recognizes the name without qualifications.
True
TRUE OR FALSE To allow Excel to distinguish formulas from data, all formulas begin with an equal sign (=).
True
TRUE OR FALSE You can create a new range by selecting the cells and typing a name in the Name box next to the formula bar.
True
The formula =6*2/3 produces the same result as =6*(2/3).
True
When modifying a spreadsheet, to revert back after pressing the Enter key, what do you click?
Undo button
In the Defined Names group, you can add Named Ranged to formulas by selecting what?
Use in Formula
In Excel, what is the result of -1+3*2/2-1?
3
All formulas begin with what character?
=
What is the formula to add all cells in a range called SALES?
=Sum(Sales)
What is the formula to multiply all cells in a range called DATA?
=product(DATA)
External reference
A cell or range in a worksheet in another Excel workbook, or a defined name in another workbook.
Relative cell reference
A cell reference that adjusts the cell identifier automatically if you insert or delete columns or rows, or if you copy the formula to another cell.
Mixed cell reference
A cell reference that uses an absolute column or row reference, but not both.
Named range
A group of cells, and occasionally a single cell, with a designated name.
Constant
A number or text value entered directly into a formula.
Value
A number, a cell address, a date, text, or Boolean data in Excel. regarding formulas, it is usually a number or cell address.
Cell reference
A reference that identifies a cell's location in the worksheet based on its row number and column letter.
Absolute cell reference
A reference to a specific cell or range of cells regardless of where the formula is located in the worksheet. An absolute cell reference uses a dollar sign in front of the column and row markers in a cell address.
Variable
A symbol or name that represents something else; it can be a cell address, a range of cells, and so on.
Operand
An element that identifies the values to be used in a calculation.
Formula
An equation that performs calculations, such as addition, subtraction, multiplication, and division, on values in a worksheet.
Calculation operators include what?
Arithmetic, comparison, text concatenation, reference
How can you view named ranges?
By viewing the Named box next to the formula bar.
An equation that performs calculations on values in a worksheet is also known as a/an _____.
formula
