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 is a link in Excel?

A link in Excel can be like a link on a webpage. By clicking on it, it can enable you to jump to different parts of the worksheet, different parts of the workbook, to a different workbook, to another kind of file and to a webpage.

Another type of link is where data in one workbook is linked to data in another workbook or other kind of document. When data is updated in one, it will also change in the other document, as it is looking at data it is linked to.

What is the formula for - tell cell B that if cell A empty leave cell B blank and if cell A is greater than 1 make cell B say Hours?

Your formula is not complete as you do not say what happens if the A cell contains 1 and is therefore not bland and not over 1. Using cells A2 and B2 the formula would be put into cell B2 and would be:

=IF(A2="","",IF(A2>1,"Hours",""))

How do you calculate current position of the planets using Microsoft Excel?

You would need to know a lot about astronomy and the ways the planets are arranged and how they move. That would be your starting point. That would be quite complex. Once you have those calculations, then it could be done in Excel. However the planets are constantly moving, and all at different speeds and taking different amounts of time to orbit the Sun and having various quirks into their movements.

You would need to know a lot about astronomy and the ways the planets are arranged and how they move. That would be your starting point. That would be quite complex. Once you have those calculations, then it could be done in Excel. However the planets are constantly moving, and all at different speeds and taking different amounts of time to orbit the Sun and having various quirks into their movements.

You would need to know a lot about astronomy and the ways the planets are arranged and how they move. That would be your starting point. That would be quite complex. Once you have those calculations, then it could be done in Excel. However the planets are constantly moving, and all at different speeds and taking different amounts of time to orbit the Sun and having various quirks into their movements.

You would need to know a lot about astronomy and the ways the planets are arranged and how they move. That would be your starting point. That would be quite complex. Once you have those calculations, then it could be done in Excel. However the planets are constantly moving, and all at different speeds and taking different amounts of time to orbit the Sun and having various quirks into their movements.

You would need to know a lot about astronomy and the ways the planets are arranged and how they move. That would be your starting point. That would be quite complex. Once you have those calculations, then it could be done in Excel. However the planets are constantly moving, and all at different speeds and taking different amounts of time to orbit the Sun and having various quirks into their movements.

You would need to know a lot about astronomy and the ways the planets are arranged and how they move. That would be your starting point. That would be quite complex. Once you have those calculations, then it could be done in Excel. However the planets are constantly moving, and all at different speeds and taking different amounts of time to orbit the Sun and having various quirks into their movements.

You would need to know a lot about astronomy and the ways the planets are arranged and how they move. That would be your starting point. That would be quite complex. Once you have those calculations, then it could be done in Excel. However the planets are constantly moving, and all at different speeds and taking different amounts of time to orbit the Sun and having various quirks into their movements.

You would need to know a lot about astronomy and the ways the planets are arranged and how they move. That would be your starting point. That would be quite complex. Once you have those calculations, then it could be done in Excel. However the planets are constantly moving, and all at different speeds and taking different amounts of time to orbit the Sun and having various quirks into their movements.

You would need to know a lot about astronomy and the ways the planets are arranged and how they move. That would be your starting point. That would be quite complex. Once you have those calculations, then it could be done in Excel. However the planets are constantly moving, and all at different speeds and taking different amounts of time to orbit the Sun and having various quirks into their movements.

You would need to know a lot about astronomy and the ways the planets are arranged and how they move. That would be your starting point. That would be quite complex. Once you have those calculations, then it could be done in Excel. However the planets are constantly moving, and all at different speeds and taking different amounts of time to orbit the Sun and having various quirks into their movements.

You would need to know a lot about astronomy and the ways the planets are arranged and how they move. That would be your starting point. That would be quite complex. Once you have those calculations, then it could be done in Excel. However the planets are constantly moving, and all at different speeds and taking different amounts of time to orbit the Sun and having various quirks into their movements.

How do you make a spreadsheet with text and numeric data?

Every spreadsheet is different. So what you do will depend on what the spreadsheet is required to do. You will type your text and numbers into cells and then add in other elements, such as formulas or charts. You can format your text and numeric data as appropriate to the spreadsheet you are creating.

What key quits range finder?

The Escape key, which sometimes just has Esc on it.

Whenever I save Excel or Word files it goes to the My Documents folder by default how do I make it go to the D drive sub folder?

In Excel, go to Tools, Options and select the General Tab. There is a place to change the default location to what ever location you wish. In Word, go to Tools, Options and select the File Locations Tab. You can highlight the document line, select Modify and change to the place you wish to be the default.

What key do use to insert current time in a worksheet cell?

Ctrl - shift and the colon key. So it would be Ctrl - Shift - :

Without the Shift it will give you the current date.

What provides the ability to perform a statistical analysis in Excel?

Excel is a spreadsheet and a spreadsheet is a tool for doing numerical analysis and manipulation. So Excel and any other spreadsheet application are ideal for doing statistical analysis. Excel has a huge range of ways of doing statistical analysis. It can be done through simple formulas, like totalling things up. It can be done with the specialised built-in statistical functions. It can be done by using a range of charts. There are lots of other special facilities too.

How are pages combined to be printed?

I am not sure what you mean by combining pages, but you usually would format the print option in the software or select special formatting options in the printer setup box.

