A Styles dialog box includes what?

Number, Alignment, Font, Border, Fill and Protection

Page Laout, Font, fill, Protection and Alignment

Number, Page Orientation, Font, Fill and Alignment

Spreadsheet Styles, Themes And Tables Quiz #6

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

Havroncl21

Community Contributor

Quizzes Created: 9 | Total Attempts: 3,928

Questions: 14 | Attempts: 124 | Updated: May 1, 2024

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

Spreadsheet Styles, Themes And Tables Quiz #6 - Quiz

Spreadsheet Styles, Themes and Tables Quiz #6 from Atomic Learning

Questions and Answers

1.

In Excel 2007, cell styles are also referred to as Quick Styles.
- A.
  
  True
- B.
  
  False
Correct Answer
A. True

Explanation
In Excel 2007, cell styles are referred to as Quick Styles. This means that when applying a cell style to a cell or range of cells, it is also known as applying a Quick Style.

Rate this question:

1
0
2.

Quick styles can be found under what command tab
- A.
  
  View
- B.
  
  Formulas
- C.
  
  Insert
- D.
  
  Home
Correct Answer
D. Home

Explanation
Quick styles, which refer to predefined formatting options for text, can be found under the "Home" command tab. This tab typically contains various formatting options such as font styles, font size, alignment, and other formatting tools. Therefore, the correct answer is "Home."

Rate this question:
3.

Check all that Apply: Cell styles include:
- A.
  
  Font, font size
- B.
  
  Number
- C.
  
  Formulas
- D.
  
  Border and shading
Correct Answer(s)
A. Font, font size
B. Number
D. Border and shading

Explanation
Cell styles in a spreadsheet refer to the formatting options that can be applied to a cell or a range of cells. These formatting options include font and font size, which determine the appearance of the text in the cell. The number formatting option allows users to specify how numeric values should be displayed, such as currency or percentage. Additionally, cell styles can also include border and shading options, which allow users to add borders and background colors to cells for visual organization and emphasis.

Rate this question:
4.

_________ allows you to see what the formatting will look like before it is applied.
- A.
  
  Magnify
- B.
  
  Live Preview
- C.
  
  Page Setup
Correct Answer
B. Live Preview

Explanation
Live Preview allows you to see what the formatting will look like before it is applied. This feature provides a real-time preview of how the document or content will appear with the selected formatting options. It helps users make informed decisions about the formatting choices they want to apply, ensuring that they achieve the desired visual outcome without having to make changes and then undo them if they are not satisfied with the result.

Rate this question:
5.

You are not able to change pre-set styles.
- A.
  
  True
- B.
  
  False
Correct Answer
B. False

Explanation
The statement "You are not able to change pre-set styles" is incorrect. In most cases, pre-set styles can be changed or modified according to the user's preferences. This allows users to customize the appearance of various elements such as fonts, colors, spacing, and layout in applications or websites. Therefore, the correct answer is False.

Rate this question:
6.

Custom cells allow you to add _______________ to your spreadsheet.
- A.
  
  Formatting
- B.
  
  Formulas
- C.
  
  Orientation
- D.
  
  Page layout
Correct Answer
A. Formatting

Explanation
Custom cells allow you to add formatting to your spreadsheet. This means that you can customize the appearance of the cells, such as changing the font, applying borders, adding colors, and adjusting the alignment. Formatting helps to make the data more visually appealing and easier to read and understand.

Rate this question:
7.

A Styles dialog box includes what?
- A.
  
  Number, Alignment, Font, Border, Fill and Protection
- B.
  
  Page Laout, Font, fill, Protection and Alignment
- C.
  
  Number, Page Orientation, Font, Fill and Alignment
Correct Answer
A. Number, Alignment, Font, Border, Fill and Protection

Explanation
The Styles dialog box includes options for Number, Alignment, Font, Border, Fill, and Protection. This means that users can customize the number format, adjust the alignment of text, change the font style, add borders to cells, apply fill colors, and protect the cells from being edited or modified.

Rate this question:
8.

The themes tab can be found in which command tab?
- A.
  
  Home
- B.
  
  Insert
- C.
  
  Page Layout
- D.
  
  Formula
Correct Answer
C. Page Layout

Explanation
The correct answer is Page Layout because the themes tab allows users to apply different themes to their document, such as changing the font, color scheme, and overall design. The Page Layout tab is where users can find options to customize the layout and design of their document, making it the most logical place to find the themes tab. The Home tab is more focused on basic formatting options, the Insert tab is for adding content to the document, and the Formula tab is specifically for working with mathematical formulas.

Rate this question:
9.

You are able to change any of the theme sets included in the default themes.
- A.
  
  True
- B.
  
  False
Correct Answer
A. True

Explanation
The statement suggests that it is possible to modify the theme sets that are included in the default themes. This means that users have the ability to customize and make changes to the themes according to their preferences. Therefore, the correct answer is true.

Rate this question:
10.

You are able to format your information as a table within your spreadsheet.
- A.
  
  True
- B.
  
  False
Correct Answer
A. True

Explanation
The given correct answer is "True". This suggests that it is possible to format information as a table within a spreadsheet. This means that users can organize and present data in a structured and visually appealing manner by using table formatting features provided by spreadsheet software.

Rate this question:
11.

The tables tool tab includes what command tab?
- A.
  
  Insert
- B.
  
  Design
- C.
  
  Page Format
- D.
  
  Home
Correct Answer
B. Design

Explanation
The Design command tab is included in the Tables tool tab. This tab allows users to customize the design and formatting of tables, such as changing the table style, adjusting cell borders, and modifying the layout. It provides various options and tools specifically for working with tables, making it easier for users to create and format tables according to their needs.

Rate this question:
12.

The Format as Table button is found in the Styles area of what command tab?
- A.
  
  Home
- B.
  
  Insert
- C.
  
  Page Layout
- D.
  
  Data
Correct Answer
A. Home

Explanation
The Format as Table button is found in the Styles area of the Home command tab.

Rate this question:
13.

A preview is always visiable in the New Table Quick Style dialog box.
- A.
  
  True
- B.
  
  False
Correct Answer
A. True

Explanation
The given statement is true because in the New Table Quick Style dialog box, a preview of the table style is always visible. This allows users to see how the selected style will look before applying it to their table.

Rate this question:
14.

You are not able to delect a custom table style.
- A.
  
  True
- B.
  
  False
Correct Answer
B. False

Explanation
This statement is false. In most software applications, including Microsoft Office, you have the ability to delete a custom table style. Custom table styles are created by the user and can be modified or removed as needed.

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
May 01, 2024

Quiz Edited by
ProProfs Editorial Team
Jan 08, 2013

Quiz Created by
Havroncl21

Spreadsheet Styles, Themes And Tables Quiz #6

In Excel 2007, cell styles are also referred to as Quick Styles.

Quick styles can be found under what command tab

Check all that Apply: Cell styles include:

_________ allows you to see what the formatting will look like before it is applied.

You are not able to change pre-set styles.

Custom cells allow you to add _______________ to your spreadsheet.

A Styles dialog box includes what?

The themes tab can be found in which command tab?

You are able to change any of the theme sets included in the default themes.

You are able to format your information as a table within your spreadsheet.

The tables tool tab includes what command tab?

The Format as Table button is found in the Styles area of what command tab?

A preview is always visiable in the New Table Quick Style dialog box.

You are not able to delect a custom table style.