What formula should be entered in cell a3 to display the results as shown below?

Assess Your Knowledge on Excel Functions and Formulas

This Excel Test is designed to help you assess your knowledge of basic Excel functions and formulas. We strongly encourage any students who are planning or are beginning their FMVA certification program to take this test to determine whether you will need to take the prerequisite Excel Crash Course and Excel Modeling Fundamentals Course. This is also a useful resource for employers to examine the technical Excel knowledge of the candidates during a finance interview or for applicants who want an Excel practice test.

If you pass this test with 80% or above (16 questions or more), it is likely that you have pretty solid fundamental knowledge of Excel!

What formula should be entered in cell a3 to display the results as shown below?

Excel Test Questions

(Note: Questions on Excel shortcut keys are only applicable to PC users)

More about CFI

Thank you for visiting CFI’s Practice Test Center and taking the Excel test.

CFI is the official global provider of the Financial Modeling and Valuation Analyst (FMVA)™ certification program, designed to transform anyone into a world-class financial analyst. Enroll now to gain the skills you need to take your career to the next level. Also, see all our Excel resources.

10 Questions | Total Attempts: 4958

  • How do you spell check an Excel worksheet?

    • Under the Tools menu, click Spelling.

    • Click the button with ABC Check Mark icon.

    • Any of the above will perform a spell check.

  • What is the keyboard shortcut key to lock cell references in a formula?

  • What are the shortcut keys for AutoSum?

  •  What are the shortcut keys to insert a new row in an Excel spreadsheet?

  • What are the shortcut keys to group rows so you can expand/contract a section of data?

  • What formula should be entered in cell A3 to display the results as shown below?

    • ="Income Statement "&"A1"

  • What are the keyboard shortcut keys to paste special?

  • What are the keyboard shortcut keys to edit the formula in a cell?

  • Which of the following features cannot be found in the Data ribbon?

  • What are the shortcut keys to open up the Find and Replace window?

  • Word
  • Computer Software
  • Word Processor
  • Computer