Spreadsheet Modeling Exam Questions and Answers

Spreadsheet Modeling Exam Questions and Answers A data ____ table describes the fields you plan to maintain in a table. -Answer-definition Press ____ to return to cell A1 in a worksheet. -Answer-Ctrl+Home In Excel, a table is a range of related data that is managed independently from the data in other ____ in the worksheet. -Answer-rows and columns To create a table, click the ____ tab on the Ribbon and then, in the Tables group, click the Table button. -Answer-inserts After Excel displays an existing entry in the column that matches the characters you typed, press the ____ key to accept the entry. -Answer-Tab The fields you use to order your data are called sort ____. -Answer-Fields To add a sort field in the Sort dialog box, click the ____ button. -Answer-Add level After you filter a column, the ____ Filter command becomes available so you can remove the filter and redisplay all the records. -Answer-Clear The ____ condition requires that all of the selected criteria be true for the record to be displayed. -Answer-AND The ____ condition requires that only one of the selected criteria be true for a record to be displayed. -Answer-OR The ____ criteria filter requires the records displayed to be greater than or equal to and less than or equal to the specified numbers. -Answer-between When you click in each cell in the Total row, a(n) ____ appears that you can click to open a list of the most commonly used functions. -Answer-arrow You can click the More Functions command on the Total arrow button list to open the ____ dialog box and select any available function. -Answer-insert function The Subtotals command offers summary information such as ____. -Answer-all of the above To calculate subtotal for a table, the first step is to use the ____ button on the Table Tools Design tab. -Answer-convert to range One advantage of PivotTables is that you can easily ____ different categories in the PivotTable to provide alternative views of the data. -Answer-any of the above The PivotTable button is available in the Tables group on the ____ tab. -Answer-Insert By default, the PivotTable report uses the ____ function for numbers in the Values area. -Answer-SUM You can use the ____ tab to change the SUM function to a different summary function, in a PivotTable. -Answer-summarize values by You cannot change data directly in the PivotTable. Instead, you must edit the Excel table, and then ____, or update, the PivotTable to reflect the updated data. -Answer- refresh