DIT Final Exam Study Guide Questions and Answers with complete solution

DIT Final Exam Study Guide Questions and Answers with complete solution Excel provides the tools to create which type of documents? Workbook 2. In Excel, the commands on each ribbon tab are organized into logical command____________. groups In Excel, where is the Fill handle located? in the right hand corner of a cell Excel __________________ are files that include preset formatting and formulas. Templates In order to display all formulas in your worksheet in Excel, what do you do? Command on Formulas tab In Excel, which calculation would be performed first in this formula?(((3+1)((2+2)-2)(11))) (4+5) (2+2) In Excel, any formula that includes cells whose values change should include what? Cell Reference In Excel, an absolute cell reference requires which symbol? $ In Excel, what is an absolute cell reference? $A$1 In Excel, what is meant by naming a range of cells? Enables you to find location quickly In Excel, which is the formula to add all cells in a range called SALES? =SUM and =SUM In Excel, which function quickly adds a contiguous range of cells? AutoSum In Excel, which of the following is a predefined formula that performs a calculation? Function In Excel, what is the alternative to manually creating a formula? 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? Financial In Excel, what separates a function containing multiple arguments? Comma In Excel, what functions do not use arguments? 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? =YEAR(TODAY())-1975 19. In Excel, all formulas must start with what character(s)? = In Excel, which is a valid syntax for the COUNT function?