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")
Wiki User
∙ 11y ago
Add your answer:
Earn +20 pts
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 are the symbols used for dividing and multiplying in a spreadsheet?
the multiple symbol is a little star which can be found on the number 8 and the divide symbol is the forward slash which can be also found on the ? key
What symbol would you use to add up two numbers in a spreadsheet?
The plus symbol: +
What does forward slash symbol mean on a spreadsheet?
It can be used for division. So the following formula will divide the value in A3 by the value in A10: =A3/A10
Which is spreadsheet package lotus Excel or quattro pro?
All three can be used as a spreadsheet. Excel is the most well known one.All three can be used as a spreadsheet. Excel is the most well known one.All three can be used as a spreadsheet. Excel is the most well known one.All three can be used as a spreadsheet. Excel is the most well known one.All three can be used as a spreadsheet. Excel is the most well known one.All three can be used as a spreadsheet. Excel is the most well known one.All three can be used as a spreadsheet. Excel is the most well known one.All three can be used as a spreadsheet. Excel is the most well known one.All three can be used as a spreadsheet. Excel is the most well known one.All three can be used as a spreadsheet. Excel is the most well known one.All three can be used as a spreadsheet. Excel is the most well known one.
What is the symbol you must enter first when creating a formula in a spreadsheet?
The equal sign(; ( = )
What symbol do you use on a spreadsheet when you want to add sets of numbers together?
a comma
What is the difference of Microsoft Excel from lotus 123?
One is a spreadsheet program made by Lotus the other is a spreadsheet program made by Microsoft. The main difference is the way in which formulas are entered - in Excel they are preceded by the = symbol and in 1-2-3 they are preceded by the + symbol.
Is a spreadsheet program used primarily to print letters?
A spreadsheet could in theory be used to write letters, but it is a job best done with a word processor, so a spreadsheet would not be used to write letters.
What does mean spreadsheet?
A spreadsheet means a computer application that is used to simulate paper accounting.
What is a feature used to add identifying information to a spreadsheet?
the feature used to add identifying information to a spreadsheet is a Header-Footer.
What symbol to use when subtract a number in Microsoft Excel 2010?
You would use a - to subtract a number on a spreadsheet
