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

What are some personal applications of spreadsheets?

A spreadsheet is like a large sheet consisting of several rows and columns this Wiki answers is done by peoples so dont believe it,it is not true please stop asking your questions over here because you will get all wrond information!

Wiki answers

secretory,Head

What could be a nonadjacent range in Excel?

A range can only be cells that are adjacent and in a rectangular shape. It is possible to select non-adjacent cells but this would not be regarded as a range. Each would be a separate range. So usually non-adjacent ranges will have gaps between them, although it is possible to have cells from to separate ranges right beside each other. You will know them by their boundaries around them.

What does average mean in a spreadsheet?

The Average function in Excel will help you calculate the average, or more specifically the arithmetic mean. Excel's average function checks all the number in a given range and calculates the average of them, by adding the values and dividing by the amount of values. Cells with no data will not be included in the calculation.

The Average function looks like this =AVERAGE(number1,number2) where each number can be a reference for a cell or range of cells or can be entered manually. For example =AVERAGE(50,100) equals 75.

What is the meaning of error in macros- Excel?

It means the same as almost any other situation in the English language. Something went wrong. You can get an error if you use the incorrect syntax for a formula or if you divide by zero. You also could get an error if a macro received input it could not handle.

Disadvantages of excel?

The main disadvantages are:

  • Not easily sharable (except for Tools, Share workbook)
  • Non relational (except for lookup & reference commands like VLOOKUP)
  • Not scalable (limited to 65536 rows in Excel 2003)
  • Limited Data VAlidation (except for Data Validation
  • No Forms (except for VBA or Data form
  • Poor Reports (except for Pivot Tables

See related links for a free manual on this subject.
The only 1 I think of is sometimes excel doesn't work but the ADVANTAGES r you don't have 2 do math excel will work it 4 u

How can you open a prs file?

.PRS have been used a few different places over the years. Probably the file you want to open is a presentation file created by Harvard Graphics. You might need the original software to open and edit.

Notepad, a few Database and other Presentation/Slide show softwares have reported being able to open these.

What is vertical alignment in Excel 2010?

Alignment is the feature in the ms-word which is used by the user to give different ways to position a paragraph or text. You can left align, right align, centre it and justify it.

How do you determine the scale of graphs?

Sales for Company X for the
Fourth Quarter-1995
Sales for Company X for the
Fourth Quarter-1995

Note the scale in the graph above:

  • The frequency scale begins at 74 and ends at 82. This is because the range of values being graphed are from 77 to 82. Since we want our smallest bar to have some height, we started the scale at 74.
  • If you look at bar heights, it looks like the ratio is 2:1. However, if you use the actual values, the ratio is then 82:77, which is not 2:1.
  • Direct comparison of bar heights can only be made when the scale begins at zero. So why not begin all scales at zero?

Note the scale in the graph above:

  • The frequency scale with begins at zero.
  • It is clear that the bars for Oct and Dec have nearly the same height. This means ratio of Oct. sales to Dec. sales is nearly 1:1
  • Having all bars appear nearly the same height makes it difficult to analyze any trends that may exist or to look at differences between months.

What are three different ways to change the column width in a spreadsheet document?

You can use the mouse to put the cursor between the two column headings and drag to change the width of the column to the left. You can also place the cursor there and double click and it will widen or narrow itself to the longest content in a cell, known as Autofit. You can go the format menu and type in a value for the column width.

You can use the mouse to put the cursor between the two column headings and drag to change the width of the column to the left. You can also place the cursor there and double click and it will widen or narrow itself to the longest content in a cell, known as Autofit. You can go the format menu and type in a value for the column width.

You can use the mouse to put the cursor between the two column headings and drag to change the width of the column to the left. You can also place the cursor there and double click and it will widen or narrow itself to the longest content in a cell, known as Autofit. You can go the format menu and type in a value for the column width.

You can use the mouse to put the cursor between the two column headings and drag to change the width of the column to the left. You can also place the cursor there and double click and it will widen or narrow itself to the longest content in a cell, known as Autofit. You can go the format menu and type in a value for the column width.

You can use the mouse to put the cursor between the two column headings and drag to change the width of the column to the left. You can also place the cursor there and double click and it will widen or narrow itself to the longest content in a cell, known as Autofit. You can go the format menu and type in a value for the column width.

You can use the mouse to put the cursor between the two column headings and drag to change the width of the column to the left. You can also place the cursor there and double click and it will widen or narrow itself to the longest content in a cell, known as Autofit. You can go the format menu and type in a value for the column width.

You can use the mouse to put the cursor between the two column headings and drag to change the width of the column to the left. You can also place the cursor there and double click and it will widen or narrow itself to the longest content in a cell, known as Autofit. You can go the format menu and type in a value for the column width.

You can use the mouse to put the cursor between the two column headings and drag to change the width of the column to the left. You can also place the cursor there and double click and it will widen or narrow itself to the longest content in a cell, known as Autofit. You can go the format menu and type in a value for the column width.

You can use the mouse to put the cursor between the two column headings and drag to change the width of the column to the left. You can also place the cursor there and double click and it will widen or narrow itself to the longest content in a cell, known as Autofit. You can go the format menu and type in a value for the column width.

You can use the mouse to put the cursor between the two column headings and drag to change the width of the column to the left. You can also place the cursor there and double click and it will widen or narrow itself to the longest content in a cell, known as Autofit. You can go the format menu and type in a value for the column width.

You can use the mouse to put the cursor between the two column headings and drag to change the width of the column to the left. You can also place the cursor there and double click and it will widen or narrow itself to the longest content in a cell, known as Autofit. You can go the format menu and type in a value for the column width.

What are the horizontal lines in Excel called?

Rows and Columns and the "boxes" are called cells

Which type of chart is best for comparing data across categories in excel?

Usually a column chart, but it depends on what exactly you want to do and the nature of the data.

What is the print area in Excel?

It is very easy. Just highlight what you want and then go to file: print area: set print area. If that doesn't work, then you've got got something wrong with your computer or a very old computer...

What is the hardcopy of your worksheet?

A hard copy refers to a printed version of any computer document. The file on your computer is known as a soft copy.

How You can ensure correctness in your formulas by carefully checking them using?

You can never guarantee 100% correctness, as there are many external factors that can affect your formulas. However, by carefully using the range finder and the Insert Function to guide you through inserting the arguments, you can reduce down the amount of errors that you can make.

What is the definition of goal seek in Excel?

Goal Seek is used to obtain a value as part of a calculation that will result in your formula a particular result. As a simple example do the following:

In cell A1 type 10. In cell A2 type:

=A1+B1

You will initially get 10 in A2. Say you now wanted to find out what value you would put in B1 so that the formula in A2 gives a total of 16. Obviously you know that it would be 6. What you can do is go to the Tools menu and select Goal Seek. In the dialog box that comes up you will get 3 things to fill in.

In the Set Cell box, type A2

In the To Value box, type 16

In the By Changing Cell box type B1.

The result will be the appearance of 6 in cell B1. Obviously that is a simple example that you could work out in your head, but occasionally there will be cases where you want to find a value that is not so easy to work out. That is when you use Goal Seek.

What is chart sheet?

When you create a chart it can be embedded into the sheet where the data appears. You also have the option of setting the chart to be on a sheet tab of its own. This is a Chart Sheet.

How can you open an existing workbook?

Use the Open option in the program, through the menus or ribbons or pressing Ctrl - O. You can also find the file in the folder on your computer and double click it. If the file has been recently opened, then it will be on the Recent Documents list and it can be clicked there.

How do you get the rows to line up in excel?

This question is not clear. All rows already are lined up. If you are trying to align the contents of cells, you can highlight the column you want to align and select the same alignment for all rows in that column.

Rename a file in Excel?

You wouldn't rename a file in Excel. You would normally do it through Windows Explorer. However when opening a file in Excel, when the Open Dialog is open, it is possible to click on a file and rename it or do it through the Tools menu in the Open Dialog box. However you would rarely use that approach. The other thing you can do is use Save As and choose a new name, which will give you a copy and retain the old file.

Can you double-click on a sheet tab to change the name of the tab?

you right click on the tab and it'll say rename then you rename it to what ever you want

What can you do with data using Microsoft Excel?

Spreadsheets can be used for financial analysis, which is something all businesses need to do. We would particularly associate them with people like accountants, but they are not limited just to them. Anyone trying to do things like record sales or costs can use a spreadsheet. A large amount of running a business involves dealing with calculations. Companies can use accountancy packages and payroll packages, but they can also do a huge amount with spreadsheets. They can use spreadsheets to generate charts which is useful for businesses. There is so many things that a spreadsheet can be used for in a business, that it would be impossible to list them all.

What is the control center in Excel?

How to open and close Control Center

The way you open and close Control Center depends on the type of device that you have. Find your device model below, then follow the steps. Or learn how to open Control Center on your iPad.

iPhone X and later

To open Control Center, swipe down from the top-right corner of your screen.

To close Control Center, swipe up from the bottom of the screen or tap the screen.

If you swipe too close to the top-center of your screen, you might open Notification Center instead of Control Center.

iPhone SE, and iPhone 8 and earlier

To open Control Center, swipe up from the bottom edge of any screen.

To close Control Center, tap the top of the screen or press the Home button.

Hope This Helps,

Peter

How do you create a pivot table in Excel?

Just select the data and then click Pivot table on the insert menu.

You have to ensure that all Headers needs to be filled to create Pivot table.

If there is any blank cell in Headers you will not able to Create pivot table for that Data field.

Can you open Excel with Microsoft PowerPoint?

You can put a link into a Powerpoint document that will open an Excel file in Excel.

You can put a link into a Powerpoint document that will open an Excel file in Excel.

You can put a link into a Powerpoint document that will open an Excel file in Excel.

You can put a link into a Powerpoint document that will open an Excel file in Excel.

You can put a link into a Powerpoint document that will open an Excel file in Excel.

You can put a link into a Powerpoint document that will open an Excel file in Excel.

You can put a link into a Powerpoint document that will open an Excel file in Excel.

You can put a link into a Powerpoint document that will open an Excel file in Excel.

You can put a link into a Powerpoint document that will open an Excel file in Excel.

You can put a link into a Powerpoint document that will open an Excel file in Excel.

You can put a link into a Powerpoint document that will open an Excel file in Excel.