UUS Practice Tests⌕ Search
IT Certifications · 77-888

Exam 77-888: Excel 2010 Expert Practice Test

Exam 77-888 practice addresses advanced Excel 2010 workbook use: constructing formulas, managing worksheet behavior, and analyzing data with PivotTables. The practice bank includes tasks such as tracing relative and absolute references, using 3-D sheet references, protecting formula cells, and identifying relationships between formulas and their source cells.

Exam overview

Exam providerMicrosoft
Exam code77-888
CategoryIT Certifications

About the Exam 77-888: Excel 2010 Expert Exam

Excel 2010 expert-level work often requires choosing the right feature for a particular workbook task. Formula questions involve functions such as AVERAGE and INDEX, mixed or absolute references, and formulas that span multiple worksheets. Worksheet-management tasks include locking selected cells before protection, freezing rows for navigation, and applying formatting without copying cell contents. Analysis skills include refreshing PivotTables after source changes and inspecting formula precedents and dependents. These concepts support work such as maintaining reusable spreadsheets, reducing accidental edits, summarizing changing data, and tracing calculation errors. Practice scenarios can help you distinguish similar commands—for example, a lookup function from a row-reference function, or a worksheet-protection setting from cell locking—while following how Excel 2010 behaves when formulas are copied or reports are refreshed.

Sample Practice Questions

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

Question 1

You need a worksheet formula to display the workbook file name and worksheet name of the current sheet. Which function can provide this information as part of its result?

  1. ACELL
  2. BINFO
  3. CSHEET
  4. DADDRESS
Show answerCorrect answer: A

CELL with the "filename" information type returns the file path, workbook name, and current worksheet name. The workbook generally needs to have been saved for the filename information to be available.

Question 2

You want to apply the same border, fill, and font formatting to several nonadjacent cells. Which tool lets you copy formatting without copying cell contents?

  1. AFormat Painter
  2. BPaste Special: Values
  3. CText to Columns
  4. DFill Series
Show answerCorrect answer: A

Format Painter copies formatting from a selected cell or range and applies it elsewhere without transferring the source values or formulas.

Question 3

You want to prevent users from changing formulas in selected cells while allowing them to edit other cells. What must you do before protecting the worksheet?

  1. AUnlock the cells users may edit, then protect the worksheet
  2. BHide all formulas, then protect the workbook structure
  3. CMark the formulas as hidden, then save as a template
  4. DApply a cell style to editable cells, then turn on filtering
Show answerCorrect answer: A

Excel cells are locked by default, but that setting takes effect only when the worksheet is protected. Unlock the cells users should be able to edit, then protect the sheet.

Question 4

A formula in D2 is =SUM($B$2:B2). When copied down to D3, what formula results?

  1. A=SUM($B$2:B2)
  2. B=SUM(B3:$B$2)
  3. C=SUM($B$2:B3)
  4. D=SUM($B$3:B3)
Show answerCorrect answer: C

The first endpoint, $B$2, is absolute and remains fixed. The second endpoint, B2, is relative and shifts down to B3 when copied one row down.

Question 5

A workbook has several sheets, and you want to create a formula that adds the value in cell B4 from each of three adjacent sheets named East, Central, and West. Which formula uses a 3-D reference?

  1. A=SUM(East!B4,Central!B4,West!B4)
  2. B=SUM(East:West!B4)
  3. C=SUM(East-West!B4)
  4. D=SUM(B4:East:West)
Show answerCorrect answer: B

A 3-D reference uses the first and last sheet names separated by a colon, followed by an exclamation mark and the cell reference. SUM(East:West!B4) includes B4 on the sheets between and including those endpoints in tab order.

Question 6

You need a formula to return the average of values in C2:C30 while ignoring cells that contain text. Which function is appropriate?

  1. AAVERAGE
  2. BSUM
  3. CCOUNT
  4. DMAX
Show answerCorrect answer: A

AVERAGE calculates the arithmetic mean of numeric values in its referenced cells and ignores text entries in a referenced range.

Question 7

A workbook contains formulas that refer to cells on several worksheets. Which feature can show the relationships between a selected formula cell and the cells it references?

  1. AWatch Window
  2. BTrace Precedents
  3. CGoal Seek
  4. DName Manager
Show answerCorrect answer: B

Trace Precedents draws arrows from cells referenced by the selected formula to that formula cell, helping you inspect its inputs.

How to use this practice test

Access is free. The bank contains 50 questions, and each practice session presents up to 20 questions selected at random. Submit a session to see your results, then revisit any missed items by checking the relevant formula behavior, worksheet setting, or PivotTable command in Excel 2010.

Preparation tips

  • Trace formulas copied between rows, noting which references are relative, absolute, or mixed and how each changes.
  • Practice creating a 3-D reference across adjacent worksheets and verify the included sheet range and cell address.
  • Lock formula cells while leaving input cells editable, then protect the worksheet and test which cells users can change.
  • Refresh a PivotTable after editing its source data, and compare its displayed summary with the underlying records.
  • Use formula auditing to inspect precedents and dependents, and practice freezing panes and copying formatting without cell contents.
Official sourceOfficial exam page ↗