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 difference between worksheet and workbook?

The worksheets are the individual sheets that you work on. A workbook contains all the individual worksheets. It is the file that you save.




Is F4 the function used to copy and paste cells?

No it isn't. The F4 key redos the last action. However, if the F4 key is hit just after something has been pasted, you can paste again into another cell.

What completes a formula in Excel?

After typing the formula, to complete it you can press any of the follow keys or key combinations.

The Enter key. (on the numeric keypad)

The Return key. (The key on the main keypad with that people mistakenly called the Enter key)

The down arrow key.

The up arrow key.

The left arrow key.

The right arrow key.

The Home key.

The End key.

The Page Up key.

The Page Down key.

The Tab key.

Ctrl-Enter

Ctrl-Shift-Enter (for array formulas)

Ctrl-Return

Ctrl-Shift-Return (for array formulas)

How do you know if granola bar is expired without box?

look around on the plastic wrapper and maybe under a flap, and it should be there

An easy way to verify that a formula references the cells that you want it to reference is to use Excel's?

Range finder. Double clicking on the formula activates the range finder and you can see what cells are in the formula. This can help you see if the correct cells are in the formula.

Is a formula an equation that performs calculations on number values in cells?

a formula is an equation that performs mathematical calculations on number values in cells

An alternative to clicking the Paste button is to?

Hit Ctrl V

----------------------

An alternative to clicking the Paste button is to press the Enter Key. The Enter Key completes the paste operation, removes the marquee from the source area, and disables the Paste button so that you cannot paste the copied source area to other destination areas.

PAGE EX153

Microsoft Office 2010

Verical lines in Microsoft Excel are called in microsoft EXcel?

The actual lines are known as gridlines, both vertical and horizontal. A vertical line of cells is known as a row.

Save as option missing in Excel 2003?

In 2003 the menus initially open only showing the more commonly used options. At the bottom of the menu you will see a double arrow head pointing down. Click on it will open the full menu, and Save As should be there. Also, if you wait a few seconds, the full menu will open, but it is quicker to click on the double arrow head.

What are the lots types of data in MS Excel?

MS Excel uses two types of data: text and numbers.

What function do you use to calculate the mean for cells that meet a criterion?

The AVERAGEIF function. It can also be done with a combination of the AVERAGE and IF functions, entered as an array formula.

What is it called when a cell is identified by the column number and cell number in Excel?

>Select the cell, range of cells, or nonadjacent selections that you want to name.

>Click the Name box at the left end of the formula bar

>Type the name that you want to use to refer to your selection,

>Press ENTER.

Where may one print out a free CMYK Colour Chart for House Use?

BestPrintingOnline contains a free CMYK Colour Chart for House Use that can be printed. One can also order large and high quality posters from their website.

What toolbars are most useful in Excel?

All toolbars are useful, depending on what you are doing. The two most generally useful toolbars are the Standard and Formatting toolbars. They have the most commonly used icons in them for working with Excel. In versions of Excel that use Toolbars, which is up to Excel 2003, it is advisable to always have those two toolbars visible.

All toolbars are useful, depending on what you are doing. The two most generally useful toolbars are the Standard and Formatting toolbars. They have the most commonly used icons in them for working with Excel. In versions of Excel that use Toolbars, which is up to Excel 2003, it is advisable to always have those two toolbars visible.

All toolbars are useful, depending on what you are doing. The two most generally useful toolbars are the Standard and Formatting toolbars. They have the most commonly used icons in them for working with Excel. In versions of Excel that use Toolbars, which is up to Excel 2003, it is advisable to always have those two toolbars visible.

All toolbars are useful, depending on what you are doing. The two most generally useful toolbars are the Standard and Formatting toolbars. They have the most commonly used icons in them for working with Excel. In versions of Excel that use Toolbars, which is up to Excel 2003, it is advisable to always have those two toolbars visible.

