Discover Talent™

You may wonder what top 10 questions multiple choice in Excel which help you to groom yourself in Excel sheet check out al Ten questions Don't forget to subscribe our blog for latest updates on. Data analytics | Excel | Certification  What is the keyboard shortcut to save an Excel spreadsheet? a) Ctrl+S b) Ctrl+P c) Ctrl+X d) Ctrl+Z Answer: a) Ctrl+S Which of the following formulas would you use to add up a range of cells in Excel? a) =SUM() b) =AVG() c) =COUNT() d) =MIN() Answer: a) =SUM() What does the function =NOW() do in Excel? a) Returns the current date and time b) Returns the current time c) Returns the current date d) Returns the current year Answer: a) Returns the current date and time Which of the following is NOT a valid chart type in Excel? a) Pie chart b) Line chart c) Bubble chart d) Email chart Answer: d) Email chart What is the shortcut key to insert a new row in Excel? a) Ctrl+R b) Ctrl+N c) Ctrl+I d) Ctrl+Shift+Plus (+) Answer: d) Ctrl+Shift+Plus (+) Which of the

 in this series are covering the topic called #NA Error , Technically, this is not an error value but a special value that you can manually enter into a cell to indicate that you don’t yet have a necessary value ( NA – No Value available )  .  If you don’t know what I meant about the context or through description don’t worry and watch the video if you still have issues in understanding then don’t hesitate comment on YouTube channel asking for the same.  We are here to help you out the   These all functions or error handling method which right now showing in the video is just for that specific formula you may deep dive with the other formulas as well and relate or resolve the issue as per your problem statement , feel free to tag us on Instagram / Facebook  share us the workbook if by any chance you are stuck somewhere while resolving the issues #Learning #Certificate #ErrorHandlingTechnique these error handling advancement makes you more proficient in excel while you use any #Formula