Answer the following questions.
1. What is a cell address? In how many ways a cell address can be given?
2.
What are functions in Excel? How many types of functions do you know?
3.
How is a mixed cell address different from relative and absolute cell addresses?
4.
Differentiate between MAX and MIN functions.
Answers
ANSWERS
1. The cell reference will be provided as a string of text. The function can return an address in a relative or absolute format and can be used to construct a cell reference inside a formula. As a financial analyst, cell ADDRESS can be used to convert a column number to a letter, and vice versa.
2. Functions
Count and Sum: The most used functions in Excel are the functions that count and sum. ...
Logical: Learn how to use Excel's logical functions, such as IF, AND, OR and NOT.
Cell References: Cell references in Excel are very important. ...
Date & Time: To enter a date in Excel, use the "/" or "-" characters.
3.relative and absolute. Relative and absolute references behave differently when copied and filled to other cells. Relative references change when a formula is copied to another cell. Absolute references, on the other hand, remain constant no matter where they are copied.
4. MAX( ) function returns the biggest value from the given set of data. MIN ( ) function returns the smallest value from the given set of data. ... The Max( ) and the Min ( ) functions. These will help you to separate the maximum and the lowest value respectively from a given set of numbers.Ma
plz mark as brainliast answer
Answer:
1 ) ᴀ ᴄᴇʟʟ ʀᴇғᴇʀᴇɴᴄᴇ, ᴏʀ ᴄᴇʟʟ ᴀᴅᴅʀᴇss, ɪs ᴀɴ ᴀʟᴘʜᴀɴᴜᴍᴇʀɪᴄ ᴠᴀʟᴜᴇ ᴜsᴇᴅ ᴛᴏ ɪᴅᴇɴᴛɪғʏ ᴀ sᴘᴇᴄɪғɪᴄ ᴄᴇʟʟ ɪɴ ᴀ sᴘʀᴇᴀᴅsʜᴇᴇᴛ. ᴇᴀᴄʜ ᴄᴇʟʟ ʀᴇғᴇʀᴇɴᴄᴇ ᴄᴏɴᴛᴀɪɴs ᴏɴᴇ ᴏʀ ᴍᴏʀᴇ ʟᴇᴛᴛᴇʀs ғᴏʟʟᴏᴡᴇᴅ ʙʏ ᴀ ɴᴜᴍʙᴇʀ. ᴛʜᴇ ʟᴇᴛᴛᴇʀ ᴏʀ ʟᴇᴛᴛᴇʀs ɪᴅᴇɴᴛɪғʏ ᴛʜᴇ ᴄᴏʟᴜᴍɴ ᴀɴᴅ ᴛʜᴇ ɴᴜᴍʙᴇʀ ʀᴇᴘʀᴇsᴇɴᴛs ᴛʜᴇ ʀᴏᴡ.
2 ) ᴀ ғᴜɴᴄᴛɪᴏɴ ɪs ᴀ ᴘʀᴇᴅᴇғɪɴᴇᴅ ғᴏʀᴍᴜʟᴀ ᴛʜᴀᴛ ᴘᴇʀғᴏʀᴍs ᴄᴀʟᴄᴜʟᴀᴛɪᴏɴs ᴜsɪɴɢ sᴘᴇᴄɪғɪᴄ ᴠᴀʟᴜᴇs ɪɴ ᴀ ᴘᴀʀᴛɪᴄᴜʟᴀʀ ᴏʀᴅᴇʀ. ᴇxᴄᴇʟ ɪɴᴄʟᴜᴅᴇs ᴍᴀɴʏ ᴄᴏᴍᴍᴏɴ ғᴜɴᴄᴛɪᴏɴs ᴛʜᴀᴛ ᴄᴀɴ ʙᴇ ᴜsᴇᴅ ᴛᴏ ǫᴜɪᴄᴋʟʏ ғɪɴᴅ ᴛʜᴇ sᴜᴍ, ᴀᴠᴇʀᴀɢᴇ, ᴄᴏᴜɴᴛ, ᴍᴀxɪᴍᴜᴍ ᴠᴀʟᴜᴇ, ᴀɴᴅ ᴍɪɴɪᴍᴜᴍ ᴠᴀʟᴜᴇ ғᴏʀ ᴀ ʀᴀɴɢᴇ ᴏғ ᴄᴇʟʟs.
3 ) ❓❓
4) ᴍᴀx ғᴜɴᴄᴛɪᴏɴ ʀᴇᴛᴜʀɴs ᴛʜᴇ ʙɪɢɢᴇsᴛ ᴠᴀʟᴜᴇ ғʀᴏᴍ ᴛʜᴇ ɢɪᴠᴇɴ sᴇᴛ ᴏғ ᴅᴀᴛᴀ. ᴍɪɴ ғᴜɴᴄᴛɪᴏɴ ʀᴇᴛᴜʀɴs ᴛʜᴇ sᴍᴀʟʟᴇsᴛ ᴠᴀʟᴜᴇ ғʀᴏᴍ ᴛʜᴇ ɢɪᴠᴇɴ sᴇᴛ ᴏғ ᴅᴀᴛᴀ.