The Number Format in Excel: Options & Properties


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

question 1 of 3

What will precede the number if your format a number using the Currency option?

Create Your Account To Take This Quiz

As a member, you'll also get unlimited access to over 75,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. Where is the ribbon menu will you click on first to access the Format Cells command?

2. In the Format Cells dialogue box, what are the formatting options called?

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 lesson will help you learn how to format cells in Excel so as to make the numbers logical, consistent, and straightforward, and this quiz/worksheet combo will help you test your new knowledge on this topic. The questions on the quiz will test you on currency format, date formats, and the elements of the Number category.

Quiz & Worksheet Goals

In these assessments, you'll be tested on:

  • Currency formatting
  • Date formatting
  • The relevant menus used in formatting cells in Excel
  • Three elements of the Number category

Skills Practiced

This quiz and worksheet will allow you to test your skills in the following areas:

  • Reading comprehension - ensure that you draw and retain the most important information on number formatting in Excel from the related lesson
  • Information recall - access the knowledge you've gained regarding date and currency formatting in Excel
  • Knowledge application - use your knowledge to answer questions about number formatting in Excel

Additional Learning

To learn more about this topic, review the accompanying lesson, The Number Format in Excel: Options & Properties. This lesson covers the following objectives:

  • Discuss the purpose of number formatting in Excel
  • Describe the menus used in number formatting
  • Differentiate between the three elements in Number formats
  • Review the steps for adding decimal places to numbers in Excel