Excel Calculate Percentage: The Complete 2026 Guide to Percent Formulas, Increases, Decreases, and Real Spreadsheet Examples
Learn how to excel calculate percentage with formulas for increase, decrease, totals, and growth. Step-by-step examples, shortcuts, and pro tips.

Learning how to excel calculate percentage values is one of the most useful skills any spreadsheet user can master, because percentages appear in nearly every business, academic, and personal finance scenario imaginable. From calculating sales tax on a receipt to figuring out quarterly growth at a Fortune 500 company, percentages translate raw numbers into meaningful insights that decision-makers can act on. Excel makes this surprisingly easy once you understand the underlying logic, and this guide will walk you through every variation you are likely to encounter in 2026. Practice with the free Excel practice test on PracticeTestGeeks (500+ questions with answer explanations).
At its core, a percentage is just a fraction multiplied by one hundred, but Excel handles that final multiplication automatically when you apply the percent format. That means a simple formula like =A1/B1 will display 25% rather than 0.25 once you click the percent button. This automatic behavior trips up beginners constantly, so understanding what Excel does behind the scenes is the foundation for everything else you will learn about percent calculations in spreadsheets today.
Beyond basic division, Excel supports advanced percentage workflows including percent change between two values, percent of total across a column, running percentages with cumulative sums, and weighted percentages using SUMPRODUCT. You can also combine percentages with logical functions like IF, conditional formatting to highlight thresholds, and pivot tables to break down percentages by category. Each of these techniques has a specific use case, and we will cover them in detail with concrete examples drawn from real spreadsheets.
Percentages also appear constantly in financial modeling, where interest rates, growth rates, tax rates, commission rates, and discount rates all rely on accurate percent formulas. A single misplaced parenthesis can throw off an entire budget forecast by millions of dollars, which is why so many finance professionals invest time in mastering Excel percentage formulas before they touch a P&L statement. The same precision matters for academic research, marketing dashboards, sports analytics, and even kitchen recipes scaled for restaurants.
This guide is structured to take you from the absolute basics to advanced techniques, with checkpoints along the way to test your understanding. We will start with the percent format itself, move into the four core percentage formulas every analyst should memorize, then progress into combined formulas, error handling, and shortcuts that will save you hours every week. By the end, you should be able to handle any percent calculation thrown at you with confidence and speed.
You do not need an advanced degree or expensive software to follow along โ any version of Excel from 2016 onward, plus the free web version, supports every formula covered here. Google Sheets users will also find the syntax nearly identical, with only minor differences in a few edge cases. If you want to test your knowledge as you read, jump to the practice quizzes linked throughout this article and try a few questions before continuing. Practice is the fastest path to fluency with formulas.
Finally, a quick note on terminology before we dive in: percent means per hundred, percentage refers to the value itself, and percentage points describe the difference between two percentages. Mixing these up is a common mistake in news headlines and business meetings, and Excel users who understand the distinction stand out immediately. With that foundation in place, let us move into the actual mechanics of how Excel handles percent values inside cells, formulas, and formatted output.
Microsoft Excel: upcoming dates and official changes
- Jun 30, 2026: Certiport retired the Microsoft Office Specialist 2016 certifications, including MOS Excel 2016, on June 30, 2026. The Microsoft 365 Apps and Office 2019 Excel exams are still available. (certiport.pearsonvue.com)
- Updated Oct 16, 2026: Delivery is now Proctored live-in-the-application exam via Certiport Authorized Testing Centers (in-center or remote-proctored) (previously Proctored live-in-the-application exam via Certiport Authorized Testing Centers).
- Updated Oct 16, 2026: Eligibility is now No formal prerequisites; about 150 hours of instruction and hands-on experience recommended (previously No formal prerequisites; ~150 hours of instruction and hands-on experience recommended (Associate)).
- Updated Oct 16, 2026: Time limit is now 50 minutes (60 minutes seat time) (previously 50 minutes (60 minutes seat time)).
Facts verified Oct 17, 2026 against Microsoft (Microsoft Office Specialist program), delivered by Certiport, a Pearson VUE business. Dates that have passed are removed automatically.
- The MOS Excel (Microsoft 365 Apps) exam has 33 to 37 questions. (certiport.pearsonvue.com)
- The MOS Excel Expert (Microsoft 365 Apps) exam has 23 to 27 questions. (certiport.pearsonvue.com)
- Microsoft Office Specialist Excel exams last 50 minutes, with 60 minutes of total seat time. (Microsoft (Microsoft Office Specialist program), delivered by Certiport, a Pearson VUE business)
- The passing score for Microsoft Office Specialist Excel exams is always 700 on Certiport's 1 to 1000 scaled score. (certiport.pearsonvue.com)
- After failing a Microsoft Office Specialist Excel exam, candidates must wait 24 hours before the first retake and 48 hours before each later retake, and there is no annual limit on attempts. (Microsoft (Microsoft Office Specialist program), delivered by Certiport, a Pearson VUE business)
- Microsoft Office Specialist Excel certifications earned on or after September 23, 2025 are valid for five years; those earned earlier do not expire. (certiport.pearsonvue.com)
- The Microsoft Office Specialist Excel exam is proctored and delivered live in the Excel application through Certiport Authorized Testing Centers, either in person or remote-proctored. (Microsoft (Microsoft Office Specialist program), delivered by Certiport, a Pearson VUE business)
- Microsoft recommends that candidates for the MOS Excel Associate (Microsoft 365 Apps) certification have about 150 hours of instruction and hands-on experience with Excel. (Microsoft (Microsoft Office Specialist program), delivered by Certiport, a Pearson VUE business)
- Candidates get their MOS Excel score report as soon as they finish the exam, and it can also be viewed in their Certiport profile. (certiport.pearsonvue.com)
Facts verified Oct 17, 2026 against Microsoft (Microsoft Office Specialist program), delivered by Certiport, a Pearson VUE business. Dates that have passed are removed automatically.
Microsoft Excel Exam at a Glance
| Item | Detail | Official source |
|---|---|---|
| Number of questions (Excel Associate (MO-210)) | 33-37 questions | certiport.pearsonvue.com |
| Number of questions (Excel Expert (MO-211)) | 23-27 questions | certiport.pearsonvue.com |
| Time limit | 50 minutes (60 minutes seat time) | Microsoft (Microsoft Office Specialist program), delivered by Certiport, a Pearson VUE business |
| Passing score | 700 on a 1โ1000 scale | certiport.pearsonvue.com |
| Retake policy | Wait 24h after 1st fail, 48h before each later retake; no annual limit | Microsoft (Microsoft Office Specialist program), delivered by Certiport, a Pearson VUE business |
| Validity | Valid 5 years (earned on/after Sept 23, 2025) | certiport.pearsonvue.com |
| Delivery | Proctored live-in-the-application exam via Certiport Authorized Testing Centers (in-center or remote-proctored) | Microsoft (Microsoft Office Specialist program), delivered by Certiport, a Pearson VUE business |
| Eligibility | No formal prerequisites; about 150 hours of instruction and hands-on experience recommended | Microsoft (Microsoft Office Specialist program), delivered by Certiport, a Pearson VUE business |
| Score release | Score report at end of exam; also in Certiport profile | certiport.pearsonvue.com |
Facts verified Oct 17, 2026 against Microsoft (Microsoft Office Specialist program), delivered by Certiport, a Pearson VUE business. Dates that have passed are removed automatically.
Free Excel Study Tools
Interactive Excel resources on PracticeTestGeeks, free to start:
- Free Excel Questions and Answers โ 16 questions with instant scoring and answer explanations
- Excel flashcards โ review key terms and concepts card by card
- Excel study guide โ topic-by-topic overview of what the exam covers
- Excel cheat sheet โ one-page printable summary for last-minute review
Excel Percentage Calculations by the Numbers

