DIT FINAL EXAM STUDY GUIDE: POWERPOINT, EXCEL, and In DESIGN

Define: Resampling correct answers __Changing the pixel dimensions of an image is called resampling.__ What type of chart should be used for analyzing trends in Excel? correct answers __Line chart______________________________ 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 bottom right cell of the selected cells Excel templates are files that include present formatting and formulas correct answers formatting and formulas 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 Everything in the parenthesis 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 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 it makes it easier to refer back to the data in excel 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, 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 hjh In Excel, what separates a function containing multiple arguments correct answers _comma_______________________________