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 A worksheet ____ is a collection of two or more selected worksheets. -Answer -group Like cell ____, a worksheet group can contain adjacent or nonadjacent sheets. -
Answer -ranges To select adjacent worksheets, you use the ____ key. -Answer -shift To select nonadjacent worksheets, you use the ____ key. -Answer -Ctrl Rather than retyping the same formulas across a series of worksheets, you can enter them all at once by creating a worksheet ____. -Answer -group The ____ caption indicates a worksheet group. -Answer -[Group]
refresh A worksheet ____ is a collection of two or more selected worksheets. -Answer -group Like cell ____, a worksheet group can contain adjacent or nonadjacent sheets. -
Answer -ranges To select adjacent worksheets, you use the ____ key. -Answer -shift To select nonadjacent worksheets, you use the ____ key. -Answer -Ctrl Rather than retyping the same formulas across a series of worksheets, you can enter them all at once by creating a worksheet ____. -Answer -group The ____ caption indicates a worksheet group. -Answer -[Group]
