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

Is there such a word as referencing?

referencing (′ref·rən·siŋ)

(engineering) The process of measuring the horizontal (or slope) distances and directions from a survey station to nearby landmarks, reference marks, and other permanent objects which can be used in the recovery or relocation of the station.

What do you use the range argument for in the SUMIF function?

There are potentially two ranges. You have the range that you want to do your checking on, the criteria, and the range you want to sum. That can be the same as the first range, like if it was numbers. So if you had a list of numbers and you only wanted to add the ones that were over 50 from that list, the range you were checking and the range you were summing from would be the same and the second reference to a range can be left out:

=SUMIF(A2:A20,">50")

If you had a list of days for a few weeks with numbers in the column beside them and you only wanted to add the numbers beside a particular day, say Monday, then the range you are checking and the range you were adding would be different, in this case the days are in column A and numbers in column B:

=SUMIF(A2:A20,"Monday",B2:B20)

How would you convert the data into a table in Excel 2007?

You do not convert any data in Excel. A table is a layout to organize the data. If you want the data to look like it is in a table, then move the data to where you would like it to display.

How do you transfer data between worksheets in excel for automatic formulas?

To transfer data, enter them in sheet 1, go to sheet 2 and the cell in which you want the linked number to appear and enter the equal "=" sign. Then go back to sheet 1 and the source cell and press Enter.

What type of chart is best for showing groups of data in portion to the whole data set?

Pie chart. The entire "pie" shows the whole data set, while each "slice" shows each group of data.
circle graphs

What are numbers and letters in a cell called?

They are called cell content. They could be labels or formulas.

What are constants for in Excel?

Constants are fixed values, so they never change. They are used in formulas where you know a particular value does not change. If you have a formula that is always going to multiply something by 2, then the 2 is a fixed value and can be entered into the formula as a constant, while the other value will be a cell reference, so it can have a variable value, like in the following formula.

=H5 * 2

Java program convert the inputed words into its upper case or lower case form?

There are methods in the String class; toUppercase() and toLowerCase().

i.e.

String input = "Hello!";

String upper = input.toUpperCase(); //stores "HELLO!"

String lower = input.toLowerCase(); //stores "hello!"

-Note: these methods are NOT modifier methods therefore the original string is still "Hello!"

How do you write data range in Excel?

You identify data ranges in Excel by locating the cells in the top left and bottom right corners of the range.

EXAMPLE:

You have a data range in columns E, F, G, H, I , and J, including rows 1-23. You would identify this range as E1:J23(the colon indicates to use every cell between the two end points).

Is text alignment important?

not really

It is if you wish it to be easily read

What is the name of the pre-written formulas in Excel that helps to complete statistics?

They are called functions. Excel has a specific category or functions used to calculate statistics.

What is the Benefits of using flow chart?

1) Easy to comprehend.

2) Can be understood by anyone.

3) Can be elaborated upon quite simply and has a lot of detail to it.

4) Can present large chunks of information in a compact and easy way.

5) Can be used in any subject, field, or discipline on a variety of topics.

Can you give you some examples of categorical data?

Race, Sex, Age group, education level, hair color... Good examples but we might elaborate: we may give categories names. Take for example the variable, hair color. We might name each of the categories like this: red, blonde, black, etc. In this case we would have nominal categorical variables. Further we can think or categorical variables as being ordered such as income level: high, medium, low, very low or socioeconomic class: low, middle, high. These are called ordinal categorical variables because they represent levels and are grouped in levels say from high to low. As another example you might group temperature levels (categories) as cold, cool, warm and hot. So you have nominal categorical variables and ordinal categorical variables. We like to put things into categories. We have classrooms, offices, addresses, etc. We have grade levels in school. What type of categorical variables is "grade"? I graduated from the 3rd grade but my father graduated from the sixth grade. Who has the highest level of education? Why do we categorize things in the world? We group things so we can make sense of the diversity around us. We catgorize animals into species; we even name people when they are born. Is a person's name a variable? Sure is! It's nominal variable. Why is a person's name a variable? Because name changes or varies from person to person. What about the number of people in a classroom. Is that a categorical variable?
name of the school

How do you calculate the mean of data using Excel?

Pick a cell in which to enter your formula

Type:

=average(

then highlight the cells you wish to average.

Press enter.

How do you make an excell spreadsheet that automatically averages the latest 12 enteries and ignores data entered before that?

Assuming that your entries are in Column B from Row 1 onwards, put this formula in cell C12:

=IF(B12>0,AVERAGE(B1:B12),"")

Use the Fill Handle to drag the formula as far down the worksheet as you want and it will automatically increment to B2:B13, B3:B14, etc. Nothing will appear in a cell in Column C until the cell to its left contains data.

What is the advantage of organizing data on a table?

You can retrieve information quickly, unlike a graph. It is also easier to compare, and to find the rate of change.

What do you mean by Microsoft Excel?

Microsoft is a brand like Addidas or Prada. Excel is a programme that you use for producing spreadsheets.

What is done prior to insertion of a diaphragm?

the inside of the dome and the rim are covered with a thick layer (perhaps a tablespoon) of a spermicide that is compatible with the diaphragm being used. The domed area covers the opening into the uterus (cervix) and keeps the spermicide in place