Question

1. What is the use of Orientation command?
2. Write the order of precedence of operators.
3. What are relational and logical operators used for?
4. Mention the rules to write a formula in Excel.
5. Explain the types of errors you get while performing calculations.
6. How is a formula copied to other cells in Microsoft Excel?
7. Write the steps to sort data in Microsoft Excel.
8. How do you print a worksheet?​

Answer 1

1. ᴘᴀɢᴇ ᴏʀɪᴇɴᴛᴀᴛɪᴏɴ ʀᴇғᴇʀs ᴛᴏ ᴛʜᴇ ᴅɪʀᴇᴄᴛɪᴏɴ ɪɴ ᴡʜɪᴄʜ ᴀ ᴅᴏᴄᴜᴍᴇɴᴛ ɪs ᴅɪsᴘʟᴀʏᴇᴅ. ɪᴛ ɪs ᴏғ ᴛᴡᴏ ᴛʏᴘᴇs; ᴘᴏʀᴛʀᴀɪᴛ (ᴠᴇʀᴛɪᴄᴀʟ) ᴀɴᴅ ʟᴀɴᴅsᴄᴀᴘᴇ (ʜᴏʀɪᴢᴏɴᴛᴀʟ). ᴛʜᴇ ᴅᴇғᴀᴜʟᴛ ᴏʀɪᴇɴᴛᴀᴛɪᴏɴ ɪs ᴘᴏʀᴛʀᴀɪᴛ; ɪᴛ ᴄᴀɴ ʙᴇ ᴄʜᴀɴɢᴇᴅ ᴛᴏ ʟᴀɴᴅsᴄᴀᴘᴇ ʙʏ ғᴏʟʟᴏᴡɪɴɢ ᴛʜᴇsᴇ sᴛᴇᴘs; sᴇʟᴇᴄᴛ ᴛʜᴇ ᴘᴀɢᴇ ʟᴀʏᴏᴜᴛ ᴛᴀʙ.

2. ʀɪɢʜᴛ-ᴀssᴏᴄɪᴀᴛɪᴠᴇ ᴏᴘᴇʀᴀᴛᴏʀs ᴏғ ᴛʜᴇ sᴀᴍᴇ ᴘʀᴇᴄᴇᴅᴇɴᴄᴇ ᴀʀᴇ ᴇᴠᴀʟᴜᴀᴛᴇᴅ ɪɴ ᴏʀᴅᴇʀ ғʀᴏᴍ ʀɪɢʜᴛ ᴛᴏ ʟᴇғᴛ.

3. ʀᴇʟᴀᴛɪᴏɴᴀʟ, ᴇϙᴜᴀʟɪᴛʏ ᴀɴᴅ ʟᴏɢɪᴄᴀʟ ᴏᴘᴇʀᴀᴛᴏʀs ᴀʀᴇ ᴜsᴇᴅ ᴛᴏ ғᴏʀᴍ ʟᴏɢɪᴄ ᴇxᴘʀᴇssɪᴏɴs. ʀᴇʟᴀᴛɪᴏɴᴀʟ ᴀɴᴅ ᴇϙᴜᴀʟɪᴛʏ ᴏᴘᴇʀᴀᴛᴏʀs ᴜsᴜᴀʟʟʏ ᴄᴏᴍᴘᴀʀᴇ ᴛᴡᴏ ɴᴜᴍʙᴇʀs ᴀɴᴅ ʀᴇᴛᴜʀɴ ᴀ ᴠᴀʟᴜᴇ ᴏғ ᴛʀᴜᴇ ᴏʀ ғᴀʟsᴇ (ғᴏʀᴍɪɴɢ ᴀ ʟᴏɢɪᴄ ᴇxᴘʀᴇssɪᴏɴ). ʟᴏɢɪᴄᴀʟ ᴏᴘᴇʀᴀᴛᴏʀs ᴄᴏᴍʙɪɴᴇ ʟᴏɢɪᴄᴀʟ ᴠᴀʟᴜᴇs ᴏғ ᴛʀᴜᴇ ᴏʀ ғᴀʟsᴇ ɪɴᴛᴏ ᴀ ʟᴏɢɪᴄᴀʟ ᴇxᴘʀᴇssɪᴏɴ.

