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
How do you use the REPT function in Microsoft Excel?
The REPT function repeats a piece of text a set amount of times.
=REPT("A",4)
The above function will repeat the A four times. The result would be:
AAAA
What are smart icons in Microsoft Excel?
They show up occasionally when you perform certain functions, such as creating forms. When you click on the icon down arrow you see options in a pop-up list.
What is a web query when using Microsoft excell?
It is a way of bringing data direct into your spreadsheet from a website. The typical example is bringing in financial information like share prices or currency exchange rates, to be used in the spreadsheet. It is important that the prices and rates are always correct, so by linking to a website, the data can be kept up to date.
What button will not select a cell in a document?
This question does not make sense. One answer is that the Shift Key will not select a cell in a document.
What chart do you use for a set of data in-Excel?
That depends on what you want to show from your data. There is a number of different types of chart that you can use, even for just one particular set of data. Each situation is different, so it up to you what chart you want. Some charts only suit certain types of data, like X Y charts or Pie Charts.
How can you quickly switch between the worksheets in a workbook?
The Ctrl - Page Up and Ctrl - Page Down key combinations will switch between worksheets in a workbook.
The Ctrl - Page Up and Ctrl - Page Down key combinations will switch between worksheets in a workbook.
The Ctrl - Page Up and Ctrl - Page Down key combinations will switch between worksheets in a workbook.
The Ctrl - Page Up and Ctrl - Page Down key combinations will switch between worksheets in a workbook.
The Ctrl - Page Up and Ctrl - Page Down key combinations will switch between worksheets in a workbook.
The Ctrl - Page Up and Ctrl - Page Down key combinations will switch between worksheets in a workbook.
The Ctrl - Page Up and Ctrl - Page Down key combinations will switch between worksheets in a workbook.
The Ctrl - Page Up and Ctrl - Page Down key combinations will switch between worksheets in a workbook.
The Ctrl - Page Up and Ctrl - Page Down key combinations will switch between worksheets in a workbook.
The Ctrl - Page Up and Ctrl - Page Down key combinations will switch between worksheets in a workbook.
The Ctrl - Page Up and Ctrl - Page Down key combinations will switch between worksheets in a workbook.
How do I populate cells in one Excel worksheet into another based on conditional data?
You just need to be able to reference the other sheet, which you do with the sheet name, an exclamation mark and a cell reference. So in a cell on Sheet2, you could have a formula referencing cell A3 on Sheet1 that could be something like:
=IF(Sheet1!A3>50, "Over 50","50 or Less")
What is the use of drawing in Microsoft Excel?
There are often occasions when you want to draw things on a worksheet, like an arrow pointing to a particular figure, doing diagrams on a worksheet, drawing shapes around things, and many other uses.
How can you limit a specific range name to a particular worksheet in the workbook in Excel?
Set the scope to a named range.
What are the areas of a pivot table report where fields can be placed?
They can be put into Filters, Rows, Columns and Values. Only numerical fields can be put into the Values area.
Why is A1 in Excel called the home cell?
Because it identifies the cell in the top left corner of the worksheet. By definition, this is called the Home Cell.
Divide the total value into the amount you want to get a percentage for. So if you want to find out what percent 3 is out of 20, then you divide 3 by 20 and format it as a percentage. If you want to find what percentage both 3 and 20 are of 23, you will be dividing each number by 23. In terms of Excel, you would use cell references rather than direct values where possible. So if the 3 was in cell B2 and the 20 in B3, then to divide the 3 by 20, your formula would be:
=B2/B3
The other percentages could be done the same way, using the appropriate cells. You could have the 23 in cell B4 by doing the calculation:
=B2+B3
How do you see how many cells are selected in Excel?
As you are selecting them, in the Name box it will show you the amount of rows and columns being selected, 5R x 6C for 5 rows and 6 columns. You can then work out how many cells are selected, in this case it was 30. You can also see the Count on the status bar, but that won't count cells that are blank.
