• Welcome to AppraisersForum.com, the premier online  community for the discussion of real estate appraisal. Register a free account to be able to post and unlock additional forums and features.

Excel Test

mdlions16

Thread Starter
Freshman Member
Joined
Oct 10, 2019
Professional Status
Appraiser Trainee
State
Arizona
Hello all,

I would really appreciate some help. I am currently working on the excel test in order to register for MAI courses and I am having some issues. I know that I am generating the correct answers because I am checking all the work with a calculator. I am using all the formulas that they are asking me to use, I do not know what to do.

Any help would be much appreciated.
 

Attachments

PL1957

Senior Member
Joined
Jul 19, 2004
Professional Status
Certified General Appraiser
State
Illinois
Hello all,

I would really appreciate some help. I am currently working on the excel test in order to register for MAI courses and I am having some issues. I know that I am generating the correct answers because I am checking all the work with a calculator. I am using all the formulas that they are asking me to use, I do not know what to do.

Any help would be much appreciated.
I STRONGLY suggest you take an Excel class before you sign up for the MAI classes. You don't want to be confused by the program when trying to learn new concepts. There's a bunch of training available on line or at various adult education/community college settings.
 

Meandering

Elite Member
Joined
Feb 26, 2006
Professional Status
Real Estate Agent or Broker
State
Pennsylvania
Hello all,

I would really appreciate some help. I am currently working on the excel test in order to register for MAI courses and I am having some issues. I know that I am generating the correct answers because I am checking all the work with a calculator. I am using all the formulas that they are asking me to use, I do not know what to do.

Any help would be much appreciated.
Do you have any experience working with excel?

What version of excel do you have?

I have some of these formulas and worksheets in excel 2010
 

Elliott

Elite Member
Joined
Apr 23, 2002
Professional Status
Certified General Appraiser
State
Oregon
Here are some hints:

=Something Economic Life/Some other factor Economic Life



1570763083569.png


There are other 'functions' which deal with some of the other issues, other questions can be answered with creating an algebraic equation. So easy, it does all the math for you.

Hope that helps.1570763083569.png
 

mdlions16

Thread Starter
Freshman Member
Joined
Oct 10, 2019
Professional Status
Appraiser Trainee
State
Arizona
Do you have any experience working with excel?

What version of excel do you have?

I have some of these formulas and worksheets in excel 2010
Yes, I have plenty of experience working with excel. I have excel for mac. I continue to use the pre-programmed formulas that they say they want, but I guess different formulas are wanted because I am doing everything that they want
 

mdlions16

Thread Starter
Freshman Member
Joined
Oct 10, 2019
Professional Status
Appraiser Trainee
State
Arizona
I STRONGLY suggest you take an Excel class before you sign up for the MAI classes. You don't want to be confused by the program when trying to learn new concepts. There's a bunch of training available on line or at various adult education/community college settings.
At this point, I would but the class is not being offered anywhere at this time
 

Thomas Holding

Sophomore Member
Joined
Jan 22, 2004
Professional Status
Certified General Appraiser
State
North Carolina
One of the best exercises you can do is to enter the formulas for the Six Functions of $1. Start with the complete formulas. As you build your formulas to solve more complex problems like finding a discounted value, you will build on your understanding of how each function is interrelated to the others.
 

Attachments

Find a Real Estate Appraiser - Enter Zip Code

Copyright © 2000-, AppraisersForum.com, All Rights Reserved
AppraisersForum.com is proudly hosted by the folks at
AppraiserSites.com
Top

AdBlock Detected

We get it, advertisements are annoying!

Sure, ad-blocking software does a great job at blocking ads, but it also blocks useful features of our website. For the best site experience please disable your AdBlocker.

I've Disabled AdBlock
No Thanks