University:
Georgia Southern University
Course:
ENGR1121 | Computing in Mechanical Engineering
Academic year:

2024
Views:

130

Pages:

14
Author:

Jalen W.

Excel window: title bar, ribbon, quick access toolbar Title bar, ribbon and quick access toolbar As you enter a numerical value in the currently active cell, you will see the value being entered in the Formula Bar as well as in the active cell. When you are finished typing the number, press the Enter key. You may also click on the ✓ symbol in the Formula Bar to accept the number, or click on the × to reject the number. A string (also called a label) is entered as a text constant simply by typing the desired text into the active cell. formulas begin with an equal sign (=), followed by a numerical expression involving constants, operators, and cell addresses. Example 2.1 Writing an Excel Formula One formula can refer to another, provided the second formula (i.e., the referenced formula) does not refer back to the first formula. If the formulas refer to each other, however, we have a circular reference, in which neither formula can be evaluated because each requires prior knowledge of the other. Thus, circular references must be avoided when writing cell formulas. Cell Names Excel allows you to assign names to individual cells so that you can use cell names rather than cell addresses in formulas. To do so, select a cell and highlight the cell address shown in the Name Box (the leftmost portion of the Formula Bar). Then type the desired cell name in place of the cell address (begin with a letter and avoid blank spaces), and press the Enter key. USING FUNCTIONS • A function consists of a function name, followed by one or more arguments. The arguments are enclosed in parentheses and separated by commas. Consider, for example, the function specification SUM(C1,C2,C3). This function calculates the sum of the quantities in cells C1, C2, and C3. The function name is SUM, and the arguments are the cell references C1, C2, and C3. • The previous function could also have been written as SUM(C1:C3). The term C1:C3 is called a range. It refers to all of the cells between the given extremities (i.e., between cells C1 and C3). The range designation is very convenient when a function requires many contiguous cells as arguments. Reading work • Saving a worksheet • Retrieving a worksheet • Printing a worksheet

Creating an Excel Worksheet

of 14

Description

Struggling with your assignment and deadlines?

Free up your schedule!

Take 5 seconds to unlock