DIT Final Exam Study Guide || Questions with complete answers.

Excel provides the tools to create which type of documents? correct answers Workbook 2. 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 Command on 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 $ In Excel, what is an absolute cell reference? correct answers $A$1 In Excel, what is meant by naming a range of cells? correct answers Enables you to find location quickly In Excel, which is the formula to add all cells in a range called SALES? correct answers =SUM and =SUM 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 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 Comma In Excel, what functions do not use arguments? correct answers Today and Date 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