answersLogoWhite

0

📱

Microsoft Excel

Excel is a spreadsheet application developed and distributed by Microsoft Corporation for computers using the Microsoft Windows and Mac OS X operating systems. It features graphing tools, chart wizards, calculations, formatting options, and pivot tables.

9,788 Questions

What happens when you click the Increase Indent button?

The contents of the active cell are indented approximately one character width.

Match the population movement term in column 1 to the definition in column 2.?

Norm: A standard, model, or pattern,

Household: People who live together in a single residence,

Chain migration: Immigrants helping others move to their new country

Adopted children: Children born to parents who are different from the parent(s) raising them

What is the conflict in six rows of pompons?

Tatsuo learns how to weed, water, and tend to his flowers but he often forgets to take care of them

How do you break Excel page into 4 panes?

Use the split option. This can be on the found on the Window menu. Wherever the active cell is a the time the vertical split will be to the left of it and the horizontal split will be above it. Another way is to drag a split onto the worksheet. Just above the vertical scroll bar is a narrow rectangle. If you put the mouse over it the pointer will change into a double headed arrow. You can then drag down onto the worksheet to create a horizontal split. You will find a similar thing can be done with a narrow rectangle at the right end of the horizontal scroll bar. Double clicking on the split or dragging it off will remove it.

Use the split option. This can be on the found on the Window menu. Wherever the active cell is a the time the vertical split will be to the left of it and the horizontal split will be above it. Another way is to drag a split onto the worksheet. Just above the vertical scroll bar is a narrow rectangle. If you put the mouse over it the pointer will change into a double headed arrow. You can then drag down onto the worksheet to create a horizontal split. You will find a similar thing can be done with a narrow rectangle at the right end of the horizontal scroll bar. Double clicking on the split or dragging it off will remove it.

Use the split option. This can be on the found on the Window menu. Wherever the active cell is a the time the vertical split will be to the left of it and the horizontal split will be above it. Another way is to drag a split onto the worksheet. Just above the vertical scroll bar is a narrow rectangle. If you put the mouse over it the pointer will change into a double headed arrow. You can then drag down onto the worksheet to create a horizontal split. You will find a similar thing can be done with a narrow rectangle at the right end of the horizontal scroll bar. Double clicking on the split or dragging it off will remove it.

Use the split option. This can be on the found on the Window menu. Wherever the active cell is a the time the vertical split will be to the left of it and the horizontal split will be above it. Another way is to drag a split onto the worksheet. Just above the vertical scroll bar is a narrow rectangle. If you put the mouse over it the pointer will change into a double headed arrow. You can then drag down onto the worksheet to create a horizontal split. You will find a similar thing can be done with a narrow rectangle at the right end of the horizontal scroll bar. Double clicking on the split or dragging it off will remove it.

Use the split option. This can be on the found on the Window menu. Wherever the active cell is a the time the vertical split will be to the left of it and the horizontal split will be above it. Another way is to drag a split onto the worksheet. Just above the vertical scroll bar is a narrow rectangle. If you put the mouse over it the pointer will change into a double headed arrow. You can then drag down onto the worksheet to create a horizontal split. You will find a similar thing can be done with a narrow rectangle at the right end of the horizontal scroll bar. Double clicking on the split or dragging it off will remove it.

Use the split option. This can be on the found on the Window menu. Wherever the active cell is a the time the vertical split will be to the left of it and the horizontal split will be above it. Another way is to drag a split onto the worksheet. Just above the vertical scroll bar is a narrow rectangle. If you put the mouse over it the pointer will change into a double headed arrow. You can then drag down onto the worksheet to create a horizontal split. You will find a similar thing can be done with a narrow rectangle at the right end of the horizontal scroll bar. Double clicking on the split or dragging it off will remove it.

Use the split option. This can be on the found on the Window menu. Wherever the active cell is a the time the vertical split will be to the left of it and the horizontal split will be above it. Another way is to drag a split onto the worksheet. Just above the vertical scroll bar is a narrow rectangle. If you put the mouse over it the pointer will change into a double headed arrow. You can then drag down onto the worksheet to create a horizontal split. You will find a similar thing can be done with a narrow rectangle at the right end of the horizontal scroll bar. Double clicking on the split or dragging it off will remove it.

