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 name given to built in calculations?

SUM is a function. It can be used as part of a formula which can carry out a calculation.

What kind of spark lines can you use in Excel?

There are three types. They are Line, Column, and Win/Loss.

How does Excel automatically enter today's date?

If you press the Ctrl key and the ; key, it will put in today's date. If you use the Today() function, it will always show the current date when a spreadsheet is opened. So in a cell you just have to put:

=Today()

Then no matter when you open the file it will always have the date of the current day in that cell.

Could this proportion be used to answer the following question 50 is 125 of what number?

The question seems to be incomplete, but here are some thoughts. In word problems, "of" usually means "multiplied by". So you could certainly ask "50 is 125 times what number? You can set this up as a very basic algebra problem, and find the answer. (Be careful; the answer is smaller than 1). It's possible that you mean "50 is 125 percent of what number?" That's a different problem altogether. It is still an easy algebra equation, but you need to be careful how you express "125%" as a factor. If you do it right, your answer will be greater than 10 and less than 100.

33 and half percentage of 100?

33.5 If the question was "what is 33 and a half expressed as a percentage of 100?" The answer would be 33.5%

What sign is used for addition in Excel?

The plus sign. +

To add values in the cells A3 and B3 you would do the following:

=A3+B3

What is a benefit of using the AutoFilter option?

It allows you to view only the neccesarry data. <plato>

Why using OFFSET in Excel?

It returns a reference to a range that is offset a number of rows and columns from another range or cell. There are a wide variety of reasons for using it. It can be a handy way of locating a cell whose position can be calculated from another given cell. It can be used to select dynamic ranges. These would be ranges that can change. This is very useful for graphs where the data is continually being added to and you want to keep the range automatically up to date.

What do you say when you are asked to dexribe your proficiency level with Microsoft Word and Microsoft Excel?

That will depend on how well you are able to use them, so without knowing that, it is impossible to answer the question for you. You just have to tell them how much you know and do it in a positive manner. If you do not know much you could say that you are willing to learn.

That will depend on how well you are able to use them, so without knowing that, it is impossible to answer the question for you. You just have to tell them how much you know and do it in a positive manner. If you do not know much you could say that you are willing to learn.

That will depend on how well you are able to use them, so without knowing that, it is impossible to answer the question for you. You just have to tell them how much you know and do it in a positive manner. If you do not know much you could say that you are willing to learn.

That will depend on how well you are able to use them, so without knowing that, it is impossible to answer the question for you. You just have to tell them how much you know and do it in a positive manner. If you do not know much you could say that you are willing to learn.

That will depend on how well you are able to use them, so without knowing that, it is impossible to answer the question for you. You just have to tell them how much you know and do it in a positive manner. If you do not know much you could say that you are willing to learn.

That will depend on how well you are able to use them, so without knowing that, it is impossible to answer the question for you. You just have to tell them how much you know and do it in a positive manner. If you do not know much you could say that you are willing to learn.

That will depend on how well you are able to use them, so without knowing that, it is impossible to answer the question for you. You just have to tell them how much you know and do it in a positive manner. If you do not know much you could say that you are willing to learn.

That will depend on how well you are able to use them, so without knowing that, it is impossible to answer the question for you. You just have to tell them how much you know and do it in a positive manner. If you do not know much you could say that you are willing to learn.

That will depend on how well you are able to use them, so without knowing that, it is impossible to answer the question for you. You just have to tell them how much you know and do it in a positive manner. If you do not know much you could say that you are willing to learn.

That will depend on how well you are able to use them, so without knowing that, it is impossible to answer the question for you. You just have to tell them how much you know and do it in a positive manner. If you do not know much you could say that you are willing to learn.

That will depend on how well you are able to use them, so without knowing that, it is impossible to answer the question for you. You just have to tell them how much you know and do it in a positive manner. If you do not know much you could say that you are willing to learn.

How do you leave a cell with a formula blank until data is entered?

You could use an IF function to check if a value has been entered into a cell, and if it has to use the formula or else display nothing. So say you wanted to multiply the value in cell B3 by 10 if there was something in B3 or otherwise show a blank. Then in another cell that you wanted the result you would enter the following formula:

=IF(ISBLANK(B3),"",B3*10)

So in one part we check if B3 is blank. If it is, we have a pair of double quotes to put nothing into the cell. If it is not blank, we multiply B3 by 10. You could put whatever formula you need there.

ISBLANK checks if the cell is blank. You can also use other similar functions, like ISNUMBER to check if there is a number or ISLOGICAL to check if there is a logical value, and some other functions. You can use whatever one of them is appropriate.

What is fill formating in Excel?

Fill formatting allows you to take just the formatting from a cell and put it into a load of other cells, similar to using the Format Painter. You could have a cell with particular formatting on it, and drag it down and pick just to take its formatting, not its value or formula, and fill that into the other cells.

Formatting cells in a worksheet allows you to change?

Formatting cells in a worksheet allows you to change the appearance of data, including font style, size, color, and background shading. It also enables adjustments to the alignment, borders, and number formats (like currency or percentages). These enhancements improve readability and presentation, making it easier to analyze and interpret the information. Overall, effective cell formatting helps convey the intended message more clearly.

Do you plant in the row or on top?

When planting, it's generally best to plant in the row, as this allows for proper spacing and organization of plants, which can enhance growth and facilitate maintenance. Planting in rows also makes it easier to manage watering, weeding, and harvesting. However, specific planting methods may vary depending on the type of crop and gardening techniques used.