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 is the horizontal line of a chart that runs left to right in excel chart?

The horizontal axis is the one going across the bottom of a chart. It can be the X axis in some kinds of charts or the category axis in other kinds of charts.

How are formulas evaluated first in Excel?

That can depend on the formula and there are different things you could be referring to. One way of looking at how formulas operate is in regard to the way the order of operations happen. These are the rules set out in mathematics as to how calculations are done. Things inside brackets are normally done first, then things that use power of or exponentiation. Then multiplications and divisions are done. Reading left to right, multiplications are done in order they are found, as they have equal precedence. Finally additions and subtractions are done, also on a left to right basis. The order of operations can be changed by having some things in brackets. So an addition that is inside a bracket will be done before a multiplication that is done outside it. A number of acronyms are used to help people remember.

BOMDAS - Brackets, Of, Multiplication, Division, Addition, Subtraction.

PEMDAS - Parentheses, Exponentiation, Multiplication, Division, Addition, Subtraction.

"Please Excuse Me Dear Aunt Sally" is used as a way of remembering that acronym.

Another element of formulas are functions that are nested, meaning functions that are inside other functions. The inside functions are always calculated first.

Shortcut key of print preview?

If you're using Microsoft Word: Ctrl and F2 (whilst still pressing the Ctrl key).

Alt - F - V will also work.

How is the MIN function used to determine the highest number in a range?

The MIN function is the function that you would use to find the lowest value in a set. You could also use the SMALL function, but that is more when you are looking for a value other than the lowest, such as the second lowest or third lowest. That is specified by a number at the end. Both of the following will find the lowest value in the range of A2 to A16:

=MIN(A2:A16)

=SMALL(A2:A16,1)

Can you draw pictures on a spreadsheet?

It is possible to draw simple pictures in Excel, though it is not a graphics application. There are lots of graphics facilities available in it though, like shapes and special images like the sun. If you want to do a detailed picture, you would be more likely to use an actual graphics application.

What is the last columns?

XFD. you keep ctrl and then you click ->.

What button do you use to automatically label the months of the year in columns or rows of your spredsheet?

There isn't a button or command to do this but there is a shortcut. If you type the name of the first month into a cell, you can then click and drag the small black + that appears when your mouse is over the bottom right corner of the cell. This will automatically fill in the other month names in sequence.

What tool can you use in Excel to automate time-consuming or tedious tasks?

Excel has many such tools, all fundamentally being formulas and functions.

What is the best chart to use for an Excel spreadsheet?

There is no single answer to that. It depends on what you want to do. There are different types of charts because there are different kinds of things that people want to create charts for. Different charts are suited to different situations. For example, a line chart can show how things change over a period of time. An XY or Scatter chart can be used to plot points and draw lines and curves using those points. Pie charts show how much of something a value takes up, by showing it as a slice. There are lots of other charts which also have particular uses. So before choosing a chart, you need to know what you are trying to do and then you can choose the most appropriate one.

What is the function of the menu bar in Microsoft Excel?

  1. Just like any Microsoft compliant application, the Title Bar in MS Excel displays the Application Name and the current Filename of the Worsheet, this can be found o the left most portion of the bar.
  2. By double-clicking on the Title-Bar, it switches its window Maximize to Restore Mode and vice-versa.
  3. You could also move the active window by click-dragging it on the Title Bar when in Restore Mode.
  4. Performing a Right-Mouse click on the Title Bar would also show the a Short cut menu for Restoring, Minimizing, Maximizing, etc the active Window

How do you deselect data on excel?

Deselecting is removing the selection of a cell. So if a cell is selected and you click onto another cell, the first cell is no longer selected. The exceptions to this are when you have the Ctrl or Shift keys pressed when you click on another cell, or if you hold the mouse button and drag, in which case the original cell will stay selected and you can select more cells.

The page setup that allows the document to be printed in a horizontal direction on a spreadsheet?

It is landscape printing format. The vertical alignment is called portrait. You change the type of page orientation in the print setup window.

What are the buttons on the formula bar in Microsoft Excel?

You can use buttons in Excel for many things. You can create them and attach commands to them, so that users can click on a button to make something happen, like changing values. Buttons can be used to do almost anything that Excel is capable of, enabling you to create a more user-friendly system.

What is a text value also known as in Excel?

There is no single answer. Often it can be a label, which may be the answer you are looking for, but text values used in Excel are not always labels. If you have a list of names in a spreadsheet, the names are not labels. There may be a label at the top like "Names", but the names themselves are not labels.

Which software to use to manage calculations and create grahps?

A spreadsheet is the main type of software that will do this. It can be done with others, most notably a database.

How do you enter ohms symbol in Excel?

The character - Omega - is in the extended character set of many of the

