CIS 105 (QUESTIONS & ANSWERS) SOLVED 100% CORRECT

Given the formula=B1*B2+B3/B4^2 where B1 contains 3, B2 contains 4, B3 contains 32, and B4 contains 4, what is the result? - Answer-14 Why would you press Ctrl+' in Excel? - Answer-To display cell formulas Which of the following is a nonadjacent range? - Answer-A1:A10, D1:D10 If you want to balance a title over several columns, what do you do? - Answer-Merge and center the data over all columns. What should you do if you see a column of pound signs (###) instead of values or results of formulas? - Answer-Increase the column width. A workbook is defined as: - Answer-a file containing related worksheets. The Formula Bar: - Answer-displays the formula or contents of an active cell. What does a sheet tab display? - Answer-The name of a worksheet within a workbook The Name Box (as it applies to Excel 2013) - Answer-identifies the address of the current cell. A cell (as it applies to Excel 2013) - Answer-is the intersection of a column and a row. You should use cell references in formulas instead of constant values so - Answer-you can change the input values without changing the formulas. Press____ to enter data into a cell and keep that cell as the active cell. - Answer-Ctrl+EnterUsing the fill handle on a cell containing formula - Answer-copies the formula in the active cell to other cells and adapts it based upon the type of cell references in the original formula. What function would most appropriately accomplish the same thing as=(B5+C5+D5+E5+F5)/5? - Answer- =AVERAGE(B5:F5) The function =PMT(C5,C7,-C3) is stored in cell C15. What must be stored in cell C7? - Answer-Number of payment periods