Q.1.Which Of These Will You Use To Separate Data Into Multiple Columns Instantly?
Q.2.You Have The Marks Of 50 Students In An Excel Sheet. You Won’t To Highlight The 3 Highest Scores. Which Conditional Formatting Rules Should You Use?
Q.3.You Can Use A Template To ……………………………………….
Q.4.A …………Control Is Used To Increase Or Decrease A Value Within A Defined Range.
Q.5.If You Want To Add Some Descriptive Text Below An Element, You Need To Use This Control.
Q.6.This Group In The Developer Tab Is Used To Insert Form Controls.
Q.7.A\An Outline Is A Hierarchy Of Groups That Allow You To Organize Your Worksheet
Q.8.In Order To Work Correctly, A Function Must Be Written According To Certain Rules Called……………..
Q.9.This Function Calculates The Payment For A Loan Based On Constant Payments And A Constant Interest Rate.
Q.10.The Match Function Searches For A Specified Item In A Range Of Cells And Returns The …….. Of That Item In The Range.
Q.11.This Function Returns The Current Date Along With The Current Time.
Q.12.The Len Function Returns The Number Of Characters In A String ………Space
Q.13.……………. Work/S Only With One Or Two Variables, But Can Accept Many Different Values For Those Variables.
Q.14.Using ………….Makes It Easy To Examine A Range Of Possibilities On A Single Worksheet.
Q.15.This Is Not A Type Of Scatter Chart.
Q.16.Wireframe Contour Is A Type Of……………Chart.
Q.17.A Bubble Chart Is A Variation Of A ………… Chart
Q.18.……………… Chart Are Used To Emphasize Different Types Of Information In A Chart By Combining Multiple Chart Types.
Q.19.A Surface Chart Is Useful When You Need To Plot….. Dependent Variable Against ……….Independent Variables.
Q.20.Filters Applied To A Pivot chart ………The Related Pivot table.
Q.21.Slicers Can Be Used To ……….Pivot table Data.
Q.23.Cell Styles Are Saved With The Workbook They Are Created In.
Q.24.Is It Possible To Use A Custom Cell Style Created In One Workbook In Another Workbook By
Q.25.You Can Copy A Macro Created In One Workbook To Another Workbook Using The Project Explorer Pane. The Ribbon Option Used To Display This Is