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
i...
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]
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller KatelynWhitman. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for £9.32. You're not tied to anything after your purchase.
