Quantcast
Sign Up For Our Newsletter
Email:

I4C

Using the Formulas tab in Excel 2007

advertisement

Using Excel in a Classroom

Using the Formulas Tab in Excel 2007


Tip: If you are unsure what the function of a feature is, let your cursor hover over the button (in Excel) to see a pop-up box explaining the feature. If you want to collapse the ribbon so that none of the buttons are displayed, double-click the name of the tab.


Function Library
Insert Function - Edit the formula in the current cell by choosing functions and editing the arguments. The keyboard shortcut to insert a function is Shift + F3 .
AutoSum - Display the sum of the selected cells directly after the selected cells. The keyboard shortcut for autosum is Alt + = .
Recently Used - Browse and select from a list of recently used functions.
Financial - Browse and select from a list of financial functions.
Logical - Browse and select from a list of logical functions.
Text - Browse and select from a list of text functions.
Date and Time - Browse and select from a list of date and time functions.
Lookup and Reference - Browse and select from a list of lookup and reference functions.
Math and Trig - Browse and select from a list of math and trigonometry functions.
More Functions - Browse and select from lists of statistical, engineering, cube, and information functions.

Defined Names
Name Manager - Create, edit, delete, and find all the names used in the workbook. The keyboard shortcut to access the name manager is Ctrl + F3 .
Defined Name - Name cells so that you can refer to them in formulas by that name. For example, you might name the cells A20 to A40 "Expenses." Names can be used in formulas to make them easier to understand.
Use in Formula - Choose a name used in the workbook and insert it into the current formula.
Create from Selection - Automatically generate names from the selected cells. Many people choose to use the text in the top row or the leftmost column of a selection. The keyboard shortcut to create from selection is Ctrl + Shift + F3 .

Formula Auditing
Trace Precedents - This will show arrows that indicate what cells affect the value of the currently selected cell.
Trace Dependents - This will show arrows that indicate what cells are affected by the value of the currently selected cell.
Remove Arrows - This will remove the arrows drawn by Trace Precedents or Trace Dependents.
Show Formulas - Display the formula in each cell instead of the resulting value. The keyboard shortcut to show formulas is Ctrl + ' .
Error Checking - Check for common errors that occur in formulas.
Evaluate Formula - Launch the Evaluate Formula dialog box to debug a formula by evaluating each part of the formula individually.
Watch Window - Monitors the values of certain cells as changes are made to the sheet. The values are displayed in a separate window that remains visible, regardless of what area of the workbook is shown.

Calculation
Calculation Options - Specify when formulas are calculated. By default, any time you change a value that affects other values, the new values are calculated immediately.
Calculate Now - Calculate the entire workbook now. This is only necessary if automatic calculation has been turned off. The keyboard shortcut to calculate now is F9 .
Calculate Sheet - Calculate the current sheet now. This is only necessary if automatic calculation has been turned off. The keyboard shortcut to calculate sheet is Shift + F9 .

In the Table below, select which section of the Formulas tab you would use to perform the stated action. [This quiz has not been completed]
1.

Question 1
         

x

2.

Question 2
         

x

3.

Question 3
         

x

4.

Question 4
         

x

5.

Question 5
         

x

6.

Question 6
         

x

7.

Question 7
         

x

8.

Question 8
         

x

9.

Question 9
         

x

10.

Question 10
         

x

Internet4classrooms is a collaborative effort by Susan Brooks and Bill Byles.
 

  

advertisement

advertisement

Use of this Web site constitutes acceptance of our Terms of Service and Privacy Policy

249849169 US 1 desktop not tablet not iPad device-width