Microsoft® Office Excel® 2007

Exploring the Excel Environment

Explore the User Interface

The Microsoft Office Button

The Ribbon

The Quick Access Toolbar

The Microsoft Office Window Frame

How to Explore the User Interface qmd_itemtypeLogicalIdentifier qmd_questiontype MultipleChoice qmd_renderingtypeChoice qmd_responsetype Singlelmnk_onlinelayouttype Horizontal1 Select the correct answer. Which interface component in Excel consists of task-specific commands grouped under tabs? The Microsoft Office button The Microsoft Office Window Frame The Ribbon The Quick Access toolbar uid-45c4b123-3995-11db-b2ae-c7c1e636fdfc-C 1 0 You are correct. You are incorrect. qmd_itemtypeLogicalIdentifier qmd_questiontype MultipleChoice qmd_renderingtypeChoice qmd_responsetype Singlelmnk_onlinelayouttype Horizontal1 Select the correct answer. Which feature allows you to display and edit a spreadsheet in a page-by-page view, and supports the inclusion of header and footer information for the pages? Page Break Preview Page Layout View Print Area Margins uid-6e99e0c6-3995-11db-b2ae-c7c1e636fdfc-B 1 0 You are correct. You are incorrect.

Work with the Ribbon

The Home Tab

The Insert Tab

The Page Layout Tab

The Formulas Tab

The Data Tab

The Review Tab

The View Tab

The Developer Tab

Dialog Box Launchers

How to Work with the Ribbon qmd_itemtypeLogicalIdentifier qmd_questiontype MultipleChoice qmd_renderingtypeChoice qmd_responsetype Singlelmnk_onlinelayouttype Horizontal1 Select the correct answer. Which tab on the Ribbon consists of commands to work with functions? Page Layout Formulas View Home uid-6dffb1b9-3997-11db-b2ae-c7c1e636fdfc-B 1 0 You are correct. You are incorrect. qmd_itemtypeLogicalIdentifier qmd_questiontype MultipleChoice qmd_renderingtypeChoice qmd_responsetype Singlelmnk_onlinelayouttype Horizontal1 Select the correct answer. Which tab has commands to add tables and charts? Developer Home Insert Data uid-8ef3d22c-3997-11db-b2ae-c7c1e636fdfc-C 1 0 You are correct. You are incorrect.

Work with Contextual Tabs

Contextual Tabs

Types of Contextual Tabs

The Mini Toolbar

How to Work with Contextual Tabs qmd_itemtypeLogicalIdentifier qmd_questiontype MultipleChoice qmd_renderingtypeChoice qmd_responsetype Singlelmnk_onlinelayouttype Horizontal1 Select the correct answer. What are contextual tabs? Context based command tabs that appear only when a particular view or mode is selected. Command tabs that appear only when a specific object such as a table or chart is selected. Command tabs that are used for inserting tables and charts. Command tabs used for performing clipboard operations and basic text and cell formatting. uid-be3faa90-3997-11db-b2ae-c7c1e636fdfc-B 1 0 You are correct. You are incorrect. qmd_itemtypeLogicalIdentifier qmd_questiontype MultipleChoice qmd_renderingtypeChoice qmd_responsetype Singlelmnk_onlinelayouttype Horizontal1 Select the correct answer. Which is a contextual tab that is displayed when you select a chart in a worksheet? Analyze Layout Developer Options uid-c4fb9ab3-3997-11db-b2ae-c7c1e636fdfc-B 1 0 You are correct. You are incorrect.

Use the Excel Galleries

Galleries

Live Preview

