Lecture 1- Arithmatic.docx - Lecture 1 Arithmatic Excel shortcuts 1 Ctrl arrow to move along the worksheet 2 To increment along row eg 1 2 3 4 till end

Lecture 1- Arithmatic.docx - Lecture 1 Arithmatic Excel...

This preview shows page 1 out of 1 page.

Lecture 1: Arithmatic Excel shortcuts 1. Ctrl+ arrow to move along the worksheet. 2. To increment along row eg: 1 2 3 4 till end of the sheet Cell 1 : 1 Cell 2: =A1+1 Ctrl+copy then ctrl+shift+right arrow then paste (ctrl+v) 3. To get random number Write Random Cell below: =rand() Then ctrl+C Then shift+down arrow
Image of page 1

You've reached the end of your free preview.

Want to read the whole page?

  • Summer '17
  • Rusha Das
  • Addition, Summation, Excel Shortcuts, new column Alt+I, Ctrl+ arrow

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture