Keiser University Real State Excel Spreadsheet Assignment In this assignment, you will add a logical test, conditional formatting, and tables to an Excel spreadsheet. You can look at a sample to get an idea of what you’ll be creating. Download the Real Estate file. This contains listing and sale information for the employees in your imaginary office. Insert two columns, one to the right of EACH Sales Agent column. Type the heading Bonus for both of these new columns. Create a logical test so that for each Sales Price, the correct amount listed below displays in the Bonus column: $299,999 and under, bonus is $1,500. $300,000 to $599,999, bonus is $3,000. $600,000 and over, bonus is $5,000. Hint: Setting up the initial formula is tough, but once you get it, copy it over to the other Bonus cells. Use conditional formatting to differentiate the cells with each of the bonus values (e.g. one color for $1,500, another for $3,000 and a third color for $5,000. Create two tables, one for Condos and one for Single Family homes. Sort the data by sales price. Format each table so they can be easily differentiated. Create a title for this worksheet. In cell A1, type the name for this real estate business. In cell A2, type Bonuses for 2009. Merge and center the title across columns A:R. Format your spreadsheet. Use formatting that makes your information easy to read and understand. Consider font size and style, background colors, cell format (i.e. currency), table borders, etc. Save your file as an Excel Workbook (.xlsx) Include the term RealEstate and your First Name when saving your file. Example: RealEstate_David.xlsx Upload your completed document using the Browse button, and then click the Submit button.
Why Choose Us
Top quality papers
We always make sure that writers follow all your instructions precisely. You can choose your academic level: high school, college/university or professional, and we will assign a writer who has a respective degree.
Professional academic writers
We have hired a team of professional writers experienced in academic and business writing. Most of them are native speakers and PhD holders able to take care of any assignment you need help with.
If you feel that we missed something, send the order for a free revision. You will have 10 days to send the order for revision after you receive the final paper. You can either do it on your own after signing in to your personal account or by contacting our support.
All papers are always delivered on time. In case we need more time to master your paper, we may contact you regarding the deadline extension. In case you cannot provide us with more time, a 100% refund is guaranteed.
Original & confidential
We use several checkers to make sure that all papers you receive are plagiarism-free. Our editors carefully go through all in-text citations. We also promise full confidentiality in all our services.
24/7 Customer Support
Our support agents are available 24 hours a day 7 days a week and committed to providing you with the best customer experience. Get in touch whenever you need any assistance.
Try it now!
How it works?
Follow these simple steps to get your paper done
Place your order
Fill in the order form and provide all details of your assignment.
Proceed with the payment
Choose the payment system that suits you most.
Receive the final file
Once your paper is ready, we will email it to you.
No need to work on your paper at night. Sleep tight, we will cover your back. We offer all kinds of writing services.
You are welcome to choose your academic level and the type of your paper. Our academic experts will gladly help you with essays, case studies, research papers and other assignments.
Admission help & business writing
You can be positive that we will be here 24/7 to help you get accepted to the Master’s program at the TOP-universities or help you get a well-paid position.
Editing your paper
Our academic writers and editors will help you submit a well-structured and organized paper just on time. We will ensure that your final paper is of the highest quality and absolutely free of mistakes.
Revising your paper
Our academic writers and editors will help you with unlimited number of revisions in case you need any customization of your academic papers