How to Use the Excel Galleries and Live Preview qmd_itemtypeLogicalIdentifier qmd_questiontype MultipleChoice qmd_renderingtypeChoice qmd_responsetype Singlelmnk_onlinelayouttype Horizontal1 Select the correct answer. What is the dynamic feature that instantaneously applies a selection from a gallery to the object selected on the spreadsheet? Quick Access toolbar Formulas More button Live Preview uid-f9054a46-3997-11db-b2ae-c7c1e636fdfc-D 1 0 You are correct. You are incorrect. qmd_itemtypeLogicalIdentifier qmd_questiontype TrueFalseqmd_renderingtype Choiceqmd_responsetype Singlelmnk_onlinelayouttype Horizontal1 Select the correct answer. True or False? Excel provides various galleries for text, charts, tables, shapes, and cell styles. True False uid-01b39489-3998-11db-b2ae-c7c1e636fdfc-A 1 0 You are correct. You are incorrect.

Customize the Excel Interface

The Excel Options Dialog Box

How to Customize the Excel Interface qmd_itemtypeLogicalIdentifier qmd_questiontype MultipleChoice qmd_renderingtypeChoice qmd_responsetype Singlelmnk_onlinelayouttype Horizontal1 Select the correct answer. Which location provides options for customizing and configuring the Excel user interface? The Microsoft Office Window Frame The Microsoft Office button The Ribbon The Excel Options dialog box uid-46563a7c-3998-11db-b2ae-c7c1e636fdfc-D 1 0 You are correct. You are incorrect. qmd_itemtypeLogicalIdentifier qmd_questiontype MultipleChoice qmd_renderingtypeChoice qmd_responsetype Singlelmnk_onlinelayouttype Horizontal1 Select the correct answer. Which category in the left pane of the Excel Options dialog box allows you to add a command shortcut to the Quick Access toolbar? Add-Ins Popular Customize Advanced uid-4ea7709f-3998-11db-b2ae-c7c1e636fdfc-C 1 0 You are correct. You are incorrect.

Organizing Data

Explore the Enhancements in Excel 2007 Spreadsheets

Excel Spreadsheet Enhancements

Excel Template Enhancements

Themes

How to Explore the Enhancements to Excel Spreadsheets qmd_itemtypeLogicalIdentifier qmd_questiontype MultipleChoice qmd_renderingtypeChoice qmd_responsetype Singlelmnk_onlinelayouttype Horizontal1 Select the correct answer. What is the feature that helps you apply color, font, and effect selections consistently throughout a spreadsheet? Cell styles Themes Templates Conditional Formatting uid-d3494c22-3998-11db-b2ae-c7c1e636fdfc-B 1 0 You are correct. You are incorrect. qmd_itemtypeLogicalIdentifier qmd_questiontype TrueFalseqmd_renderingtype Choiceqmd_responsetype Singlelmnk_onlinelayouttype Horizontal1 Select the correct answer. True or False? The Excel Options dialog box allows you to create either a blank workbook or a workbook based on an online template. True False uid-d87e2715-3998-11db-b2ae-c7c1e636fdfc-B 1 0 You are correct. You are incorrect.

Insert Tables

The Enhanced Excel Table

How to Insert Tables qmd_itemtypeLogicalIdentifier qmd_questiontype MultipleChoice qmd_renderingtypeChoice qmd_responsetype Singlelmnk_onlinelayouttype Horizontal1 Select the correct answer. How will you insert an Excel table? On the Data tab, in the Data Tools group, click Consolidate. On the Insert tab, in the Text group, click Object. On the Home tab, in the Cells group, click Insert. On the Insert tab, in the Tables group, click Table. uid-070ddc68-3999-11db-b2ae-c7c1e636fdfc-D 1 0 You are correct. You are incorrect. qmd_itemtypeLogicalIdentifier qmd_questiontype TrueFalseqmd_renderingtype Choiceqmd_responsetype Singlelmnk_onlinelayouttype Horizontal1 Select the correct answer. True or False? The Excel table contains the filter option and banded rows by default. True False uid-0d4dbebb-3999-11db-b2ae-c7c1e636fdfc-A 1 0 You are correct. You are incorrect.

Format Tables

Table Tools

