Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

excel advanced applying

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel Advanced - Applying Names

Excel Advanced - Applying Names

ResolvedVersion 2003

Excel Advanced - Applying Names

Hi,
I am reading the reference manual and page 5 talks about applying names.
I do not understand this section, how it is useful or what I am supposed to do.

Can someone please help me?

Thank you

Stefania

Edited on Mon 15 Dec 2008, 10:03

RE: Excel Advanced - Applying Names

Hi Stefania,
Thank you for your question;
In answer: We use names to give unique properties to our cells or ranges of cells. When you name a cell or range that name becomes unique throughout the workbook and can be used in a formula or function. (Or to put it another way) If you consider an absolute cell reference which is fixed in a worksheet formula, a named cell would be fixed through the workbook....I hope that helps..

RE: Excel Advanced - Applying Names

Hi Pete,
thank you for your reply.
I will practice this evening about it.

Kind regards

Stefania

Excel tip:

Use RANDBETWEEN to generate random numbers

There may be occassions where you need to generate random numbers in your spreadsheet. Use the RANDBETWEEN function to generate random numbers between two values that you specify.

The function looks like this:

=randbetween(LOW,HIGH)

where LOW is the lowest number you want generated; and HIGH is the highest number you want generated.

This formula will work with both positive and negative LOWs and HIGHs. Also it will only generate integer numbers unless forced to do otherwise by the following:

=randbetween(LOW*10^PRECISION,
HIGH*10^PRECISION)/(10^PRECISION).

where PRECISION represents the levels of decimal precision needed (i.e. if you need numbers with one decimal place, PRECISION would be 1; 2 for two decimal places and so on).

One final note, if the RANDBETWEEN formula does not work in your spreadsheet or returns a "#NAME" error, you need to install the Analysis Toolpak Add-In. You will need to press F2 then Enter following the installation.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.08 secs.