CIS 105 Exam Questions & Answers 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? - ANSWERS14 Why would you press Ctrl+' in Excel? - ANSWERSTo display cell formulas Which of the following is a nonadjacent range? - ANSWERSA1:A10, D1:D10 If you want to balance a title over several columns, what do you do? - ANSWERSMerge 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? - ANSWERSIncrease the column width. A workbook is defined as: - ANSWERSa file containing related worksheets. The Formula Bar: - ANSWERSdisplays the formula or contents of an active cell. What does a sheet tab display? - ANSWERSThe name of a worksheet within a workbook The Name Box (as it applies to Excel 2013) - ANSWERSidentifies the address of the current cell. A cell (as it applies to Excel 2013) - ANSWERSis the intersection of a column and a row. You should use cell references in formulas instead of constant values so - ANSWERSyou can change the input values without changing the formulas. Press____ to enter data into a cell and keep that cell as the active cell. - ANSWERSCtrl+Enter Using the fill handle on a cell containing formula - ANSWERScopies the formula in the