Question

What are the rules to enter a Function?​

Answer 1

Answer:

The rules to enter a Function are:

All Excel functions must begin with = sign.

Function name must be a valid Excel name. For example: SUM, AVERAGE

.

Function name must be followed by an opening and closing parenthesis.

Arguments are enclosed in the parenthesis. For example, =SUM (A1:A5) .

Answer 2

Answer:

ᴛʜᴇ ʀᴜʟᴇꜱ ᴛᴏ ᴇɴᴛᴇʀ ᴀ ꜰᴜɴᴄᴛɪᴏɴ ᴀʀᴇ:-

1. ᴀʟʟ ᴇxᴄᴇʟ ꜰᴜɴᴄᴛɪᴏɴꜱ ᴍᴜꜱᴛ ʙᴇɢɪɴ ᴡɪᴛʜ = ꜱɪɢɴ.
2. ꜰᴜɴᴄᴛɪᴏɴ ɴᴀᴍᴇ ᴍᴜꜱᴛ ʙᴇ ᴀ ᴠᴀʟɪᴅ ᴇxᴄᴇʟ ɴᴀᴍᴇ. ꜰᴏʀ ᴇxᴀᴍᴩʟᴇ: ꜱᴜᴍ, ᴀᴠᴇʀᴀɢᴇ.
3. ꜰᴜɴᴄᴛɪᴏɴ ɴᴀᴍᴇ ᴍᴜꜱᴛ ʙᴇ ꜰᴏʟʟᴏᴡᴇᴅ ʙy ᴀɴ ᴏᴩᴇɴɪɴɢ ᴀɴᴅ ᴄʟᴏꜱɪɴɢ ᴩᴀʀᴇɴᴛʜᴇꜱɪꜱ.
4. ᴀʀɢᴜᴍᴇɴᴛꜱ ᴀʀᴇ ᴇɴᴄʟᴏꜱᴇᴅ ɪɴ ᴛʜᴇ ᴩᴀʀᴇɴᴛʜᴇꜱɪꜱ. ꜰᴏʀ ᴇxᴀᴍᴩʟᴇ, =ꜱᴜᴍ (ᴀ1:ᴀ5) .