Formatting Cells
-
Which option of Home Tab is use for format the cell in Style Group ?
-
Conditional Formatting
-
Format as Table
-
Cell Style
-
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.
Quiz Preview
- 2.
What term describes explanatory text attached to a cell
-
Callout
-
Comment
-
Dialog
-
Extension
Correct Answer
A. CommentExplanation
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:
-
- 3.
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 PanesExplanation
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:
-
- 4.
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 commandExplanation
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:
-
- 5.
After you merge a range into a single cell, you can't realign its content.
-
True
-
False
Correct Answer
A. FalseExplanation
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:
-
- 6.
The format Cell Number can has an option to show negative numbers in _______.
-
Green
-
Blue
-
Red
-
Quotes
Correct Answer
A. RedExplanation
The format Cell Number can have an option to show negative numbers in red.Rate this question:
-
- 7.
we can format the cell by cell style option which is located in Style group.
-
True
-
False
Correct Answer
A. TrueExplanation
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:
-
- 8.
We can lock the cell.
-
True
-
False
Correct Answer
A. TrueExplanation
The given statement suggests that it is possible to lock the cell. Since there is no additional context or information provided, we can assume that the statement is true. Locking a cell can refer to various actions such as protecting the cell from being edited or securing the physical cell with a lock.Rate this question:
-
- 9.
How can we give the color to the cell ?
-
Fill color
-
Text color
-
Word Art
Correct Answer
A. Fill colorExplanation
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:
-
- 10.
What is the name of that option which merge the cells ?
-
Cell Merge
-
Merge and Center
-
Center merge
Correct Answer
A. Merge and CenterExplanation
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:
-
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, 2023Quiz Edited by
ProProfs Editorial Team -
Apr 08, 2011Quiz Created by
Nsurani
Back to top