Scribd
Upload
14 views10 pages

Excel Basics en

The document provides a series of exercises focused on navigation, names, and hotkeys in Excel. It includes tasks such as selecting cells, copying and pasting data, using various paste options, and calculating sums. Additionally, it explains the behavior of relative cell references when formulas are copied.

Uploaded by

Daria Moldovan
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
14 views10 pages

Excel Basics en

The document provides a series of exercises focused on navigation, names, and hotkeys in Excel. It includes tasks such as selecting cells, copying and pasting data, using various paste options, and calculating sums. Additionally, it explains the behavior of relative cell references when formulas are copied.

Uploaded by

Daria Moldovan
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 10

Start

Navigation, Names & Hotkeys


Exercise Task
Start at A1
1 Use Ctrl + → to go to the next entry in row 1
Use Ctrl + ← to go back to Start
Now go from the very end of row 1 using Ctrl + → twice
2 Then go to the very bottom of the last column using Ctrl + ↓
Go back to Start afterwards using Ctrl+Home
Navigate to cell ABC123 by entering "ABC123" in the Name Box
3 Unhide the cell
Hide it again afterwards
Start at A1
4 Play around with Page Down, Page Up, Alt + Page Down, and Alt + Page Up
Start at D4
Select cell range D4:D11 by using Shift + ↓
5 Now do the same by using Shift + Ctrl + ↓
Give the range the name "MyRange" by typing this in the Name Box
Calculate the sum of MyRange by entering "=sum(MyRange)" in cell D12
1
2
3
4
5
6
7
8
Sum: 36
And now, the end is near…
This is the end…
Hold your breath and count to ten
Navigation, Names & Hotkeys
Exercise Task
Start in cell F4
Use Ctrl+Shift+↓ to select cells F4:F11
1 Use Ctrl+C to copy these cells and use Ctrl+V to past them in cells J4:J11
Explain what happens
When pasting something, you will see the "Paste Options button" appearing
2 Select option "Values" to copy the numbers from cells F4:F11 to cells K4:K11
Try out "Values & Number Formatting" and "Values & Source Formatting" as well
Click cells G4, G6, and G8 while holding Ctrl
3 Copy these cells and paste them in L4:L6 using paste option "Keep Source Column Width"
Start in cell E4
Use Ctrl+Shift+↓+→ to select cells E4:H11
4 Use Paste Option "Transpose" to copy cells E4:H11 to cells M4:T7
Undo the previous operation using Ctrl+Z
Now redo it by using Ctrl+Y
1.0
2.0
As a default, Excel pastes formulas. Column F contains relative cell references: cell F4 3.0
takes the cell to its left and multiplies it by 10. The formula copied to J4 will therefore
contain a relative cell reference as well: it will take the cell to its left (I4), and multiply 4.0
it by 10, which equals 0. 5.0
6.0
7.0
8.0
10.0 100.0 1000.0 0.0 10.0 100.0 1.0 2.0
20.0 200.0 2000.0 0.0 20.0 300.0 10.0 20.0
30.0 300.0 3000.0 0.0 30.0 500.0 100.0 200.0
40.0 400.0 4000.0 0.0 40.0 1000.0 2000.0
50.0 500.0 5000.0 0.0 50.0
60.0 600.0 6000.0 0.0 60.0
70.0 700.0 7000.0 0.0 70.0
80.0 800.0 8000.0 0.0 80.0
3.0 4.0 5.0 6.0 7.0 8.0
30.0 40.0 50.0 60.0 70.0 80.0
300.0 400.0 500.0 600.0 700.0 800.0
3000.0 4000.0 5000.0 6000.0 7000.0 8000.0

You might also like