Formatting Cells

Reviewed by Editorial Team
The ProProfs editorial team is comprised of experienced subject matter experts. They've collectively created over 10,000 quizzes and lessons, serving over 100 million users. Our team includes in-house content moderators and subject matter experts, as well as a global network of rigorously trained contributors. All adhere to our comprehensive editorial guidelines, ensuring the delivery of high-quality content.
Learn about Our Editorial Process
| By Nsurani
N
Nsurani
Community Contributor
Quizzes Created: 14 | Total Attempts: 15,686
| Attempts: 495
SettingsSettings
Please wait...
  • 1/10 Questions

    We can lock the cell.

    • True
    • False
Please wait...
About This Quiz

This quiz titled 'Formatting Cells' assesses knowledge on Excel functionalities such as cell styling, comments, freezing panes, format painter, and handling of merged cells. It is designed to test and enhance practical skills in managing and formatting data effectively in Excel.

Excel Quizzes & Trivia

Quiz Preview

  • 2. 

    we can format the cell by cell style option which is located in Style group.

    • True

    • False

    Correct Answer
    A. True
    Explanation
    The statement is true because the cell style option in the Style group allows us to format cells individually. This means we can customize the font, color, borders, and other formatting elements for each cell separately, giving us more control over the appearance of our spreadsheet.

    Rate this question:

  • 3. 

    How can we give the color to the cell ?

    • Fill color

    • Text color

    • Word Art

    Correct Answer
    A. Fill color
    Explanation
    We can give color to a cell by using the "Fill color" option. This option allows us to select a specific color and apply it to the background of the cell. By choosing a fill color, we can change the appearance of the cell and make it more visually appealing or highlight important information.

    Rate this question:

  • 4. 

    The format Cell Number can has an option to show negative numbers in _______.

    • Green

    • Blue

    • Red

    • Quotes

    Correct Answer
    A. Red
    Explanation
    The format Cell Number can have an option to show negative numbers in red.

    Rate this question:

  • 5. 

    What is the name of that option which merge the cells ?

    • Cell Merge

    • Merge and Center

    • Center merge

    Correct Answer
    A. Merge and Center
    Explanation
    Merge and Center is the correct answer because it is the option that allows users to merge multiple cells into one cell. This option is commonly used in spreadsheet software like Microsoft Excel to combine the content of multiple cells into a single cell, making it easier to format and organize data.

    Rate this question:

  • 6. 

    What term describes explanatory text attached to a cell

    • Callout

    • Comment

    • Dialog

    • Extension

    Correct Answer
    A. Comment
    Explanation
    A comment is explanatory text attached to a cell in a spreadsheet or document. It is used to provide additional information or clarification about the content of the cell. Comments are often used to explain calculations, provide context, or add notes for collaborators. They can be visible to others who have access to the document and can help improve understanding and collaboration.

    Rate this question:

  • 7. 

    After you merge a range into a single cell, you can't realign its content.

    • True

    • False

    Correct Answer
    A. False
    Explanation
    When you merge a range into a single cell, you can still realign its content. This means that you can adjust the alignment of the text within the merged cell, such as aligning it to the left, center, or right of the cell. Therefore, the statement is false.

    Rate this question:

  • 8. 

    Which Excel 2007 feature can be used to keep user selected rows or columns visible at all times when scrolling around the sheet?

    • Headers

    • Filter

    • Freeze Panes

    • Data Validation

    Correct Answer
    A. Freeze Panes
    Explanation
    Freeze Panes is an Excel 2007 feature that allows users to keep selected rows or columns visible at all times while scrolling through the sheet. This feature is helpful when working with large datasets or when comparing data across different sections of the sheet. By freezing panes, users can easily reference important information without losing sight of it as they navigate through the spreadsheet.

    Rate this question:

  • 9. 

    To format a cell like an already formatted one you can use ------------------------------- .

    • The Fill down command

    • The Autosum command

    • The Format Painter command

    • None of the above.

    Correct Answer
    A. The Format Painter command
    Explanation
    The Format Painter command allows you to copy the formatting from one cell and apply it to another cell or range of cells. This is useful when you want to quickly format multiple cells in the same way as a previously formatted cell. By selecting the cell with the desired formatting and using the Format Painter command, you can easily apply the same formatting to other cells without manually adjusting each individual format option.

    Rate this question:

  • 10. 

    Which option of Home Tab is use for format the cell in Style Group ?

    • Conditional Formatting

    • Format as Table

    • Cell Style

    Correct Answer
    A. Cell Style
    Explanation
    The option "Cell Style" in the Home Tab's Style Group is used to format the cell. It provides various pre-defined styles that can be applied to cells, such as headings, titles, and data styles. This option allows users to quickly format cells with a consistent style throughout the worksheet.

    Rate this question:

Quiz Review Timeline (Updated): Mar 22, 2023 +

Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.

  • Current Version
  • Mar 22, 2023
    Quiz Edited by
    ProProfs Editorial Team
  • Apr 08, 2011
    Quiz Created by
    Nsurani
Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.