Wokr Flashcards

1
Q

How to select only one column on pdf

A

alt select

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

insert work sheet

A

shift f11

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

freeze

A

alt w f

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

zoom control

A

alt v z

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

Remove border

A

ctrl shift -

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

Autocolor cell

A

ctrl alt e

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

AutoColor sheet

A

ctrl alt s

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

Vertical alignement

A

ctrl shift v

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

Horizontal alignement

A

ctrl shift H

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

Date spread

A

ctrl alt D

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

Zoom in out

A

ctrl alt = or -

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

smart transpose

A

ctrl alt T

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

Formatting

A

ctrl shift +
1 = number
2 = date
4= currency
5= %

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

creat newbook

A

ctrl n

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

Increase decrease font

A

ctrl shift F / G

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

Binary

A

ctrl shift Y

17
Q

to do touble subset

A

ctrl shift I

18
Q

Wrap

A

Ctrl shift W

19
Q

Full border

A

ctrl shift B

20
Q

border

A

ctrl alt shift and arrow

21
Q

Highlight

A

alt shift &

22
Q

Increase table size

A

ctrl alt shift f or G

23
Q

Change the case

A

alt shift C

24
Q

comment resize

A

More tools in factset / sheet formatting / comment resize

25
Q

auto size row

A

alt shift page up / down

26
Q

auto size column

A

alt shift ctrl page up / down

27
Q

bookmark setup / kill

A

ctrl alt b or x

28
Q

bookmaker next

A

ctrl alt n or p

29
Q

you can copy past factset grpaghs

A

excel charting tools

30
Q

you can add easy CAGR

A

modelling tool

31
Q

Clear formatting

A

alt eaf

32
Q

rename tab

A

alt h o r

33
Q

Check formula

A

shift f3

34
Q

Delete sheet

A

Alt → H → D → S