Package deal
Spreadsheets WGU Questions and Verified Answers Pack | Passed | A+
Spreadsheets WGU Questions and Verified Answers Pack | Passed | A+
[Show more]Spreadsheets WGU Questions and Verified Answers Pack | Passed | A+
[Show more]Workbook 
: An Excel file that stores all the information, previous calculations, and analyses 
that you may have already completed; must contain at least one worksheet 
Worksheet 
: A collection of cells arranged in the form of a table that contains the actual data 
and calculations. 
Cells 
: Sm...
Preview 2 out of 8 pages
Add to cartWorkbook 
: An Excel file that stores all the information, previous calculations, and analyses 
that you may have already completed; must contain at least one worksheet 
Worksheet 
: A collection of cells arranged in the form of a table that contains the actual data 
and calculations. 
Cells 
: Sm...
Question 1 Main Concept 
: Payment 
How to find Interest Amount 
How to find Principal Amount 
How to find Balance Amount 
Total Amount Paid 
Total Interest Paid 
Sum Check Calculation 
How to find monthly interest amount? 
: Previous balance X Monthly Interest Rate 
How to find monthly principal a...
Preview 2 out of 8 pages
Add to cartQuestion 1 Main Concept 
: Payment 
How to find Interest Amount 
How to find Principal Amount 
How to find Balance Amount 
Total Amount Paid 
Total Interest Paid 
Sum Check Calculation 
How to find monthly interest amount? 
: Previous balance X Monthly Interest Rate 
How to find monthly principal a...
Cell addresses 
: Cells are referenced by 
addresses made from their column letter 
and row number 
To Edit a Cell's Content 
: Select the cell andclick the Formula Bar,or double-click the cell. Edit the cell 
contentsand press 
Enter 
To Clear a Cell's Content 
: Select the cell(s) and press ...
Preview 2 out of 8 pages
Add to cartCell addresses 
: Cells are referenced by 
addresses made from their column letter 
and row number 
To Edit a Cell's Content 
: Select the cell andclick the Formula Bar,or double-click the cell. Edit the cell 
contentsand press 
Enter 
To Clear a Cell's Content 
: Select the cell(s) and press ...
Excel common uses 
: - Data entry and storage 
- Accounting and budgeting 
- Data analysis 
- Forecasting and reporting 
Absolute cell value 
: When you want a value used in calculations not to change. Use a $ in front of 
the value you don't want to change. 
relative and absolute cell 
: - A1 = b...
Preview 2 out of 6 pages
Add to cartExcel common uses 
: - Data entry and storage 
- Accounting and budgeting 
- Data analysis 
- Forecasting and reporting 
Absolute cell value 
: When you want a value used in calculations not to change. Use a $ in front of 
the value you don't want to change. 
relative and absolute cell 
: - A1 = b...
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
You can quickly pay through credit card for the summaries. There is no membership needed.
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Stuvia is a marketplace, so you are not buying this document from us, but from seller TestTrackers. Stuvia facilitates payment to the seller.
No, you only buy these notes for £19.03. You're not tied to anything after your purchase.
4.6 stars on Google & Trustpilot (+1000 reviews)
81298 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy revision notes and other study material for 14 years now