0
Enter one set of numbers in a column and another set of numbers in a row at the top of that column, so that the numbers you want to multiply intersect at a column and row.
EXAMPLE:
In A2 enter 2.
In B1 enter 3.
In B2 enter =A2*B1 (observe the answer 6)
TIP: If you want to be able to enter the formula only in the first intersecting cell of the row, then copy the formula to all the rest of the cells in the row, use the formula =$A$2*B1. That will make A2 and absolute reference that will not change as you copy the formula to other cells in the row, but will automatically update B1 to C1, D1, etc.
What else can I help you with?
What is the use of time table in Microsoft Excel?
You can make a time table in Excel to show schedules of many things (trains, airplanes, etc.).
Can you make a program in Microsoft excel?
I think you can.
How do you make a table of values and then graph the data?
use microsoft office excel ..!! tabulate the date and select the type of graph u want to plot :)
How to make table in excel-?
Here is a video tutorial http://www.videojug.com/film/how-to-create-tables-in-excel on how to make a table in Excel.
How do you use Excel for typing Microsoft Word?
Excel and Microsoft word are two different programs. To ask how to you use excel for typing ms word does not make sense
What make is an excel?
It is a spreadsheet application published by Microsoft.
How do I make a weekly workout schedule?
You can make a weekly workout schedule by using Microsoft excel to make a table and then inserting in your weekly routine to make it all organized. Print it and paste it onto your wall.
How is a scatter chart used in Microsoft Excel?
frst make a table. then highlight it. click insert at the top of the page. there will be a selection of graphs. choose scatter plot.
How do you make graphs charts and tables?
Use Microsoft Excel.
How do you make a file in Microsoft Excel?
click SAVE or SAVEAS
How do you make a timeline in openoffice?
you can't...use Microsoft excel.
Does Microsoft Excel Apply to you?
Microsoft Excel can be used by anyone. It is a very versatile application with many uses, so anybody can make use of it, from business people to a child.
