NEW
Font size
WorksheetsMicrosoft Excel - Basics, Formatting and Calculating
Total questions: 10
Worksheet time: 5mins
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
