194 Answered Questions for the topic Excel

04/26/22

How do I integrate two separate large raw data tables with the same variables into one large?
I have two tables showing the concentration of a substance over time, in which the beaker are shun with various colors. The lab is done in six trials. As you see the two tables are structured... more
Follows • 1
Expert Answers •1
Excel

03/15/22

How can I put chemical prices on one sheet and then put the mix of chemicals on another sheet then have it go back and put the prices in the proper place?
Master pageroundup 20.45cinch 18.61captam 12.25Mixesroundup roundup captam cinch captam cinch cinch
Follows • 1
Expert Answers •1

03/15/22

What are the Objective Function and Constraints for this problem?
A producer has three products, A, B, and C, which are composed from many of the same raw materials and subassemblies by the same skilled workforce. Each unit of product A uses 15 units of Raw... more
Follows • 1
Expert Answers •1
Excel

01/25/22

The formula for how to total different amounts in non-consecutive cells. Please.
in cell b10 add the total amounts for A2 bedtime set with amount in B2, A3 corduroy pants with amount in B3, & A8 inorganic kit with amount in B8, using a formula with cell references. So: just... more
Follows • 1
Expert Answers •1

11/25/21

Need help to do it in excel please.
Based on the following data and using Regression function in Microsoft Excel, fit a multiple linear equation to the data and determine the R2x1 0 1 1 2 2 3 3 ... more
Follows • 1
Expert Answers •1

10/07/21

Economic graphs are hard and i am using a chromebook that does not give full excel, can someone help me?
You are presented with the following sales data from 2015-2018 of The Cullins Auto Corporation on sales of its used automobiles from both of its auto sales centers; one in Albany, NY and the other... more
Follows • 1
Expert Answers •1

09/20/21

How can I find Gross Margin and COGS knowing Sales, Profit, Discount, Product Quantity, Shipping Cost?
I have an E-Commerce dataset. How can I find Gross Margin and COGS knowing Sales, Profit, Discount, Product Quantity, Shipping Cost?
Follows • 2
Expert Answers •1

08/14/21

Assign value to First and Last row of each group.
This is My Table+------------------------+| id | session ID | bal |+------------------------+| 0 | 00000002 | 100 || 1 | 00000002 | 120 || 2 | 00000002 | 140 || 3 | 00000001 | 900 ... more
Follows • 1
Expert Answers •2

08/13/21

How to highlight first and last row of each group in excel?

Below is an extract of my Excel data A 20160101 A 20160104 A 20160105 A 20160106 A 20160107 AA 20160108 AA 20160111 AA 20160112 AA 20160113 AA 20160114 AA 20160115 AA 20160118 AB 20160119 AB... more
Follows • 1
Expert Answers •3

08/12/21

Urgent please solve this Excel problem
Below is an extract of my Excel data A 20160101 A 20160104 A 20160105 A 20160106 A 20160107 AA 20160108 AA 20160111 AA 20160112 AA 20160113 AA 20160114 AA 20160115 AA 20160118 AB ... more
Follows • 1
Expert Answers •2

07/27/21

How Do I Create a Vlookup?
Follows • 1
Expert Answers •2

07/23/21

Excel: I need to take given data and sort between f, d, or Both. Then I need to separate the data once determined by f or d pounds
So, imagine there is an excel sheet with a column full of f or d values, another with random minute values, and 5 different zone columns with a number in only one of these per row(These 5 columns... more
Follows • 1
Expert Answers •1
Excel

06/15/21

Move all to one row
I have a report of 60,000 loan numbers, borrowers first and last names tax ID numbers. Some loans have multiple borrowers and are laid out in consecutive order on the spreadsheet.... more
Follows • 1
Expert Answers •1
Excel Finance

06/09/21

Is there a formula in Excel to solve for a maximum lease payment?
Is there a formula in Excel to solve for a maximum lease payment when you know the total present value of future lease payments, the interest rate, and the number of periods?
Follows • 1
Expert Answers •1
Excel

03/21/21

Assume the value in cell A2 is 0 and the value in B2 is 1%. If the value in A2 is equal to 0 and the value in B2 is greater than 1%, then the output of the function should be OK.
Follows • 1
Expert Answers •1

03/12/21

formula with mixed and absolute reference
In cell B8, create a formula without using a function that multiplies the value in cell B7 by the value in cell B6 and then adds the value in B7. In this formula, use a mixed reference for cell B6... more
Follows • 1
Expert Answers •1
Excel Computer

03/10/21

Excel Module 2 PC
1.) Cell A5 contains the number 24.7835. In another cell, Ariane wants to enter the number from cell A5 but rounded to two decimal places. Which of these formulas can she use to do... more
Follows • 1
Expert Answers •1

03/04/21

Why are the rows and columns of my pivot table showing blank when there is data?
Follows • 1
Expert Answers •2

01/23/21

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
Follows • 1
Expert Answers •3

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?
Follows • 1
Expert Answers •2
Excel Maths

12/07/20

help with working out sell price after taking into account all variables

need a formular creating which will calculate the sell price after taking into account the following variables. We wont know the sale price, so the caluclation needs to automatically calculate this... more
Follows • 2
Expert Answers •1

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
Follows • 1
Expert Answers •1

08/30/20

How can I learn Microsoft Excel?
Follows • 1
Expert Answers •2

07/28/20

How to calculate daily log return of T-bill, using treasury yield curve rates?
I am trying to calculate daily log return of T-bill and T-note (3-month, 5-year, and 10-year) in excel. At first, I thought that just by dividing a treasury yield curve rate at time t by that at... more
Follows • 1
Expert Answers •1
Excel

07/19/20

Automating and adding flexibility to Excel GoalSeek and Solver?
Suppose you want to compare several "What-If" scenarios with complex dependencies between the variables. You plan to use GoalSeek or Solver to find the input value that makes two outcome values the... more
Follows • 1
Expert Answers •1

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.