What does lithotripsy treat?

Lithotripsy is the use of high-energy shock waves to fragment and disintegrate kidney stones.

What is pane tree?

tree pane is a portion of windows explorer that shows all drives and sub drives

How do you create more slots in the if function on Excel?

You could use more IF functions, stringing them together or nesting them, which means put If functions inside other IF functions. You could also include other functions within the IF, like the AND function. It all depends on specifically what it is you are actually trying to do. There are different solutions for each problem. See more details about the IF function, including examples of nested IFs in the question below.

What theme is applied to a chart when it is copied from Excel and pasted into Word?

by default what themes is applied to a chart when it is copies from excel and pasted into word

How do you move the cell pointer to the lower right corner of the worksheet with a single action?

Using Ctrl-End will bring you to the lower right corner of the active area of the worksheet. It will put the cursor in the cell which is on the lowest row furthest right column. So if the last row you had something in was row 129 and the last column you had something in was column T, Ctrl-End would bring you toe cell T129. There would not necessarily be anything in that cell, but it is the cell in the last row and last column that there is data in.

Using Ctrl-End will bring you to the lower right corner of the active area of the worksheet. It will put the cursor in the cell which is on the lowest row furthest right column. So if the last row you had something in was row 129 and the last column you had something in was column T, Ctrl-End would bring you toe cell T129. There would not necessarily be anything in that cell, but it is the cell in the last row and last column that there is data in.

Using Ctrl-End will bring you to the lower right corner of the active area of the worksheet. It will put the cursor in the cell which is on the lowest row furthest right column. So if the last row you had something in was row 129 and the last column you had something in was column T, Ctrl-End would bring you toe cell T129. There would not necessarily be anything in that cell, but it is the cell in the last row and last column that there is data in.

Using Ctrl-End will bring you to the lower right corner of the active area of the worksheet. It will put the cursor in the cell which is on the lowest row furthest right column. So if the last row you had something in was row 129 and the last column you had something in was column T, Ctrl-End would bring you toe cell T129. There would not necessarily be anything in that cell, but it is the cell in the last row and last column that there is data in.

Using Ctrl-End will bring you to the lower right corner of the active area of the worksheet. It will put the cursor in the cell which is on the lowest row furthest right column. So if the last row you had something in was row 129 and the last column you had something in was column T, Ctrl-End would bring you toe cell T129. There would not necessarily be anything in that cell, but it is the cell in the last row and last column that there is data in.

Using Ctrl-End will bring you to the lower right corner of the active area of the worksheet. It will put the cursor in the cell which is on the lowest row furthest right column. So if the last row you had something in was row 129 and the last column you had something in was column T, Ctrl-End would bring you toe cell T129. There would not necessarily be anything in that cell, but it is the cell in the last row and last column that there is data in.

Using Ctrl-End will bring you to the lower right corner of the active area of the worksheet. It will put the cursor in the cell which is on the lowest row furthest right column. So if the last row you had something in was row 129 and the last column you had something in was column T, Ctrl-End would bring you toe cell T129. There would not necessarily be anything in that cell, but it is the cell in the last row and last column that there is data in.

Using Ctrl-End will bring you to the lower right corner of the active area of the worksheet. It will put the cursor in the cell which is on the lowest row furthest right column. So if the last row you had something in was row 129 and the last column you had something in was column T, Ctrl-End would bring you toe cell T129. There would not necessarily be anything in that cell, but it is the cell in the last row and last column that there is data in.

Using Ctrl-End will bring you to the lower right corner of the active area of the worksheet. It will put the cursor in the cell which is on the lowest row furthest right column. So if the last row you had something in was row 129 and the last column you had something in was column T, Ctrl-End would bring you toe cell T129. There would not necessarily be anything in that cell, but it is the cell in the last row and last column that there is data in.

Using Ctrl-End will bring you to the lower right corner of the active area of the worksheet. It will put the cursor in the cell which is on the lowest row furthest right column. So if the last row you had something in was row 129 and the last column you had something in was column T, Ctrl-End would bring you toe cell T129. There would not necessarily be anything in that cell, but it is the cell in the last row and last column that there is data in.

Using Ctrl-End will bring you to the lower right corner of the active area of the worksheet. It will put the cursor in the cell which is on the lowest row furthest right column. So if the last row you had something in was row 129 and the last column you had something in was column T, Ctrl-End would bring you toe cell T129. There would not necessarily be anything in that cell, but it is the cell in the last row and last column that there is data in.

How can a Gantt chart template be used?

A Gantt chart template can be used alongside software such as Microsoft Excel to present data and charts in the Gantt chart format. Microsoft Excel does not include the Gantt chart format by default.

What displays information about selected data including the number of cells?

As you select cells, the number of rows and columns being selected is shown in the Name box. Once you have finished selecting, the address of the active cell or of the range will show with those cells selected. On the status bar you will see the total of any values in the cells. This can be a quick way to see what the total of values in cells are, without using a formula. It is also possible to see other things, like the average.

What is a columns in excel?

A column in Excel is the vertical (up and down) list of cells. You can think of columns the same as columns on a building that go from the top to bottom of a spreadsheet. The horizontal direction (e.g., left to right) is called a row.
A row of numbers or data will go along from left to right, while a column will go from top to bottom (vertically).