UUS Practice Tests⌕ Search
IT Certifications · 77-602

Exam 77-602: MOS: Using Microsoft Office Excel 2007 Practice Test

Exam 77-602 practice focuses on using Excel 2007 to organize worksheet data, format cells, and work with workbook elements. The available practice questions touch on sorting and filtering lists, removing duplicate records, naming cell ranges, applying conditional formatting, and navigating long worksheets. These tasks rely on choosing commands that keep data readable and make relevant values easier to locate.

Exam overview

Exam providerMicrosoft
Exam code77-602
CategoryIT Certifications

About the Exam 77-602: MOS: Using Microsoft Office Excel 2007 Exam

Excel 2007 work involves distinguishing workbook-level structures from worksheet ranges and selecting tools that suit the task. Sorting rearranges records according to values in one or more columns, while filtering temporarily limits visible rows to specified criteria. Removing duplicates changes the data by deleting repeated records, so it should not be confused with filtering. Named ranges let formulas refer to cells through descriptive labels; the Name Box can identify or navigate to a cell or range. Other practical decisions include using conditional formatting to make values stand out, freezing panes to retain headings while scrolling, and applying consistent appearance with Format Painter. Merging cells affects the selected cell layout, so consider how it may interact with nearby data and worksheet use. These concepts support routine spreadsheet work such as reviewing lists, locating records, and presenting information clearly.

Sample Practice Questions

Review a selection from this exam's published US Practice Tests practice bank.

Question 1

In Excel 2007, which command arranges selected rows so that entries with identical values in one or more columns are grouped together?

  1. AFilter
  2. BSort
  3. CFreeze Panes
  4. DGroup Worksheets
Show answerCorrect answer: B

Sorting rearranges rows according to values in selected columns. This can place matching entries together; filtering instead hides rows that do not meet criteria.

Question 2

You want to name a range of cells so that formulas can refer to it by a descriptive label. Which Excel 2007 feature is designed for this?

  1. ADefine Name
  2. BRemove Duplicates
  3. CText to Columns
  4. DGoal Seek
Show answerCorrect answer: A

Define Name assigns a meaningful name to a cell or range. A formula can then use that name instead of the range's cell addresses.

Question 3

In Excel 2007, which feature applies a visual format to cells when their values meet a specified condition?

  1. AConditional Formatting
  2. BFormat Painter
  3. CPage Break Preview
  4. DName Manager
Show answerCorrect answer: A

Conditional Formatting changes a cell’s appearance based on rules, such as highlighting values above a threshold.

Question 4

Which Excel 2007 feature can display only the rows in a list that meet criteria you specify, without deleting the other rows?

  1. AAutoFilter
  2. BRemove Duplicates
  3. CText to Columns
  4. DSubtotal
Show answerCorrect answer: A

AutoFilter temporarily hides rows that do not match the selected filter criteria. The underlying rows remain in the list and can be shown again by clearing the filter.

Question 5

Which Excel 2007 command helps identify and delete records that repeat across selected columns in a data range?

  1. ARemove Duplicates
  2. BConsolidate
  3. CText to Columns
  4. DData Validation
Show answerCorrect answer: A

Remove Duplicates checks selected columns for repeated records and removes duplicate rows according to the columns you choose. Reviewing the selected range first helps avoid deleting valid data.

Question 6

In Excel 2007, what is the primary purpose of a workbook?

  1. ATo store one or more worksheets in a single file
  2. BTo apply a theme to every open program
  3. CTo create a single printed page from a chart
  4. DTo convert formulas into images
Show answerCorrect answer: A

An Excel workbook is the file that can contain multiple worksheets, charts, and related data.

Question 7

What is the effect of merging selected cells in Excel 2007?

  1. AIt combines their displayed area into one larger cell
  2. BIt adds the numeric values in the selected cells
  3. CIt creates a separate worksheet for each selected cell
  4. DIt sorts the selected cells alphabetically
Show answerCorrect answer: A

Merge commands combine selected cells into a single larger cell area. Merging does not perform a calculation on their contents.

How to use this practice test

The free practice session draws up to 20 random questions from the 50 published questions for this exam. Answer each item by matching the requested spreadsheet task to the relevant Excel 2007 command or feature. Results appear after the session, helping you spot concepts to revisit, such as filtering versus deleting records or navigating named ranges.

Preparation tips

  • Practice sorting a list by one column and then by multiple columns; check how the order of sort levels changes the result.
  • Compare filtering with Remove Duplicates: identify which action hides rows and which permanently removes repeated records from the selected range.
  • Create a named range, select it through the Name Box, and use its label in a formula to reinforce how range references work.
  • Apply conditional formatting to a value range, then use Freeze Panes to keep worksheet headings visible while scrolling.
  • Use Format Painter on a sample range and inspect merged cells to understand how formatting and layout changes affect worksheet readability.
Official sourceOfficial exam page ↗