Format

Question 1

paste: merging conditional formatting of the destination and source ranges

Answer 1

(Ctrl + Alt + V) + G

Question 2

paste format

Answer 2

(Ctrl + Alt + V) + T

Question 3

paste column widths

Answer 3

(Ctrl + Alt + V) + W

Question 4

display the “style” dialog box

Answer 4

Alt + ‘

Question 5

within the “border” tab of the “format cells” dialog box, add/remove bottom border

Answer 5

Alt + B

Question 6

within the “border” tab of the “format cells” dialog box, add/remove downward diagonal border

Answer 6

Alt + D

Question 7

within the “border” tab of the “format cells” dialog box, when more than 1 row is selected, add/remove horizontal interior border

Answer 7

Alt + H

Question 8

increase the number of decimals displayed

Answer 8

Alt + H + 0

Question 9

apply or remove double underlining

Answer 9

Alt + H + 3 + D

Question 10

decrease indent

Answer 10

Alt + H + 5

Question 11

increase indent

Answer 11

Alt + H + 6

Question 12

decrease the number of decimals displayed

Answer 12

Alt + H + 9

Question 13

align text to the bottom of the cell

Answer 13

Alt + H + AB

Question 14

align text to the center (left/right) of the cell

Answer 14

Alt + H + AC

Question 15

align text to the left of the cell

Answer 15

Alt + H + AL

Question 16

align text to the middle (top/bottom) of the cell

Answer 16

Alt + H + AM

Question 17

choose accounting format

Answer 17

Alt + H + AN

Question 18

display the “format cells” dialog box with the “number” tab and the “accounting” category selected

Answer 18

Alt + H + AN + M

Question 19

align text to the right of the cell

Answer 19

Alt + H + AR

Question 20

align text to the top of the cell

Answer 20

Alt + H + AT

Question 21

expand “borders” drop-down menu

Answer 21

Alt + H + B

Question 22

all borders

Answer 22

Alt + H + B + A

Question 23

bottom double border

Answer 23

Alt + H + B + B