Use the split option. This can be on the found on the Window menu. Wherever the active cell is a the time the vertical split will be to the left of it and the horizontal split will be above it. Another way is to drag a split onto the worksheet. Just above the vertical scroll bar is a narrow rectangle. If you put the mouse over it the pointer will change into a double headed arrow. You can then drag down onto the worksheet to create a horizontal split. You will find a similar thing can be done with a narrow rectangle at the right end of the horizontal scroll bar. Double clicking on the split or dragging it off will remove it.

Use the split option. This can be on the found on the Window menu. Wherever the active cell is a the time the vertical split will be to the left of it and the horizontal split will be above it. Another way is to drag a split onto the worksheet. Just above the vertical scroll bar is a narrow rectangle. If you put the mouse over it the pointer will change into a double headed arrow. You can then drag down onto the worksheet to create a horizontal split. You will find a similar thing can be done with a narrow rectangle at the right end of the horizontal scroll bar. Double clicking on the split or dragging it off will remove it.

Use the split option. This can be on the found on the Window menu. Wherever the active cell is a the time the vertical split will be to the left of it and the horizontal split will be above it. Another way is to drag a split onto the worksheet. Just above the vertical scroll bar is a narrow rectangle. If you put the mouse over it the pointer will change into a double headed arrow. You can then drag down onto the worksheet to create a horizontal split. You will find a similar thing can be done with a narrow rectangle at the right end of the horizontal scroll bar. Double clicking on the split or dragging it off will remove it.

Use the split option. This can be on the found on the Window menu. Wherever the active cell is a the time the vertical split will be to the left of it and the horizontal split will be above it. Another way is to drag a split onto the worksheet. Just above the vertical scroll bar is a narrow rectangle. If you put the mouse over it the pointer will change into a double headed arrow. You can then drag down onto the worksheet to create a horizontal split. You will find a similar thing can be done with a narrow rectangle at the right end of the horizontal scroll bar. Double clicking on the split or dragging it off will remove it.

How do you insert brackets in cells?

To insert a bracket in a cell, you just press the [ or ] key.

If you are trying to enter braces { or } (usually Shift-[ and Shift-]) to indicate an array formula, you use a special procedure:

  1. Type your array formula in a cell.
  2. Press CTRL+SHIFT+ENTER.
  3. If you edit the formula, you need to press Press CTRL+SHIFT+ENTER again to let Excel know you want an array formula.

How do you denoted 12th row and 10th column in Excel?

12 is the twelfth row and J is the tenth column. The cell address J12 is where the two meet.

Is the backslash a concatenation character in Excel?

No. You use the & as the concatenation character in a formula. The following will add the two pieces of text together resulting in one piece of text:

="Hello " & "World"

How do you print a graph paper in Excel or word?

In Excel, you can set the column width to 2 and display borders around the cells of the number of cells you would like to display on your graph paper, then print.

What are the characters that a number can contain?

A number itself can only contain the 10 digits and a decimal point and a minus sign to indicate if it is negative or a plus sign for positive, though it is usually not shown. After that there are formatting symbols like a £ or a $ but they are not part of the number itself as such.

What term best describes what vlookup function does?

It is a complicated function, but the simplest term is probably a Search function. However that is far too simple a description and does not give its full description and show what it is capable of doing.

What is an active cell?

In a spreadsheet application, it is the cell that has focus and that input can be made.

The cell with the bold boundary is the active cell.

When argument are passed by value the function works with the original arguments in the calling program?

When a function is passed by value the calling function makes a copy of the passed argument and works on that copy. And that's the reason that any changes made in the argument value does gets reflected to the caller.

List the keys used to move from one cell to another in a worksheet?

You can use any of the arrow keys. You can use the Tab key. You can use the Enter key. You can use the Page Up and Page Down keys. You can use the Home and End keys, in conjunction with the Ctrl and Shift keys. You can use the F5 key to go to a specific cell.

How do you solve a row of numbers from one to nine for total of each row equal 15?

I think what you're looking for is the 3 x 3 "magic square".

It looks like this:

[ 8 ] [ 1 ] [ 6 ]

[ 3 ] [ 5 ] [ 7 ]

[ 4 ] [ 9 ] [ 2 ]

Every row, column, and diagonal adds up to 15.