• Learn
    • Courses
    • Career Tracks
    • Projects
    • Upcoming Courses
  • Certificates
    • Career Track Certificate
    • Course Certificate
  • Resources
    • All Resources
    • Templates
    • Course Notes
    • Career Guides
    • Cheat Sheets
    • Finance Data
    • Infographics
    • Practice Exams
    • Knowledge Hub
    • Career Advice
    • Reviews
  • Pricing
  • For Business
  • Login
  • Sign Up
Log In Sign Up
Follow this topic
Share
yeshash m.c.
Posted on:

14 Aug 2022

0

Row input parameter & column input parameter interchanging in the example case of Data tables

in Introduction to Excel / Perform Sensitivity Analysis with Excel's Data Tables Functionality

I wanted to know why was interest rate taken as the row input parameter when in the table made, it was the column...similarly time period was made the column input parameter when it was the rows of the table? this interchanging didn't have any effect, why was that?

0 answers ( 0 marked as helpful)

Submit an answer

GET

World-Class

FINANCE COURSES

Тaught by Industry Experts from:

4.8/5

related questions

Mario Contreras
1
12
Why are we using SUMIF to transfer data instead of using VLOOKUP?
Yuvraj Shivaji Dhepe
0
10
Resolved: How to solve data entry exercise test ?
Michelle Cheng
0
10
Resolved: Sensitivity Analysis with Data Tables
kavya k
0
10
Error in the code column
Dylan Ritter
0
8
How did you quickly select the B column around 50 seconds?
Moses
0
6
Resolved: Changing Column A Width?
Divya
0
6
Resolved: sum of the value of the entire "Distribution" column?
Oumaima
0
4
Text To column in excel problem
Syed Huzaifa
0
4
filter shortcut key for opening data of that filter button
Muntaser Younis
0
4
Sum for column H
Shafiqul Islam Shafiq
1
4
How can I easily select a column from entire dataset to place in PivotTable Area?
Dylan Ritter
0
4
Resolved: Column width increasing instead of decreasing?

All the Online Finance Courses You Need

About

  • About Us
  • Contact Us
  • Pricing

Learn

  • Courses
  • Career Tracks
  • Career Certificate
  • Course Certificate

Resources

  • Templates
  • Course Notes
  • Cheat Sheets
  • Finance Data
  • Infographics
  • Practice exams
  • Knowledge Hub
  • Career Advice

Platform

  • Q&A Hub
  • Help Center
  • Verify Certificate
© 2025 365 Financial Analyst. All Rights Reserved.
Sitemap Terms of Use Privacy Policy Cookies