Posts

Showing posts with the label Ms excel 100% free

Ms excel Questions by discover Talent presents

Image
Which keyboard shortcut opens the Go To dialog box? a. Ctrl + B b. Ctrl + Shift + B c. F2 d. F5 @@@@@@@@@@@@@@@@@@@ To keep specific rows and columns from scrolling off the screen you first must  position the cell pointer a. to the right of the column you want to remain on the screen b. below the row you want to remain on the screen c. on the row you want to remain on the screen d. both below and right of the row and column you want to remain on the screen @@@@@@@@@@@@@@@@@@@@@ When you create two or four separate windows containing part of the  spreadsheet that can be viewed, you have created a. sections b. panes c. views d. subsheets @@@@@@@@@@@@@@@@@@@@@ The accounting style shows negative numbers in a. Bold b. Brackets c. Paranthesis d. Quotes @@@@@@@@@@@@@@@@@@11 Which of the following component displays the contents of active cell? a. Name box b. Formula bar c. Menu bar d. Status bar @@@@@@@@@@@@@@@@@@@ How many sheets are there in Excel Workbook by default? a. 2 b. 3 c. 4 d. 5 @

Without Macro Record excel Cells

Image
 As we all know there is amazing feature call macro in excel. Which helps you to work efficiently and it removes the manual task for sure A macro is like a set of actions which we ideally record or type codes in the form so whenever required to perform those steps we can use or run multiple times.  A macro helps in automating or repeating tasks by recording or storing our input sequences like mouse strokes or keyboard presses. Once this input is stored, it makes up a macro which is open to any possible changes. We have Macro based videos coming soon on our channel But what if you NOVICE in Macro and still wanted to remove manual effort!! Can't you  work smart??  The ans is NO  It's not necessary to learn code specially if the inbuilt feature is available in Ms excel  So do you perform that task using Ms Excel In built function.  As we all know instead of reading videos create nice impact for understanding So recommend you to watch the below given video and subscribe our channe

Discover Talent Presents | Top40 Ms Excel Short Cut keys lesson 2

Image
 world is changing  rapidly and we need to go along with the flow by enhancing the skill sets this #ShortCut Keys will help you in your #Competitive exams #Govt as well as  #Private job . This is a basic approach if you have gone through my previous video which is lesson 1 you will be more than happy to continue with this series. as i told you earlier #MsExcel is too vast i think i need to prepare other #Lession3 video which will cover almost all shortcut keys which will help you to enhance your #Skill sets so what are you waiting for ? urge you to please check out the videos which is available on the #DiscoverTalent143 and watch entire video series which will help you to grow in your career. learning is never ending . if you not able to understand any short cut keys in the #Video then please comment in the below section i am happy to help you out with demo as well. main goal our #DiscoverTalentPresents channel is #ToGrowTogether  as we know this is really easy but not sure where to st

Discover Talent Presents | Top 30 Short Cut Keys in Ms Excel Lesson 1

Image
 in #MsExcel #ShortCut plays a very important role . Especially the people who work upon the dash boards , daily reporting , #MIS work . We got amazing response on our #DiscoverTalent143 #Instagram handle . Requesting for the #MicrosoftExcel Shortkeys ! there are ample amount of short cut keys on the . #Google Etc. thing but what my audience needed i know better hence they showed trust upon me :) and without hesitation demanded for the #Begineer level #ShortCutKeys  Here is the video as requested i assure you if you implement this in your daily regime #Working from office or home will help you to stay smartly among the all coworkers so what are you waiting for  Watch the Full video and dont miss the ending ! :) amazing fun and yes you can also find the Discover Talent now on #Google as well Just type - #DiscoverTalentPresents on the Google and be found. We are also available on the -  #Pinterest https://www.pinterest.com/pin/659144095455107390/ #Instagram : #DiscoverTalent143 #Tumblr