4. ᴍɪᴄʀᴏsᴏғᴛ ᴇxᴄᴇʟ ғᴏʀᴍᴜʟᴀs - ᴛʜᴇ ʙᴀsɪᴄs

ᴀʟʟ ᴇxᴄᴇʟ ғᴏʀᴍᴜʟᴀs ʙᴇɢɪɴ ᴡɪᴛʜ ᴀɴ ᴇϙᴜᴀʟ sɪɢɴ (=).

ᴀғᴛᴇʀ ᴛʜᴇ ᴇϙᴜᴀʟ sʏᴍʙᴏʟ, ʏᴏᴜ ᴇɴᴛᴇʀ ᴇɪᴛʜᴇʀ ᴀ ᴄᴀʟᴄᴜʟᴀᴛɪᴏɴ ᴏʀ ғᴜɴᴄᴛɪᴏɴ. ғᴏʀ ᴇxᴀᴍᴘʟᴇ, ᴛᴏ ᴀᴅᴅ ᴜᴘ ᴠᴀʟᴜᴇs ɪɴ ᴄᴇʟʟs ʙ1 ᴛʜʀᴏᴜɢʜ ʙ5, ʏᴏᴜ ᴄᴀɴ ᴇɪᴛʜᴇʀ: ᴛʏᴘᴇ ᴛʜᴇ ᴇɴᴛɪʀᴇ ᴇϙᴜᴀᴛɪᴏɴ: =ʙ1+ʙ2+ʙ3+ʙ4+ʙ5. ...

ᴘʀᴇss ᴛʜᴇ ᴇɴᴛᴇʀ ᴋᴇʏ ᴛᴏ ᴄᴏᴍᴘʟᴇᴛᴇ ᴛʜᴇ ғᴏʀᴍᴜʟᴀ. ᴅᴏɴᴇ!

5. ɢᴇɴᴇʀᴀʟʟʏ ᴇʀʀᴏʀs ᴀʀᴇ ᴄʟᴀssɪғɪᴇᴅ ɪɴᴛᴏ ᴛʜʀᴇᴇ ᴛʏᴘᴇs: sʏsᴛᴇᴍᴀᴛɪᴄ ᴇʀʀᴏʀs, ʀᴀɴᴅᴏᴍ ᴇʀʀᴏʀs ᴀɴᴅ ʙʟᴜɴᴅᴇʀs. ɢʀᴏss ᴇʀʀᴏʀs ᴀʀᴇ ᴄᴀᴜsᴇᴅ ʙʏ ᴍɪsᴛᴀᴋᴇ ɪɴ ᴜsɪɴɢ ɪɴsᴛʀᴜᴍᴇɴᴛs ᴏʀ ᴍᴇᴛᴇʀs, ᴄᴀʟᴄᴜʟᴀᴛɪɴɢ ᴍᴇᴀsᴜʀᴇᴍᴇɴᴛ ᴀɴᴅ ʀᴇᴄᴏʀᴅɪɴɢ ᴅᴀᴛᴀ ʀᴇsᴜʟᴛs. ᴛʜᴇ ʙᴇsᴛ ᴇxᴀᴍᴘʟᴇ ᴏғ ᴛʜᴇsᴇ ᴇʀʀᴏʀs ɪs ᴀ ᴘᴇʀsᴏɴ ᴏʀ ᴏᴘᴇʀᴀᴛᴏʀ ʀᴇᴀᴅɪɴɢ ᴘʀᴇssᴜʀᴇ ɢᴀɢᴇ 1.01ɴ/ᴍ2 ᴀs 1.10ɴ/ᴍ2.

6. ᴄᴏᴘʏ ᴀ ғᴏʀᴍᴜʟᴀ

sᴇʟᴇᴄᴛ ᴛʜᴇ ᴄᴇʟʟ ᴄᴏɴᴛᴀɪɴɪɴɢ ᴛʜᴇ ғᴏʀᴍᴜʟᴀ ᴛʜᴀᴛ ʏᴏᴜ ᴡᴀɴᴛ ᴛᴏ ᴄᴏᴘʏ.

