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 the Dangers of being hung upside down?

you will die eventually by all the blood pressure from your body going to your brain

How many rows and columns are there in Excel?

That depends on the version you have. Up to Excel 2003, the standard amount of columns has been 256. They are labelled by letters. After Z you get AA, AB, AC etc. until you get to AZ. Then it is BA, BB, BC and so on. The 256th column is IV. There have been 65,536 rows, all numbered. That makes 16,777,216 cells. That was the case up to Excel 2003.

In Excel 2007 the maximum number of rows per worksheet increased to 1,048,576 and the number of columns increased to 16,384 which is column XFD. That makes 17,179,869,184 cells. Excel 2010 and Excel 2013 have the same amount of rows and columns.

Would it be a mixed or relative cell reference to copy the same formula in cell C13 to cell D13?

What determines what type of reference a cell is, is how it is typed, not what happens when you copy it. It is the type of reference that influences how it changes when it is copied, not the other way around. If the formula does not change at all, it would be an absolute reference. The cell references would all have 2 dollars, like $C$5. If it does change, it can be either a mixed or a relative reference. A mixed reference will have one dollar sign, either $C5 or C$5. What direction it is copied will and how it changes, is determined by which dollar you have. The first dollar locks the column, and the second dollar locks the row. A relative reference has no dollars. Copying a formula from C13 to D13, will change the column references only, so if the cell reference is the first kind of mixed, then it won't change.

What are slices in Excel?

In Excel slices relate to pie charts. Pieces of pie charts are referred to as slices. They represent the different values that are being charted.

How do you write a formula for if cell a is less than 88 then return 2 but if cell a is greater than 91 then return 0 and if it is anything in between those two numbers then return 1?

=if(a < 88, 2, if(a > 91, 0, 1))

Which says:

if a less than 88 return 2 else if a greater than 91 then return 0 else return 1 (since a is greater than or equal to 88 and less than or equal to 91).

I assume "between" in your question means inclusive - otherwise there is nothing in your question which states what to do when cell a is 88 or 91.

Depending upon your spreadsheet program, the commas may need to be replaced by semicolons.

Can you update an Excel chart linked to a Word document?

If they are linked probably, you should be able to update it automatically.

What is a worksheet grid?

It is the collection of lines you see crossing the page to define the boundaries of each cell. The grid normally does not print, but is used to aid spreadsheet design.

How information for spreadsheet could be present?

Information from a spreadsheet can be presented in different ways. You can show the actual data as it is. You can show just totals, using the Group and Outline option. You could also consolidate data. You could set up Custom Views to show particular parts of the worksheet and move to them quickly. You could also present data in the charts that are available. You could also copy any of these things to a presentation software, such as Powerpoint, and use it to present the data. You could also print it out. It really depends on what you are trying to do and who the data is being presented to and what they want to see.

What ribbon is the goal seeking command on in Excel?

In Excel 2007, on the Data ribbon tab, click on What-If Analysis in the Data Tools group, and select Goal Seek. In older versions of Excel it is on the Tools menu.

What is one page on a worksheet?

There is no specific name for one page on a worksheet. A worksheet can be printed and will appear on many pages, depending on its size. Word processing documents have pages, whereas spreadsheet documents have worksheets. A worksheet is broken down into rows, columns and cells. They are not really though of in terms of pages, until printing happens.

When typing in a cell in Excel what does a TAB do?

The Tab key will move from one cell to the next in Excel, or through different options in a dialog box if one is open. If you are typing when you hit the tab key it will enter what you have typed into that cell and move the cursor one cell to the right.

When was the binary system first created and by whom?

It appears to have been first used by the Indian scholar Pingala, some time between the 5th and 2nd centuries BCE. See link for more.

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).

Why should you reserve the first row for a spreadsheet what?

You can keep it for headings. It can also give you flexibility to add in more data easier at the top.

What does the represent in an Excel spreadsheet?

The word "the" does not really represent anything in an excel spreadsheet. My guess is that the person who asked this question left something out or was trying to find the meaning of a symbol which can't be represented here.

An efficient way to locate and utilize functions in Excel is to use?

You can use the Function option on the Insert menu or you can click on the function button beside the formula bar which is like fx.

Can data from Excel workbook be added to a PowerPoint slide?

Yes. You can add date from a MS Excel worksheet to a Power Point slide 2 ways.

1. You can highlight the cells you want to use and then copy and paste them to the slide.

2. You can create a table on the slide the same size and layout as the data in the Excel worksheet and copy/paste the data from the worksheet into the slide table either one at a time or all at once.

Why are cells in a spreadsheet locked?

They are not actually locked as such. The locking only occurs when Protection is turned on. Having locked already set just makes it simpler when Protection is put on, rather than having to go through the individual cells to lock them then too. As long as Protection is off locking has no effect so you can work on the spreadsheet as normal. If a user wants some cells to be left so that nobody can change them, like rates of pay for staff that might be using it, locking can be implemented with Protection.

Are Excel documents printed in landscape orientation?

In Excel you can choose landscape or portrait from the print menu, the default is normally portrait.

Which of the following Excel taks creates a formula that refers to cells in another workbook?

Stop copying your multiple-choice homework questions here. If you want help with your homework, at least form a question that includes words that make it clear what you want to know.