DIT Semester 2 Exam Study Guide || Guaranteed Pass!!!

Excel provides the tools to create which type of documents? correct answers Workbooks In Excel, the commands on each ribbon tab are organized into logical command _ correct answers Groups In Excel, where is the Fill handle located? correct answers in the right hand corner of a cell Excel ___ are files that include preset formatting and formulas. correct answers Templates In order to display all formulas in your worksheet in Excel, what do you do? correct answers Click the Show Formulas command button on the Formulas tab In Excel, which calculation would be performed first in this formula?(((3+1)*((2+2)-2)*(1*1)))* (4+5) correct answers (2+2) In Excel, any formula that includes cells whose values change should include what? correct answers Cell reference In Excel, an absolute cell reference requires which symbol? correct answers dollar sign $ In Excel, what is an absolute cell reference? correct answers absolute cell reference is one that does not change when it's moved, copied or filled. In Excel, what is meant by naming a range of cells? correct answers You can create a named range in Excel for each data category, and then use that name instead of the cell references. In Excel, which is the formula to add all cells in a range called SALES? correct answers Select a cell next to the numbers you want to sum, click AutoSum on the Home tab, press Enter, and you're done. In Excel, which function quickly adds a contiguous range of cells? correct answers AUTOSUM In Excel, which of the following is a predefined formula that performs a calculation? correct answers function In Excel, what is the alternative to manually creating a formula? correct answers File Options Formulas Calculation options section Workbook Calculation. In Excel, if you want to calculate how much interest you will pay on your mortgage, which function icon would you click in the Formulas tab? correct answers Financial In Excel, what separates a function containing multiple arguments? correct answers a comma In Excel, what functions do not use arguments? correct answers RAND, TODAY, NOW In Excel, which of the following is a valid TODAY formula to calculate the number of years you have lived if you were born in 1975 correct answers =YEAR(TODAY())-1975