How to Use Formulas & Functions in Excel


Choose an answer and hit 'next'. You will receive your score and answers at the end.

question 1 of 3

There are 4 major elements of a formula. Characters, Operators and Cell References are three of them. What is the fourth element of a formula?

Create Your Account To Take This Quiz

As a member, you'll also get unlimited access to over 79,000 lessons in math, English, science, history, and more. Plus, get practice tests, quizzes, and personalized coaching to help you succeed.

Try it risk-free
Try it risk-free for 30 days. Cancel anytime
Already registered? Log in here for access

1. The plus symbol (+) and the equal sign (=) are considered what part of a formula?

2. Which of the following is an example of a Cell Reference?

Create your account to access this entire worksheet
A Premium account gives you access to all lesson, practice exams, quizzes & worksheets
Access to all video lessons
Quizzes, practice exams & worksheets
Certificate of Completion
Access to instructors
Create an account to get started Create Account

About This Quiz & Worksheet

This quiz and worksheet will heighten your comprehension of the formulas and functions that are used in Excel. The quiz will also assess your understanding of concepts like the elements of a formula and cell references.

Quiz & Worksheet Goals

Use these assessment tools to test your knowledge of:

  • The language or set of rules that a formula follows
  • Cell references
  • The parts of a formula in given examples

Skills Practiced

This worksheet and quiz let you practice the following skills:

  • Making connections - use understanding of how a formula is structured using a particular set of rules
  • Critical thinking - apply relevant concepts to examine information about saving time and increasing data accuracy in a different light
  • Interpreting information - verify that you can read information regarding Excel formulas and interpret it correctly

Additional Learning

To learn more about how to use formulas and functions in Excel, review the lesson called How to Use Formulas & Functions in Excel. The material covers the following objectives:

  • Understand the benefits of using a formula
  • Define formula
  • Identify the Function Library grouping of commands