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

Can I create conditional sheet within a workbook based on a pick-list?

Yes you can. The value you select from your pick list can be put into a cell, with the linked cell value. Then you can use that cell as part of your conditional action. That could be part of Conditional Formatting, using the "Formula Is" setting, or for use in an IF function for a regular formula. It may take a little work to lay it out and get it to work the way you want, but it can be done.

What will excel name a chart saved on a sheet as?

A chart on an existing worksheet is an embedded sheet and has no specific name. A chart on its on sheet is known as a chart sheet and will initially have the name Chart1, with Chart2 for the next one, Chart3 for the next one and so on. These names can be changed by the users.

How do you get the bar chart on Microsoft Excel 2003 to start at 0?

You need to format the axis on the chart. If you click on the axis to select it and then click Format Axis and then on Scale. You can then set the minimum value to 0.

What happened when Excel spreadsheet was established?

Spreadsheets existed before Microsoft Excel. Visicalc was the first one, launched in 1979. The first version of Excel came out in 1985. All that really happened then was that Microsoft now had a spreadsheet application. Microsoft Excel is now the most popularly used of the many spreadsheet applications.

In Microsoft Excel what column do you Make a cell active to insert a new column between E and F?

A new column or row will always go where the active cell is, or in the place of the row(s)/Column(s) selected. So if you want to put a column between column E and column F, the new column will be where column F now is, so you select column F, or put the active cell in it. It is better to have it selected. To do that, either click on the heading of the column, of with the active cell in the column, press and hold the Ctrl key and press the spacebar.

What is a donut chart in Excel?

A doughnut chart is like a pie chart, but has no centre. So it actually looks like a doughnut. Unlike a pie chart, it can deal with more than one series, showing the data groups in concentric circles.

How do you read an Army MAC Chart?

The Army Maintenance System MAC This introduction provides a general explanation of all maintenance and repair functions authorized at various maintenance levels under the standard Army Maintenance System concept. The MAC (immediately following the introduction) designates overall authority and responsibility for the performance of maintenance functions on the identified end item or component. The application of the maintenance functions to the end item or component shall be consistent with the capacities and capabilities of the designated maintenance levels, which are shown on the MAC in column (4) as: Unit - includes two subcolumns, C (operator/crew) and O (unit) maintenance. Direct Support - includes an F subcolumn. General Support - includes an H subcolumn. Depot - includes a D subcolumn. The tools and test equipment requirements (immediately following the MAC) list the tools and test equipment (both special tools and common tool sets) required for each maintenance function as referenced from the MAC. The remarks (immediately following the tools and test equipment requirements) contain supplemental instructions and explanatory notes for a particular maintenance function. Maintenance Functions Maintenance functions are limited to and are defined as follows: 1. Inspect. To determine the serviceability of an item by comparing its physical, mechanical, and/or electrical characteristics with established standards through examination (e.g., by sight, sound, or feel.) 2. Test. To verify serviceability by measuring the mechanical, pneumatic, hydraulic, or electrical characteristics of an item and comparing those characteristics with prescribed standards. 3. Service. Operations required periodically to keep an item in proper operating condition, i.e. to clean (includes decontaminate, when required), to preserve, to drain, to paint, or to replenish fuel, lubricants, chemical fluids, or gases. 4. Adjust. To maintain or regulate, within prescribed limits, by bringing into proper position, or by setting the operating characteristics to specified parameters. 5. Align. To adjust specified variable elements of an item to bring about optimum or desired performance

What is it called when you change the contents of a cell in Excel?

Editing.

Editing.

Editing.

Editing.

Editing.

Editing.

Editing.

Editing.

Editing.

Editing.

Editing.

What is the data source contains the text that varies from one merged document to the next?

The Data Source file can be a text document, a table in word, a table in a database or a file in Excel where data has been laid out in a tabular format. In all cases, you will need headings to indicate the field titles that are to be used. Then the data can be picked up in the Mail Merge process.

Do you use formulas in Excel to perform calculations such as adding multiplying and averaging?

Yes you do.

Yes you do.

Yes you do.

Yes you do.

Yes you do.

Yes you do.

Yes you do.

Yes you do.

Yes you do.

Yes you do.

Yes you do.

Where would it be possible to find information on how to convert Excel to PDF format?

To find information on how to convert Excel to PDF, asking someone with a technology background would be a good start. Another thing to do would be to attempt a quick search to find some instructions.

How do you add less than symbol in Excel?

The less than symbol is < the greater than symbol is > and you can add the symbol in the input line when typing a formula.

What direction are columns in Excel?

Columns are vertical, so they go up and down.

What should cell references replace in an Excel document?

