0
Want this question answered?
Be notified when an answer is posted
Add your answer:
Earn +20 pts
How do make an times table on Microsoft Excel?
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 type of entry does Excel assume you are?
Excel assumes data is text initially, but can treat it differently depending on the way you enter it. That is why you enter an equals sign at the beginning of a formula to indicate to Excel that you are creating a formula.
Where does excel display the data as you enter it?
in the cell and in the formula bar
What is it called where excel displays data as you enter it?
formula bar
What is the area of the excel window in which you enter and edit data?
cell or formula bar!
How do you enter data in Excel and what do you call the place formed by the intersection of a row and column?
Where a row and column intersect is a cell. To enter data into a cell, first select it and then type in what you want in the cell. Finally, press enter.
When you enter a formula in a cell Excel assigns the cell the same format as the cell reference in the formula?
first
How do you number your rows in Excel?
To number your rows in Excel, put a '1' in the first row, for instance in cell a1, the formula '=a1+1' in the second row, and then copy that formula to each additional row you want to number. Be careful, though, as inserting and deleting rows will mess the sequence up, and you will need to fix it as needed.
How do you enter an array formula?
After you enter your formula, press CTRL+SHIFT+ENTER at the same time. You will see the array formula displayed with brackets ({}) around it. If you type the same text, including the brackets and press just ENTER, you will not tell Excel the formula is an array and may display only text. You need to enter the formula, without the brackets, and press CTRL+SHIFT+ENTER to let Excel know it is an array. See related links for more details about array formulas.
What is a formula bar used for in Excel?
To enter the formula in selected cell, To view the farmula or content of selected cell.
What is the formula for selecting the lowest or highest value from a row of numbers in a spreadsheet?
There is no single formula. MIN(range) and MAX(range) are the Excel formulae
Where is the enter box in Excel?
The Enter box is the green tick that appears beside the formula bar when you are entering or editing a cell.
