Keiser University Bank Record Balance Sheet Spreadsheet 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 Bank_Records file. On this spreadsheet, debits and credits to a bank account over three months are shown. In cell A1, type your name and Checkbook Register. Merge and center the title across columns A:G. Insert 4 rows below the title. In cell C3, type Starting Balance. In cell C4, type January Balance. In cell C5, type February Balance. In cell C6, type March Balance. In cell G8, type Balance. In cell D3, enter $1500. In cell G9, enter a formula that uses the Starting Balance to calculate the balance after this transaction. Debits should be subtracted and credits should be added. In cell G10, enter a formula which uses the previous balance to calculate the balance after this transaction. Copy and paste this formula to the rest of the cells in the Balance column. Enter cell references to show ending balances. In cell D4, enter a cell reference that shows the ending balance for January. In cell D5, enter a cell reference that shows the ending balance for February. In cell D6, enter a cell reference that shows the ending balance for March. Use What-If Analysis to: Create a scenario showing how a higher or lower credit for your paycheck would affect each monthly balance. Create a scenario summary that displays how the monthly balances would be affected by the scenario you created. This summary will automatically be displayed on a separate worksheet. Insert a PivotTable on a separate sheet, setting Category as Row Labels and Credit and Debit as Values. For Value Field settings, select Sum for Debit and Credit. Your finished PivotTable will show how much you paid and deposited within each category. Format your Bank Records 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 Bank and your First Name when saving your file. Example: Bank_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