As much as possible they should replace values in a formula. So instead of having a formula like =2+4 you would put the 2 and the 4 into cells and do something like =B5+C5 where B5 and C5 are the two cells that have the numbers in them. You can then put new numbers into the cells and the formula does not have to be changed to give you the new answer. Using cell references as much as possible is an essential element of building formulas and there are many other reasons for using them rather than actual values.

As much as possible they should replace values in a formula. So instead of having a formula like =2+4 you would put the 2 and the 4 into cells and do something like =B5+C5 where B5 and C5 are the two cells that have the numbers in them. You can then put new numbers into the cells and the formula does not have to be changed to give you the new answer. Using cell references as much as possible is an essential element of building formulas and there are many other reasons for using them rather than actual values.

As much as possible they should replace values in a formula. So instead of having a formula like =2+4 you would put the 2 and the 4 into cells and do something like =B5+C5 where B5 and C5 are the two cells that have the numbers in them. You can then put new numbers into the cells and the formula does not have to be changed to give you the new answer. Using cell references as much as possible is an essential element of building formulas and there are many other reasons for using them rather than actual values.

As much as possible they should replace values in a formula. So instead of having a formula like =2+4 you would put the 2 and the 4 into cells and do something like =B5+C5 where B5 and C5 are the two cells that have the numbers in them. You can then put new numbers into the cells and the formula does not have to be changed to give you the new answer. Using cell references as much as possible is an essential element of building formulas and there are many other reasons for using them rather than actual values.

As much as possible they should replace values in a formula. So instead of having a formula like =2+4 you would put the 2 and the 4 into cells and do something like =B5+C5 where B5 and C5 are the two cells that have the numbers in them. You can then put new numbers into the cells and the formula does not have to be changed to give you the new answer. Using cell references as much as possible is an essential element of building formulas and there are many other reasons for using them rather than actual values.

As much as possible they should replace values in a formula. So instead of having a formula like =2+4 you would put the 2 and the 4 into cells and do something like =B5+C5 where B5 and C5 are the two cells that have the numbers in them. You can then put new numbers into the cells and the formula does not have to be changed to give you the new answer. Using cell references as much as possible is an essential element of building formulas and there are many other reasons for using them rather than actual values.

As much as possible they should replace values in a formula. So instead of having a formula like =2+4 you would put the 2 and the 4 into cells and do something like =B5+C5 where B5 and C5 are the two cells that have the numbers in them. You can then put new numbers into the cells and the formula does not have to be changed to give you the new answer. Using cell references as much as possible is an essential element of building formulas and there are many other reasons for using them rather than actual values.

As much as possible they should replace values in a formula. So instead of having a formula like =2+4 you would put the 2 and the 4 into cells and do something like =B5+C5 where B5 and C5 are the two cells that have the numbers in them. You can then put new numbers into the cells and the formula does not have to be changed to give you the new answer. Using cell references as much as possible is an essential element of building formulas and there are many other reasons for using them rather than actual values.

As much as possible they should replace values in a formula. So instead of having a formula like =2+4 you would put the 2 and the 4 into cells and do something like =B5+C5 where B5 and C5 are the two cells that have the numbers in them. You can then put new numbers into the cells and the formula does not have to be changed to give you the new answer. Using cell references as much as possible is an essential element of building formulas and there are many other reasons for using them rather than actual values.

As much as possible they should replace values in a formula. So instead of having a formula like =2+4 you would put the 2 and the 4 into cells and do something like =B5+C5 where B5 and C5 are the two cells that have the numbers in them. You can then put new numbers into the cells and the formula does not have to be changed to give you the new answer. Using cell references as much as possible is an essential element of building formulas and there are many other reasons for using them rather than actual values.

As much as possible they should replace values in a formula. So instead of having a formula like =2+4 you would put the 2 and the 4 into cells and do something like =B5+C5 where B5 and C5 are the two cells that have the numbers in them. You can then put new numbers into the cells and the formula does not have to be changed to give you the new answer. Using cell references as much as possible is an essential element of building formulas and there are many other reasons for using them rather than actual values.

How is Microsoft Excel used in warehouse?

It could be used to keep track of the amount of items in stock. It can be used to record incoming and outgoing stock and where they are in the warehouse. It can be used to calculate prices for stock. It can be used to calculate how much space is in the warehouse and if more things can be taken in or if there is a need to order more. It can also be used to produce forms to be filled in with the data then automated. All of those things and a lot more can be done with a spreadsheet in a warehouse.

It could be used to keep track of the amount of items in stock. It can be used to record incoming and outgoing stock and where they are in the warehouse. It can be used to calculate prices for stock. It can be used to calculate how much space is in the warehouse and if more things can be taken in or if there is a need to order more. It can also be used to produce forms to be filled in with the data then automated. All of those things and a lot more can be done with a spreadsheet in a warehouse.

