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

An example of a ruled tabulation with main headings?

Gross Receipts by Branch ($`000,000)Jan-marBranchesBarbadosGuyanaTrinidadJamaicaJan-mar31183926April-june35122320July-sept19341732Oct-dec22102919

How do you decide when to use Excel or Access database program?

You would use Access when you want to create a database. A database is a file full of organised data. It is a structured set of records comprising a large amount of data or information, which is usually related. It can be a Manual Paper Work collection or Electronic Computer Data. A database is a collection of records organized so that data can be easily retrieved. When you want to deal with lists of data and be able to organise it and retrieve information, that is when you would use Microsoft Access or another database application.

Excel is for creating spreadsheets. Spreadsheets are used for numerical analysis and manipulation. When you have a lot of numbers and you want to do calculations on them, then it is best to use a spreadsheet. It also allows you to do things like create charts and to try different combinations of numbers to see what the effects are of having different values, like how much a company can make if they were to increase the amount of their products that they manufacture and sell.

There are things that both a spreadsheet and a database can do. You can use a spreadsheet to do some databasing operations and you can use a database to do some spreadsheet operations, but you would pick the one that is most suited to the task you want to do. If you are mostly dealing with numbers and doing lots of calculations, it is usually best to use a spreadsheet. If you are dealing with lists of data, like a list of people's names and addresses, then it is best to use a database.

What is the importance of zooming in and out in viewing a spreadsheet?

Zoom in to see more detail about a particular section of the spreadsheet and zoom out to see the entire spreadsheet layout.

What is a a cool excel formula you know?

Put your date of birth in cell A1 as a date. Then in cell A2 type the following formula:

=weekday(A1)

You will get a number between 1 and 7, telling you what day of the week that you were born on.

1 is Sunday
2 is Monday
3 is Tuesday
4 is Wednesday
5 is Thursday
6 is Friday
7 is Saturday

You can put any date into A1 and it will give you the correct day in A2. Try today's date, by holding the Ctrl key and then pressing the ; key.

A tick box in excel?

Use the built in Help (F1 key) ask the question (call it forms or checkbox) there!

Can formatting change the actual data in the cell in Excel?

Formatting won't change the actual data. It may change how it looks, so it appears to be different. For example if you reduce the amount of decimal places in a number, it may round the number up, so 3.46 could be displayed as 3.5, but it won't change the actual value. Even though you would now see 3.5 it will still contain 3.46 and use that in the calculations it is used in.

What symbol is used to specify calculation?

Use the equal sign (=) to identify cell entries that should attempt to calculate a value.

What is column break in Microsoft Excel?

A column break is a term associated with Microsoft Word, not Excel. In Word, it starts a new column of text. In Excel, you can just go to another column to start entering new data.

Where do you click to insert a column?

In excel, right click on the column heading (top of the column) to the right of where you want to insert a new column, this brings up a mini drop down menu, click 'insert column'

How do you create a chart from selected cells in Excel?

Once the cells are selected you can start the Chart Wizard. Then you can follow through the options you want for the particular chart you need. Pressing the F11 key will instantly create the default chart, without giving you any options. You can then adjust the chart to your needs.

How do you add a data series to an already existing chart?

Go to the Chart Menu, pick Source Data and then Add Series. You then have to select the data you want and it can be added to the chart. You can do it quickly by right-clicking on the chart and picking Source Data from there.

Go to the Chart Menu, pick Source Data and then Add Series. You then have to select the data you want and it can be added to the chart. You can do it quickly by right-clicking on the chart and picking Source Data from there.

Go to the Chart Menu, pick Source Data and then Add Series. You then have to select the data you want and it can be added to the chart. You can do it quickly by right-clicking on the chart and picking Source Data from there.

Go to the Chart Menu, pick Source Data and then Add Series. You then have to select the data you want and it can be added to the chart. You can do it quickly by right-clicking on the chart and picking Source Data from there.

Go to the Chart Menu, pick Source Data and then Add Series. You then have to select the data you want and it can be added to the chart. You can do it quickly by right-clicking on the chart and picking Source Data from there.

Go to the Chart Menu, pick Source Data and then Add Series. You then have to select the data you want and it can be added to the chart. You can do it quickly by right-clicking on the chart and picking Source Data from there.

Go to the Chart Menu, pick Source Data and then Add Series. You then have to select the data you want and it can be added to the chart. You can do it quickly by right-clicking on the chart and picking Source Data from there.

Go to the Chart Menu, pick Source Data and then Add Series. You then have to select the data you want and it can be added to the chart. You can do it quickly by right-clicking on the chart and picking Source Data from there.

Go to the Chart Menu, pick Source Data and then Add Series. You then have to select the data you want and it can be added to the chart. You can do it quickly by right-clicking on the chart and picking Source Data from there.

Go to the Chart Menu, pick Source Data and then Add Series. You then have to select the data you want and it can be added to the chart. You can do it quickly by right-clicking on the chart and picking Source Data from there.

Go to the Chart Menu, pick Source Data and then Add Series. You then have to select the data you want and it can be added to the chart. You can do it quickly by right-clicking on the chart and picking Source Data from there.

What is the use of the chart of component in Excel?

There are different kinds of charts, so they don't all have the same components. Typical things are title, legend, axes, plot area and series.


There are different kinds of charts, so they don't all have the same components. Typical things are title, legend, axes, plot area and series.


There are different kinds of charts, so they don't all have the same components. Typical things are title, legend, axes, plot area and series.


There are different kinds of charts, so they don't all have the same components. Typical things are title, legend, axes, plot area and series.


There are different kinds of charts, so they don't all have the same components. Typical things are title, legend, axes, plot area and series.


There are different kinds of charts, so they don't all have the same components. Typical things are title, legend, axes, plot area and series.


There are different kinds of charts, so they don't all have the same components. Typical things are title, legend, axes, plot area and series.


There are different kinds of charts, so they don't all have the same components. Typical things are title, legend, axes, plot area and series.


There are different kinds of charts, so they don't all have the same components. Typical things are title, legend, axes, plot area and series.


There are different kinds of charts, so they don't all have the same components. Typical things are title, legend, axes, plot area and series.


There are different kinds of charts, so they don't all have the same components. Typical things are title, legend, axes, plot area and series.

What can an Excel spreadsheet be used to make?

There are a huge amounts of things it can make, far more than could be mentioned. There are the standard things like tables, formulas, charts and graphics. You could also use it to create forms and diagrams and flowcharts and many other things. You can create databases with it. You can type text like in a word processor, so you can create letters in it. There are so many other things. It is very versatile.

What symbol displays when date and currency values are too wide to fit in the column?

You will see the # symbol filling the cell. Just widen the column enough and the data will display as usual.

How can you use autofit with row height?

In Microsoft Excel, you can auto adjust row height by double clicking the row separation line between two rows.

Why would use sub totals in Microsoft Excel?

When you have a long list of numbers that are in natural groups, subtotals can be handy. You could have a list of numbers for sales throughout the year and put in subtotals for each month for example. You might have subtotals for each sales person or sub totals for each region or anything like that. All you need is to have the numbers and something to distinguish them into their different groups and have them in the order of their groups. Then you can create subtotals, as Excel will be able to detect the end of one group and the start of the next and then put a subtotal in for the group.

What is a row or column in ICT?

A row is a horizontal line of cells in a spreadsheet or table. A column is a vertical line of cells in a spreadsheet or table.

What are the functions of eMILPO?

Personnel Services, Personnel Accounting, DTAS, Promotions, Readiness, Reassignments, PERS TEMPO

What is the format that displays text in multiple lines with in a cell called?

If you are referring to Excel spreadsheets, that is called wrap text.

What are the disadvantages of chart?

None, providing the organizational chart provides flexibility to the organization as future events dictate.