- Basic Quiz On Microsoft Excel Exam!
- You need to have JavaScript enabled in order to access this site.
- You need to have JavaScript enabled in order to access this site.
- Module 4 – Spreadsheets
- Module 4 – Spreadsheets

## Basic Quiz On Microsoft Excel Exam!

If you do not see the. The program will add the file extension for you automatically. If cell B6 does not display your name, delete the file and download a new copy from the SAM website. Justin and Kaleen Millowski have always dreamed of purchasing and running a campground. She also wants to consider how different mortgage interest rates will impact the total cost of the campground. Switch to the Campground Mortgage worksheet. Put a negative sign before the PMT function to make the formula return a positive value. Kaleen calculated the anticipated total cost of the campground using the mortgage interest rate she expects to qualify for. She now wants to determine how different interest rates could impact the total cost of the campground. Select the range AA26 and fill it with a percent series based on the values in range AA Create a single variable data table to determine the impact that the variable interest rates in the range AA22 will have on the total cost of the campground. In cell B11, create a formula without using a function that references cell D5 the monthly payments. In cell C11, create a formula without using a function that references cell D6 the total interest paid on the loan. In cell D11, create a formula without using a function that references cell D7 the total cost of the mortgage. Select the range AD26 and create a single-variable data table, using an absolute reference to cell D3 the mortgage interest rate as the Column input cell. To help Kaleen identify how each rate in her Variable Interest Rate Schedule compares to the interest rate she anticipates on her mortgage, she decides to highlight the matching interest rate in the schedule with a conditional formatting rule. Apply a Highlight Cells conditional formatting rule to the range AA26 that formats any cell in the range that is equal to the value in cell D3 using an absolute reference to cell D3 with Green Fill with Dark Green Text. Kaleen now wishes to finalize the Amortization schedule. In cell J4, create a formula without using a function that subtracts the value in cell I4 from the value in cell H4 to determine how much of the mortgage principal is being paid off each year. Copy the formula in cell J4 to the range J5:J In cell K4, create a formula using the IF function to calculate the interest paid on the mortgage or the difference between the total payments made each year and the total amount of mortgage principal paid each year. The formula should first check if the value in cell H4 the balance remaining on the loan each year is greater than 0. If the value in cell H4 is greater than 0, the formula should return the value in J4 subtracted from the value in cell D5 multiplied by Use a relative cell reference to cell J4 and an absolute cell reference to cell D5. If the value in cell H4 is not greater than 0, the formula should return a value of 0. Copy the formula from cell K4 into the range K5:K Kaleen decides to add custom cell borders to the amortization schedule to make it easier to read. Add an Outline border with a Medium border style 2 nd column, 5 th row to the range G3:K Add a Top border with a Light border style 1 st column, 7 th row to the range G4:K4. Add a Bottom border with a Light border style 1 st column, 7 th row to the range GK To make the various elements of the Campground Mortgage worksheet easier to select and print, Kaleen wants to add custom names to ranges in the worksheet. Assign names to the cells in the range D5:D7 by selecting the range C5:D7 and creating names from the selection using the values in the Left column as the defined names.## You need to have JavaScript enabled in order to access this site.

Part of working smarter and not harder in Excel means becoming a pro at using Excel shortcut keys to move and make selections in the worksheet. Part of working smarter and not harder in Excel means becoming a pro at using keyboard shortcuts to cut, copy, paste, and format the contents of the cells. Learn Excel shortcut keys and work smarter not harder. The Excel shortcut inset row, delete row, columns and cells as well as adjust column width and row height are ones you will use every day. Improve your Excel proficiency with this free Excel Quiz. Learn Excel formatting shortcuts and save yourself enough time for a well earned coffee break! Part of working smarter and not harder in Excel means becoming a pro at using keyboard shortcuts to to enter formulas. These multiple choice tests are a great way to prepare for an Excel assessment test. An overview of the common tasks that can be completed using the File Tab aka The Backstage View including the list of recent documents, using pushpins to keep documents at the top of the list, print and print preview, and save and save as. There are different ways to view your worksheet depending on what you want to do. Understanding and using the different views in Excel can make your work much easier. Excel worksheets can be quite big and contain multiple columns and rows of data. Knowing how to use the mouse, keyboard and Go To features as well as how to select columns, rows and multiple cells makes using Excel much easier and can save you a lot of time. The Ribbon replaces the old Menu system. Learn how the tabs are organized into groups, how to open the group dialog box and how to hide the ribbon. The Quick Access Toolbar can be customized with your most frequently used buttons. Learn how to add, delete and change the position of the buttons you use the most. Nothing is more fundamental to using Excel than knowing how to enter, edit and delete text and numbers in cells. In Excel you will frequently copy and paste text and numbers using keyboard shortcuts, the right mouse button, the fill handle and the drag and drop functions. Using the copying and pasting functions in Excel will not only save you time from having to re-enter data repeatedly, it may also ensure more accurate data entry and less frustration. You type in Monday and Excel will type in the rest of the days. You can do the same with dates and numbers using the fill handle and Auto Fill feature. You can even create your own list. This is a great time saver. Brush up on your Microsoft Excel skills with these powerful and dynamic arithmetic formulas and functions that differentiate Excel from simply, for example, using a table in a Word document or a sheet of paper to list number values. A good place to start is with getting to know how cell references work. To get the math correct every time you have to understand Absolute and Relative cell references when creating, copying and moving formulas. Copying formulas using the fill handle saves a lot of time. So does knowing how to change the formula to its actual value. You want numbers to appear correctly. This is done by formatting numbers for currency, percentage, dates, and fractions including decimal places and negative numbers. Functions are predefined formulas that are the powerhouse behind Excel. Understanding functions, how Excel organizes functions, and creating functions using the Function dialog box takes Excel beyond basic math. IF functions in Excel allow you to create formulas based on true or false evaluations. Nested functions add super powers to your normal formulas and functions and allow you to perform more complex calculations.

