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

In excel if you input a value in a cell how do you get it to copy to another CELL depending on a certain value?

You can not "push" a value from one cell to another cell without writing a specifc macro to do the task. You need to "pull" the value. If you want to copy the value from A1 to B1 if the value of A1 is greater than 6, put the following formula in B1:

=IF(A1>6,A1,"")

Where and by whom was the first spreadsheet created?

Visicalc was the first spreadsheet program. It was designed and created by a Harvard business student called Dan Bricklin and Bob Frankston who was a friend of his and a programmer. It was created in Cambridge Massachusetts and first released in 1979. This was done through the company called Software Arts that the two men founded.

What colors tend to reach towards your worksheet's reader?

If you are referring to colours which will catch a person's eye and interest, bold colours could be used that they are the strongest and therefore stand out the most in our vision. Colour combinations such as red and black, red and white and blue and white could attract a person's attention.

How do you remove table formatting in excel 2007?

Highlight the table range, go to cell formatting, and change the format to whatever you like.

What are elements of effective charts and graphs?

clear presentation of information

accurate information

simple, meaningful, attractive design

What is the meaning of name in excel?

It is a meaningful representation of a cell location. If total sales is displayed in cell D34, you can give the cell D34 a name called "total_sales" to help identify the cell. In this case, =D34 is the same as =total_sales.

How does columns run in Microsoft Excel?

Columns are vertical cells (they run up and down).

What makes Excel user friendly?

"User friendly" is a relative term. Will Rogers, a famous American entertainer of the 1930s, it credited with saying, "Everyone is ignorant -- but on different issues." No matter how easy a software program is for those who use it all the time, it presents a challenge to the first-time user.

If you have not used Excel before, I recommend you learn with Excel 2007. Microsoft spend a lot of money and time to develop a menu system for MS Office 2007 that is more intuitive and easier to learn that any previous version of Office (including Excel). If you are an experienced user of Excel 2003 or earlier, you will hate the new menu ribbon. But, if Excel is new to you, then so is the menu ribbon.

Excel (and all spreadsheet applications) originally was designed to replicate the work of using a manual ledger. Pages in some ledgers were called spreadsheets, and the name transferred from the paper product to the electronic one. Originally, when someone transitioned from a paper spreadsheet to an electronic one, the transition was not too painful, because the process was the same and the computer did all the arithmetic for you -- saving hours of tedious updates if you had to change one entry.

Those who use an electonic spreadsheet for the first time, not only have to learn how the program works, but also has to learn the process of organizing and working on a spreadsheet layout. Overall, I think those who do not have to deal with all of the arithmetic become productive much more quickly than those who spend hours tracking down an arithmetic error on line 123 of a 250 line manual spreadsheet.

Can workbook be inserted by the INSERT command?

No, but you can use the insert command to insert a new worksheet (a workbook is a collection of worksheet).

Why does the whole word delete when you press the back space key in Excel?

When you press the back space key while you have the cursor on a cell, you will delete the entire cell. If you want to delete only one character, select the cell, put your cursor in the formula bar at the top of the screen, then press the backspace key (that way you will edit only one character at a time instead of the entire cell).

True or falseThe primary advantage of the worksheet is to summarize text documents?

This is a false statement, but not a question. Ask again using words that make it clear what you want to know.

An example of using spreadsheet software for analyzing student performance would be?

o Creating a presentation using presentation software such as MS PowerPoint with pie charts

o Download PASS data into an application such as MS Excel

o Creating a table using software such as MS Word

Is there a spray can on Microsoft Word?

MSWord is a word-processing application, and Microsoft Office doesn't have any drawing-type applications, so I would doubt that there is a spray can. OpenOffice.org does have a built-in drawing app (OOo Draw) and the various 'parts' of OOo can work together, much better than the MSOffice 'parts' do.

I would recommend looking into Inkscape http://www.inkscape.org for a very powerful, Free (FLOSS) application, which you can then import the saved images into your MSWord, if you require MSWord for this project.

