answersLogoWhite

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.

18,601 Questions
Internet
Microsoft Excel

What is extension added to Excel files?

Excel 2003:

.xls = Workbook

.xla = VBA Add-in

.xlb = Toolbar (where custom toolbar settings are stored)

.xlc = Chart

.xld = Dialog (from older versions of Excel)

.xlk = Archive (Excel spreadsheet backup)

.xll = DLL Add-in

.xlm = Macro

.xlt = Template

.xlv = VBA Module

.xlw = Workspace (collection of multiple Workbooks)

Excel 2007:

.xlsx = Workbook (XML format)

.xlsm = Macro-enabled Workbook

.xlsb = Excel Binary Workbook (instead of XML format)

.xltm = Macre-enabled Template

.xlam = Add-in (XML format)

http://wiki.answers.com/What_is_the_file_extension_that_indicates_an_excel_file#ixzz16E1eq6Mr

373374375
Software and Applications (non-game)
Microsoft Excel

How do you insert a PDF file into an excel sheet?

You want to insert an OBJECT (select from file), then select PDF from the choices of what to insert. That is:

Insert>>Object>>Select "Adobe Acrobat Document">> OK

If you wanna convert PDF to Excel, then you'd better use enolsoft PDF to Excel with OCR converter.

357358359
Business and Industry
Business Accounting and Bookkeeping
Microsoft Excel

What are some ways to use Excel?

There are many uses for Excel. If you have novel ways to use Excel, please add your ideas here or on the discussion page.

Here are some ideas:

  • Set up a favorite friend list and enter the number of SMS messages you send them each month. The person at the end of the year that received the most messages is your favorite texting friend.
  • Plan a vacation budget. Decide how much money you will spend for your vacation and set up a budget for each item. Take the budget with you and keep track of actual expenses. When you get back, enter actual expenses and compare with budgeted expenses. Use this information to help plan your next vacation.
  • Design a form. You can change the column width to 2 characters to create a grid system to allow you to layout a form. Join several cells together to create each form area.
  • Create a mailing list and use this list to merge with a letter you make in Word. You can send out annual letters to all of your friends keep them up to date on what is happening with you. In the mailing list, include personal information about the person. That way, you can personalize each letter in a mass mailing to your friends.
  • Set up a work schedule and calculate how many hours each worker is required to work. You can break down the totals by week, month, year, or any other time period you choose.
  • Track income and expenses to see what your profits are at the end of each week, month, quarter, and year.
  • You can use Excel as an advanced calculator to calculate almost any kind of math of financial problem. Excel can calculate the square root of any number a quickly as you can press the enter key.
  • Use it to track the birds or other animals you see in your back yard. You can set up columns for type of animal, time of day, day of week, how long they stayed, what they did, etc.
  • Collect and track weather data, then create charts to view and evaluate the data over time. You can see what day was the hottest last year, how many days rained, what day received the most snow, etc. The amount of data you collect is limited only by your imagination.
  • Evaluate different purchase options. If you want to purchase a new car, you can record as much data as you can find about each type of car you would like to consider, then make charts to view and help analyze data. You can assign a point value to each car feature then total up the points to see which car gets the most points.
  • You can keep track of various baseball statistics to compare your stats with what the sports casters are talking about. You can create your own unique best-of categories, like which team got the most strikes on days that were cloudy.

    Track daily meals to find out how many calories you consume each day, week, month, year, etc. You can sort the data to see if there are any days of the week where you consume more or less calories compared to other days.

  • If you have health issues, you can track your blood sugar, temperature, blood pressure, weight, etc. to see if you are meeting or exceeding expected results over time. You can create a chart that shows you almost any way you would like to view the results.
  • As a classroom project, you can give each student a bag of M&Ms, Skittles, or some other snack that uses different colors. Have the students record how many of each color is in the bag. Then the students can create charts to view and evaluate the results of their study.
  • Create a simple inventory sheet to determine how many items you have in stock, the total value of each item, the total value of all items, color-coded totals to show which items should be reordered, etc.
  • Make a decision matrix. Along the side of the spreadsheet, list all of the items you would like to evaluate. Across the top list all the criteria that you want to consider in your decision. For example, you want to decide where to go on a vacation. You list all the places you might want to consider along the left side. Across the top you list things like, cost, distance, things to do, etc. Assign relative values to each criteria for every option (e.g. 3 = Best, 2 = OK, 1 = Maybe, 0 = Not a chance). Create a formula to add all the values and see which option gets the most points.

It can be used to manipulate dates and text. It has some graphical capabilities, as you can craw things in it. You can use it to make flowcharts and structured diagrams. It can be good for creating structured forms for printing out. It can be used for databasing. It has a lot of other uses that you can come up with once you start using it.

