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

How do the different parts of the Excel worksheet differ from a word processor?

A worksheet and a word processing document are completely different. A worksheet is a grid and so it has rows and columns. The rows are identified by numbers and the columns by letters. There are row headers down the side and column headers across the top. A word processor has a blank page. It has rulers on the top and on the side and it has margins. It has individual pages with set sizes, whereas a worksheet is a lot larger. You usually type directly into the page of the word processor, whereas you can either type into the formula bar or direct into the cells on a worksheet. It is only when you have a table in a word processing document that it looks a bit more like a worksheet.

Why does the 'ATAN' function in Excel differ greatly from that of a scientific calculator?

It is because the angles in Excel are measured in radians, not degrees. Often the default setting for measuring angles - even on scientific calculators - is the elementary mathematical degrees rather than the more advanced mathematicians' radians.

180 degrees = pi radians.

So Excel gives ATAN(1) = 0.7854 radians which is 0.7854*180/pi = 45 degrees.

Note that all trig functions in Excel are based on angles measured in Radians NOT degrees.

What is the keyboard shortcut for selecting the Instant Search box?

Ctrl+F will bring up the Find box in Excel, but there is nothing called "Instant Search" in Excel. If this does not answer your question, please ask again with more specifc criteria and ensure it is in the correct category.

What is the difference between copy and paste and fill handle features?

Not much. The fill handle just makes it a little easier (or at least offers a different method) to copy data to adjacent cells.

How does Excel make a worksheet fit on one page when you choose the Fit to option?

It reduces the size of fonts and other objects on the page until they are small enough to fit the space allocated on the paper.

How can you copy Excel data and paste in G mail body keeping Excel formatting?

E-mails are normally text, so when you paste something from another application you may lose some of the formatting. In this instance, GMail is not Excel, so you will lose some of the formatting. You could put the data into a Google Spreadsheet or just attach an Excel file with the data you want, as better solutions to your problem.

Does Pressing the F9 key instruct Excel to recalculate all formulas?

When you are working in Manual Recalculation mode, that is what it will do. For Automatic Recalculation it is not really used, as formulas will update any time a change is made. Pressing F9 will still recalculate them, but there is no need to. There are a few exceptions where you might use F9 when Automatic Recalculation is working. You could use it to regenerate values for the RANDBETWEEN function for example.

How you use equals DSUM in Excel?

DSUM is similar to SUM, except that it works on a database. To use it you need a table of data to act as a database, which can have several columns. Each column should be labelled like a database field. You then have to choose which field you want to add values from. You also need criteria to determine what you want to add. So for example, you could have a list of sales made by different members of your sales staff, where the same people can have made more than one sale. You could try to sum just the sales made by one individual or in one month or sales greater than a certain value. You separately need to specify a criteria. So say one of your fields is called Sales, then that will be at the top of its column of data. Separately you could put the heading Sales into a cell and under it, put something like >500. You then specify your table of data, which field you want to sum and where the criteria is. Say your table is from A1 to C100 and column A has the month, column B the name of the sales person and C has the amount of each sale. Say then that you want to find the total amount of sales made in January. In cell E1 you could put Month, the same heading as in A1 and in E2 the name of an actual month, say April. Your DSUM function would then have a structure like below:

=DSUM(database, field, criteria)

Your actual function would then be this:

=DSUM(A1:C100, "Month", E1:E2)

This will sum all the sales for April. If you change April for another month, you will get that month's total. You can also specify multiple criteria by adding more columns to your criteria. So you could set up a DSUM to calculate the total of sales made by a certain individual in a certain month.

What does wrap help with in the cell excel?

It keeps text in a cell by wrapping it around onto two or more lines, so that it fits in the cell and does not spill over a neighbouring cell. It may heighten the cell as a result.

It keeps text in a cell by wrapping it around onto two or more lines, so that it fits in the cell and does not spill over a neighbouring cell. It may heighten the cell as a result.

It keeps text in a cell by wrapping it around onto two or more lines, so that it fits in the cell and does not spill over a neighbouring cell. It may heighten the cell as a result.

It keeps text in a cell by wrapping it around onto two or more lines, so that it fits in the cell and does not spill over a neighbouring cell. It may heighten the cell as a result.

