Excel Lesson 4- Using Basic Formulas

Réussis tes devoirs et examens dès maintenant avec Quizwiz!

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


Ensembles d'études connexes

Modules 4-7: Ethernet Concepts Exam Answers

View Set

ASL Final Exam Segment 1 Module 4

View Set

Medical terminology study guide chapter 1-3

View Set

Chapter 3: Structure and Function of the Reproductive System

View Set

MGT 2180 Module 2 (Excel) Chapter 2 matching

View Set