311 Answered Questions for the topic Microsoft Excel

Microsoft Excel

4d

#### 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

26d

#### 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.

#### 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

11/09/19

#### Financial Functions Excel

The casino threw in a new twist. In addition to the previous offer (options 1 and 2):1) $30,000 five years from now, or2) $25,000 todayThey are offering to pay you an annuity (option 3):3) $9,000...
more

Microsoft Excel

11/05/19

#### Single average of entries per day

I maintain a trouble ticket report... each ticket has it's own row and contains the date opened, the ticket type, and ultimately a date closed (blank means its still open).I'm trying to create a ...
more

Microsoft Excel

09/17/19

#### Is my distribution skewed or normal?

So my mean, median and mode are all 88, but on the histogram it looks skewed. I was using the score of 200 test scores. It doesn’t look symmetrical at all but the mean, median and mode are all the...
more

#### Find the next two terms of sequence

U0 = 1U1 =3And Un is defined by Un+2 = 2 * Un+1 + 3 * UnFind the next two terms

Microsoft Excel

09/12/19

#### Microsoft Excel question.

Create a formula without a function using absolute references that subtracts the values of cells B5 and B7 from B6 and then multiples the result by cell B8. Separate formula Create a formula...
more

08/14/19

#### Help with analyzing Rank Data with Weighted Responses

I'm working in Excel on data related to hotels. Responses need to be weighted based the percent of total rooms in the sample. (E.g. Hotel A has 12 rooms, sample is 100 rooms spread over x hotels....
more

#### Copy Excel worksheet and maintain relative cell reference in formulas?

Another copy problem in Excel: How can I copy a Worksheet from WorkbookA.xlsx into WorkbookB.xlsx without the copied Worksheet still referencing WorkbookA.xlsx e.g. the formula `=B!23` becomes...
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.