D100 Intro to Spreadsheets Exams Questions and Verified Answers Pack | Passed | A+

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 calculations. Cells : Smal...

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...

Absolute Cell Reference : A cell reference that remains constant when a formula is pasted into a new cell; contains two "$". Algorithm : The part of a calculation that is applied to the measure. Example: average gas price. Arguments : The information inputted to create a function Bar Cha...

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...

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...

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 ...