How to Format Tables qmd_itemtypeLogicalIdentifier qmd_questiontype MultipleChoice qmd_renderingtypeChoice qmd_responsetype Singlelmnk_onlinelayouttype Horizontal1 Select the correct answer. Which tab on the Ribbon has commands to format an Excel table? Layout Design Options Format uid-426004ae-3999-11db-b2ae-c7c1e636fdfc-B 1 0 You are correct. You are incorrect. qmd_itemtypeLogicalIdentifier qmd_questiontype TrueFalseqmd_renderingtype Choiceqmd_responsetype Singlelmnk_onlinelayouttype Horizontal1 Select the correct answer. True or False? Using the Format As Table button on the Home tab, you can create a pre-formatted table. True False uid-460df181-3999-11db-b2ae-c7c1e636fdfc-A 1 0 You are correct. You are incorrect.

Analyzing Data

Apply Conditional Formatting

The Conditional Formatting Button

Conditional Formatting Categories

Conditional Formatting Rules Manager

How to Apply Conditional Formatting qmd_itemtypeLogicalIdentifier qmd_questiontype MultipleChoice qmd_renderingtypeChoice qmd_responsetype Singlelmnk_onlinelayouttype Horizontal1 Select the correct answer. Which formatting style can be applied using the Conditional Formatting menu? Data Bars Themes Cell Styles Table Styles uid-6aceaa54-3999-11db-b2ae-c7c1e636fdfc-A 1 0 You are correct. You are incorrect. qmd_itemtypeLogicalIdentifier qmd_questiontype MultipleChoice qmd_renderingtypeChoice qmd_responsetype Singlelmnk_onlinelayouttype Horizontal1 Select the correct answer. How will you display the New Formatting Rule dialog box? On the Design tab, in the Table Styles group, click the More button. On the Design tab, in the Tools group, click Convert To Range. On the Home tab, in the Styles group, on the Conditional Formatting menu, click New Rule. On the Home tab, in the Cells group, click Format. uid-7067c557-3999-11db-b2ae-c7c1e636fdfc-C 1 0 You are correct. You are incorrect.

Sort Data in a Spreadsheet

Enhanced Sort Options

How to Sort Data in a Spreadsheet qmd_itemtypeLogicalIdentifier qmd_questiontype MultipleChoice qmd_renderingtypeChoice qmd_responsetype Singlelmnk_onlinelayouttype Horizontal1 Select the correct answer. How will you display the Sort dialog box? On the Data tab, in the Sort & Filter group, click Sort. On the Home tab, in the Cells group, click Format. On the Review tab, in the Changes group, click Allow Users To Edit Ranges. On the View tab, in the Window group, click Split. uid-ac194baa-3999-11db-b2ae-c7c1e636fdfc-A 1 0 You are correct. You are incorrect. qmd_itemtypeLogicalIdentifier qmd_questiontype TrueFalseqmd_renderingtype Choiceqmd_responsetype Singlelmnk_onlinelayouttype Horizontal1 Select the correct answer. True or False? Excel 2007 provides 64 levels of sorting. True False uid-afd31f5d-3999-11db-b2ae-c7c1e636fdfc-A 1 0 You are correct. You are incorrect.

Filter Data in a Spreadsheet

Enhanced Filter Options

How to Filter Data in a Spreadsheet qmd_itemtypeLogicalIdentifier qmd_questiontype MultipleChoice qmd_renderingtypeChoice qmd_responsetype Singlelmnk_onlinelayouttype Horizontal1 Select the correct answer. How will you filter data by number? On the Review tab, in the Changes group, click Allow Users To Edit Ranges. On the Formulas tab, in the Function Library group, click Logical. On the Data tab, in the Sort & Filter group, click Filter. On the Home tab, in the Number group, click the Accounting Number Format button. uid-d71eefe0-3999-11db-b2ae-c7c1e636fdfc-C 1 0 You are correct. You are incorrect. qmd_itemtypeLogicalIdentifier qmd_questiontype TrueFalseqmd_renderingtype Choiceqmd_responsetype Singlelmnk_onlinelayouttype Horizontal1 Select the correct answer. True or False? The enhanced filter options in Excel 2007 enable you to filter data ranges based on the cell color or font color. True False uid-db16b6f3-3999-11db-b2ae-c7c1e636fdfc-A 1 0 You are correct. You are incorrect.

