Module 2 Excel Definitions

Question 1

Accounting format

Answer 1

The number format that places a currency symbol at the left edge of the column, adds a thousands separator to the value, shows two decimal places, lines up numbers within a column by their currency symbols and decimal points, displays negative numbers within parentheses, and displays zero

Question 2

automatic page break

Answer 2

A page break Excel sets when the page of the printout is full.

Question 3

AVERAGE function

Answer 3

An Excel function that calculates the average value from a collection or numbers.

Question 4

cell style

Answer 4

Predefined formatting options that you can apply to cells in a workbook.

Question 5

Comma style

Answer 5

The number format that adds a thousands separator to numbers, adds two decimal places, and lines up values within a column by their decimal points.

Question 6

conditional formatting

Answer 6

Formatting that is applied to a cell when its value meets a specified condition.

Question 7

Currency format

Answer 7

The number format that places a currency symbol directly to the left of the first digit of the currency value, adds a thousands separator to the value, shows two decimal places, lines up numbers within a column by their decimal points, and displays negative numbers with a negative sign.

Question 8

fill color

Answer 8

A background color that can be added to cells to help differentiate parts of a worksheet or highlight data.

Question 9

font

Answer 9

A set of characters that employ the same typeface, such as Arial, Times New Roman, and Courier.

Question 10

font style

Answer 10

Formats that can applied to a font such as italic, bold, bold italic, underline, strikethrough, and color.

Question 11

footer

Answer 11

Information that appears at the bottom of each printed page

Question 12

Format Painter

Answer 12

A feature that copies and pastes formatting from one cell or range to another without duplicating any data.

Question 13

header

Answer 13

Information that appears at the top of each printed page.

Question 14

legend

Answer 14

A key that identifies the colors or the shapes used in a worksheet or a chart.

Question 15

Live Preview

Answer 15

A showing of how a workbook would be affected by an option in a gallery.

Question 16

Long Date format

Answer 16

A format for dates that displays the day of the week and the full month in addition to the day of the month and the year.

Question 17

manual page break

Answer 17

A page break you set to indicate where a new page of the printout should start.

Question 18

margin

Answer 18

The space between the page content and the edges of the page.

Question 19

merge

Answer 19

To combine, such as several cells into one cell.

Question 20

Mini toolbar

Answer 20

A toolbar that contains buttons to perform common formatting options for a selection.

Question 21

Percent style

Answer 21

The number format for percentages that adds the % symbol after the number and no decimal places.

Question 22

print area

Answer 22

The range or ranges in a worksheet that you specify to be printed.

Question 23

print title

Answer 23

Information that is included on every page of the printout; specified as rows or columns to repeat on the top or left of each page.

Question 24

Quick Analysis tool

Answer 24

A button that appears whenever you select a range of cells, providing access to the most common tools for data analysis and formatting for the selected range.

Question 25

Short Date format

Answer 25

An abbreviated format for dates in the format mm/dd/yyyy.

Question 26

standard color

Answer 26

One of 10 colors—dark red, red, orange, yellow, light green, green, light blue, blue, dark blue, and purple—that is always available regardless of the workbook’s theme.

Question 27

style

Answer 27

A collection of formatting options that include a specified font, font size, font styles, font color, fill color, and borders.

Question 28

theme

Answer 28

A collection of formatting for text, colors, images, and graphical effects that are applied throughout a workbook to create a specific look and feel.

Question 29

theme color

Answer 29

One of 12 colors that belong to the workbook’s theme

Question 30

theme font

Answer 30

A font associated with a particular theme and used for headings and body text in the workbook; theme fonts change automatically when the theme is changed.