Spreadsheet Modeling Test
with complete solution 2023-2024
A data ____ table describes the fields you plan to maintain in a table. - Answersdefinition
Press ____ to return to cell A1 in a worksheet. - AnswersCtrl+Home
In Excel, a table is a range of related data that is managed independently from the data in other ____
in the worksheet. - Answersrows and columns
To create a table, click the ____ tab on the Ribbon and then, in the Tables group, click the Table
button. - Answersinserts
After Excel displays an existing entry in the column that matches the characters you typed, press the
____ key to accept the entry. - AnswersTab
The fields you use to order your data are called sort ____. - AnswersFields
To add a sort field in the Sort dialog box, click the ____ button. - AnswersAdd level
After you filter a column, the ____ Filter command becomes available so you can remove the filter
and redisplay all the records. - AnswersClear
The ____ condition requires that all of the selected criteria be true for the record to be displayed. -
AnswersAND
, The ____ condition requires that only one of the selected criteria be true for a record to be
displayed. - AnswersOR
The ____ criteria filter requires the records displayed to be greater than or equal to and less than or
equal to the specified numbers. - Answersbetween
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. - Answersarrow
You can click the More Functions command on the Total arrow button list to open the ____ dialog
box and select any available function. - Answersinsert function
The Subtotals command offers summary information such as ____. - Answersall of the above
To calculate subtotal for a table, the first step is to use the ____ button on the Table Tools Design
tab. - Answersconvert to range
One advantage of PivotTables is that you can easily ____ different categories in the PivotTable to
provide alternative views of the data. - Answersany of the above
The PivotTable button is available in the Tables group on the ____ tab. - AnswersInsert
By default, the PivotTable report uses the ____ function for numbers in the Values area. -
AnswersSUM
You can use the ____ tab to change the SUM function to a different summary function, in a
PivotTable. - Answerssummarize 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. - Answersrefresh
A worksheet ____ is a collection of two or more selected worksheets. - Answersgroup
with complete solution 2023-2024
A data ____ table describes the fields you plan to maintain in a table. - Answersdefinition
Press ____ to return to cell A1 in a worksheet. - AnswersCtrl+Home
In Excel, a table is a range of related data that is managed independently from the data in other ____
in the worksheet. - Answersrows and columns
To create a table, click the ____ tab on the Ribbon and then, in the Tables group, click the Table
button. - Answersinserts
After Excel displays an existing entry in the column that matches the characters you typed, press the
____ key to accept the entry. - AnswersTab
The fields you use to order your data are called sort ____. - AnswersFields
To add a sort field in the Sort dialog box, click the ____ button. - AnswersAdd level
After you filter a column, the ____ Filter command becomes available so you can remove the filter
and redisplay all the records. - AnswersClear
The ____ condition requires that all of the selected criteria be true for the record to be displayed. -
AnswersAND
, The ____ condition requires that only one of the selected criteria be true for a record to be
displayed. - AnswersOR
The ____ criteria filter requires the records displayed to be greater than or equal to and less than or
equal to the specified numbers. - Answersbetween
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. - Answersarrow
You can click the More Functions command on the Total arrow button list to open the ____ dialog
box and select any available function. - Answersinsert function
The Subtotals command offers summary information such as ____. - Answersall of the above
To calculate subtotal for a table, the first step is to use the ____ button on the Table Tools Design
tab. - Answersconvert to range
One advantage of PivotTables is that you can easily ____ different categories in the PivotTable to
provide alternative views of the data. - Answersany of the above
The PivotTable button is available in the Tables group on the ____ tab. - AnswersInsert
By default, the PivotTable report uses the ____ function for numbers in the Values area. -
AnswersSUM
You can use the ____ tab to change the SUM function to a different summary function, in a
PivotTable. - Answerssummarize 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. - Answersrefresh
A worksheet ____ is a collection of two or more selected worksheets. - Answersgroup
