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

When using Excel how do you center a cell both horizontally and vertically?

  1. Highlight all the cells across the columns where you want to center the text.
  2. Select cell format and choose alignment, then check merge cells.
  3. Observe that now you have one cell that combines all the highlighted cells.
  4. Type your text and select center.

When a formula is in an active cell the underlying formula is visible in the what Formula Bar or Worksheet or Status bar or Name Box?

If there is a formula in the active cell, then the formula will be displayed in the formula bar and the result of the formula will appear in the cell.

Does Excel come with Windows XP?

No. Windows XP is an operating system. Microsoft Excel is an application. It must be purchased separately. When you buy a computer you could ask to buy a version of Microsoft Office and have it installed on your computer, but it does not come automatically with your computer.

What is text orientation in MS Excel?

It can be related to printing. Portrait orientation means you will print with the long side of the paper on the left and right. Landscape orientation means you will print with the long side of the paper at the top and bottom. That can be done through Page Setup.

Orientation can also be related to the direction data appears in a cell. It is possible to have the data going diagonally by a chosen amount for example. That can be done through the alignment options when formatting a cell.

What does rule mean in spreadsheets?

Rules can be applied to control things in a spreadsheet to affect the data you have. You can have validation rules to make sure the data you enter is more controlled. So you could do something like set a rule that limits what the highest value you can enter is. You can have conditional formatting rules to do things like change the colour of cells for different types of values. If a date is before today you could have it as a different colour than dates after today and have the spreadsheet do this automatically.

What is a smart tag indicator in excel?

The Smart Tag indicator is a purple triangle in the bottom right corner of the cell letting you know a Smart Tag is available. It indicates that Excel can take certain actions on the data; the action depends on what data is in the cell. You can attach smart tags to dates, financial symbols, names, and many more entries.

What can you format using the Number group in Excel's Home tab?

You have the option from a drop down list to choose the various number formats. Directly on the group you are also given buttons for Accounting, Percentage and Comma styles. You also have the buttons to increase and decrease decimal places. You can also expand out the full Number dialog box by clicking on the little arrow in the bottom right corner of the group. So it is possible to do all of the standard number formats including date, time, fraction, scientific, custom, text, currency and special.

What are the different categories of data in Microsoft Excel?

There are lots of data types in Excel. For example: Number, Text, Date, Time, Logical. You can take Number in a broad sense or you can think of numbers in terms different data types like Percentage, Scientific Notation, Currency and others.

In excel the person or persons requesting the worksheet should supply their requirements in a document?

This is not a question--it is a statement. Ask again as a question, so it is clear what you want to know.

What action sets the width of a column to fit the longest entry in the column in Excel?

The auto-fit column width, which you can do by placing the cursor between the border of the column headings of the column you want to widen and the column to its right. You will get a bar with two arrows showing on it and if you then double click, it will widen the column to the appropriate size to fit the widest entry.

What is using the mouse to copy cells?

There are a number of ways of copying cells with the mouse in Excel, so there is no single name that covers all of these methods. You may be referring to when you use the fill handle, which can be called filling or dragging.

There are a number of ways of copying cells with the mouse in Excel, so there is no single name that covers all of these methods. You may be referring to when you use the fill handle, which can be called filling or dragging.

There are a number of ways of copying cells with the mouse in Excel, so there is no single name that covers all of these methods. You may be referring to when you use the fill handle, which can be called filling or dragging.

There are a number of ways of copying cells with the mouse in Excel, so there is no single name that covers all of these methods. You may be referring to when you use the fill handle, which can be called filling or dragging.

There are a number of ways of copying cells with the mouse in Excel, so there is no single name that covers all of these methods. You may be referring to when you use the fill handle, which can be called filling or dragging.

There are a number of ways of copying cells with the mouse in Excel, so there is no single name that covers all of these methods. You may be referring to when you use the fill handle, which can be called filling or dragging.

There are a number of ways of copying cells with the mouse in Excel, so there is no single name that covers all of these methods. You may be referring to when you use the fill handle, which can be called filling or dragging.

