Spreadsheets Formatting Cells Quiz #4

Approved & Edited by ProProfs Editorial Team
The editorial team at ProProfs Quizzes consists of a select group of subject experts, trivia writers, and quiz masters who have authored over 10,000 quizzes taken by more than 100 million users. This team includes our in-house seasoned quiz moderators and subject matter experts. Our editorial experts, spread across the world, are rigorously trained using our comprehensive guidelines to ensure that you receive the highest quality quizzes.
Learn about Our Editorial Process
| By Havroncl21
H
Havroncl21
Community Contributor
Quizzes Created: 9 | Total Attempts: 3,907
Questions: 12 | Attempts: 167

SettingsSettingsSettings
Spreadsheets Formatting Cells Quiz #4 - Quiz

Spreadsheets Formatting Cells Quiz #4 from Atomic Learning


Questions and Answers
  • 1. 

    In what command tab can formatting commands be found?

    • A.

      Insert

    • B.

      Data

    • C.

      Home

    • D.

      Formula

    Correct Answer
    C. Home
    Explanation
    Formatting commands can be found in the Home command tab. This tab is typically located at the top of the interface in various software applications, including Microsoft Office programs like Word, Excel, and PowerPoint. The Home tab provides users with a wide range of formatting options, such as font styles, font sizes, text alignment, and various other formatting tools to customize the appearance of the document or spreadsheet.

    Rate this question:

  • 2. 

    Formatting allows you to change the apperance of the information in your spreadsheet.

    • A.

      True

    • B.

      False

    Correct Answer
    A. True
    Explanation
    Formatting in a spreadsheet allows users to modify the appearance of the data, such as changing font styles, applying colors, adjusting cell borders, and adding conditional formatting. This helps to enhance the visual presentation of the information and make it easier to read and interpret. By customizing the appearance of the spreadsheet, users can highlight important data, organize information, and improve overall clarity and understanding. Therefore, the statement that formatting allows you to change the appearance of the information in a spreadsheet is true.

    Rate this question:

  • 3. 

    Text is aligned, by defult, to the ______ when entered into a spreadsheet.

    • A.

      Left

    • B.

      Right

    Correct Answer
    A. Left
    Explanation
    When text is entered into a spreadsheet, it is aligned to the left by default. This means that the text starts at the left side of the cell and extends towards the right. This alignment is commonly used for text-based data such as names, descriptions, or labels. It allows for easy reading and scanning of the information in the spreadsheet.

    Rate this question:

  • 4. 

    Numbers are aligned, by defult, to the ______ when entered into a spreadsheet

    • A.

      Left

    • B.

      Right

    Correct Answer
    B. Right
    Explanation
    Numbers are aligned to the right when entered into a spreadsheet by default. This is because the right alignment allows for easier reading and comparison of numerical values. It also ensures that decimal points are properly aligned, making it easier to perform calculations and analyze the data.

    Rate this question:

  • 5. 

    You are not able to center your informtion in your cell.

    • A.

      True

    • B.

      False

    Correct Answer
    B. False
    Explanation
    The statement suggests that you are unable to center your information in your cell. The correct answer is False because it is possible to center information in a cell. There are various ways to center information in a cell, such as using the alignment options in spreadsheet software or by manually adjusting the cell's formatting settings.

    Rate this question:

  • 6. 

    Information in cells can be rotated up to 95 degrees.

    • A.

      True

    • B.

      False

    Correct Answer
    B. False
    Explanation
    The statement is false because there is no information provided that suggests that cells can be rotated up to 95 degrees. Without any supporting evidence or context, it is not possible to determine the rotation capability of cells. Therefore, the correct answer is false.

    Rate this question:

  • 7. 

    Why would you want to angle your information?

    • A.

      Condense Information

    • B.

      Save Space

    • C.

      Add Emphasis

    • D.

      All of the Above

    Correct Answer
    D. All of the Above
    Explanation
    Angling your information can serve multiple purposes. Firstly, it allows you to condense information by presenting it in a concise and streamlined manner, making it easier for the audience to comprehend. Secondly, angling your information helps in saving space, especially when you have limited room or when presenting on a smaller platform. Lastly, angling can be used to add emphasis to certain points or ideas, making them stand out and grab the attention of the audience. Therefore, all of the given options are valid reasons for wanting to angle your information.

    Rate this question:

  • 8. 

    To create one large cell using multiple cells is called.

    • A.

      Merge & Center

    • B.

      Center

    • C.

      Align

    Correct Answer
    A. Merge & Center
    Explanation
    Merge & Center is the correct answer because it refers to the action of combining multiple cells into one large cell. This feature is commonly used in spreadsheet software to improve the appearance and organization of data. By merging cells, the content from the individual cells is combined into a single cell, allowing for better alignment and formatting options.

    Rate this question:

  • 9. 

    To add emphasis to a cell or cells you could add a _________________.

    • A.

      Shading

    • B.

      Border

    • C.

      All of the Above

    Correct Answer
    C. All of the Above
    Explanation
    To add emphasis to a cell or cells, you have the option to add shading, border, or both. Shading can be used to fill the cell with a different color, making it stand out from the rest. Borders can be added to outline the cell or create a border around it, drawing attention to the cell. By selecting "All of the Above," it implies that both shading and border can be used to add emphasis to a cell or cells.

    Rate this question:

  • 10. 

    You are only able to draw borders.

    • A.

      True

    • B.

      False

    Correct Answer
    B. False
    Explanation
    The statement suggests that the only thing you can do is draw borders. If this statement is true, it means that you have no other capability besides drawing borders. However, if the statement is false, it implies that you have other abilities or options besides just drawing borders.

    Rate this question:

  • 11. 

    The format dialog box contains which tabs?

    • A.

      Number, Alignment, Font, Border, Fill and Protection

    • B.

      Border Style, Center, Times New Roman, Color

    • C.

      Home, View, Insert, Data

    Correct Answer
    A. Number, Alignment, Font, Border, Fill and Protection
    Explanation
    The format dialog box contains tabs for Number, Alignment, Font, Border, Fill, and Protection. These tabs allow users to customize the formatting of the selected text or cells in a spreadsheet. The Number tab allows users to format the appearance of numbers, such as changing the number of decimal places or applying a currency symbol. The Alignment tab controls the alignment and orientation of text within cells. The Font tab allows users to change the font, size, and style of the selected text. The Border tab is used to add borders around cells or selected ranges. The Fill tab allows users to apply colors or patterns to cells. The Protection tab is used to lock or protect cells to prevent editing.

    Rate this question:

  • 12. 

    What does the format painter icon look like?

    • A.

      A Pencil

    • B.

      A Paintbrush

    • C.

      An Eraser

    Correct Answer
    B. A Paintbrush
    Explanation
    The format painter icon is represented by a paintbrush. This is a common symbol used in various software programs to indicate the ability to copy formatting from one object or text to another. The paintbrush represents the action of applying the formatting, similar to how a painter applies paint to a canvas.

    Rate this question:

Quiz Review Timeline +

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

  • Current Version
  • Mar 21, 2023
    Quiz Edited by
    ProProfs Editorial Team
  • Jan 07, 2013
    Quiz Created by
    Havroncl21
Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.