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

Can clicking the minimize button minimize the function arguments dialog box so you can select cells in a worksheet?

If you are selecting cells to be used in a function, you can do it without having to minimise the dialog box. You can click straight into the cells you want, once the cursor is in the right argument box for that function. You can also click on the little select icon that is at the end of each argument box that can refer to cells.

How do you insert sum functions into each of the selected cells with a single action?

Select all of the cells. Type in the SUM function into one of the cells. Then press Ctrl-Enter rather than just Enter. It will put a SUM function into all of the cells. This works for anything you type into a cell, when you have others selected.

What does Page Preview show you?

It shows you how a worksheet will look on a printed page.

When should you link to an external data source?

If an application other than access is also going to update the data.

if the data is shared over a network.

What category in Excel returns a true or false value?

Excel has a category called Logical Functions. The IF function is the one of those that most people use and associate with returning True or False values. Other functions also return True or False values. There is a TRUE function and a FALSE function. The OR function and the AND function can be used to return True or False values too. The NOT function can reverse a True or False value, so it also returns True or False.

How do you automatically group and summarize data in excel?

You use the Group and Outline option, which you can find in the Data menu.

You use the Group and Outline option, which you can find in the Data menu.

You use the Group and Outline option, which you can find in the Data menu.

You use the Group and Outline option, which you can find in the Data menu.

You use the Group and Outline option, which you can find in the Data menu.

You use the Group and Outline option, which you can find in the Data menu.

You use the Group and Outline option, which you can find in the Data menu.

You use the Group and Outline option, which you can find in the Data menu.

You use the Group and Outline option, which you can find in the Data menu.

You use the Group and Outline option, which you can find in the Data menu.

You use the Group and Outline option, which you can find in the Data menu.

What are the disadvantages of spread sheet?

1. to have a spreadsheet you need a computer and that will take up alot of room and also costs a lot.

2. you have to re-copy data over and over again to maintain it in separate data files,

3. you can not efficiently identify data errors,

4. theres a lack of detailed sorting and querying abilities,

5. sharing violations among users wishing to view or change data at the same time.

6. spreadsheets are restricted to a finite number of records

7. require a large amount of hard-drive space for data storage

8. cannot create reports like databases

What dialog box can be used to sort and filter a data source?

You'll have to do a little bit of research, but I recommend starting with 21 cup.

Which button is used to enter data in a cell?

You can click on the tick on the formula bar or just press the Enter key.

What were the Festival dates in the year 1982?

Diwali

There are many festival dates within the year stated. Traditions and festivals are different and numerous in differing calendars. To detail any and the date concerned it is necessary to know the calendar in use.

What is the dollar sign called when put in between cell numbers in a spreadsheet?

The sign itself is still referred to as a dollar, but it changes a cell reference from being a relative reference to being either a mixed reference, if one dollar is used, or an absolute reference if two dollars are used.

What functions can an accountant use in Excel?

There is a specialised category of Financial functions that an accountant could use, but they would use all sorts of different Excel functions besides the Financial functions. So regular ones like SUM and MAX and so on.

Why is Microsoft so important?

Microsoft provides us with powerful tools to run businesses around the world, create solutions and discoveries. Also they provide 100.000 people with jobs. Not counting all the people that gotten jobs other places because of the growing need for IT and because of their Operating system.

Today, computing and networking is our largest technology and Microsoft have always had the leading role bringing us User Interface, Software and Security Updates.

In addition to this they bring a decent amount of good home entertainment systems with their consoles, software and accessories.

Need a Lotus expert to translate some formulas from Lotus to Excel?

Excel can import and export Lotus 123 files directly if you installed the converter when you installed Microsoft Office. If you have the installation CD, do an install and at some point it will ask you if you want to repair/remove or modify. Modify and install the Excel converter.
Try changing the extension to WK3 or WK4 etc., which is the file format. For points on Excel 2007, see the related link.

How does an Excel window look like?

See the link below for a view of an Excel 2007 window. Other versions of Excel can look slightly different, but are fundamentally the same as they are spreadsheets.

What are the functions of oligodendrocytes?

They insulate axons by producing myelin sheathing in the neural network of some vertebrates.

Where do you find a list of Excel arguments?

Each function in Excel that has arguments will differ in terms of what arguments are needed. The help for a particular function will indicate what arguments may be needed. Some functions can be used in different ways and may not always need all arguments.

What is A6 and E9 called in a spreadsheet?

They are both cell references. A6 is the cell where column A meets row 6. E9 is where column E meets row 9.

What function is considered a conditional function?

The IF function is a conditional function. See the related question below.

What is a button on the standard toolbar that allows you to select a formula to apply?

The Autosum button allows you to choose several functions that you can use for formulas, and appeared on the old Standard toolbar.