How Excel Handles Percentages Step by Step
Enter the Raw Decimal
Apply Percent Format
Type a Percent Directly
Use in a Formula
Format the Result
The four core percentage formulas you need to know cover the vast majority of business scenarios you will face. The first is percent of total, written as =part/total, which tells you what share one value represents out of a larger group. For example, if your January sales were $25,000 and total yearly sales were $300,000, the formula =25000/300000 returns 8.33% when formatted as a percent. This formula appears in budget breakdowns, market share analysis, and survey results every single day.
The second core formula is percent change, written as =(new-old)/old. If revenue grew from $100,000 to $125,000, the formula =(125000-100000)/100000 returns 25%, meaning revenue increased by twenty-five percent. This formula powers every growth dashboard, year-over-year comparison, and trend report in modern business intelligence. Always remember that the denominator must be the original or older value, otherwise you will calculate the wrong direction of change and embarrass yourself in front of stakeholders during the next quarterly review.
The third essential formula is percent increase or decrease applied to a base value, written as =original*(1+rate) for an increase or =original*(1-rate) for a decrease. To add a 15% tax to a $200 product, type =200*(1+0.15) to get $230. To apply a 20% discount to a $500 item, type =500*(1-0.20) to get $400. This pattern shows up in pricing engines, tax calculators, commission structures, and inflation adjustments across every industry from retail to real estate.
The fourth formula is reverse percent, used to find the original value when you only know the final amount and the rate. If a price tag shows $104 including 15% sales tax, the original price is =115/(1+0.15), which returns $104. This pattern is especially common in accounting reconciliation, where you need to back out tax from gross receipts to report net revenue accurately. Many bookkeepers waste hours doing this calculation manually before they learn the formula, so it pays to commit it to memory.
Beyond these four, Excel offers helpful percentage variants through functions like PERCENTILE, PERCENTRANK, and SUMIFS combined with division. These advanced formulas let you find the value below which a given percentage of data falls, rank a value within a dataset as a percentile, or calculate conditional percentages where only certain rows count toward the denominator. Mastering these unlocks pivot-table-quality analysis without ever leaving the raw data sheet.
One critical tip: when working with percentages in formulas, always double-check whether your input is a decimal (0.25) or a percent (25%). Mixing them creates errors that are extremely hard to spot because the math still runs without throwing a #VALUE error. A common bug is multiplying by 25 when you meant 25%, which inflates your result by a factor of 100. Use the percent format to visualize the difference and catch these mistakes before they cascade through your model.
Finally, consider wrapping percentage formulas in error handlers like IFERROR or IFNA when the denominator might be zero or missing. For example, =IFERROR((B2-A2)/A2,0) safely returns zero instead of #DIV/0! when A2 is blank or zero. This small habit prevents cluttered dashboards full of error messages and keeps your spreadsheets looking professional even when underlying data is incomplete or still being collected from various sources across the organization.
Microsoft Excel Practice Test Questions
Prepare for the Microsoft Excel exam with our free practice test modules. Each quiz covers key topics to help you pass on your first try.
Microsoft Excel Excel Basic and Advance
Microsoft Excel Exam Questions covering Excel Basic and Advance. Master Microsoft Excel Test concepts for certification prep.
Microsoft Excel Excel Formulas
Free Microsoft Excel Practice Test featuring Excel Formulas. Improve your Microsoft Excel Exam score with mock test prep.
Microsoft Excel Excel Functions
Microsoft Excel Mock Exam on Excel Functions. Microsoft Excel Study Guide questions to pass on your first try.
Microsoft Excel Excel MCQ
Microsoft Excel Test Prep for Excel MCQ. Practice Microsoft Excel Quiz questions and boost your score.
Microsoft Excel Excel
Microsoft Excel Questions and Answers on Excel. Free Microsoft Excel practice for exam readiness.
Microsoft Excel Excel Trivia
Microsoft Excel Mock Test covering Excel Trivia. Online Microsoft Excel Test practice with instant feedback.
Three Approaches to Calculating Percent Change in Excel
The most common method is the simple subtraction-and-divide pattern: =(B2-A2)/A2 where A2 holds the old value and B2 holds the new value. Format the result as a percent and you get a clean growth or decline figure. This is the textbook approach taught in every accounting course and used in virtually every financial report produced today.
This formula works best when both cells are guaranteed to contain numbers and the original value is never zero. It is fast to type, easy to audit, and renders cleanly across all Excel versions including the web app and mobile. For most everyday tasks like monthly sales comparisons or budget variance reports, this is the formula you should reach for first without overthinking the problem.