It could be used to keep track of the amount of items in stock. It can be used to record incoming and outgoing stock and where they are in the warehouse. It can be used to calculate prices for stock. It can be used to calculate how much space is in the warehouse and if more things can be taken in or if there is a need to order more. It can also be used to produce forms to be filled in with the data then automated. All of those things and a lot more can be done with a spreadsheet in a warehouse.

It could be used to keep track of the amount of items in stock. It can be used to record incoming and outgoing stock and where they are in the warehouse. It can be used to calculate prices for stock. It can be used to calculate how much space is in the warehouse and if more things can be taken in or if there is a need to order more. It can also be used to produce forms to be filled in with the data then automated. All of those things and a lot more can be done with a spreadsheet in a warehouse.

It could be used to keep track of the amount of items in stock. It can be used to record incoming and outgoing stock and where they are in the warehouse. It can be used to calculate prices for stock. It can be used to calculate how much space is in the warehouse and if more things can be taken in or if there is a need to order more. It can also be used to produce forms to be filled in with the data then automated. All of those things and a lot more can be done with a spreadsheet in a warehouse.

It could be used to keep track of the amount of items in stock. It can be used to record incoming and outgoing stock and where they are in the warehouse. It can be used to calculate prices for stock. It can be used to calculate how much space is in the warehouse and if more things can be taken in or if there is a need to order more. It can also be used to produce forms to be filled in with the data then automated. All of those things and a lot more can be done with a spreadsheet in a warehouse.

It could be used to keep track of the amount of items in stock. It can be used to record incoming and outgoing stock and where they are in the warehouse. It can be used to calculate prices for stock. It can be used to calculate how much space is in the warehouse and if more things can be taken in or if there is a need to order more. It can also be used to produce forms to be filled in with the data then automated. All of those things and a lot more can be done with a spreadsheet in a warehouse.

It could be used to keep track of the amount of items in stock. It can be used to record incoming and outgoing stock and where they are in the warehouse. It can be used to calculate prices for stock. It can be used to calculate how much space is in the warehouse and if more things can be taken in or if there is a need to order more. It can also be used to produce forms to be filled in with the data then automated. All of those things and a lot more can be done with a spreadsheet in a warehouse.

It could be used to keep track of the amount of items in stock. It can be used to record incoming and outgoing stock and where they are in the warehouse. It can be used to calculate prices for stock. It can be used to calculate how much space is in the warehouse and if more things can be taken in or if there is a need to order more. It can also be used to produce forms to be filled in with the data then automated. All of those things and a lot more can be done with a spreadsheet in a warehouse.

It could be used to keep track of the amount of items in stock. It can be used to record incoming and outgoing stock and where they are in the warehouse. It can be used to calculate prices for stock. It can be used to calculate how much space is in the warehouse and if more things can be taken in or if there is a need to order more. It can also be used to produce forms to be filled in with the data then automated. All of those things and a lot more can be done with a spreadsheet in a warehouse.

It could be used to keep track of the amount of items in stock. It can be used to record incoming and outgoing stock and where they are in the warehouse. It can be used to calculate prices for stock. It can be used to calculate how much space is in the warehouse and if more things can be taken in or if there is a need to order more. It can also be used to produce forms to be filled in with the data then automated. All of those things and a lot more can be done with a spreadsheet in a warehouse.

How are vertical and horizontal alignment done in Excel?

Horizontal alignment is the positioning of content in the cell across, like to the left, right or centre. Vertical alignment is the position of the content from the top of the cell to the bottom of a cell. If a cell is increased in height over its usual setting, then the vertical alignment can be used to position content at the top, middle or bottom of a cell. Both vertical and horizontal alignment can be done on the Alignment tab in the Format Cells dialog box. Pressing Ctrl-1 will open it.

What spreadsheet formula is associated with budgets?

You cannot say that there is just one formula associated with budgets. Many different types of calculations are done in a budget. They require different kinds of formulas, not just one. Lots of functions could be used. The closest you could give as an answer is the SUM function. It is what is used to total up figures. So if you had a list of numbers in the cells B2 to B40, the following SUM function could be used:

=SUM(B2:B40)

In a budget spreadsheet, you could have lots of SUM functions and they would use different cell ranges than in the example, so there is no definitive answer to the question.

How many uses are there for Microsoft Excel?

There is no real limit to the amount of things you can do with Excel and most other major computer applications. It is down to your imagination and ingenuity. Excel provides many features and facilities, but it is down to the users as how they use them and what they can achieve by using them. Broadly speaking a spreadsheet is used for numerical analysis and manipulation, but there is a lot more you can do with it. It would be impossible to list them all here. See the related questions below for some ideas.