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 do you use to clear results on Excel?
Highlight them and press the Delete key.
Highlight them and press the Delete key.
Highlight them and press the Delete key.
Highlight them and press the Delete key.
Highlight them and press the Delete key.
Highlight them and press the Delete key.
Highlight them and press the Delete key.
Highlight them and press the Delete key.
Highlight them and press the Delete key.
Highlight them and press the Delete key.
Highlight them and press the Delete key.
What group on the home tab contains options for changing a paragraph's alignment?
Click on Format then paragraph. The menu box will be easy to follow to do what you want
If you have a set dollar goal to reach and a set dollar amount that you can contribute, then I think I can help.
There's a function in Excel called NPER. It stands for number of periods. It will give you the total number of periods, which is essential for time value of money. Click on Insert at the top of the screen and a drop down appears. Then click on Function and choose all, and scroll for NPER, it should explain everything to you. Once you have the number of periods via the formula, you must manually multiply that by the dollar amount of the payments which you'll be making.
Tell me the answer you get so we can do a reasonable-ness test.
How can you tell your current position in a worksheet?
The cell reference will be in the top left of the spreadsheet, showing what cell is the currently active cell. Also, the column heading and row heading are highlighted.
Why do you use the formatting toolbar?
The fomatting toolbar appears in many applications. It is a toolbar that has the icons that provide the various formatting settings for data in your applicaion. For example, it can allow you to change the colours items. It allows you to change fonts. It allows you to set the alignment text or numbers. It allows you apply borders. It allows you to change the format of numbers, like adjusting the amount of decimals they have or changing them to percentage format. It can change indentation. It allows you to apply bolding, italics and underlines to data. There are some variations on the formatting toolbar between different applications, because the different applications do different things. However, many facilities appear as standard on all of them.
What button is used to merge cells so that you can position the table title across the columns?
The Merge and Center button.
What is the code for the lower case letters?
=Lower(text)
Where text is either the direct text "Like This", or the individual cell reference you wish to correct the case of.
Similar functions:
=Upper(text)
=Proper(text)
Can you alphabetize playlists in rhapsody?
Hold ctrl and shift and click on the title header of the column to be sorted. Repeat to reverse order.
How do I format cell G5 using the accounting number format?
First you need to select cell G5. Clicking on it will do that. The go to the number formatting options. You can do that pressing the Ctrl - 1 key combination. Choose the Accounting format and click the OK button.
When integrating Word and Excel Word is usually?
Word normally hosts data from Excel. It can display charts that are linked from Excel and will show data from Excel in tables in Word. A Paste Link can be set up, so that if the data changed in the Excel document, it will also change in the Word document.
They make it very easy to represent values in a range of cells, by representing each value by a bar. A longer bar represents a higher value. They are like bars in a bar chart, except that they are contained in a cell. They can be of different colours and they can be shaded.
What is a validation list in Excel?
As part of validating data, you can set up lists of valid data from which a value can be chosen. These are knowns as validations lists. You may want to have a list of regions from which one can be be used to put into a cell. You create the list by putting the values into a set of cells. Then, choosing the Data Validation option, you choose "List" in the validation criteria. Then you can specify the cells that you want to use as the list. When the process is complete, when you click into the cell you've validated, you'll get a drop list of values to choose from.
Can an existing database be recalibrated when you start Excel?
All formulas recalculate when Excel opens, so if a database in Excel has formulas in it, it will be recalibrated. It could also be linked to another file or external source which may make it change when it is opened.
How do you move multiple numbers to different cells on your spreadsheet?
Highlight the numbers you want to move, then cut and paste to the location where you would like them displayed.
After mail merge can you break the document into different files?
Yes, you can save to as many different files as you like. If you would like to save half of the file to file one and the second half of the file to file two, there are several ways you can do this. My preferred method is to copy the original file to as many files as you like (just give the files different names). Then, for each file, delete whatever you do not want to save in that file. This method may take a little longer than cutting and pasting to multiple files, but it is the best way to recover from mistakes (at least until you delete content in the final file).
What is the importance of being able to apply the graph on a spreadsheet?
They give a visual representation of the data, so they can be useful as a way of interpreting the data.
What is replicating a formula in Excel?
Replicating means copying. So replicating a formula in Excel is copying a formula. This is a very common activity that is done in Excel. You create one formula and then use it in other places on the worksheet.
Write down the 3 different formulae of MS-Excel?
There are a lot more that 3 different formulas in Excel. The amount of formulas that can be done is limitless.
How do you put a speech bubble in excel?
If you go to Insert Shapes and the Callouts group, you will find the speech bubble. It can then be clicked on and then you draw it out onto the worksheet.
If you go to Insert Shapes and the Callouts group, you will find the speech bubble. It can then be clicked on and then you draw it out onto the worksheet.
If you go to Insert Shapes and the Callouts group, you will find the speech bubble. It can then be clicked on and then you draw it out onto the worksheet.
If you go to Insert Shapes and the Callouts group, you will find the speech bubble. It can then be clicked on and then you draw it out onto the worksheet.
If you go to Insert Shapes and the Callouts group, you will find the speech bubble. It can then be clicked on and then you draw it out onto the worksheet.
If you go to Insert Shapes and the Callouts group, you will find the speech bubble. It can then be clicked on and then you draw it out onto the worksheet.
If you go to Insert Shapes and the Callouts group, you will find the speech bubble. It can then be clicked on and then you draw it out onto the worksheet.
If you go to Insert Shapes and the Callouts group, you will find the speech bubble. It can then be clicked on and then you draw it out onto the worksheet.
If you go to Insert Shapes and the Callouts group, you will find the speech bubble. It can then be clicked on and then you draw it out onto the worksheet.
If you go to Insert Shapes and the Callouts group, you will find the speech bubble. It can then be clicked on and then you draw it out onto the worksheet.
If you go to Insert Shapes and the Callouts group, you will find the speech bubble. It can then be clicked on and then you draw it out onto the worksheet.
How do you use worksheet function to fill the selected cell with the largest value?
Each program has its own formula, one should look for the tutorial on the program one is using in order to know the correct way for each separate program.
What is the difference between currency style in Excel comma style and accounting style in excel?
Accounting format align all the currency symbols at the left edge of the cell while Currency format align all the currency symbols them next to the number. Accounting shows a dash for zero value, Currency shows an actual zero. The actual difference is
Currency has: #,##0.00_);(#,##0.00)
Accounting has: _(* #,##0.00_);_(* (#,##0.00);_(* "-"??_);_(@_)
; SANJAY KISHORE
What is the unique name assigned to a cell in Excel?
The cell address uniquely identifies each cell, based or the column letter and row number. Cell F58 is the cell where column F and row 58 meet for example. Cells can also be given individual names to make them easy to use in formulas. A name can also be applied to a range of cells.
Copy the information from the one word document by right clicking and clicking copy and paste it into the other by right clicking where you would like the information to go and click paste. Don't do it, you'll make the file crash!!! If you have large files (i.e. 5 Mb +) I would suggest you don't join them until you absolutely have to. It will cause you problems. Word is not made to handle large documents.