Using Excel for Percentage Calculations: Pros and Cons
- +Built-in percent formatting handles display automatically with one keystroke
- +Works with thousands of rows instantly using simple formula drag-fill
- +Supports advanced functions like PERCENTILE, PERCENTRANK, and SUMIFS
- +Easy to audit because every cell shows its formula and inputs clearly
- +Integrates with charts, pivot tables, and conditional formatting for visualization
- +Compatible with Google Sheets and most other spreadsheet platforms today
- โConfusion between decimal storage and percent display trips up beginners
- โDivision by zero throws #DIV/0! errors that require IFERROR wrapping
- โRounding can introduce small inconsistencies in financial reports if uncontrolled
- โMixing percent and decimal formats in formulas leads to silent bugs
- โLarge datasets can slow down volatile percent formulas across many sheets
- โMobile and web versions occasionally render percent formats differently than desktop
Pros and Cons at a Glance
| Pros | Cons |
|---|---|
| Built-in percent formatting handles display automatically with one keystroke | Confusion between decimal storage and percent display trips up beginners |
| Works with thousands of rows instantly using simple formula drag-fill | Rounding can introduce small inconsistencies in financial reports if uncontrolled |
| Supports advanced functions like PERCENTILE, PERCENTRANK, and SUMIFS | Mixing percent and decimal formats in formulas leads to silent bugs |
| Easy to audit because every cell shows its formula and inputs clearly | Large datasets can slow down volatile percent formulas across many sheets |
| Integrates with charts, pivot tables, and conditional formatting for visualization | Mobile and web versions occasionally render percent formats differently than desktop |
Excel Calculate Percentage Setup Checklist
- โIdentify whether you need percent of total, percent change, or percent increase/decrease
- โConfirm your data is stored as numbers, not text masquerading as numbers
- โDecide on decimal precision before you start formatting (0, 1, or 2 places)
- โApply Ctrl+Shift+% to format result cells as percentages immediately
- โUse absolute references with dollar signs when dragging formulas down columns
- โWrap risky divisions in IFERROR to prevent #DIV/0! errors in your output
- โTest edge cases including zero, negative, and blank input values
- โDocument the formula logic with a comment or adjacent label cell
- โVerify totals add to 100% when calculating shares of a whole
- โAudit a sample of results manually against a calculator before sharing widely
Always remember Excel stores 25% as 0.25 internally
This single concept is the source of about half of all percentage errors in Excel. When you reference a percent-formatted cell in a formula, Excel uses the underlying decimal value, not the displayed number. So multiplying a price by a 25%-formatted cell gives you the correct result, but multiplying by the literal number 25 inflates the answer by 100x. Always think in decimals when reading your own formulas.
Let us walk through a realistic business scenario to put these concepts into practice. Imagine you manage a small retail store and need to analyze last month's sales performance across five product categories. Column A holds category names, column B holds sales figures, and you want column C to show each category as a percent of total. The formula in C2 would be =B2/SUM($B$2:$B$6), with the dollar signs locking the sum range so the formula can be dragged down without breaking. Format column C as percent and you have a clean breakdown ready for management review.
Next, suppose you want to compare this month to last month. Column D holds last month's figures, and column E will hold the percent change. The formula in E2 is =(B2-D2)/D2, again formatted as percent. To make the report more readable, you can use conditional formatting to highlight increases in green and decreases in red automatically. This visual cue helps managers spot trends instantly without scanning numbers, especially when reviewing dozens of products or business units at the end of each reporting cycle.
Another common scenario is calculating sales tax on a list of products. If column A holds prices and the tax rate is 8.25% stored in cell F1, the formula =A2*(1+$F$104) returns the gross price including tax. By using an absolute reference to F1, you can change the tax rate in one cell and watch the entire column recalculate instantly. This is the same logic used in invoice templates, purchase orders, and point-of-sale systems running on Excel in millions of small businesses around the world today.
Commission calculations follow a similar pattern but often involve tiered percent rates. For example, sales reps might earn 5% on the first $10,000 and 8% on amounts above. A nested IF formula handles this elegantly: =IF(A2<=10000, A2*0.05, 10000*0.05 + (A2-10000)*0.08). The same logic applies to tax brackets, performance bonuses, and volume discounts in distribution agreements. Once you master the tiered IF structure, you can model almost any progressive rate schedule used in real-world finance.
For inventory and budgeting, percent of remaining is a useful metric. If column B holds budgeted amounts and column C holds actual spend, then column D can show =C2/B2 as percent utilized, while column E shows =(B2-C2)/B2 as percent remaining. Combined with conditional formatting at the 80%, 90%, and 100% thresholds, this gives project managers an instant view of which line items are nearing exhaustion before any overruns occur. It is one of the most valued tools in a project manager's spreadsheet toolkit.
Marketing teams use percentages to track conversion rates, click-through rates, and bounce rates from web analytics exports. If column A holds page views and column B holds conversions, then =B2/A2 formatted as percent gives the conversion rate per page. Sorting by this column reveals top-performing pages and underperformers in seconds. Combined with percentile functions, you can flag the bottom 10% of pages for optimization, which is exactly the workflow used by SEO and CRO professionals worldwide today.
Finally, HR teams calculate compensation adjustments using percent raises and bonuses. If column A holds current salaries and column B holds raise percentages, then =A2*(1+B2) returns the new salary. Total payroll impact is =SUM(A2*B2 down the column), giving leadership the dollar cost of a planned compensation cycle in one number. These workflows replace what used to require dedicated software, and they run on any laptop with a basic Excel license available almost anywhere in the world.

