Excel 3 Flashcards Preview

Data Management 1 > Excel 3 > Flashcards

Flashcards in Excel 3 Deck (13):
0

The format of a cell is

What determines how the labels and values look

1

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

Font

2

What is the default font of Excel

11-point Calibri

3

What are attributes

Styling formats such as bold, italics and underlying

4

What determines the position of data in a cell

Alignment

5

What does the format painter allow you to do

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

6

What is the default column width for Excel

8.43 characters wide

7

What does autofit column width do

Fits to the widest entry in column

8

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

Insert a new row and info shifts down
Column and Info shifts right

9

What are cell styles

Pre designed combinations of formatting attributes

10

What is automatic application of formatting attributes on cell values called

Conditional formatting

11

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

Data bars

12

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

3