Module 2 Excel Definitions Flashcards

1
Q

Accounting format

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

automatic page break

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

AVERAGE function

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

cell style

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

Comma style

A

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.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

conditional formatting

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

Currency format

A

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.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

fill color

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

font

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

font style

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

footer

A

Information that appears at the bottom of each printed page

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

Format Painter

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

header

A

Information that appears at the top of each printed page.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

legend

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

Live Preview

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

Long Date format

A

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.

17
Q

manual page break

A

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

18
Q

margin

A

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

19
Q

merge

A

To combine, such as several cells into one cell.

20
Q

Mini toolbar

A

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

21
Q

Percent style

A

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

22
Q

print area

A

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

23
Q

print title

A

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.

24
Q

Quick Analysis tool

A

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.

25
Short Date format
An abbreviated format for dates in the format mm/dd/yyyy.
26
standard color
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.
27
style
A collection of formatting options that include a specified font, font size, font styles, font color, fill color, and borders.
28
theme
A collection of formatting for text, colors, images, and graphical effects that are applied throughout a workbook to create a specific look and feel.
29
theme color
One of 12 colors that belong to the workbook’s theme
30
theme font
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.