See related links for more great ideas about how to use Excel and to download some free helpful Excel templates.

  • Track a budget (find out home much money you have coming in and how much you have going out).
  • If you have a large collection of something, you can list the the items and their price, then you can add a total to each list. Every time you update any of the values, the total value automatically updates. Additionally, you can have several worksheets, one for each of your collectable items, and a totals worksheet that provides an overview of your entire collection. Each of the individual worksheets can be linked to the overview, so you can see all the important information about your collection on a single page.
  • Make a decision matrix to help you choose between several options (courses of action). You can list your options across the top and the criteria you would like to evaluate along the side. In the cell where each criteria matches an otion, you can enter a number to indicate your preference. Add the columns listing your preferences, and the one with the highest number (or lowest number, depending on the measurement scale you choose) meets most of the criteria you have selected. A large number on a decision matrix is not the only reason you should select a course of action, but it is a tool to help point you in the desired direction.

Excel is used to create spreadsheets, charts, and graphs to be used by businesses.
Microsoft has provided Excellent online help. Also, few user like me has made blog. Kindly visit my blog at related links.

See related questions for ways to use Excel.
Microsoft Excel is a spreadsheet program. A Spreadsheet is a computer application used for numerical analysis and manipulation. A Spreadsheet is split into Columns and Rows based on an accountant's worksheet.

Columns are referenced by letters.

Rows are referenced by numbers.

Where a Column and a Row intersect a Cell is formed.

A Cell is referenced by its Column letter and Row Number (e.g. A12 = Column A; Row 12).

A Range or Block is a rectangular group of cells referenced by the top left and bottom right cells.

A Spreadsheet has thousands of columns and thousands of rows and therefore millions of cells.

One of the most powerful features of a spreadsheet is the ability to use formulas for calculations. Formulas should always be used in preference to manually working out results of calculations. All formulas in Excel begin with the = sign.

Functions are pre-written formulas that come supplied with the Spreadsheet to enable the user to carry out specialised or common tasks. There are functions to do a wide range of tasks. The functions are usually classified under various headings, including Mathematical, Logical, Special, Text, Date/Time, Financial, Statistical and Database Functions. You can do things related to all of these areas, and almost anything that is related to numbers and calculations.

You can make simple spreadsheets, make databases, use it for accountancy, for stock control and a whole range of other things. Businesses use them for doing planning and evaluation in relation to things like their sales and how their business has been doing and how they expect it to do. You can also use it for creating graphs or diagrams. You can use it for creating structured forms. In short, a spreadsheet is one of the most useful of all applications, enabling you to do a wide range of things.
A spreadsheet is a collection of rows and columns, which are used to organize data in such a way that the arithmetic operation can be carried out on whole rows of columns extremely quickly.

  • to use spreadsheets as modeling tools
  • plan, design and create a database
also spreadsheets are used to calculate arithmetic equations with ease.
  • The benefits of a spread sheet include the fact that you can make formulas and work out complex sums easily.

One major use is to create a Operating Budget (either for business or home use) so you can track where your income is being spent.
Excel is a 'spreadsheet' program and spreadsheets are used for mathematical equations.

Whether you just want to add up rows/columns of numbers or do advanced calculations.

eg: if column 1 total is subtracted from column 6 total, what is the answer? or

if this particular information is a percentage of that information, what percentage is the remaining information in relation to column X.

Many and varied calculations can be done in relation to any information.
You can create spreadsheets or tables.

For example when you need to do your accounting, tax returns or so.
Microsoft Excel is used to make spreadsheets, do calculations, make graphs, and make tables.
Exel is a spreadsheet program that enables you to enter formulas and data into the cells in order to organize information.
you can make charts,diagrams,various mathematical calculations,convert money,measurements,text document connect to database,insert content from web pages and many,many more
1) Perform repetative and complex mathematics

2) Connect to a database to get snapshots of data

3) Create dynamic graphs on data quickly and easily

4) Sort and filter large volumes of information quickly

5) Validate user input; allowing them to use dropdown boxes and enforcing rules on the data

293294295
Microsoft Excel

Why is Microsoft Excel called a spreadsheet program?

It is because it is a electronic spreadsheet program. A spreadsheet in the traditional sense is a piece of paper with rows and columns that people use to write figures on and do calculations. In 1978 a business student named Dan Bricklin, thought that there should be a simpler way of doing them than on paper, as they were slow and tedious to use, especially when changes in the figures needed to be made. He got together with Bob Frankston who was a friend and a programmer. They created VisiCalc, the first electronic spreadsheet program. Many other spreadsheet programs were created by other people after that and Microsoft Excel is one of those.

131415
Computer Terminology
Microsoft Excel

How do you add date stamp on excel?

Try this formula: =NOW()

If you don't want the time, the formula is

=TODAY()

349350351
Computer Programming
Microsoft Excel