All toolbars are useful, depending on what you are doing. The two most generally useful toolbars are the Standard and Formatting toolbars. They have the most commonly used icons in them for working with Excel. In versions of Excel that use Toolbars, which is up to Excel 2003, it is advisable to always have those two toolbars visible.

All toolbars are useful, depending on what you are doing. The two most generally useful toolbars are the Standard and Formatting toolbars. They have the most commonly used icons in them for working with Excel. In versions of Excel that use Toolbars, which is up to Excel 2003, it is advisable to always have those two toolbars visible.

All toolbars are useful, depending on what you are doing. The two most generally useful toolbars are the Standard and Formatting toolbars. They have the most commonly used icons in them for working with Excel. In versions of Excel that use Toolbars, which is up to Excel 2003, it is advisable to always have those two toolbars visible.

All toolbars are useful, depending on what you are doing. The two most generally useful toolbars are the Standard and Formatting toolbars. They have the most commonly used icons in them for working with Excel. In versions of Excel that use Toolbars, which is up to Excel 2003, it is advisable to always have those two toolbars visible.

All toolbars are useful, depending on what you are doing. The two most generally useful toolbars are the Standard and Formatting toolbars. They have the most commonly used icons in them for working with Excel. In versions of Excel that use Toolbars, which is up to Excel 2003, it is advisable to always have those two toolbars visible.

All toolbars are useful, depending on what you are doing. The two most generally useful toolbars are the Standard and Formatting toolbars. They have the most commonly used icons in them for working with Excel. In versions of Excel that use Toolbars, which is up to Excel 2003, it is advisable to always have those two toolbars visible.

All toolbars are useful, depending on what you are doing. The two most generally useful toolbars are the Standard and Formatting toolbars. They have the most commonly used icons in them for working with Excel. In versions of Excel that use Toolbars, which is up to Excel 2003, it is advisable to always have those two toolbars visible.

What does ctrl plus R do in Microsoft Excel?

If you have a range of cells selected which includes more than column, it copies what is in the first column to the right. So whatever is in the first cell on each row in the area selected, is copied across that row within the area selected.

What must you do to enter a number as a label in a Excel cell?

Put a single quote before the number or type it in as usual and format it as Text. The number will align to the left, which indicates that it is text. Using the single quote is simpler, like this:

'64

How many cells are there in the Excel worksheets 2016?

Since Excel 2007, continuing to Excel 2016, the maximum number of rows per worksheet is now 1,048,576 and the number of columns is 16,384. That makes 17,179,869,184 cells.

What is a field in excel?

A field is more a database term than a spreadsheet term. In a spreadsheet a field can refer to a column of data that is of the same type, like all numbers or all dates or birth or all home addresses etc. This would be in a case where your spreadsheet is laid out similar to a database table.

Cannot open word files MSG is the command cannot be performed because a dialog box is open click OK and then close open dialog boxes to continue?

AMDG+JMJ

I found this info on some other sites. The problem is with Norton Anti Virus (not Norton Internet Security). If you disable the MS Office plugin option it fixes the problem.

Here's a link that shows how to do it.

http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=109

If the above didn't help or not applicable, user profile could be corrupted in some way.

To fix it, try logging as the local admin or another user with admin level rights. Then hide the profile in question located in 'C:\Documents and Settings\' by renaming it. I usually add "OLD_" before the original profile name to make it recognizable while renaming it differently.

Afterwards, have that user login again which would re-create the user profile. After the profile was re-created files and settings could be transferred.

This problem also happens when you do not even have Norton Anti Virus installed on your computer. It is due to a Corrupt file. To fix - completely uninstall Microsoft Office then reinstall. You must uninstall Office first then do a complete reinstallation. Doing a repair does not fix it.

How do you add zero before values in excel document?

  • Highlight (Select) the cells in the Column
  • right click mouse go to format cell
  • go to custom
  • the one below top option should be 0
  • In the type are (0###) if you want to add 0 before 110
  • the result would be (0110) this should show in the sample box.

Cheers.