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
How do you protect file in Excel?
If you have Microsoft exel 2007, all you have to do is go onto review, then go to protect sheet (or workbook, it depends how you want to lock it - if your not sure, hover over each one and it'll tell you), then enter the password you want, then click Ok.
What is the difference between sheet tabs and worksheets?
A worksheet contains columns, rows and cells and is where you do your work. Each worksheet has a name. You can have more than one worksheet in a workbook. Each worksheet has a tab at the bottom of the screen, with its name on it. This is a sheet tab. It allows you to identify the different worksheets and by clicking on a sheet tab, you can change from one worksheet to another.
How can too much color hurt a spreadsheet?
The most important thing is that your formulas are correct and everything works. Colours are just used to highlight things and emphasise certain elements, like headings and totals. So they do not need to be used much. It is not a piece of art and Excel is not a graphics package. Too many colours can make it look gaudy. It can be very distracting. There is no use in having a very colourful workbook, if your formulas don't work. You will not get any plaudits for it. So you need to concentrate on getting your figures correct so that people that are using it can rely on the figures. That is what Excel is for.
What is a specific way Excel displays numbers in a cell?
Excel has many formats for numbers. The can be displayed with decimal points or as percentages or in Scientific notation or in currency and in a few other formats. They can have comma separation, so you could have 1,000,000 instead of 1000000. You can also format negative numbers to be displayed with a minus sign or in red. You can also set up custom formats for your numbers.
Difference in Word Excel and PowerPoint?
MS Word is a word processor and MS Excel is a spreadsheet. They serve different purposes. MS Word is used to type letters and documents. In a way, it replaces the old-fashioned typewriter. MS Excel is used to perform calculations and what-if scenarios on data. In a way, it is very sophisticated calculator.
MS Word is for creating, and editing text documents. MS Excel is for creating and editing spreadsheets. MS Power Point is for creating and editing presentations.
Excel is a spreadsheet, which is used for numerical analysis and doing calculations and many other mathematical and financial things to do with numbers. Word is a word processor, which is used for dealing with text, like writing letters or reports and being able to decide on the colour of text, the size of text; being able to bold or italicise text; run spell checks; etc.
What other key can you use to select a command using the keyboard?
The Shortcut key can be used for selecting some commands. There are also many specific shortcut key combinations for commands and there are the Function keys.
Hold down the Ctrl key & press ~ to toggle between showing formulas and resulting values
Row headers are cells containing a name for (or a description of) the information to be found in that row; they are usually placed in the leftmost column of the spreadsheet.
What happens when you change a value in Excel on which a chart is dependent?
It will immediately redraw the chart based on the new value
How do you convert excel to txf files?
With a file open, go into the File menu and pick Save As and you can choose a different file type to save your document as.
How are cell references affected by the insertion or deletion of cell in excel?
Cell references will adjust themselves to accommodate the insertion of deletion of rows and columns, so that formulas do what they are meant to do. The user is still free to make any additional adjustments that may be needed.
A simple meaning of word 'Excel'?
Microsoft Excel is the name of an electronic spreadsheet application that is produced by Microsoft and informally known as Excel. It is the leading spreadsheet application at the current time, and versions of it have been around since 1985. It is the most popular, but not the original electronic spreadsheet. That was VisiCalc, invented in 1978.
In which group of the chart tools design tab will you find the change chart type?
It is in its own group, which is just called "Type".
What is a default in spreadsheet?
A default is an existing setting. So in Excel when you type something into a cell, a font has already been set, a size has already been set, a colour is already set and so on. You can then change any of those things, but their initial settings are the default settings.
How do you unhide and hide rows and columns in excel 2007?
Click home tab, click hide and unhide, click unhide sheet. Click home tab, click hide and unhide click hide sheet.
What is the brand names of spreadsheet software?
There's quite a few... Lotus 123, Supercalc, & Microsoft Excel are three 'stand alone' programs. There are others combined into 'suites' of programs such as OpenOffice and MS Works.
Goal Seek.
What are the advantages of spreadsheet packages?
The data only needs to be input once, but can be manipulated over and over again. For instance, you have a spreadsheet of customer's addresses, you could use that data in a mail-merge. Then use the same customer data to generate reports, invoices, and so on.
The cell address F7 indicates that the cell?
It indicates that the cell is in column F and row 7. This sort of notation is often used on spreadsheets.
How do you undo a command in Excel?
Yes, there is an Undo button in Excel just like in other Microsoft applications. It works in the same way, allowing you to undo certain things.
Yes, there is an Undo button in Excel just like in other Microsoft applications. It works in the same way, allowing you to undo certain things.
Yes, there is an Undo button in Excel just like in other Microsoft applications. It works in the same way, allowing you to undo certain things.
Yes, there is an Undo button in Excel just like in other Microsoft applications. It works in the same way, allowing you to undo certain things.
Yes, there is an Undo button in Excel just like in other Microsoft applications. It works in the same way, allowing you to undo certain things.
Yes, there is an Undo button in Excel just like in other Microsoft applications. It works in the same way, allowing you to undo certain things.
Yes, there is an Undo button in Excel just like in other Microsoft applications. It works in the same way, allowing you to undo certain things.
Yes, there is an Undo button in Excel just like in other Microsoft applications. It works in the same way, allowing you to undo certain things.
Yes, there is an Undo button in Excel just like in other Microsoft applications. It works in the same way, allowing you to undo certain things.
Yes, there is an Undo button in Excel just like in other Microsoft applications. It works in the same way, allowing you to undo certain things.
Yes, there is an Undo button in Excel just like in other Microsoft applications. It works in the same way, allowing you to undo certain things.
What is the use of graphical representation in Microsoft Excel?
Primarily to create charts for use in analysing and displaying data. Excel also has ability to use some very basic graphic facilities.
Primarily to create charts for use in analysing and displaying data. Excel also has ability to use some very basic graphic facilities.
Primarily to create charts for use in analysing and displaying data. Excel also has ability to use some very basic graphic facilities.
Primarily to create charts for use in analysing and displaying data. Excel also has ability to use some very basic graphic facilities.
Primarily to create charts for use in analysing and displaying data. Excel also has ability to use some very basic graphic facilities.
Primarily to create charts for use in analysing and displaying data. Excel also has ability to use some very basic graphic facilities.
Primarily to create charts for use in analysing and displaying data. Excel also has ability to use some very basic graphic facilities.
Primarily to create charts for use in analysing and displaying data. Excel also has ability to use some very basic graphic facilities.
Primarily to create charts for use in analysing and displaying data. Excel also has ability to use some very basic graphic facilities.
Primarily to create charts for use in analysing and displaying data. Excel also has ability to use some very basic graphic facilities.
Primarily to create charts for use in analysing and displaying data. Excel also has ability to use some very basic graphic facilities.