Which table option is selected to format even and odd columns differently?

  1. In Excel 2007, after you have created your table, click on the table.
  2. Select the Design tab on the menu ribbon.
  3. In the Table Style Options, click on "Banded Columns"

What is the effect of double clicking on the Format Painter icon?

If you click format painter for once you can use it at once ( in one particular cell or an array selected at once)

If you double click the format painter, you can use it multiple times/selection - in multiple cells and multiple arrays.

Please note that - to switch off the option activated by double clicking, you will have to press 'Esc'.

How do you identify a vertical column in excel?

Columns are identified by letters at the top of the column.

What is a documentation page in Excel?

If this question is referring to a page within an Excel workbook, it could be interpreted as a page where the author of the spreadsheet documents function and actions relevant to the spreadsheet functionality.

EXAMPLE: When you design a complex spreadsheet, it is a good idea to include a tab called HELP, or some other appropriate title, explaining how to complete the spreadsheet.

How do you use Microsoft Excel roundup?

RoundUp function returns a number rounded up to a specified number of digits. (Rounds away from 0.)

Syntax: RoundUp( number, digits )

number = number to round up

digits = number of digits to round the number up to

What is text alignment shortcut key justified?

Excel does not have any shortcut keys for aligning text. See related links for all shortcut keys for Excel 2007.

How do you write a single formula for two columns of data to find the median of the second column for all values that are greater than 1 in the first column?

The most critical aspect of this problem is to use an array formula. After you type the formula into a the cell you need to press CTRL+SHIFT+ENTER instead of just ENTER. This lets Excel know you want to evaluate an array (collection of cells in multiple columns) all at once, instead of considering just single cells or columns.

There are three main parts to this equation.

1) Add all the values in column 2 that correspond to specific values in column 1.

=SUM(IF(C3:C12>1,D3:D12,0))

2) Determine how many values in column 2 correspond to specific values in column 1.

=COUNT(IF(C3:C12>1,MATCH(D3:D12,D3:D12,0)))

3) Divide the SUM by the COUNT.

=SUM(IF(C3:C12>1,D3:D12,0))/COUNT(IF(C3:C12>1,MATCH(D3:D12,D3:D12,0)))

EXAMPLE SETUP:

- Put evaluation critera in C3:C12 (values that include > 1)

- Put results in D3:D12 (values for which you want to find the median)

- Put the following formula in D13:

=SUM(IF(C3:C12>1,D3:D12,0))/COUNT(IF(C3:C12>1,MATCH(D3:D12,D3:D12,0)))

After you press CTRL+SHIFT+ENTER you will see the following in the formula bar for D13:

{=SUM(IF(C3:C12>1,D3:D12,0))/COUNT(IF(C3:C12>1,MATCH(D3:D12,D3:D12,0)))}

NOTE: If you see the #VALUE! error message in the cell, that probably means you pressed ENTER instead of the combination of CTRL+SHIFT+ENTER to tell Excel you want to use an array. If you just surround the formula with {} and press enter, you still will get the error message. You must use CTRL+SHIFT+ENTER to enter an array formula.

When to use a pareta chart?

I've included some links. It frequently is both a bar graph and a line graph. The x axis show several categories, and the vertical axis shows frequency of occurrence. The bars are ordered from highest to lowest.

The bar graph y-axis can show other attributes as well, such as accidents/ year, profits, costs, etc. The main attribute is the the categories are ranked from highest to lowest.

This graph is used to prioritize efforts to make improvements. It is most useful when there is sufficient reliable data and the causes of actions are easily determined. The example used in the link, of people coming in late, is a good example, if they are honest about why they arrived late.

I've included a related link on the Pareto Principle, which is also used by businesses and individuals in prioritizing efforts. If 80% of my weight gain is due to not exercising, perhaps I should join a gym instead of answering Wikipedia questions.

What is a combo box in spreadsheet?

A combo box is a drop down list that gives you a list of things you can pick something from. You will see lots of these in programs or on web pages. It is possible to put them into Excel from the Forms toolbar or the Controls toolbar.