Formatting Cells

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 Nsurani

Nsurani

Community Contributor

Quizzes Created: 14 | Total Attempts: 15,263

Questions: 10 | Attempts: 494 | Updated: Mar 22, 2023

Questions

Settings

Feedback

During the Quiz End of Quiz

Difficulty

Sequential Easy First Hard First

Play as

Quiz Flashcard

Create your own Quiz

Share on Facebook Share on Twitter Share on Whatsapp Share on Pinterest Share on Email Copy to Clipboard Embed on your website

Questions and Answers

1.

Which option of Home Tab is use for format the cell in Style Group ?
- A.
  
  Conditional Formatting
- B.
  
  Format as Table
- C.
  
  Cell Style
Correct Answer
C. 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:
2.

What term describes explanatory text attached to a cell
- A.
  
  Callout
- B.
  
  Comment
- C.
  
  Dialog
- D.
  
  Extension
Correct Answer
B. 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:
3.

Which Excel 2007 feature can be used to keep user selected rows or columns visible at all times when scrolling around the sheet?
- A.
  
  Headers
- B.
  
  Filter
- C.
  
  Freeze Panes
- D.
  
  Data Validation
Correct Answer
C. 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:
4.

To format a cell like an already formatted one you can use ------------------------------- .
- A.
  
  The Fill down command
- B.
  
  The Autosum command
- C.
  
  The Format Painter command
- D.
  
  None of the above.
Correct Answer
C. 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:
5.

After you merge a range into a single cell, you can't realign its content.
- A.
  
  True
- B.
  
  False
Correct Answer
B. 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:
6.

The format Cell Number can has an option to show negative numbers in _______.
- A.
  
  Green
- B.
  
  Blue
- C.
  
  Red
- D.
  
  Quotes
Correct Answer
C. Red

Explanation
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.
- A.
  
  True
- B.
  
  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:
8.

We can lock the cell.
- A.
  
  True
- B.
  
  False
Correct Answer
A. True

Explanation
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 ?
- A.
  
  Fill color
- B.
  
  Text color
- C.
  
  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:
10.

What is the name of that option which merge the cells ?
- A.
  
  Cell Merge
- B.
  
  Merge and Center
- C.
  
  Center merge
Correct Answer
B. 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:

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 22, 2023

Quiz Edited by
ProProfs Editorial Team
Apr 08, 2011

Quiz Created by
Nsurani

Formatting Cells

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

What term describes explanatory text attached to a cell

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

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

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

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

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

We can lock the cell.

How can we give the color to the cell ?

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