answersLogoWhite

0

It is used in specifying text in a function, and sometimes dates. It differentiates names for ranges and actual text. Functions use different kinds of data, such as numbers, dates, logical values and text. Text is indicated by enclosing it in quotation marks, and dates can be indicated that way too. See the following examples:

=FIND("A", C30)

=WEEKDAY("2/5/90")

If you had a range named Sales you could do this with Excel to sum the range, but you would not use the quotations marks to specify it, otherwise it would not work, as it would treat it as text. Assuming you did have a ranged named Sales, then the first of these two is correct and second will not work:

=SUM(Sales)

=SUM("Sales")

User Avatar

Marisa Predovic

Lvl 10
4y ago

What else can I help you with?

Related Questions

What symbol would you use to add up two numbers in a spreadsheet?

The plus symbol: +


What symbol would you use to multiply two numbers on a spreadsheet?

On a spreadsheet you use the * symbol rather than x as used normally in mathematics.


What symbol to use when subtract a number in Microsoft Excel 2010?

You would use a - to subtract a number on a spreadsheet


When do you use the '-' symbol in a spreadsheet?

The most common use is in a formula that includes subtraction.


What symbol do you use on a spreadsheet when you want to add sets of numbers together?

a comma


Why would a shopkeeper need to use a spreadsheet?

You can analyze your profit and loss on a spreadsheet.


Is using a spreadsheet more like using a proccessor on Microsoft Excel?

Microsoft Excel is a spreadsheet application, so that is what it would be used for. You would not use it for things like word processing.Microsoft Excel is a spreadsheet application, so that is what it would be used for. You would not use it for things like word processing.Microsoft Excel is a spreadsheet application, so that is what it would be used for. You would not use it for things like word processing.Microsoft Excel is a spreadsheet application, so that is what it would be used for. You would not use it for things like word processing.Microsoft Excel is a spreadsheet application, so that is what it would be used for. You would not use it for things like word processing.Microsoft Excel is a spreadsheet application, so that is what it would be used for. You would not use it for things like word processing.Microsoft Excel is a spreadsheet application, so that is what it would be used for. You would not use it for things like word processing.Microsoft Excel is a spreadsheet application, so that is what it would be used for. You would not use it for things like word processing.Microsoft Excel is a spreadsheet application, so that is what it would be used for. You would not use it for things like word processing.Microsoft Excel is a spreadsheet application, so that is what it would be used for. You would not use it for things like word processing.Microsoft Excel is a spreadsheet application, so that is what it would be used for. You would not use it for things like word processing.


What symbol would you use to add two numbrs together in a spreadsheet?

In a spreadsheet, you would use the plus sign (+) to add two numbers together. For example, if you wanted to add the values in cells A1 and B1, you would enter the formula =A1 + B1 in another cell. This will calculate the sum of the two numbers and display the result.


Why would a ateacher use a spreadsheet for?

a chart


In a spreadsheet you would '' symbol when you want to?

In a spreadsheet, you would use the "''" symbol (apostrophe) when you want to indicate that the following entry should be treated as text, regardless of its format. This is particularly useful for preventing automatic formatting, such as when entering numbers that start with zeros (e.g., phone numbers or ZIP codes). It ensures that the data is displayed exactly as you input it without any alterations.


Does a formula have equals SIGN in it?

In an Excel spreadsheet and equals sign normally starts a formula. You can also start with a plus or minus or start a function with the @ symbol, because some spreadsheet applications use that, but they will be converted to an equals sign. The equals signs tells Excel that you are going to use a formula, so if you started a function without it, the function would be treated like a piece of text.In an Excel spreadsheet and equals sign normally starts a formula. You can also start with a plus or minus or start a function with the @ symbol, because some spreadsheet applications use that, but they will be converted to an equals sign. The equals signs tells Excel that you are going to use a formula, so if you started a function without it, the function would be treated like a piece of text.In an Excel spreadsheet and equals sign normally starts a formula. You can also start with a plus or minus or start a function with the @ symbol, because some spreadsheet applications use that, but they will be converted to an equals sign. The equals signs tells Excel that you are going to use a formula, so if you started a function without it, the function would be treated like a piece of text.In an Excel spreadsheet and equals sign normally starts a formula. You can also start with a plus or minus or start a function with the @ symbol, because some spreadsheet applications use that, but they will be converted to an equals sign. The equals signs tells Excel that you are going to use a formula, so if you started a function without it, the function would be treated like a piece of text.In an Excel spreadsheet and equals sign normally starts a formula. You can also start with a plus or minus or start a function with the @ symbol, because some spreadsheet applications use that, but they will be converted to an equals sign. The equals signs tells Excel that you are going to use a formula, so if you started a function without it, the function would be treated like a piece of text.In an Excel spreadsheet and equals sign normally starts a formula. You can also start with a plus or minus or start a function with the @ symbol, because some spreadsheet applications use that, but they will be converted to an equals sign. The equals signs tells Excel that you are going to use a formula, so if you started a function without it, the function would be treated like a piece of text.In an Excel spreadsheet and equals sign normally starts a formula. You can also start with a plus or minus or start a function with the @ symbol, because some spreadsheet applications use that, but they will be converted to an equals sign. The equals signs tells Excel that you are going to use a formula, so if you started a function without it, the function would be treated like a piece of text.In an Excel spreadsheet and equals sign normally starts a formula. You can also start with a plus or minus or start a function with the @ symbol, because some spreadsheet applications use that, but they will be converted to an equals sign. The equals signs tells Excel that you are going to use a formula, so if you started a function without it, the function would be treated like a piece of text.In an Excel spreadsheet and equals sign normally starts a formula. You can also start with a plus or minus or start a function with the @ symbol, because some spreadsheet applications use that, but they will be converted to an equals sign. The equals signs tells Excel that you are going to use a formula, so if you started a function without it, the function would be treated like a piece of text.In an Excel spreadsheet and equals sign normally starts a formula. You can also start with a plus or minus or start a function with the @ symbol, because some spreadsheet applications use that, but they will be converted to an equals sign. The equals signs tells Excel that you are going to use a formula, so if you started a function without it, the function would be treated like a piece of text.In an Excel spreadsheet and equals sign normally starts a formula. You can also start with a plus or minus or start a function with the @ symbol, because some spreadsheet applications use that, but they will be converted to an equals sign. The equals signs tells Excel that you are going to use a formula, so if you started a function without it, the function would be treated like a piece of text.


Where would you use a fill-handle?

You would use it for copying data or formulas in a spreadsheet.