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 make numerical data?

You can code the data.

For example, male = 1, female = 2.

Or

Strongly Agree = 5

Agree = 4

Neither agree nor disagree = 3

Disagree = 2

Strongly Disagree = 1

What is a formula and why do you use them?

If you are talking about math, a formula is a representation of some type of operation, usually between numbers. An example of a formula in Excel is: =12*(34+14). Use use them to find a result of some type of calculation.

What is the formula to calculate the area of your room wherein plastering job has been done?

Measure length and width of each area that has been plastered or needs to be plastered. Multiply length times width for each area, then add the results.

EXAMPLE:

  • You have two areas, each with a length and width of ten feet.
  • In A1, calculate area 1 [=10*10]
  • In A2, calculate area 2 [=10*10]
  • In A3, calculate total area [=A1+A2]

What can you do a bar chart on?

you could do a bar chart on what types of crisps people like or on which days it rains.

What search for a range of values in one field use the RANGE operator?

Sorry, but this question is not clear. You can not search for a range within one field, since a range contains more than one field. Please ask again using words that make it clear what you want to know.

When does the sum of 2 and 2 become 5?

Either when it's 2.5, or if you have a broken calculator, or in a world where math is mixed up.

How do you calculate gorsspay?

There is no English word "gorsspay," so this question does not have an answer. The best I can figure is that you are asking about "Gross Pay." If that is the case, then you just look at your pay stub to see the total amount of pay you received before deductions. If you are paid by the hour, let us say $12.00 per hour, work 40 hours, and have no other benefit payments, your Gross Pay is:

$12.00 per hour x 40 hours = $480.00.

What is the name of the feature you would use in Excel to create a series of odd numbers from 1 to 99 in a column?

I'd enter the numbers 1 and 3 in two cells, highlight both cells, then drag the fill handle until I have all the numbers 1 - 99 in the column.

Excel help refers to it as "dragging the fill handle" or "Auto Fill"

What do you learn about bar chart?

Bar chart consists of "x" axis 7 "y" axis which are been represented at the left vertical side & the bottom side respectively. To study the bar graph we have to first see what information is that chart telling u about 7 then see the units [if any]. And then to read the graph we first have to draw a parallel line from the top of the graph & joining to the x-axis. On the x-axis there r some measurements. Form that find the one {measurement} on which the line which u have drawn from the bar. Do the same with the y-axis too. And then u get the answer.

Does the scale used on a bar chart does not affect the way the bar chart looks?

Technically, no. If you use a different scale the bars will change in size, but they change in proportion. Its like different sized shapes; if you make a square bigger, its still a square.

Selecting the maximum value out of a range A1 to B20?

To select the maximum value out of a range A1 to B20 in a spreadsheet program like Microsoft Excel, you can use the MAX function. Simply enter "=MAX(A1:B20)" in a cell, and it will return the highest value within that range. This function evaluates all the numbers in the specified range and displays the largest one.

How do shopkeepers use a spreadsheet?

Well, isn't that just a happy little question! Shopkeepers use spreadsheets to keep track of their inventory, sales, and expenses. They can organize their products, calculate profits, and make informed decisions to help their business grow and thrive. Just like painting a beautiful landscape, a well-organized spreadsheet can bring a sense of peace and clarity to their daily operations.

Why does a teacher use spreadsheet's?

A teacher may use a spreadsheet for several different reasons;

1) Commonly spreadsheets are used to hold the grades from examinations in percentage form. By holding the results in a spreadsheet the teacher can calculate the percentages gained by their pupils in different areas of a test. This information could be used to inform the next term's teaching, with the teacher revisiting topics which were commonly misunderstood.

2) Spreadsheets can also be helpful in tracking a student's progress as terms and year progress. This information is useful if the student's personal circumstances change and the teacher wants to apply for special circumstances to be taken into consideration in formal exams.

1) A teacher may use a spreadsheet to calculate the overall grade for a unit of work, where several exams and coursework go to calculating the overall grade. This saves time in working out calculations individually.

What is the function of text color and its use?

Text color plays a crucial role in enhancing readability, emphasizing important information, and conveying emotions or themes in written content. By using different colors, designers can guide the reader's attention, create visual hierarchy, and improve overall user engagement. Additionally, color can evoke specific feelings or associations, making it an essential tool for branding and effective communication. Proper contrast between text and background colors also ensures accessibility for all readers.

Which group on the formulas ribbon contains a command that allows a user to create names for cells to use in a formula?

The "Defined Names" group on the Formulas ribbon contains the command that allows users to create names for cells to use in formulas. This group includes options like "Define Name," which lets you assign a specific name to a cell or range, making formulas easier to read and manage.

Which button do you use to change the alignment of text in a cell?

To change the alignment of text in a cell, you typically use the "Align" buttons found in the formatting toolbar of spreadsheet applications like Microsoft Excel or Google Sheets. These buttons usually include options for left, center, and right alignment, as well as vertical alignment options. You can select the desired cell and then click the appropriate alignment button to adjust the text alignment accordingly.

Is centering considered a character format?

In the context of document formatting, centering is typically considered a paragraph format rather than a character format. Character formatting refers to changes applied to individual characters or groups of characters within a paragraph, such as font style, size, or color. Centering, on the other hand, refers to the alignment of the entire paragraph or block of text along the center of the page or column.

What is a formula that depends on its own value?

A circular reference. It will cause an error.

A circular reference. It will cause an error.

A circular reference. It will cause an error.

A circular reference. It will cause an error.

A circular reference. It will cause an error.

A circular reference. It will cause an error.

A circular reference. It will cause an error.

A circular reference. It will cause an error.

A circular reference. It will cause an error.

A circular reference. It will cause an error.

A circular reference. It will cause an error.

Which key moves the insertion point to the beginning of data in a cell?

Well, darling, the key you're looking for is the Home key. It's like the bouncer of your cell, pushing that insertion point right to the front of the line. So, go ahead and give it a little tap and make that data line up like a well-behaved bunch of pixels.