Beginning Flashcards
1
Q
Format for input
A
blue and yellow box
2
Q
Format for number from external source
A
green
3
Q
what does the concatenate function do
A
assemble multiple cells together
4
Q
how to select entire column
A
control + spacebar
5
Q
autofit column
A
Alt + H + O + i
6
Q
look at formula
A
F2
7
Q
Background colour change
A
Alt + H + H
8
Q
Text colour change
A
Alt + H + F + C
9
Q
formatting
A
F1
10
Q
Anchor cell
A
F4, hit again to make it just the row
11
Q
fill out selection in hihglighted column
A
Control + D
12
Q
Fill out selction in row
A
Control + R
13
Q
Centre cells
A
Alt + H + A +C
14
Q
enter date
A
CONTROL + ;
15
Q
APPLY % FORMAT
A
CONTORL + SHIFT + 5