Apply a Formula

The Enhanced Formula Bar

The Formula AutoComplete Feature

The Enhanced Function Wizard

The Function Library

The Name Manager Dialog Box

Calculation Options

How to Apply Formulas qmd_itemtypeLogicalIdentifier qmd_questiontype MultipleChoice qmd_renderingtypeChoice qmd_responsetype Singlelmnk_onlinelayouttype Horizontal1 Select the correct answer. Which Excel feature provides the options for assigning names for items such as cells, cell ranges, and tables in the Excel spreadsheet? Create New Theme Colors dialog box New Formatting Rule dialog box Watch Window Name Manager dialog box uid-0393b476-399a-11db-b2ae-c7c1e636fdfc-D 1 0 You are correct. You are incorrect. qmd_itemtypeLogicalIdentifier qmd_questiontype TrueFalseqmd_renderingtype Choiceqmd_responsetype Singlelmnk_onlinelayouttype Horizontal1 Select the correct answer. True or False? The Formula AutoComplete feature is available only for the AutoSum function. True False uid-08c3ad69-399a-11db-b2ae-c7c1e636fdfc-B 1 0 You are correct. You are incorrect.

Presenting Data

Create Charts

Enhanced Charts

How to Create Charts qmd_itemtypeLogicalIdentifier qmd_questiontype MultipleChoice qmd_renderingtypeChoice qmd_responsetype Singlelmnk_onlinelayouttype Horizontal1 Select the correct answer. How will you create a chart in Excel? On the Insert tab, in the Charts group, click a chart type, and in the displayed gallery, select a chart. On the Insert tab, in the Charts group, in a chart gallery, click All Chart Types. In the left pane, select a chart type. In the right pane, select a chart and click Set As Default Chart. On the Insert tab, in the Text group, click Symbol. On the Insert tab, in the Text group, click Object. uid-2bf4023c-399a-11db-b2ae-c7c1e636fdfc-A 1 0 You are correct. You are incorrect. qmd_itemtypeLogicalIdentifier qmd_questiontype TrueFalseqmd_renderingtype Choiceqmd_responsetype Singlelmnk_onlinelayouttype Horizontal1 Select the correct answer. True or False? In terms of look and feel, charts in Excel 2007 are no different from that in Excel 2003. True False uid-3003970f-399a-11db-b2ae-c7c1e636fdfc-B 1 0 You are correct. You are incorrect.

Format Charts

The Enhanced Chart Tools

Chart Templates

How to Format Charts qmd_itemtypeLogicalIdentifier qmd_questiontype MultipleChoice qmd_renderingtypeChoice qmd_responsetype Singlelmnk_onlinelayouttype Horizontal1 Select the correct answer. Which option enables you to change the chart type? Change Chart Type dialog box Other Charts gallery Create Chart dialog box All Chart Types button uid-56c046f2-399a-11db-b2ae-c7c1e636fdfc-A 1 0 You are correct. You are incorrect. qmd_itemtypeLogicalIdentifier qmd_questiontype TrueFalseqmd_renderingtype Choiceqmd_responsetype Singlelmnk_onlinelayouttype Horizontal1 Select the correct answer. True or False? You can format a chart using the Design, Layout, and Format contextual tabs. True False uid-5a991455-399a-11db-b2ae-c7c1e636fdfc-A 1 0 You are correct. You are incorrect.

Work with Illustrations

The SmartArt Gallery

The Enhanced Shapes Gallery

