Spreadsheets Formatting Cells Quiz #4

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: