Microsoft Excel Final review Questions With Correct Answers

When you apply a filter, Excel______ - Answer Temporarily hides the records not meeting your specifications the options in the Subtotal dialog box determines the column for which subtotals are calculated and the ______ used in the calculations - Answer function to convert a worksheet into a table you must choose the Convert command on the ribbon - Answer true structured references all formulas to adjust results automatically as rows and columns are added to, or deleted from, the table - Answer trus structured references adjust as you_____ - Answer rename tables edit column headers move or cop formulas formulas in the total row of a table use the Subtotal function and automatically recalculate for the filtered records - Answer true when you create an outline for a worksheet list, Excel organizes the data into_______ - Answer detail groups outline groups can be created both automatically and manually - Answer true cropping of an image cannot be undone - Answer false SmartArt graphics cannot contain text - Answer false custom templates you create are saved by default to the _________ folder on your computer - Answer Templates the only templates you can use in Excel are templates you create yourself - Answer false SmartArt includes predefined charts to show relationships between ideas - Answer true handles on the outside of a selected image allow you to change its - Answer rotation size and shape you hold down the [Control] key to draw shapes that remain in the equal portion of width and height - Answer false a template contains the extension______ - Answer xltx you should save a macro to the Personal Macro Workbook if you want to use it in more than one workbook - Answer true the VLOOKUP and HLOOKUP functions are used to retrieve a piece of data from a lookup table located - Answer within a different worksheet workbook and within the same worksheet which of the following is NOT an acceptable macro name? - Answer Format Table the PivotTable Fields task a pane contains a section for each of the following except - Answer data