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

When would you use a chart rather than a table?

A chart is a graphical representation of your figures, like in a pie chart, a line chart or a column chart for example. A table consists of the figures in your spreadsheet, arranged in an orderly fashion, and from which you can make a chart.

In a database, a table is usually lists of data, such as names or addresses. Word can also have tables to list out names and addresses, or to list out numbers like in a spreadsheet.

What does formatting only in Excel mean?

It is possible to copy just the formatting of one cell on to others. Normally when you copy you copy the formula, but sometimes you may just want to use the formatting from one cell. So you can take the "formatting only" and apply it to the other cells. This will change the format of the cells, but not what is actually in them.

What tab does the freeze panes appear?

It is in the Windows group on the View tab.

What is cell reference C10?

It is a relative reference to the cell in column C and row 10.

What are the steps to fit a printout on one page on excel?

  1. From Print Preview, select Page Setup.
  2. On the Page tab, click "Fit to:" in the scaling section (identify how many pages wide and tall you want to display).

Moving from column A to column B would be equivalent to what process?

To move the cursor, you can tab or use the arrow keys or click on the cell. To move data you can cut and paste it.

When new rows are added to an existing worksheet what do cell references do?

Cell references will adjust to suit the new situation so that all formulas still work correctly. This is essential, as a spreadsheet could not work in a practical manner if you needed to continually adjust formulas when insert or removing rows or columns.

What does speed fill do in Excel?

It allows you to quickly fill a range of cells with some data or a formula.

What is the expressions which help to calculate and analyze the data in your worksheet in Microsoft Excel?

They are called formulas.

They are called formulas.

They are called formulas.

They are called formulas.

They are called formulas.

They are called formulas.

They are called formulas.

They are called formulas.

They are called formulas.

They are called formulas.

They are called formulas.

Why is it every time you turn off the power to your laptop you lose everything like your favorites your search engine and some data you had in Excel and so on?

There are two different ways to turn your laptop off. For you, the best method would probably be to hit the power button on your laptop rather than to hit the shut down option in your start menu. Unless there is an update or you need to sync files to a server, there is no real need for the complete shutdown. When you turn your laptop on again, everything you previously had open should still be there.

Is it true that a formula can consist of a single cell reference?

It is possible for a formula not to have any cell references. Lots of functions do not use any values. To show the current date you could have the following in a formula:

=TODAY()

You could have a formula with a single cell reference with some operation being done on it:

=B4*10

You can have a formula that just has a cell reference which will just request that the current cell displays what is seen in another cell:

=B4

It is possible for a formula not to have any cell references. Lots of functions do not use any values. To show the current date you could have the following in a formula:

=TODAY()

You could have a formula with a single cell reference with some operation being done on it:

=B4*10

You can have a formula that just has a cell reference which will just request that the current cell displays what is seen in another cell:

=B4

It is possible for a formula not to have any cell references. Lots of functions do not use any values. To show the current date you could have the following in a formula:

=TODAY()

You could have a formula with a single cell reference with some operation being done on it:

=B4*10

You can have a formula that just has a cell reference which will just request that the current cell displays what is seen in another cell:

=B4

It is possible for a formula not to have any cell references. Lots of functions do not use any values. To show the current date you could have the following in a formula:

=TODAY()

You could have a formula with a single cell reference with some operation being done on it:

=B4*10

You can have a formula that just has a cell reference which will just request that the current cell displays what is seen in another cell:

=B4

It is possible for a formula not to have any cell references. Lots of functions do not use any values. To show the current date you could have the following in a formula:

=TODAY()

You could have a formula with a single cell reference with some operation being done on it:

=B4*10

You can have a formula that just has a cell reference which will just request that the current cell displays what is seen in another cell:

=B4

It is possible for a formula not to have any cell references. Lots of functions do not use any values. To show the current date you could have the following in a formula:

=TODAY()

You could have a formula with a single cell reference with some operation being done on it:

=B4*10

You can have a formula that just has a cell reference which will just request that the current cell displays what is seen in another cell:

=B4

It is possible for a formula not to have any cell references. Lots of functions do not use any values. To show the current date you could have the following in a formula:

=TODAY()

You could have a formula with a single cell reference with some operation being done on it:

=B4*10

You can have a formula that just has a cell reference which will just request that the current cell displays what is seen in another cell:

=B4

It is possible for a formula not to have any cell references. Lots of functions do not use any values. To show the current date you could have the following in a formula:

=TODAY()

You could have a formula with a single cell reference with some operation being done on it:

=B4*10

You can have a formula that just has a cell reference which will just request that the current cell displays what is seen in another cell:

=B4

It is possible for a formula not to have any cell references. Lots of functions do not use any values. To show the current date you could have the following in a formula:

=TODAY()

You could have a formula with a single cell reference with some operation being done on it:

=B4*10

You can have a formula that just has a cell reference which will just request that the current cell displays what is seen in another cell:

=B4

It is possible for a formula not to have any cell references. Lots of functions do not use any values. To show the current date you could have the following in a formula:

=TODAY()

You could have a formula with a single cell reference with some operation being done on it:

=B4*10

You can have a formula that just has a cell reference which will just request that the current cell displays what is seen in another cell:

=B4

It is possible for a formula not to have any cell references. Lots of functions do not use any values. To show the current date you could have the following in a formula:

=TODAY()

You could have a formula with a single cell reference with some operation being done on it:

=B4*10

You can have a formula that just has a cell reference which will just request that the current cell displays what is seen in another cell:

=B4

Is it possible to sum the cells in the given range which meets given criteria using MS-Excel?

Yes. You can use the SUMIF function. Suppose you wanted to add all the cells in the range from B2 to B15 that have values greater than 50:

=SUMIF(B2:B15,">50")

What formula adds 100 to cell A1?

=A1+100

or

=100+A1

This can be put in any cell except A1, so the total will show in the new cell, not in A1 itself. To actually add 100 to the A1 itself, first type 100 into another cell. Then select it and copy it. The select A1. Go to Paste Special and click on Add in operations, and then click OK. 100 will be added to the value that was in A1.

What are the functions of kalanchoe?

Kalanchoe is a versatile succulent plant known for its ornamental and medicinal functions. Ornamentally, it is popular for its vibrant flowers and foliage, making it a favored choice for indoor and outdoor gardens. Medicinally, certain species of Kalanchoe are used in traditional medicine for their anti-inflammatory and wound-healing properties. Additionally, it is known for its air-purifying qualities, contributing to improved indoor air quality.

What does hide and unhide do in Excel?

Hide and unhide literally do what they say. They enable you to hide and unhide rows and columns on a worksheet. Sometimes you may have some data on a worksheet that is needed, but does not have to be seen, so it can be hidden. A formula that is important on the sheet may be based on another formula, that does not need to be displayed. You may want to hide data that supports a formula. There may be data that you do not want users to see, which will prevent them from editing it or even deleting it, which may affect other formulas. For these and lots of other reasons, sometimes it is useful to be able to hide rows and columns in a worksheet, so this option is available.

What is a Term for how you view yourself?

The term for how you view yourself is "self-concept." This encompasses your beliefs, values, and perceptions about your identity, abilities, and worth. It plays a crucial role in shaping your behavior and interactions with others. A positive self-concept can lead to greater confidence and resilience, while a negative self-concept may hinder personal growth and well-being.