UUS Practice Tests⌕ Search
IT Certifications · 77-882

Exam 77-882: Excel 2010 Practice Test

Exam 77-882: Excel 2010 practice covers spreadsheet operations, cell formatting, formulas, references, and worksheet presentation. The available questions include tasks such as splitting delimited text into columns, applying data validation, copying formulas, and preparing a sheet for printing. These skills support accurate data entry, calculation, organization, and reporting in Excel 2010.

Exam overview

Exam providerMicrosoft
Exam code77-882
CategoryIT Certifications

About the Exam 77-882: Excel 2010 Exam

Work with formulas by recognizing absolute references such as $C$5 and understanding how formulas behave when copied between cells. Function questions include counting characters with LEN and retrieving a row number with ROW. Other tasks focus on editing and presenting worksheet data: using Text to Columns with a delimiter, applying Format Painter, and choosing Merge & Center with awareness of how it affects a selected range. Data validation helps limit entries to whole numbers within a specified range, while selecting nonadjacent cells and confirming an entry can apply the same value across multiple locations. Page Layout view supports inspection of page-oriented worksheet presentation. Together, these operations connect cell-level accuracy with readable, printable spreadsheet output.

Sample Practice Questions

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

Question 1

Which command can split the contents of one column into multiple columns using a delimiter such as a comma?

  1. AText to Columns
  2. BConsolidate
  3. CGroup
  4. DSubtotal
Show answerCorrect answer: A

Text to Columns can divide text in a column into separate columns, either by delimiters such as commas or by fixed character widths.

Question 2

In Excel 2010, which formula returns the number of characters in cell A1, including spaces?

  1. A=COUNT(A1)
  2. B=LEN(A1)
  3. C=VALUE(A1)
  4. D=FIND(A1)
Show answerCorrect answer: B

LEN returns the number of characters in a text string, counting spaces as characters. COUNT counts numeric cells, while VALUE converts text that represents a number.

Question 3

In a formula, what does the reference $C$5 indicate?

  1. AA relative reference to column C and row 5
  2. BAn absolute reference to column C and row 5
  3. CA reference to the worksheet named C and row 5
  4. DA reference that changes only when the workbook is saved
Show answerCorrect answer: B

The dollar signs make both the column and row absolute, so copying the formula does not adjust the reference from C5.

Question 4

In Excel 2010, what is the usual effect of choosing Merge & Center for a selected range?

  1. AIt combines the selected cells into one cell and centers the content
  2. BIt centers the content in each cell without changing the cells
  3. CIt adds a border around every cell in the range
  4. DIt combines the values while keeping all cells separate
Show answerCorrect answer: A

Merge & Center merges the selected cells into a single cell and centers the resulting cell's content. Only the content in the upper-left cell is retained when merging cells that contain data.

Question 5

You want to restrict entries in a cell to whole numbers within a specified range. Which Excel feature is appropriate?

  1. AData Validation
  2. BFind and Replace
  3. CGroup
  4. DWatch Window
Show answerCorrect answer: A

Data Validation can limit the type and range of values users may enter in a cell, including whole numbers within specified bounds.

Question 6

You want to enter the same value into several nonadjacent cells selected together. Which key combination completes the entry in all selected cells?

  1. ACtrl+Enter
  2. BAlt+Enter
  3. CShift+Enter
  4. DCtrl+Shift+Enter
Show answerCorrect answer: A

After selecting the cells, type the value and press Ctrl+Enter to place that entry in every cell in the selection. Alt+Enter inserts a line break while editing a cell.

Question 7

What is the purpose of the Format Painter in Excel?

  1. ATo copy formatting from one area and apply it to another
  2. BTo copy formulas while keeping their original references unchanged
  3. CTo convert a worksheet into a picture
  4. DTo sort cells by their formatting
Show answerCorrect answer: A

Format Painter copies formatting—such as font, fill, borders, and number format—from a selected cell or range and applies it elsewhere.

How to use this practice test

The free practice bank contains 50 published questions. Each session presents up to 20 random questions, then shows results so you can identify areas to revisit. Use missed items to pinpoint whether the issue involved formula references, a function, a formatting command, data entry, or worksheet layout, then retry with attention to the specific Excel action involved.

Preparation tips

  • Practice distinguishing relative, absolute, and mixed cell references, and predict how each changes when a formula is copied to another cell.
  • Use sample data to test LEN and ROW, checking the result for a cell containing spaces and for a known cell reference.
  • Try Text to Columns with comma-delimited data, then compare the output with the original column before proceeding.
  • Create a validation rule for whole numbers within a range and test both an allowed value and a rejected value.
  • Switch to Page Layout view and inspect how worksheet content is arranged for printing; compare this with the effect of Merge & Center.
Official sourceOfficial exam page ↗