329 Answered Questions for the topic Microsoft Excel

Microsoft Excel

6h

#### Microsoft Excel - I don't understand relative and absolute references

What is a relative or absolute reference?

Microsoft Excel

6h

#### How do I write an IF statement and embed another IF statement

The format of the IF statement is: =IF(logical_test, value_if_true, value_if_false)Example=IF(A2 = "Pizza","Yes, Pizza","No")Is cell A2 has Pizza, then it will return "Yes, Pizza" otherwise it will...
more

Microsoft Excel Excel

4d

#### How do I link my excel spread sheet contents over to a word document

I need help with trying to link my excel spreadsheet contents over to a word document (such that, when I do the data entry into excel, it also updates the word document) I have taken a basic course...
more

Microsoft Excel

12/15/20

#### How do you SORT in MS Excel (Online)?

Given a small database (Used Car Dealership) shown below:
Model
Type (C or T)
Color
Price
2 or 4...
more

Microsoft Excel Excel

12/14/20

#### if function in excel

I have scores from ranging from 1 to 14 that I would like to prorate down to a number out of 5. Is there a way to do this with an IF function?

Microsoft Excel

12/03/20

#### Which MS Excel function will return the rank of a value as a percentage of a given array or dataset?

(array, x)array = what range of data are you looking at?x = Which value within the range are you looking at?

Microsoft Excel

11/24/20

#### Graphing equations

A publisher needs to send many books to a local book retailer and will send the books in a combination of small and large boxes. Each small box can hold 25 books and each large box can hold 50...
more

Microsoft Excel Excel

10/06/20

#### Building a dynamic table in excel based on dropdown lists options

I need to create a fitness training program that contains 4 dropdown lists (Program 1-3, Phase 1-3, Week 1-4, Day 1-5) and that each possible combination of these variables will retrieve a...
more

Microsoft Excel

09/21/20

#### 10. In cell H7, create a formula that uses the NETWORKDAYS function to calculate the number of working days between the dates in cells H5 and H6.

Microsoft Excel Excel

08/30/20

#### How can I learn Microsoft Excel?

Microsoft Excel

08/09/20

#### If formula error

Why is my If formula not copying down? It’s giving me a false error, I’ve tried adding absolutes as well.

Microsoft Excel Power Bi

07/16/20

#### Create a summary table using power BI

Hello, Join multiple tables to create a summary table i.e picking one or two columns from 7 to 10 tables/spreadsheets to create a summary table. Summary table will have one record per subject. I am...
more

Microsoft Excel

06/22/20

#### Excel Lookup Functions

You have a data table and need to find data points in relation to other data in the table. The data you are looking for are to the left of (or above) the column (row) with the reference data, so...
more

Microsoft Excel

05/16/20

#### Copy a column in excel to another area of a sheet that matches a field in the top

I have some data trying to organize using excel functions, one of the question i have is below.I have 2 tables in one sheet (those can be in two sheet/tabs also). In table 1, the data in Apr-2020...
more

Microsoft Excel Excel

05/13/20

#### help with excel

I can’t figure out how to make this happen. i have a user form created in excel. i have radio buttons, drop down lists and a text box on the userform. for example: if in the drop down list I choose...
more

Microsoft Excel

04/01/20

#### Excel formula help

10. In cell D21, enter a formula without using a function that multiplies the value of cell D22 by 2.83 and then adds the value of cell D19 to the result.

02/20/20

#### What is lagging effect?

I have no idea what this question is about. I have the graph plotted but stuck at lagging effect? 'Does this plot support the theory that lead in the environment (and hence taken up by children) is...
more

12/22/19

#### Import Gantt chart from excel to word 2010

helloi have inserted the diagram and link it with the excelbut i want to have only the word filehow i can embed the chart without needing the external excel file?

Microsoft Excel

12/04/19

#### Using Countif in Conditional Formatting with Sequential Cells

Hello,I have an excel sheet which I need to highlight rows based on value from another cell. If this particular cell is part of a set of certain numbers, the entire row gets highlighted. Easy...
more

11/09/19

#### Excel Financtial Functions

You are considering making an investment. The initial payment for the investment is $1000. In the secondyear, you will receive $3500, in the third year you will have to pay $2000, in the fourth...
more

11/09/19

#### Excel Financtial Functions

The IRR (Internal Rate of Return) is another very useful function. Internal rate of return (IRR) is a metricused in capital budgeting to measure the profitability of potential investments. Internal...
more

11/09/19

#### Excel Financial Functions

Time to learn some new functions! Depreciation is the process by which a company spreads the expense ofan asset over its useful life. Even though a company may actually pay for the asset...
more

11/09/19

#### Excel Financtial Functions

Calculate the total monthly payment: You want to buy a house that costs $250,000, you have $25,000 for adown payment, loan rate interest is 3.5% a year compounded monthly and you plan to get a...
more

11/09/19

#### Excel Financial Functions

Assume the same data as provided in question #4. How much would you have to pay each month to pay offthe loan in 10 years?Data from question #4: Time for a new problem. You want to borrow $200,000...
more

11/09/19

#### Excel Financial Functions

Time for a new problem. You want to borrow $200,000 at 4% interest compounded monthly. If you canafford to make monthly payments of only $1200/month, how many months (cell J14 on the sample...
more

## Still looking for help? Get the right answer, fast.

Ask a question for free

Get a free answer to a quick problem.

Most questions answered within 4 hours.

#### OR

Find an Online Tutor Now

Choose an expert and meet online. No packages or subscriptions, pay only for the time you need.