Summary: There are times when you are working with complex formulas that you need to calculate each section of the formula separately. This is called evaluating the formula. Here is how to do this:
To evaluate each part of a formula involved the following steps.
- Select the cell that contains the formula you wish to evaluate.
- Click on the Formula tab.
- In the Formula Auditing group click on Evaluate Formula.
- The formula appears in the evaluation window with some part of it underlined.
- Click the Step In button if it is activated. If it isn't skip this step.
- A new section will appear in the window, showing the results of the underlined portion.
- Repeat Steps 5 and 6 if the Step In button is still active.
- When the Step In button is no longer active, click the Step Out button to return to the previous level. Each click of the button returns you to the previous level.
- Click the Evaluate button and Excel will evaluate the underlined portion, replacing it in the formula with the returned or calculated value.
- Continue to Evaluate or Step In to watch the formula calculate.
- Excel is done with the evaluation when only the calculated value appears in the Evaluation field. You can either click Restart to go through the steps again, or click Close to return to Excel.
Converting Measurement Systems
Back to top
Summary: There are times when you need to convert temperatures from Celcius to Fahrenheit or Fahrenheit to Celcius. Here is how to do this:
You need to use the CONVERT function. Assume you have a temperature of 15 degrees Celcius in cell A1.
In B1 enter the following function:
=CONVERT(A1, "C", "F")
You will get the answer 53 degrees which is the conversion of 15 degrees Celsius to Fahrenheit.
If you change the function to :
You will get the answer -9 which is the conversion of 15 degrees Fahrenheit to Celsius.
Counting the Number of Blank Cells
Back to top
Summary: There are times when you want to know how many blank cells there are in a range of cells. Here is how to do this.
The CountBlank function will give you this information. The form is as follows:
=COUNTBLANK(Range of Cells)
This function returns a number that represents the number of blank cells in the range. Be careful, however, because COUNTBLANK will not count cells that have a zero value.
Summary: There are times when you are working in a document when you need to replace a word or words with a different word or words throughout the document. Find and Replace handles this task easily. Here is how to do this:
- Click on the Home tab in the Ribbon.
- Click on Replace in the Editing Group.
- The Find and Replace dialog box appears with the Replace tab displayed.
- Enter the word or phrase that you want to search for.
- Enter the word or phrase that you want to replace the found item(s) with in the Replace With text box.
- Click Find Next. The first occurrence in the document below the current insertion point will be highlighted.
- Choose one of the following options:
Click Replace if you want to replace the current instance that was found with the text you entered. Word replaces the instance and automatically finds the next one.
Click Find Next if you do not want to replace the text that was found and want to find the next occurrence.
Click Replace All if you want to replace all the occurrences of the word that are found in the document.
- Click Close when you are finished working through the documents.
Summary: If your want to make sure that the recipient reads your e-mail you can request a receipt. Here is how to do this::
To obtain receipts for all your messages:
- Click Tools, Options, and click the E-mail Options button.
- In the E-mail Options dialog box, click the Tracking Options button.
- In the lower half of the dialog box, click Read Receipt, Delivery Receipt or both.
- You can choose an option for responding to other senders' requests.
- You have the following options:
- Always send a response.
- Never send a response.
- of Ask Me Before Sending a Response.
- Click OK three times.
To obtain a single receipt:
- Create an e-mail message.
- Click on the Options tab in the Message window.
- In the Tracking Group, click Request a Delivery Receipt, Request a Read Receipt or both.
- Click Close.
PowerPoint Slide Show Shortcuts
Summary: In the table below you will find a number of shortcuts that are useful when you are doing a PowerPoint presentation.
|To Perform This||Press|
|Start a presentation from the beginning.||F5|
|Perform the next animation or advance to the next slide.||N, ENTER, PAGE DOWN, RIGHT ARROW, DOWN ARROW, or SPACEBAR|
|Perform the previous animation or return to the previous slide.||P, PAGE UP, LEFT ARROW, UP ARROW, or BACKSPACE|
|Go to slide number.||number+ENTER|
|Display a blank black slide, or return to the presentation from a blank black slide.||B or PERIOD|
|Display a blank white slide, or return to the presentation from a blank white slide.||W or COMMA|
|Stop or restart an automatic presentation.||S|
|End a presentation.||ESC or HYPHEN|