There are a number of ways of copying cells with the mouse in Excel, so there is no single name that covers all of these methods. You may be referring to when you use the fill handle, which can be called filling or dragging.

There are a number of ways of copying cells with the mouse in Excel, so there is no single name that covers all of these methods. You may be referring to when you use the fill handle, which can be called filling or dragging.

There are a number of ways of copying cells with the mouse in Excel, so there is no single name that covers all of these methods. You may be referring to when you use the fill handle, which can be called filling or dragging.

There are a number of ways of copying cells with the mouse in Excel, so there is no single name that covers all of these methods. You may be referring to when you use the fill handle, which can be called filling or dragging.

What is a function screentip in excel?

As you enter a function, it puts up tip text to show you the parts of the function that are needed. It helps the user to put the function in, making it easier to use.

As you enter a function, it puts up tip text to show you the parts of the function that are needed. It helps the user to put the function in, making it easier to use.

As you enter a function, it puts up tip text to show you the parts of the function that are needed. It helps the user to put the function in, making it easier to use.

As you enter a function, it puts up tip text to show you the parts of the function that are needed. It helps the user to put the function in, making it easier to use.

As you enter a function, it puts up tip text to show you the parts of the function that are needed. It helps the user to put the function in, making it easier to use.

As you enter a function, it puts up tip text to show you the parts of the function that are needed. It helps the user to put the function in, making it easier to use.

As you enter a function, it puts up tip text to show you the parts of the function that are needed. It helps the user to put the function in, making it easier to use.

As you enter a function, it puts up tip text to show you the parts of the function that are needed. It helps the user to put the function in, making it easier to use.

As you enter a function, it puts up tip text to show you the parts of the function that are needed. It helps the user to put the function in, making it easier to use.

As you enter a function, it puts up tip text to show you the parts of the function that are needed. It helps the user to put the function in, making it easier to use.

As you enter a function, it puts up tip text to show you the parts of the function that are needed. It helps the user to put the function in, making it easier to use.

What are charts in Excel?

In Microsoft Excel charts are used to make a graphical representation of any set of data. Most popular types of charts are bar charts, line charts, pie charts, histograms, tree charts, area charts, cartograms.

How do you enter a fractional value in Excel?

To enter you could type it in as a formula, using the division operator. To enter 6 over 8, you could type:

=6/8


You could also enter the value as a decimal. Whichever way you enter it, to show it as a fraction you would then go to Format cells and pick the Fraction format to display it. From there you have various options as ways to display it.

What is the use of increase decimal in Excel?

This function has to do with the format of a cell and how many decimal places are shown. Applies only to numbers. Keep in mind that the actuall value is unchanged. For example, the number will be rounded if you specify 0 decimal places.

What are two types of cell contents excel?

The cell contents are what is actually typed into a cell. This is not always the same as what is displayed. So you can type a formula into a cell, which would be its contents, and the formula will do a calculation and display a result, which is the cell display. When you look at the cell you would see the result of the formula, but not the formula itself. The cell contents are always displayed on the formula bar. If you just type a number in, then the cell content and cell display can be the same. What you could then do is to format the cell and the number would be displayed in that format.

What does Insert Function mean on Excel?

Insert Function in Excel allows you to enter a function into your worksheet. You can choose your function from different categories fo functions. It will also give you a little help on the function so that you can use it in the correct way.

What type of a database is Microsoft Excel?

Microsoft Office Access uses a database type known as the Microsoft Jet Database Engine. You can learn more about Microsoft Access online from the Wikipedia.

What is a function that is used to count cells with content in range?

COUNTA will count cells with anything in them, whereas COUNT just counts cells with numbers.

Enumerate the parts of Microsoft Excel and Screen and their functions?

For more information on For each loop enumerators (Foreach ADO.NET Schema Rowset Enumerator using Excel Sheets) and programming integration service (SSIS) using C# .Net and VB .Net, please visit the below link: http://www.sqllion.com/2009/06/programming-foreach-loop-container-%e2%80%93-enumerating-excel-sheets/