Exam 15: Excel 2013 : Analyzing Table Data

Subtotals can be used in an Excel table.

(True/False)

4.8/5

(24)

Question 61

When you issue the Subtotal command,clicking the 2 outline symbol shows only subtotals and the ____________________ total.

(Short Answer)

4.9/5

(34)

Question 62

The Advanced Filter command allows you to search for data using And and Or ____________________ conditions.

(Short Answer)

4.7/5

(25)

Question 63

When specifying criteria in the Custom AutoFilter dialog box,use the * (asterisk)wildcard to represent any single character._________________________

(True/False)

4.8/5

(29)

Question 64

When performing an advanced filter,you specify ____ conditions by placing the criteria in the same row.

(Multiple Choice)

4.8/5

(34)

Question 65

Showing 61 - 65 of 65

Subtotals can be used in an Excel table.

When you issue the Subtotal command,clicking the 2 outline symbol shows only subtotals and the ____________________ total.

The Advanced Filter command allows you to search for data using And and Or ____________________ conditions.

When specifying criteria in the Custom AutoFilter dialog box,use the * (asterisk)wildcard to represent any single character._________________________

When performing an advanced filter,you specify ____ conditions by placing the criteria in the same row.

Word 2013 : Creating and Formatting Tables

Word 2013 : Illustrating Documents With Graphics

Word 2013 : Working With Themes and Building Blocks

Word 2013 : Merging Word Documents

Powerpoint 2013 : Working With Advanced Tools and Masters

Powerpoint 2013 : Enhancing Charts

Powerpoint 2013 : Inserting Graphics, Media, and Objects

Powerpoint 2013 : Using Advanced Features

Integration : Integrating Word and Excel

Integration : Integrating Word, Excel, and Access

Integration : Integrating Word, Excel, Access, and Powerpoint

Excel 2013 : Analyzing Data Using Formulas

Excel 2013 : Managing Workbook Data

Excel 2013 : Managing Data Using Tables

Access 2013 : Modifying the Database Structure

Access 2013 : Improving Queries

Access 2013 : Enhancing Forms

Access 2013 : Analyzing Data With Reports

Working in the Cloud

Filters