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

When was Gaffers' Row created?

Gaffers' Row was created on 2008-03-11.

Which function allows the user to work backward from a formula in Excel?

You can use the Formula Auditng which includes the Evaluate facility and Trace Precedents, which would be useful.

How do you find outliers in Excel?

Excel does not have built in functions for outlier identification. However, if you want to identify quickly data that is in the very low or high range, then use the sort routine in Excel. You can make a scatter plot to identify points distant from the normal scattering. I've also included a related link, which shows some tests of outliers, which can be implemented using the functions in Excel. The Chauvenet's criteria involves use of normal distribution, available in Excel, to identify the probability of data points. An outlier is not necessarily an erroneous number. See related link. It is just a number that is distant from others the set. However, if there is some physical limit on your data, then you might want to screen for numbers beyond this limit. For example, you are measuring heights of men, so you will want to screen you data for heights too big or too small as possible data errors. Certainly, if you find a 600 ft person, you know that this outlier was an error, like forgetting a decimal point.

WHAT DOES THE CELL REFERENCE INDICATE?

It identifies the cell, by indentifying the column and row that it is in. Cell C15 is in column C, row 15. A cell reference also indicates if it is a relative, mixed or absolute reference:

C15 (Relative)

$C15 and C$15 (Mixed)

$C$15 (Absolute)

What is mis how to prepare mis report in excel what are the functions or topics used for mis reports in excel?

Details of employee

a. E.Code

b. Name of employee

c. Date of birth d. Designation

e. CTC

f. Address for communication

g. Permanent address

h. Contact number

i. Blood group

j. Maximum qualification

k. Extra qualification

l. Total Experience

M. Salary structure

N. New Joinees

O. Resigned employees

What does the logical function TRUE mean?

It returns the logical value TRUE. It can be used by itself, say when building a truth table, or as part of another function, such as the IF function. Here is it checking if someone passed an exam:

=IF(A2>=40%, TRUE(), FALSE() )

You can in fact leave out the pair of brackets immediately after TRUE and after FALSE, and they will still work.

Why is your neck not staying aligned?

Neck misalignment can occur due to poor posture, such as slouching or hunching over screens, leading to muscle strain and tension. Additionally, injuries, stress, or sleeping positions can contribute to misalignment. Regular stretching, ergonomic adjustments, and strengthening exercises can help maintain proper alignment and alleviate discomfort. If problems persist, consulting a healthcare professional is advisable.

What is merging cells?

It is when you merge cells together in Excel. How do u not no tht u porn star

What list of software installed on the computers using Microsoft Word?

MS Word is a software and it is not used by any other software.

MS Word however needs operating system as any other program - Word works on Windows and Mac OS.

You may think list of files that are used/using MS Word.

It is all text files with extensions like these:

doc

docx

txt

rtf

15 A is a useful tool to help the controller keep the exercise on track and?

Instead of cutting and pasting part of your homework questions, use different words that make it clear what you what to know.

What do functions allow us to do that formulas don't?

Functions give you automatic ways of doing things, that you would otherwise have to do manually. This could be much longer or more complicated. As a simple example, you could add all the cells from A2 to A10 manually like this:

=A2+A3+A4+A5+A6+A7+A8+A9+A10

Using a SUM function it is much simpler and faster:

=SUM(A2:A10)

SUM is a simple function, but there are many other functions that do much more complicated actions which have been built in to Excel to let people do things without having to work out how to do it themselves and with confidence that the result they get is accurate. If you are using functions it still means you are creating a formula. So using functions as part of formulas is very beneficial.

How do you find R2?

Under the home tab in the find and select group click find and select then click on the go to command. Then type go to R2 or on the top right of the spreadsheet there is a find command.. type r2.. its right beside the formula bar

What kind of operation can be done in Microsoft Excel?

Add, subtract, multiply and divide as well as calculating powers. Pretty much anything you can do in math can be done in Excel.