Keyboard shortcuts mastery in Figma - Cell-by-Cell Formula Trace

Sample Data

This data shows common Figma keyboard shortcuts for basic actions.

Cell	Value
A1	Action
B1	Shortcut
A2	Copy
B2	Ctrl + C
A3	Paste
B3	Ctrl + V
A4	Undo
B4	Ctrl + Z
A5	Redo
B5	Ctrl + Y
A6	Group selection
B6	Ctrl + G
A7	Ungroup selection
B7	Ctrl + Shift + G
A8	Zoom in
B8	Ctrl + +
A9	Zoom out
B9	Ctrl + -

Formula Trace

COUNTIF(B2:B9, "Ctrl + *")

Step 1: Range B2:B9 values = ["Ctrl + C", "Ctrl + V", "Ctrl + Z", "Ctrl + Y", "Ctrl + G", "Ctrl + Shift + G", "Ctrl + +", "Ctrl + -"]

Step 2: Check which values start with "Ctrl + "

Step 3: Count how many true values

Cell Reference Map

    A       B
1 | Action | Shortcut   |
2 | Copy   | Ctrl + C   |
3 | Paste  | Ctrl + V   |
4 | Undo   | Ctrl + Z   |
5 | Redo   | Ctrl + Y   |
6 | Group  | Ctrl + G   |
7 | Ungroup| Ctrl + Shift + G |
8 | Zoom In| Ctrl + +   |
9 | Zoom Out| Ctrl + -  |

The formula references the shortcut keys in cells B2 through B9.

Result

    A       B           C
1 | Action | Shortcut   | Result |
2 | Copy   | Ctrl + C   |        |
3 | Paste  | Ctrl + V   |        |
4 | Undo   | Ctrl + Z   |        |
5 | Redo   | Ctrl + Y   |        |
6 | Group  | Ctrl + G   |        |
7 | Ungroup| Ctrl + Shift + G |   |
8 | Zoom In| Ctrl + +   |        |
9 | Zoom Out| Ctrl + -  |   8    |

The formula counts 8 shortcuts starting with 'Ctrl + ' and shows the result in cell C9.

Sheet Trace Quiz - 3 Questions

How many shortcuts in B2:B9 start with 'Ctrl + '?

A 6

B 8

C 4

D 2

Key Result

COUNTIF counts how many cells in a range match a text pattern starting with a specific string.