## You need to have JavaScript enabled in order to access this site.

NOTE: Whenever sending email, please be sure to indicate your course title and number in the subject line and include your full name at the end of the email. Box University, MS Phone:toll-free Fax: E-mail: istudy olemiss. You will learn the basic components of the four most popular Microsoft Office programs: Word word processorExcel spreadsheetPowerPoint presentationand Access database. Each unit in this course corresponds to a module in the book, and you will be expected to:. Note that all units have a textbook module assignment and a SAM project. All assignments must be completed and submitted on the SAM website. Though not required for this course, if you are unfamiliar with MS Officeit is recommended that you complete the first four sections of the textbook which includes Computer Concepts, the Windows environment, File Management strategies, and Internet basics. It will be assumed that each student knows these features. This course consists of 14 instructional modules, 2 proctored examinations, and 1 final project. You MUST take the syllabus quiz within 2 weeks of enrolling or you will be dropped from the course. If you are a semester student, you must reach the midpoint of your course by the date specified in your information. The exact date semester students are required to reach the midpoint is specified in your information. You must submit the lessons required to take the course exam s. Lessons required but not submitted will receive a grade of zero. For the final exam, all coursework must be submitted and graded. Textbook Information: Textbook information will be provided upon enrollment in your iStudy course. Course Objectives: Each unit in this course corresponds to a module in the book, and you will be expected to: Complete and turn in the textbook module assignment which is a hands-on step-by-step approach. Course Outline: This course consists of 14 instructional modules, 2 proctored examinations, and 1 final project. All lesson assignments or exams needed to reach the midpoint of the course The exact date semester students are required to reach the midpoint is specified in your information. For lesson or test administration issuesplease contact the iStudy department:. Each unit in this course corresponds to a module in the book, and you will be expected to: Complete and turn in the textbook module assignment which is a hands-on step-by-step approach. All lesson assignments or exams needed to reach the midpoint of the course. To be scheduled and completed before proceeding.

## Module 4 – Spreadsheets

Sign up with Facebook Sign up with Twitter. I don't have a Facebook or a Twitter account. If you do not see the. The program will add the file extension for you automatically. If cell B6 does not display your name, delete the file and download a new copy from the SAM website. Justin and Kaleen Millowski have always dreamed of purchasing and running a campground. She also wants to consider how different mortgage interest rates will impact the total cost of the campground. Put a negative sign before the PMT function to make the formula return a positive value. Kaleen calculated the anticipated total cost of the campground using the mortgage interest rate she expects to qualify for. She now wants to determine how different interest rates could impact the total cost of the campground. Select the range AA26 and fill it with a percent series based on the values in range AA Create a single variable data table to determine the impact that the variable interest rates in the range AA22 will have on the total cost of the campground. In cell B11, create a formula without using a function that references cell D5 the monthly payments. In cell C11, create a formula without using a function that references cell D6 the total interest paid on the loan. In cell D11, create a formula without using a function that references cell D7 the total cost of the mortgage. Select the range AD26 and create a single-variable data table, using an absolute reference to cell D3 the mortgage interest rate as the Column input cell. To help Kaleen identify how each rate in her Variable Interest Rate Schedule compares to the interest rate she anticipates on her mortgage, she decides to highlight the matching interest rate in the schedule with a conditional formatting rule. Apply a Highlight Cells conditional formatting rule to the range AA26 that formats any cell in the range that is equal to the value in cell D3 using an absolutereference to cell D3 with Green Fill with Dark Green Text. Kaleen now wishes to finalize the Amortization schedule. In cell J4, create a formula without using a function that subtracts the value in cell I4 from the value in cell H4 to determine how much of the mortgage principal is being paid off each year. In cell K4, create a formula using the IF function to calculate the interest paid on the mortgage or the difference between the total payments made each year and the total amount of mortgage principal paid each year. The formula should first check if the value in cell H4 the balance remaining on the loan each year is greater than 0. If the value in cell H4 is greater than 0, the formula should return the value in J4 subtracted from the value in cell D5 multiplied by Use a relative cell reference to cell J4 and an absolute cell reference to cell D5. If the value in cell H4 is not greater than 0, the formula should return a value of 0. Kaleen decides to add custom cell borders to the amortization schedule to make it easier to read. Add an Outline border with a Medium border style 2nd column, 5th row to the range G3:K Add a Top border with a Light border style 1st column, 7th row to the range G4:K4. Add a Bottom border with a Light border style 1st column, 7th row to the range GK To make the various elements of the Campground Mortgage worksheet easier to select and print, Kaleen wants to add custom names to ranges in the worksheet. Assign names to the cells in the range D5:D7 by selecting the range C5:D7 and creating names from the selection using the values in the Left column as the defined names. However, since her assumptions about the price of the campground, the down payment, and the mortgage interest rate may be incorrect, she wants to be able to update these values in the protected worksheet. Protect the Campground Mortgage worksheet without a password. Kaleen had previously hidden a worksheet containing data on other recently purchased campgrounds in New Hampshire. Now she wants to compare the data in that worksheet with the data she just calculated. In cell B8, create a formula without using a function that determines the total interest associated with the mortgage. First multiply the value in cell B6 the number of terms by the value in cell B7 the number of monthly payments and by 12 to convert the yearly terms to monthly termsand then subtract the value in cell B4 the total loan amount.

## Comments on “Excel module 4 sam exam answers”