Nothing Special   »   [go: up one dir, main page]
Scribd Logo
Upload

Welcome to Scribd!

  • 74 views

    Information Sheet Number Group Commands

    Uploaded by

    racquel jimenez
    This document provides information about number formatting in Excel. It includes an activity sheet for a student to learn about the Number Group commands, which allow setting formats like percent, comma, and decimal places. It also discusses applying number formats to make spreadsheets easier to read and ensure formulas calculate correctly. Common number formats covered are currency, percentage, and date formats. The activity sheet asks the student to complete a table about number formatting commands and identify statements about their functions.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd

    Information Sheet Number Group Commands

    Uploaded by

    racquel jimenez
    74 views5 pages
    This document provides information about number formatting in Excel. It includes an activity sheet for a student to learn about the Number Group commands, which allow setting formats like percent, comma, and decimal places. It also discusses applying number formats to make spreadsheets easier to read and ensure formulas calculate correctly. Common number formats covered are currency, percentage, and date formats. The activity sheet asks the student to complete a table about number formatting commands and identify statements about their functions.

    Original Description:

    Original Title

    -ICF-9_actvity sheet

    Copyright

    © © All Rights Reserved

    Available Formats

    DOCX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    This document provides information about number formatting in Excel. It includes an activity sheet for a student to learn about the Number Group commands, which allow setting formats like percent, comma, and decimal places. It also discusses applying number formats to make spreadsheets easier to read and ensure formulas calculate correctly. Common number formats covered are currency, percentage, and date formats. The activity sheet asks the student to complete a table about number formatting commands and identify statements about their functions.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    74 views5 pages

    Information Sheet Number Group Commands

    Uploaded by

    racquel jimenez
    This document provides information about number formatting in Excel. It includes an activity sheet for a student to learn about the Number Group commands, which allow setting formats like percent, comma, and decimal places. It also discusses applying number formats to make spreadsheets easier to read and ensure formulas calculate correctly. Common number formats covered are currency, percentage, and date formats. The activity sheet asks the student to complete a table about number formatting commands and identify statements about their functions.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    of 5

    Learning Activity Sheet

    Name of Student: ______________________________________


    Learning Area: ICF 9
    Date: ______________________________

    INFORMATION SHEET
    Number Group Commands
    The commands in the Number Group allow you to set the format, percent, comma,
    style and decimal places.

    Number
    Group

    NUMBER GROUP COMMANDS


    Icon Name Function
    Number Format Shows a list of format
    options

    Accounting Number Format Places currency and other


    number formats

    Percent Style Changes the number to


    percentage.

    Comma Style Adds comma separator to


    numbers

    Increase Decimal Increases the decimal


    number.
    Decrease Decimal Decreases the decimal
    numbers.

    Formatting text and numbers

    One of the most powerful tools in Excel is the ability to apply specific formatting for
    text and numbers. Instead of displaying all cell content in exactly the same way, you can use
    formatting to change the appearance of dates, times, decimals, percentages
    (%), currency ($), and much more.

    Why use number formats?

    Number formats don't just make your spreadsheet easier to read—they also make it
    easier to use. When you apply a number format, you're telling your spreadsheet exactly what
    types of values are stored in a cell. For example, the date format tells the spreadsheet that
    you're entering specific calendar dates. This allows the spreadsheet to better understand
    your data, which can help ensure that your data remains consistent and that your formulas are
    calculated correctly.

    Applying number formats


     Go to the Home tab, click the Number Format drop-down menu in
    the Number group, and select the desired format.

    In this example, we've applied the Currency number format, which adds currency


    symbols ($) and displays two decimal places for any numerical values.
    Percentage Formats

    One of the most helpful number formats is the percentage (%) format. It displays


    values as percentages, such as 20% or 55%. This is especially helpful when calculating
    things like the cost of sales tax or a tip. When you type a percent sign (%) after a number, the
    percentage number format will be be applied to that cell automatically.

    Date formats

    Whenever you're working with dates, you'll want to use a date format to tell the
    spreadsheet that you're referring to specific calendar dates, such as July 15, 2014. Date
    formats also allow you to work with a powerful set of date functions that use time and date
    information to calculate an answer.

    Spreadsheets don't understand information the same way a person would. For instance, if you
    type October into a cell, the spreadsheet won't know you're entering a date so it will treat it
    like any other text. Instead, when you enter a date, you'll need to use a specific format your
    spreadsheet understands, such as month/day/year (or day/month/year depending on which
    country you're in)
    This activity sheet is designed for students to learn and identify on how to customize
    basic setting and format worksheets.

    ACTIVITY 1: COMPLETE ME!

    Direction: Complete the given table below.

    NUMBER GROUP COMMANDS


    Icon Name Function

    1. 2.

    Accounting Number Format


    3.

    4. 5.

    Comma Style Adds comma separator to


    6. numbers
    7. 8.

    Decreases the decimal


    9. numbers.
    10.

    ACTIVITY 2: IDENTIFY ME!

    Direction: Identify the following statement.


    ______________1. allow you to set the format, percent, comma, style and decimal places.
    ______________2. adds currency symbols ($) and displays two decimal places for any
    numerical values.
    ______________3. It displays values as percentages.
    ______________4. Adds comma separator to numbers
    ______________5. Increases the decimal number.

    You might also like