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 the difference between incomplete and delinquent chart?

a incomplete chart is a chart that is missing patient information and a delinquent chart is a chart that has been signed off on by a physician but is not complete and is missing documents and patient information.

Which icon allows you to insert the sum of a list of numbers on excel?

Google the image of a capital sigma. It is a greek letter that looks similar to an E. it is black in colour

To create a sine function with Excel?

The function is =Sin(). Inside the brackets put the value you want to find the sine for. So if you want the sine of 10°, then you would put the formula as follows:

=SIN(10)

There is no need to use the ° symbol. You could just put the value into a cell and use the the cell reference. You could have the 10 in cell A3 and in some other cell have:

=SIN(A3)

What function rounds a number up or down to the number of digits indicated in the function?

Try the ROUND function.

ROUND(number,num_digits)

For example,

=ROUND(101.52,-1) yields: 100

=ROUND(101.52,0) yields: 102

=ROUND(101.52,1) yields: 101.5

In Excel 2011 which two keys can you use to move quickly to the furthermost right column?

You can use the Ctrl key and the right arrow key to move across blocks of data and to the right end.

You can use the Ctrl key and the right arrow key to move across blocks of data and to the right end.

You can use the Ctrl key and the right arrow key to move across blocks of data and to the right end.

You can use the Ctrl key and the right arrow key to move across blocks of data and to the right end.

You can use the Ctrl key and the right arrow key to move across blocks of data and to the right end.

You can use the Ctrl key and the right arrow key to move across blocks of data and to the right end.

You can use the Ctrl key and the right arrow key to move across blocks of data and to the right end.

You can use the Ctrl key and the right arrow key to move across blocks of data and to the right end.

You can use the Ctrl key and the right arrow key to move across blocks of data and to the right end.

You can use the Ctrl key and the right arrow key to move across blocks of data and to the right end.

You can use the Ctrl key and the right arrow key to move across blocks of data and to the right end.

Which command ensures that header rows and columns remain visible when a worksheet is scrolled?

Using Freeze Panes is the best way. Before implementing it, put the cursor in the cell that is in the row below the rows you want to freeze and in the column to the right of the ones that you want to keep. You could also use the Split option but that is not really what it is for as the window with the headings in it could also be scrolled, though you can scroll other windows independently, so Freeze Panes is the proper way to do it.

How do you calculate sharpe ratio in Excel?

The related link provides an excel template and some notes on how to calculate the sharpe ratio..pretty simple and effective.

When did Dbget arrive in excel?

You may be referring to DGET, which has been in Excel since version 2000.

How do you know that a table has been filtered in Excel?

You will notice some row headings missing on the left. Your table will be shorter. The drop down arrows at the top of the column will have changed to blue.

Is spreadsheet a document?

Any printed item can be called a document. Usually, related to computer applications, a document referrs to a word processing output, while a spreadsheet referrs to output from a spreadsheet program, like MS Excel.

How to set up whole column with same formula?

Copy from the cell that has the formula you want, then use the Paste Formula option for the cells where you want to copy the formula. The Paste Formula option allows you to retain the original formatting in the target cells.

Can you store Microsoft Excel 2007 page as .xls?

You can save as a .xls file, but that will require you saving it as an older format.

You can save as a .xls file, but that will require you saving it as an older format.

You can save as a .xls file, but that will require you saving it as an older format.

You can save as a .xls file, but that will require you saving it as an older format.

You can save as a .xls file, but that will require you saving it as an older format.

You can save as a .xls file, but that will require you saving it as an older format.

You can save as a .xls file, but that will require you saving it as an older format.

You can save as a .xls file, but that will require you saving it as an older format.

You can save as a .xls file, but that will require you saving it as an older format.

You can save as a .xls file, but that will require you saving it as an older format.

You can save as a .xls file, but that will require you saving it as an older format.

What is the shortcut key to get Autofilter in Excel?

Ctrl+Shift+L (or)

Alt + D + F + F

That will open the Data>filter>autofilter

Display the AutoFilter list for the current column Select the cell that contains the column label, and then press

ALT + DOWN ARROW

Close the AutoFilter list for the current column

ALT + UP ARROW

Select the next item in the AutoFilter list

DOWN ARROW

Select the previous item in the AutoFilter list

UP ARROW

Select the first item (All) in the AutoFilter list

HOME

Select the last item in the AutoFilter list

END

Filter the list by using the selected item in the AutoFilter list

ENTER

How are columns designated?

Columns are designated by letters or combinations of letters. The first is Column A, then B, then C and so on. After Column Z, the next is AA, then AB and so on. Depending on what version of Excel you have, the last column is either Column IV, which is the 256th column, or Column XFD, which is the 16,384th column.

Is it true that the Cell A1 contains 5 and B1 contains 10 What will be the result of the formula?

You have not specified a formula, so it depends on what you are doing. You could be adding them or subtracting them or multiplying them or dividing them or averaging them etc. Without a specific formula, then there is no answer to your question.

Can you replace a formula with its function so it can remain constant?

No but if you replace a constant with a function it will remain a formula

What are 6 types of cell alignment?

There are alignments for both vertical and horizontal. Including them all you would have General, Left, Center, Center across selection, Right, Bottom, Top, Justify, Fill and Distributed.

How do you cube a number on Excel?

You can use the exponentiation operator or the Power function. So if you want to cube the number 2, you could do it in either of the following ways:

=2^3

=POWER(2,3)

You can use the exponentiation operator or the Power function. So if you want to cube the number 2, you could do it in either of the following ways:

=2^3

=POWER(2,3)

You can use the exponentiation operator or the Power function. So if you want to cube the number 2, you could do it in either of the following ways:

=2^3

=POWER(2,3)

You can use the exponentiation operator or the Power function. So if you want to cube the number 2, you could do it in either of the following ways:

=2^3

=POWER(2,3)

You can use the exponentiation operator or the Power function. So if you want to cube the number 2, you could do it in either of the following ways:

=2^3

=POWER(2,3)

You can use the exponentiation operator or the Power function. So if you want to cube the number 2, you could do it in either of the following ways:

=2^3

=POWER(2,3)

You can use the exponentiation operator or the Power function. So if you want to cube the number 2, you could do it in either of the following ways:

=2^3

=POWER(2,3)

You can use the exponentiation operator or the Power function. So if you want to cube the number 2, you could do it in either of the following ways:

=2^3

=POWER(2,3)

You can use the exponentiation operator or the Power function. So if you want to cube the number 2, you could do it in either of the following ways:

=2^3

=POWER(2,3)

You can use the exponentiation operator or the Power function. So if you want to cube the number 2, you could do it in either of the following ways:

=2^3

=POWER(2,3)

You can use the exponentiation operator or the Power function. So if you want to cube the number 2, you could do it in either of the following ways:

=2^3

=POWER(2,3)