ɪɴ ᴛʜᴇ ᴄʟɪᴘʙᴏᴀʀᴅ ɢʀᴏᴜᴘ ᴏғ ᴛʜᴇ ʜᴏᴍᴇ ᴛᴀʙ, ᴄʟɪᴄᴋ ᴄᴏᴘʏ.

ᴅᴏ ᴏɴᴇ ᴏғ ᴛʜᴇ ғᴏʟʟᴏᴡɪɴɢ: .

..

ᴠᴇʀɪғʏ ᴛʜᴀᴛ ᴛʜᴇ ᴄᴇʟʟ ʀᴇғᴇʀᴇɴᴄᴇs ɪɴ ᴛʜᴇ ғᴏʀᴍᴜʟᴀ ᴘʀᴏᴅᴜᴄᴇ ᴛʜᴇ ʀᴇsᴜʟᴛ ᴛʜᴀᴛ ʏᴏᴜ ᴡᴀɴᴛ. ...

sᴇʟᴇᴄᴛ ᴛʜᴇ ᴄᴇʟʟ ᴛʜᴀᴛ ᴄᴏɴᴛᴀɪɴs ᴛʜᴇ ғᴏʀᴍᴜʟᴀ.

7. ʜᴏᴡ ᴛᴏ sᴏʀᴛ ɪɴ ᴇxᴄᴇʟ?

sᴇʟᴇᴄᴛ ᴀ sɪɴɢʟᴇ ᴄᴇʟʟ ɪɴ ᴛʜᴇ ᴄᴏʟᴜᴍɴ ʏᴏᴜ ᴡᴀɴᴛ ᴛᴏ sᴏʀᴛ.

ᴏɴ ᴛʜᴇ ᴅᴀᴛᴀ ᴛᴀʙ, ɪɴ ᴛʜᴇ sᴏʀᴛ & ғɪʟᴛᴇʀ ɢʀᴏᴜᴘ, ᴄʟɪᴄᴋ. ᴛᴏ ᴘᴇʀғᴏʀᴍ ᴀɴ ᴀsᴄᴇɴᴅɪɴɢ sᴏʀᴛ (ғʀᴏᴍ ᴀ ᴛᴏ ᴢ, ᴏʀ sᴍᴀʟʟᴇsᴛ ɴᴜᴍʙᴇʀ ᴛᴏ ʟᴀʀɢᴇsᴛ).

ᴄʟɪᴄᴋ. ᴛᴏ ᴘᴇʀғᴏʀᴍ ᴀ ᴅᴇsᴄᴇɴᴅɪɴɢ sᴏʀᴛ (ғʀᴏᴍ ᴢ ᴛᴏ ᴀ, ᴏʀ ʟᴀʀɢᴇsᴛ ɴᴜᴍʙᴇʀ ᴛᴏ sᴍᴀʟʟᴇsᴛ).

8. ᴘʀɪɴᴛ ᴀʟʟ ᴏʀ ᴘᴀʀᴛ ᴏғ ᴀ ᴡᴏʀᴋsʜᴇᴇᴛ

ᴄʟɪᴄᴋ ᴛʜᴇ ᴡᴏʀᴋsʜᴇᴇᴛ, ᴀɴᴅ ᴛʜᴇɴ sᴇʟᴇᴄᴛ ᴛʜᴇ ʀᴀɴɢᴇ ᴏғ ᴅᴀᴛᴀ ᴛʜᴀᴛ ʏᴏᴜ ᴡᴀɴᴛ ᴛᴏ ᴘʀɪɴᴛ. ᴄʟɪᴄᴋ ғɪʟᴇ, ᴀɴᴅ ᴛʜᴇɴ ᴄʟɪᴄᴋ ᴘʀɪɴᴛ. ᴜɴᴅᴇʀ sᴇᴛᴛɪɴɢs, ᴄʟɪᴄᴋ ᴛʜᴇ ᴀʀʀᴏᴡ ɴᴇxᴛ ᴛᴏ ᴘʀɪɴᴛ ᴀᴄᴛɪᴠᴇ sʜᴇᴇᴛs ᴀɴᴅ sᴇʟᴇᴄᴛ ᴛʜᴇ ᴀᴘᴘʀᴏᴘʀɪᴀᴛᴇ ᴏᴘᴛɪᴏɴ. ᴄʟɪᴄᴋ ᴘʀɪɴᴛ.