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

How do you protect selected area in Excel sheet?

CLick on the cell you want to protect then go to tools and protection. In the protection drop down go toallow users to edit ranges then you can click new. In new you then select the areas that people can edit and then click protect. This will then protect the sheet and not allow any areas which are locked to be edited.

What Excel sorting options do you use to sort a table of employee names in order from A to Z?

Not possible to answer this question accurately. Next time you want someone to do your homework for a multiple-choice question, choose words that make it clear what you want to know instead of just copying the text here.

What is a background formula checking in Excel?

Excel continually reviews the workbook for errors in formulas as you create or manipulate it

What is the bottommost right corner in Microsoft Excel 2007?

The bottommost corner is XFD1048576. It took a while, but I went to 1000000 and held enter until it stopped and there was grey at the bottom.

What key should you use to stop editing a cell and move on to another cell?

The 'Tab' key, usually above the caps lock key and is symbolized by two arrows pointing left and right.

Should I learn Excel or SQL?

It depends on what you want to do. Both are useful to learn and know about. Knowing either one of them would enable you to do lots of things. Knowing something about both of them would be even better.

What types of Excel charts support trend lines?

Line charts, column charts, area charts, bar charts, stock charts, xy (scatter) charts and bubble charts.

What is row banding IN EXCEL?

It is colouring alternating rows in different colours to help them stand out a bit easier when creating a formal list or table. They are coloured rows, often alternating neighbouring rows are different colours.

Is it true or false that the column headings in an Excel worksheet begin with A and end with IV?

That depends on the version. Up to version 2003, it is true. For versions since Excel 2007, the last column is XFD.

What kind of formula is function in Excel?

A function is a pre-written or built-in formula in Excel. There are many of them, all designed to do very specific tasks. The SUM function is one of the most common, making it easy to add a range of cells. See the related question below.

How do you know Excel is in copy mode?

On the status bar you will see a message telling you to choose a destination to paste to.

What symbol is typed first when a formula is entered in excel?

An equal sign because in order for the formula to go through correctly it has to have an (=)

Why would you want to hide worksheets in a workbook?

Often the main data needs supporting data, which doesn't necessarily need to be seen. Data may be sourced from lookups for example. Instead of having them on the same worksheet as the main data, you can put them onto a separate sheet and reference them and hide that sheet. If all of the supporting data is on a separate worksheet, it can help tidy up the main sheet, making it easier to follow. It also gives you more flexibility to design it better. You may also want to keep some data private, so it can be hidden on other worksheets. Sometimes, you want to have different versions of the same worksheet for different users, so you could have similar worksheets hidden in one version that is not hidden in another. So there are lots of reasons for hiding worksheets.

How do you stack information in a cell in Excel?

You need to format that cell and allow word wrap. That will enable you to say type two words like Grand Total and if the width of the column is set for the width of the word Grand then the word Total will automatically stack under as a second line. But this will change the Row's Height.

What is done prior to lithotripsy?

Prior to the lithotripsy procedure, a complete physical examination is performed, followed by tests

Why a cell in a spreadsheet has name?

It helps you clearly identify the spreadsheet. You should properly name all things on computers like spreadsheets and other kinds of documents. Then when you come to look for certain files it is easier to find them and to know what they contain. So you should always give files specific names.

Which of these is reference to the theory of evolutionism?

The development and changes that occur to all life on earth...

A+ Class