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 a 3-D cell reference?

A cell reference that contains the column, row and sheet of a cell. The sheetname comes first, followed by an exclamation mark and then the cell. So cell C3 on Sheet1 would be referenced like this:

Sheet1!C3

How do you make excel repeat a word?

You highlight the box the word is in and drag it to other boxes

How do you change string data into date format in Excel?

An example is given below, where 111013 is in cell A1:

=DATE(RIGHT(A1,2),MID(A1,3,2),LEFT(A1,2))

Further information is given in the related link.

Can i see a Fossil chart?

We don't show charts on here. I suggest you do a search.

What does the Escape key do in Excel?

The ESC key can be your friend in some circumstances. If you click on a menu item by mistake, sometimes you can cancel the task by pressing the ESC key. If you start typing in a cell and change you mind, just press the ESC key to blank the cell and let you start over.

Why is a KWL chart helpful when reading a selection?

A KWL chart is helpful when reading a selection because it encourages active engagement with the material by prompting readers to identify what they Already know (K), what they Want to learn (W), and what they have Learned (L) after reading. This structured approach enhances comprehension and retention, as it helps to activate prior knowledge and set specific learning goals. Additionally, it provides a clear framework for summarizing key takeaways, making it easier to reflect on the reading experience. Overall, it fosters a more interactive and purposeful reading process.

What are box and whisker diagrams used for?

Box and whisker plots are based on medians. The first step is to rewrite the data in order, from smallest length to largest. Then find the median of all numbers. The next step is to find the lower median... according to your data. Next, you find the upper median. Now you are ready to construct the actual box and whisker graph. First, draw an ordinary number line that extends far enough to include all of the numbers in your data. Then, locate the main median using a vertical line just above your number line. When you locate your lower and upper median, you place smaller vertical lines on top of those. Next, draw a box, using the lower and upper median lines as endpoints. Finally, the whiskers extend out to the data's smallest number and to the largest number. This is a box and whisker plot.

A box and whisker plot is used to display a set of data so that you can easily see where most of the numbers are.

Here is an example and a picture of a box and whisker plot!

By: a 7th grade Algebra 1 student

What are five types of formatting?

Indentation
Paragraphing
Justifying
Left aligning
Changing fonts.

What function do you use to determine how many entries are in a particular column?

The Count function can be used if you are looking for just numbers and the Counta function if you are looking for numbers and text entries.

Should dates that include years both before and after the year 2000 be formatted with a two digit year?

Ideally you should use a 4 digit year. It will depend on what way the system is set up to deal with two digits. Years close to 2000, before or after, should be ok. If you wanted to use a wide range of dates, something like 1914 and put in 14, it would default to 2014. Using the 4 digit format will make it clear. So it depends on the context.

Ideally you should use a 4 digit year. It will depend on what way the system is set up to deal with two digits. Years close to 2000, before or after, should be ok. If you wanted to use a wide range of dates, something like 1914 and put in 14, it would default to 2014. Using the 4 digit format will make it clear. So it depends on the context.

Ideally you should use a 4 digit year. It will depend on what way the system is set up to deal with two digits. Years close to 2000, before or after, should be ok. If you wanted to use a wide range of dates, something like 1914 and put in 14, it would default to 2014. Using the 4 digit format will make it clear. So it depends on the context.

Ideally you should use a 4 digit year. It will depend on what way the system is set up to deal with two digits. Years close to 2000, before or after, should be ok. If you wanted to use a wide range of dates, something like 1914 and put in 14, it would default to 2014. Using the 4 digit format will make it clear. So it depends on the context.

Ideally you should use a 4 digit year. It will depend on what way the system is set up to deal with two digits. Years close to 2000, before or after, should be ok. If you wanted to use a wide range of dates, something like 1914 and put in 14, it would default to 2014. Using the 4 digit format will make it clear. So it depends on the context.

Ideally you should use a 4 digit year. It will depend on what way the system is set up to deal with two digits. Years close to 2000, before or after, should be ok. If you wanted to use a wide range of dates, something like 1914 and put in 14, it would default to 2014. Using the 4 digit format will make it clear. So it depends on the context.

Ideally you should use a 4 digit year. It will depend on what way the system is set up to deal with two digits. Years close to 2000, before or after, should be ok. If you wanted to use a wide range of dates, something like 1914 and put in 14, it would default to 2014. Using the 4 digit format will make it clear. So it depends on the context.

Ideally you should use a 4 digit year. It will depend on what way the system is set up to deal with two digits. Years close to 2000, before or after, should be ok. If you wanted to use a wide range of dates, something like 1914 and put in 14, it would default to 2014. Using the 4 digit format will make it clear. So it depends on the context.

Ideally you should use a 4 digit year. It will depend on what way the system is set up to deal with two digits. Years close to 2000, before or after, should be ok. If you wanted to use a wide range of dates, something like 1914 and put in 14, it would default to 2014. Using the 4 digit format will make it clear. So it depends on the context.

Ideally you should use a 4 digit year. It will depend on what way the system is set up to deal with two digits. Years close to 2000, before or after, should be ok. If you wanted to use a wide range of dates, something like 1914 and put in 14, it would default to 2014. Using the 4 digit format will make it clear. So it depends on the context.

Ideally you should use a 4 digit year. It will depend on what way the system is set up to deal with two digits. Years close to 2000, before or after, should be ok. If you wanted to use a wide range of dates, something like 1914 and put in 14, it would default to 2014. Using the 4 digit format will make it clear. So it depends on the context.

What is the y axis on a chart?

Normally, the y axis on on a graph is the one that goes vertically. It usually used to represent the output of a function, where the x axis (the horizontal one) represents the input.

Made changes to an excel document then saved then exited now want to get original?

If you have saved it over the previous document, using the same name and location, then the previous version is gone and cannot be restored. So you can either find a completely separate copy of the original or open the document and try to make the changes to restore it to the way it was. If you are doing that, maybe first save the newest version with a different name, in case you want to have that one too.

What shows objects arrangged in equal rows and columns?

This is a square matrix where the number of rows and the number of columns are equal.

What is range reference in Excel?

A range is a group of two or more cells that can be referenced as a single block using the top left and bottom right cells. The addresses of the two cells are separated by a colon to form the range reference. So the cell reference A3:A10 refers to all of the cells A3, A4, A5, A6, A7, A8, A9 and A10. The cell reference C12:E14 refers to cells C12, D12, E12, C13, D13, E13, C14, D14 and E14. A range reference is always used in a function, like in the examples below:

=SUM(A3:A10)

=AVERAGE(C12:E14)

What consists of text that you type until you press the ENTER key?

Formulas display as text while you are entering them in a cell. They display a calculated value after you press the ENTER key. For example, you can type =8+2 in a cell and when you press ENTER, the cell will display the value 10.

What does it mean to stack charts in excel?

A stacked column chart allows each column to represent more than one value. So if you wanted to see how sales you had in four regions, but wanted the four regions in a single column, then you would use a stacked column chart.

What movement does the column left right movement most closely resemble?

There are no columns shown. This makes it impossible to go through and provide an accurate answer for you.