How do you make a dot plot on Excel?

It's called an X-Y scatter plot. The procedure is different depending on which version you have. Basically, you highlight all of the cells containing, the data; click on 'Insert' then click the icon that looks like a 'dot plot' and it should have the word 'scatter' underneath it.

339340341
Microsoft Word
Microsoft Excel

What does portrait orientation mean?

it means vertical allignment, document is more heigh then wide

328329330
Microsoft Excel

How do make an times table on Microsoft Excel?

Enter one set of numbers in a column and another set of numbers in a row at the top of that column, so that the numbers you want to multiply intersect at a column and row.

EXAMPLE:

In A2 enter 2.

In B1 enter 3.

In B2 enter =A2*B1 (observe the answer 6)

TIP: If you want to be able to enter the formula only in the first intersecting cell of the row, then copy the formula to all the rest of the cells in the row, use the formula =$A$2*B1. That will make A2 and absolute reference that will not change as you copy the formula to other cells in the row, but will automatically update B1 to C1, D1, etc.

309310311
Microsoft Excel

What types of documents can be created in excel?

workbook files, also called spreadsheets

307308309
Microsoft Excel

Why is VLOOKUP function used moere often than other lookup functions?

Data is more commonly arranged in such a way that a VLookup is better able to extract the data. The same kinds of data are generally arranged to be grouped in columns and that is what VLookup is best for searching through. It searches through data vertically, or in other words through columns.

307308309
Microsoft Windows
Microsoft Excel

What does ctrl and home key do?

It will bring you to the start of a document.

305306307
Microsoft Excel

What does the delete button do in excel?

It erases what is inside the cell.

301302303
Microsoft Excel

What the print set area command is use to?

If you want to print just a part of a spreadsheet and not the whole lot of it, you can select the part you want to print and set the Print Area. It is a very useful feature if you only want to print an important part from what is a large spreadsheet, like some totals or some columns. When you have finished, you can use the setting to clear the print area which will set the setting back to normal and do a full print of the spreadsheet.

299300301
Statistics
Microsoft Excel

How do you calculate Spearman's rank using excel?

See video at related links for instructions.

289290291
Microsoft Windows
Microsoft Word
Microsoft Excel
Typography

How is the font size in Word and Excel measured?

Microsoft Word measures fonts in points. A common example would be something like 10 or 12 point Arial or Times New Roman. Excel is similar.

283284285
Microsoft Word
Microsoft Excel

How do you draw a partition in Microsoft Word?

You can do that with table, Insert - Table. Table can have visible or invisible borders, Design tab (appears when you insert or draw table) Table Styles section - Borders.

281282283
Math and Arithmetic
Microsoft Excel

What are Some of the ways to format numbers is to use?

Under the Home tab in 2007/2010 Excel you have Number. Clicking on the lower right selector arrow under that shows the various ways:

Number (decimal places and + and - numbers)

Currency (Including symbols besides US currency, decimal places and + and - notation style)

Accounting

Date (various forms)

Time (How you want it notated and 12 or 24 hour clock)

Percentage

Fraction

Scientific

Special and Custom

281282283
Microsoft Excel

What is the formula in excel for counting base 8?

To convert from decimal to octal, use the function DEC2OCT.

EXAMPLE: =DEC2OCT(58, 3) Converts decimal 58 to octal (072).

281282283
Microsoft Excel

How can I export from Excel to a Dymo Label Writer?

Ask this question again to specify which model of Dymo Label Writer you are using. Or, perhaps you can find what you need at the related links.

281282283
Microsoft Word
Microsoft Excel
Microsoft PowerPoint

Where is the undo button located?

Since Office 2007 it is located in the top left corner of the page in the Quick Access toolbar. You can also use the Ctrl - Z shortcut key to undo things.

281282283
Microsoft Excel

What spreadsheet software do teachers use?

Teachers can use many different spreadsheet programs. Microsoft Excel is the most common one, so most would use that, but they could use any of the others available, such as Calc in Open Office or Lotus 1-2-3 etc.

269270271
Microsoft Word
Microsoft Excel
The Difference Between

Difference between paste and paste special?

In word programs, there is normal pasting which is normally done with images, text, etc, then there is special pasting which allows you to copy a section of text from word for example and past it into another word program as a picture eg.

It just allows you to copy one type of information and paste it as another.

255256257
Microsoft Excel

What does the countblank function actually count?

Countblank function is a derivative of count function and it is doing a very simple task - countblank function counts the number of cells in the range with no data. Actually, if you'll add the results for count/a function and countblank function you'll get the total number of cells in the range (empty and not).

267268269

Copyright © 2020 Multiply Media, LLC. All Rights Reserved. The material on this site can not be reproduced, distributed, transmitted, cached or otherwise used, except with prior written permission of Multiply.