Excel 3 Flashcards

0
Q

What is the name for a collection of characters with a similar, specific design

A

Font

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

The format of a cell is

A

What determines how the labels and values look

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

What is the default font of Excel

A

11-point Calibri

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

What are attributes

A

Styling formats such as bold, italics and underlying

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

What determines the position of data in a cell

A

Alignment

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

What does the format painter allow you to do

A

Allows you to copy all formatting attributes of selected cells and apply them to other cells

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

What is the default column width for Excel

A

8.43 characters wide

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

What does autofit column width do

A

Fits to the widest entry in column

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

When you insert a new column and row where do the contents of the worksheet shift to

A

Insert a new row and info shifts down

Column and Info shifts right

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

What are cell styles

A

Pre designed combinations of formatting attributes

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

What is automatic application of formatting attributes on cell values called

A

Conditional formatting

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

What is a type of conditional formatting that visually illustrates differences among values

A

Data bars

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

By default, how many worksheets are contained in an Excel workbook

A

3

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