Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

comp apps 2 > excel test 2 > Flashcards

excel test 2 Flashcards

1
Q

theme

A

a collection of formatting for text, colors, and effects that give a workbook a specific look/feel

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

theme font

A

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

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

standard font

A

retains its appearance no matter what theme is used with the workbook

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

standard color

A

one of the 10 colors - dark red, red, orange, yellow, light green, light blue, blue, dark blue, purple - that is always available regardless of the workbook’s theme

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

serif font

A

have extra strokes at the end of each character. EX: Times New Roman

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

sans serif font

A

does not include extra strokes at end of each character. EX: Arial, Calibri

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

Theme color

A

one of 12 coordinated colors that belong to workbook’s theme

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

mini toolbar

A

contains buttons for common formatting options used for that selection

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

percent change

A

(current year - previous year) / previous year

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

General format

A

the number format that mostly displays values exactly as they are typed - cells start out formatted in General format

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

Commas (style)

A

separates thousands in large numbers adds two decimals, lines up vales within a column by their decimal points

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

Excel stores dates as ___

A

numbers, not text

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

Short Date Format

A

the abbreviated format mm/dd/yyyy

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

Long Date format

A

displays the day of the week and the full month name in addition to date of month and year
Monday, February 5, 2024

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

In general, a _____ should appear above a subtotal and a ____ should be added below a calculated number

A

single black border
single bottom border

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

Format painter

A

copies and pastes formatting from one cell or range to another, without duplicating data

17
Q

Print title

A

row and/or columns that are included on every page of the printout

18
Q

Manual page break

A

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

19
Q

Conditional formatting

A

applies format to a cell when its value meets a specified condition

20
Q

Cell style

A

predefined formatting options that can be applied to cells in a workbook

21
Q

page break preview

A

shows location of print area all page breaks, last button on right side of status bar

22
Q

Quick analysis tool

A

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

23
Q

Legend

A

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

click Conditional Formatting button, point to Highlight Cells Rules, and click Text that Contains

24
Q

Print area

A

the range or ranges in a WS that you specify to be printed.

click Page Layout, Print Area, Set Print Area

25
Q

Header

A

information that appears at the top of each printed page

26
Q

Footer

A

the information that appears on the bottom of every page

27
Q

Margin

A

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

28
Q

Cost of sales

A

the cost of running the stores including the employment and insurance costs

29
Q

Net Profit/Loss

A

the difference between the income form the gross sales and the total cost of sales/operating expenses

30
Q

Gross sales

A

the total amount of sales at all the stores

31
Q

operating expenses

A

the cost of creating the products

32
Q

Currency format

A

number format - places a currency symbol directly to left of first digit, adds a thousands separator to the value, shows two decimal places, lines up number in a column, displays negative numbers with a negative sign

33
Q

font

A

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

34
Q

font style

A

formats that can be applied to a font such as italic, bold, BI, underline, strikethrough, color

35
Q

Accounting format

A

number format - places a currency symbol at left EDGE of column, adds a thousands separator to value, shows two decimal places lines up numbers in column, displays negatives with negative sign

36
Q

Nontheme font

A

a font not associated with a particular theme so it retains its appearance no matter what theme is used with the workbook

37
Q

Percent style

A

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

38
Q

Style

A

a collection of formatting options that include a specfifed font, fotn size, font styles, font color, fill color, and border

comp apps 2 (7 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2024 Bold Learning Solutions. Terms and Conditions