default fonts, such as Ariel and Times New Roman - use Windows Character Map

to identify the extra characters. Or choose the symbon font from the Insert

What is a formula finder on Excel?

This can refer to finding what formulas use particular cells and what cells are used particular formulas. If you have a cursor on a cell with a value and press Ctrl and ] it will bring you to any formulas that use that cell. They are known as dependents. Ctrl and [ used on a formula will show the cells that formula uses. They are known as precedents. You can also get these through the Formula Auditing options.

This can refer to finding what formulas use particular cells and what cells are used particular formulas. If you have a cursor on a cell with a value and press Ctrl and ] it will bring you to any formulas that use that cell. They are known as dependents. Ctrl and [ used on a formula will show the cells that formula uses. They are known as precedents. You can also get these through the Formula Auditing options.

This can refer to finding what formulas use particular cells and what cells are used particular formulas. If you have a cursor on a cell with a value and press Ctrl and ] it will bring you to any formulas that use that cell. They are known as dependents. Ctrl and [ used on a formula will show the cells that formula uses. They are known as precedents. You can also get these through the Formula Auditing options.

This can refer to finding what formulas use particular cells and what cells are used particular formulas. If you have a cursor on a cell with a value and press Ctrl and ] it will bring you to any formulas that use that cell. They are known as dependents. Ctrl and [ used on a formula will show the cells that formula uses. They are known as precedents. You can also get these through the Formula Auditing options.

This can refer to finding what formulas use particular cells and what cells are used particular formulas. If you have a cursor on a cell with a value and press Ctrl and ] it will bring you to any formulas that use that cell. They are known as dependents. Ctrl and [ used on a formula will show the cells that formula uses. They are known as precedents. You can also get these through the Formula Auditing options.

This can refer to finding what formulas use particular cells and what cells are used particular formulas. If you have a cursor on a cell with a value and press Ctrl and ] it will bring you to any formulas that use that cell. They are known as dependents. Ctrl and [ used on a formula will show the cells that formula uses. They are known as precedents. You can also get these through the Formula Auditing options.

This can refer to finding what formulas use particular cells and what cells are used particular formulas. If you have a cursor on a cell with a value and press Ctrl and ] it will bring you to any formulas that use that cell. They are known as dependents. Ctrl and [ used on a formula will show the cells that formula uses. They are known as precedents. You can also get these through the Formula Auditing options.

This can refer to finding what formulas use particular cells and what cells are used particular formulas. If you have a cursor on a cell with a value and press Ctrl and ] it will bring you to any formulas that use that cell. They are known as dependents. Ctrl and [ used on a formula will show the cells that formula uses. They are known as precedents. You can also get these through the Formula Auditing options.

This can refer to finding what formulas use particular cells and what cells are used particular formulas. If you have a cursor on a cell with a value and press Ctrl and ] it will bring you to any formulas that use that cell. They are known as dependents. Ctrl and [ used on a formula will show the cells that formula uses. They are known as precedents. You can also get these through the Formula Auditing options.

This can refer to finding what formulas use particular cells and what cells are used particular formulas. If you have a cursor on a cell with a value and press Ctrl and ] it will bring you to any formulas that use that cell. They are known as dependents. Ctrl and [ used on a formula will show the cells that formula uses. They are known as precedents. You can also get these through the Formula Auditing options.

This can refer to finding what formulas use particular cells and what cells are used particular formulas. If you have a cursor on a cell with a value and press Ctrl and ] it will bring you to any formulas that use that cell. They are known as dependents. Ctrl and [ used on a formula will show the cells that formula uses. They are known as precedents. You can also get these through the Formula Auditing options.

What is a value in Excel?

A value is something that can be used in a calculation. Usually that means a number, but it could also be a date or a time. As a number it can take various formats, such as percentage, currency, decimal, scientific notation and others, depending on what is it you are trying to do.

What is the cost of Microsoft Excel?

Microsoft Office Home and Student is $99.99.

I would recommend, however, that you use OpenOffice for home use, as it is completely free and does just about everything that Microsoft Office does.

Although it can do some similar stuff, you can not however use wordart or make autoshapes.

which is not so good:(

What is displayed next to a cell in which a formula error occurs?

The # will always be the first character shown and it will be followed by the name of the particular error. Common ones could be:

#REF!

#VALUE!

#NUM!

If you see the # repeated, it indicates that the cell is not wide enough to show the value in the cell. It is not necessarily an error.

OR

A green triangle in the upper left corner of the cell

Can you use a name range instead of a cell address in a formula in Excel 2016?

Yes you can. That is part of the reason for having them. It makes referring to cells or ranges easier and makes formulas easier to understand like in the two sets of examples below:

=SUM(A2:A20)

=SUM(Income)

=B20-A20

=Income-Expenses