Spreadsheets Formatting Cells Quiz #4

2.

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

True
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.

Left
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

Left
Right

Correct Answer

A. 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.

True
False

Correct Answer

A. 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.

True
False

Correct Answer

A. 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?

Condense Information
Save Space
Add Emphasis
All of the Above

Correct Answer

A. 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.

Merge & Center
Center
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 _________________.

Shading
Border
All of the Above

Correct Answer

A. 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.

True
False

Correct Answer

A. 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?

Number, Alignment, Font, Border, Fill and Protection
Border Style, Center, Times New Roman, Color
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 Pencil
A Paintbrush
An Eraser

Correct Answer

A. 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:

Spreadsheets Formatting Cells Quiz #4

In what command tab can formatting commands be found?

Quiz Preview

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

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

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

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

Information in cells can be rotated up to 95 degrees.

Why would you want to angle your information?

To create one large cell using multiple cells is called.

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

You are only able to draw borders.

The format dialog box contains which tabs?

What does the format painter icon look like?