Microsoft Excel - Basics, Formatting and Calculating

To select cells A1 to E1 together you will press__________ key

• Enter

• Tab

• Shift

• Ctrl

You have typed =C1+C2+C3 in a cell. It is also visible in

• Formula Bar

• Name Box

• Title Bar

• Status Bar

To edit value of a cell you need to press ______ function key.

• F1

• F2

• F5

• F7

The Tab that helps you set the row height is

• Format Tab

• Home Tab

• Layout Tab

• Edit Tab

The shortcut to Copy and Paste a formula is

• Ctrl + C and Ctrl +P

• Ctrl +X and Ctrl + P

• Ctrl + C and Ctrl + V

• Ctrl +X and Ctrl + V

Cell D1 has a formula =A2+B2. This formula is copied to cell D4. What do you see in cell D4?

• =A2+B2

• Error Message

• =A4+B4

• =A5+B5

Formula to add values of cells A1,A3 and A5 is

• =A1+A3+A5

• =A1:A3:A5

• =A1:A5

• =A1,A3,A5

Formula to find average of cells A2, A3 and A5 is

• =(A2:A5)/3

• =A2+A3+A5/3

• =(A2+A3+A5)/3

• =(A2:A5)/4

Function to find the sum of all the numbers from cell A1 to A5 is

• =Sum(A1 to A5)

• =Sum(A1+A2+A3+A4+A5)

• =Sum(A1:A2:A3:A4:A5)

• =Sum(A1:A5)

In the formula =A7/(A1+A2)^A3 what will be executed first

• Division

• Addition

• Exponential

• No output will be seen