The single most common mistake is using the new value as the denominator in percent change formulas. Always divide by the original or older value, not the new one. =(New-Old)/Old is correct, while =(New-Old)/New is wrong and will produce misleading growth figures that have caused real-world reporting scandals and budget miscalculations in major organizations.
Speed matters when you are working with percentages all day, so memorizing a few keyboard shortcuts will dramatically improve your productivity. Ctrl+Shift+% applies the percent format instantly to any selected cell or range, replacing the slower path through Format Cells dialog. Ctrl+1 opens the Format Cells dialog directly, where you can fine-tune decimal places, use a thousands separator, or switch to scientific notation if needed. Ctrl+D fills down a formula from the cell above, which is perfect for copying percent formulas across hundreds of rows in seconds without touching the mouse at all.
The F4 key is another time-saver because it toggles absolute and relative references in your formulas. After typing a cell reference like B2, press F4 to cycle through $B$2, B$2, $B2, and back to B2. This is essential when building percent-of-total formulas where the total cell or range must stay locked while the part cell moves with each row. Without F4, you would have to type dollar signs manually every time, which slows you down and increases the chance of typos and broken formula references throughout your worksheet.
For repeated percent calculations across many sheets, consider naming your key cells using the Name Box. If your tax rate lives in one cell, name it TaxRate using the Name Box in the upper left corner. Now you can write formulas like =Price*(1+TaxRate) instead of =Price*(1+$F$104), which is far more readable and self-documenting. Anyone opening your spreadsheet can understand the logic immediately without hunting for what F1 contains, which is a huge benefit when handing off work to colleagues or auditors.
Conditional formatting takes percent calculations from numbers to insights. Highlight a column of percent change values, then apply a color scale that goes from red for negative values through white at zero to green for positive values. This visual treatment turns a spreadsheet into a dashboard instantly, with no charts required. You can also use data bars to show relative magnitude within each cell, which works beautifully for percent of total columns where you want viewers to compare share sizes at a glance.
Pivot tables handle percent calculations through the Show Values As feature. After dragging a numeric field into the Values area, right-click and choose Show Values As, then pick % of Grand Total, % of Column Total, % of Row Total, or % of Parent Total. Each option transforms the raw numbers into percentages with one click, eliminating the need for manual formulas in many reporting scenarios. This feature alone justifies learning pivot tables for anyone who regularly produces percent breakdowns from large datasets across departments or time periods.
Finally, learn to use the QUOTIENT and MOD functions for cases where percentages do not fit cleanly. QUOTIENT returns the integer portion of a division, while MOD returns the remainder. Together they let you build custom percent logic for scenarios like progress bars, completion tracking, and discrete percent buckets. These are advanced techniques but invaluable in dashboards where you need rounded percent groupings or step-function percent thresholds rather than continuous decimal output throughout your reporting framework today.
One final shortcut: install a custom keyboard layout or use AutoCorrect to expand common percent formulas. Type pct in any cell and have AutoCorrect replace it with =/, ready for you to fill in the part and total. Tiny tricks like this compound into hours saved every month, which is why power users obsess over them. Combined with the formulas covered earlier in this guide, you will be calculating percentages faster than colleagues who still reach for a calculator beside their keyboard whenever a percent question comes up.
For a deeper look at this topic, see our guide to excel calculate percentage.
For a deeper look at this topic, see our guide to excel calculate percentage.
Readers who want more detail usually continue with excel calculate percentage.
To cement everything covered in this guide, start with a small practice spreadsheet of your own. Create a list of ten products with prices, then add columns for tax, discount, final price, and percent of total revenue. Try each formula manually rather than copying from this article โ typing each one builds muscle memory in a way that reading never does. Within a few minutes you will have a working pricing model that demonstrates every concept from this guide in one compact and reusable workbook ready for daily use.
Next, extend your practice with a real dataset from your work or studies. Export a CSV from any system you use โ a bank statement, sales report, fitness tracker, or sports stats page โ and load it into Excel. Pick three to five percentage questions to answer using the data, such as percent of total spending by category or percent change month over month. Real data forces you to handle messy inputs, blank cells, and edge cases that artificial examples never quite capture for true learning across realistic scenarios.
Build a habit of always formatting result cells as percent immediately after writing a percent formula. This small discipline prevents the common confusion between displayed and stored values, and it makes your spreadsheets self-documenting to anyone who opens them later. Pair this with consistent decimal precision โ usually one or two places for business reports โ and your output will look polished and professional without any extra effort during your final review process before sharing with stakeholders or saving as a finished report.
When formulas fail, debug systematically rather than randomly. Click into the cell, press F2 to enter edit mode, and observe how Excel highlights each referenced range in different colors. Use the Evaluate Formula tool under the Formulas ribbon to step through complex calculations one operation at a time. These tools turn debugging from frustration into a structured process, and they will save you hours every month once you incorporate them into your normal workflow as part of your professional spreadsheet toolkit going forward.
Take advantage of online quizzes to test yourself regularly. The PTG quiz links throughout this article cover basic and advanced Excel topics including percent formulas, functions, and overall spreadsheet fluency. Spending ten minutes a day on practice questions reinforces concepts and surfaces blind spots you might not realize you have. Many users find that quiz practice is more efficient than re-reading articles, because active recall locks knowledge in place far more effectively than passive reading does for long-term retention and confident application.
If you work with percentages constantly, consider building a personal cheat sheet of your most-used formulas with examples and edge cases noted. Store it in OneDrive or Google Drive so you can access it from any device. Update it when you discover new techniques or trip over new bugs. Within a year, this cheat sheet becomes a personalized reference that beats any book or website because it reflects exactly the problems you face daily and the solutions you have personally verified through real work tasks completed.
Finally, share what you learn with colleagues. Teaching is the fastest way to deepen your own understanding, and most teams have at least one person who struggles with percent calculations and would benefit from a quick five-minute walkthrough. By becoming the Excel percent expert on your team, you build a reputation for analytical competence that opens doors to better projects, higher visibility, and ultimately better career outcomes in any field that relies on spreadsheets, which today means virtually every white-collar role in modern business everywhere.
Sample Excel Practice Questions
Try these questions from our free Excel practice tests. The correct answer and an explanation follow each question.
What hidden Easter egg game could be found in Excel 97?
- A. A flight simulator
- B. A pinball game
- C. A maze game
- D. A card game
Answer: A. A flight simulator
Excel 97 contained a hidden flight simulator Easter egg that could be accessed through a specific sequence of steps involving the chart wizard and a particular cell reference.
What is a sparkline in Excel?
- A. A type of conditional formatting
- B. A tiny chart within a single cell showing data trends
- C. An animated chart effect
- D. A chart template
Answer: B. A tiny chart within a single cell showing data trends
Sparklines are miniature charts that fit inside a single cell.
What does Excel's "Custom" number format mean?
- A. A number format that you create to fit your specific needs
- B. A number format that only displays negative numbers
- C. A number format that is automatically applied to every cell in a worksheet
- D. A number format that rounds numbers up or down
Answer: A. A number format that you create to fit your specific needs
Excel's 'Custom' number format allows users to define their own specific rules for how numbers, dates, and text are displayed in cells. This provides a high degree of flexibility, enabling you to create unique display formats that are not available in the standard options. You can use special codes to control decimal places, currency symbols, text placement, and more.
Which of the following formulas will add B2's value to C3's value?
- A. =B2+C3
- B. =6+4
- C. =C3+B3
- D. =B+C
Answer: A. =B2+C3
To perform an addition in Excel, you start with an equals sign (=) followed by the cell references you want to add, separated by a plus sign (+). Therefore, '=B2+C3' correctly instructs Excel to take the value from cell B2 and add it to the value from cell C3.
Take the full Excel practice test
Excel Questions and Answers
Written and edited by Nathan Beja, founder of Practice Test Geeks, with AI assistance. Exam facts are checked against the official sources linked below. Editorial policy
Sources & references
Exam facts on this page (fees, format, dates, passing scores) are checked against these official sources; the date is our last check. Editorial policy
- store.certiport.com โ Fees, retake fee ยท verified Nov 2026
- certiport.pearsonvue.com โ Renewal, score validity, score release, exam format ยท verified Nov 2026
- learn.microsoft.com โ Test delivery, time limit, eligibility ยท verified Nov 2026