It keeps text in a cell by wrapping it around onto two or more lines, so that it fits in the cell and does not spill over a neighbouring cell. It may heighten the cell as a result.

It keeps text in a cell by wrapping it around onto two or more lines, so that it fits in the cell and does not spill over a neighbouring cell. It may heighten the cell as a result.

It keeps text in a cell by wrapping it around onto two or more lines, so that it fits in the cell and does not spill over a neighbouring cell. It may heighten the cell as a result.

It keeps text in a cell by wrapping it around onto two or more lines, so that it fits in the cell and does not spill over a neighbouring cell. It may heighten the cell as a result.

It keeps text in a cell by wrapping it around onto two or more lines, so that it fits in the cell and does not spill over a neighbouring cell. It may heighten the cell as a result.

It keeps text in a cell by wrapping it around onto two or more lines, so that it fits in the cell and does not spill over a neighbouring cell. It may heighten the cell as a result.

It keeps text in a cell by wrapping it around onto two or more lines, so that it fits in the cell and does not spill over a neighbouring cell. It may heighten the cell as a result.

How do you do trademark in Excel?

  1. Click on the cell where you want to enter the Registered Trademark symbol.
  2. Select Insert from the ribbon.
  3. Click on the Symbol icon on the right side of the Insert ribbon.
  4. Scroll through the list of options to find the Registered Sign ®.
  5. Click on the Registered Sign to highlight it.
  6. Click the Insert button (or just double-click directly on the Registered Sign).
  7. Observe the Registered Sign in your highlighted cell.

What is a database report?

- a report on a database is the answer to a query -

e.g.

SURNAME NAME AGE

Smith Willow 24

Neet Charlotte 20

Sindad Daniel 13

Juugo Ryan 17

QUERY: Everyone over the age of 18

THE REPORT WOULD LOOK LIKE THIS:

SURNAME NAME AGE

Smith Willow 24

Neet Charlotte 20

What includes button's and galleries in Excel?

Like many programs Microsoft Excel financial spreadsheet application can be customised. The menu bar can be changed by adding and removing buttons and galleries to the menu bar it self and the functions that can be called from the menu bar

Does a screen tip appear automatically based on tasks you perform and contains commands related to changing the appearance of text in a document?

a mini toolbar appears automatically based on tasks you perform and contains commands related to changing the appearance of text in a document.

What is data menu in Microsoft Excel?

Data menu is that on that we can sort,filter,subtotals,validation,text to columns,pivot tables and pivot chart report

What cell does formulas and functions in Excel make use of?

Cells are the fundamental element of a worksheet. All formulas are put into them. Most functions and formulas will reference cells on the worksheet. So cells are extremely important in Excel. Without them, you do not have a worksheet.

What does accounting mean in Microsoft Excel?

It can mean doing financial accounts. It can also refer to one of the formatting options available. Accounting format is used for monetary values. It aligns the currency symbols and decimal points of numbers in a column. The Accounting format displays zeros as dashes and negative numbers in parentheses.

Can you create a contact list through excel?

You can, but you are better off doing it in Outlook or Access.

You can, but you are better off doing it in Outlook or Access.

You can, but you are better off doing it in Outlook or Access.

You can, but you are better off doing it in Outlook or Access.

You can, but you are better off doing it in Outlook or Access.

You can, but you are better off doing it in Outlook or Access.

You can, but you are better off doing it in Outlook or Access.

You can, but you are better off doing it in Outlook or Access.

You can, but you are better off doing it in Outlook or Access.

You can, but you are better off doing it in Outlook or Access.

You can, but you are better off doing it in Outlook or Access.

What is Microsoft Excel particularly well suited for?

Absolutely anything to do with numbers, like calculating or analysing them for example. Excel is a very versatile application and can be used for all sorts of things to do with numbers. Many professions can make use of it, as can ordinary people.

Is there a way to swap column headings and row headings?

Data can be transposed in Excel, so that the data that was in a row will go into a column and data that was in a column will go into a row. There is a TRANSPOSE function or you can copy your data and then use Paste Special and pick the Transpose option.