How to Work with Illustrations qmd_itemtypeLogicalIdentifier qmd_questiontype MultipleChoice qmd_renderingtypeChoice qmd_responsetype Singlelmnk_onlinelayouttype Horizontal1 Select the correct answer. Which feature in Excel would you use to illustrate processes, hierarchies, process cycles, and relationships? WordArt Shapes SmartArt graphics Charts uid-8c8a4428-399a-11db-b2ae-c7c1e636fdfc-C 1 0 You are correct. You are incorrect. qmd_itemtypeLogicalIdentifier qmd_questiontype TrueFalseqmd_renderingtype Choiceqmd_responsetype Singlelmnk_onlinelayouttype Horizontal1 Select the correct answer. True or False? You can insert a SmartArt graphic using the Picture button in the Illustrations group. True False uid-903cc4db-399a-11db-b2ae-c7c1e636fdfc-B 1 0 You are correct. You are incorrect.

Create PivotTables and PivotCharts

Enhanced PivotTables

Enhanced PivotCharts

How to Create PivotTables and PivotCharts qmd_itemtypeLogicalIdentifier qmd_questiontype MultipleChoice qmd_renderingtypeChoice qmd_responsetype Singlelmnk_onlinelayouttype Horizontal1 Select the correct answer. Which group on the Insert tab consists of the command to create a PivotChart? Charts Tables Illustrations Text uid-b349650e-399a-11db-b2ae-c7c1e636fdfc-B 1 0 You are correct. You are incorrect. qmd_itemtypeLogicalIdentifier qmd_questiontype TrueFalseqmd_renderingtype Choiceqmd_responsetype Singlelmnk_onlinelayouttype Horizontal1 Select the correct answer. True or False? When PivotChart is created, a PivotTable is automatically created along with it. True False uid-b6f99bd1-399a-11db-b2ae-c7c1e636fdfc-A 1 0 You are correct. You are incorrect.

Share Excel Charts

The Chart Sharing Feature

How to Share Excel Charts qmd_itemtypeLogicalIdentifier qmd_questiontype MultipleChoice qmd_renderingtypeChoice qmd_responsetype Singlelmnk_onlinelayouttype Horizontal1 Select the correct answer. How will you share a chart with any other Microsoft Office application? Click the Microsoft Office button and then choose Publish. Click the Microsoft Office button and then choose Prepare. On the Home tab, in the Clipboard group, click Paste. Copy the chart and paste it in a Word or PowerPoint file. uid-e4854ea4-399a-11db-b2ae-c7c1e636fdfc-D 1 0 You are correct. You are incorrect. qmd_itemtypeLogicalIdentifier qmd_questiontype TrueFalseqmd_renderingtype Choiceqmd_responsetype Singlelmnk_onlinelayouttype Horizontal1 Select the correct answer. True or False? When an Excel chart is shared, any changes made to the data source of the chart are automatically updated in the charts that share the same data source. True False uid-e8272d87-399a-11db-b2ae-c7c1e636fdfc-A 1 0 You are correct. You are incorrect.

Save Data in Presentable Formats

Enhanced Save As Options

The Prepare Options

How to Save Data in Presentable Formats qmd_itemtypeLogicalIdentifier qmd_questiontype MultipleChoice qmd_renderingtypeChoice qmd_responsetype Singlelmnk_onlinelayouttype Horizontal1 Select the correct answer. How will you save a Workbook as a Binary Workbook ? On the Microsoft Office button menu, place the mouse pointer over the Save As arrow, and from the displayed submenu, choose Excel Binary Workbook On the Microsoft Office button menu, place the mouse pointer over the Publish arrow, and from the displayed submenu, choose Excel Services. On the Microsoft Office button menu, place the mouse pointer over the Prepare arrow, and from the displayed submenu, choose Properties. On the Microsoft Office button menu, click Save. uid-0e25214a-399b-11db-b2ae-c7c1e636fdfc-A 1 0 You are correct. You are incorrect. qmd_itemtypeLogicalIdentifier qmd_questiontype TrueFalseqmd_renderingtype Choiceqmd_responsetype Singlelmnk_onlinelayouttype Horizontal1 Select the correct answer. True or False? Saving spreadsheets in XML Data format or Excel Binary Workbook format enable you to secure data and recover corrupted files. True False uid-136f800d-399b-11db-b2ae-c7c1e636fdfc-A 1 0 You are correct. You are incorrect.