Posts

Showing posts with the label FAQ

Drag Option not working in excel sheet

Image
 To filled out the formulas digit or the value in cells we need this option #msexcel #drag #excel_Hacks  Drag Option not working in excel sheet there are couple of instances where we see this issue. In excel its well known issue also on YouTube ▶️ channel seen this question were asked by the viewers hence  we Discover talent presents came up with  This quick guide which will help you to resolve your issue.  Take a look at below video 🎥 .  If you find it useful would encourage you to share or subscribe our blog or YouTube channel which ever you find suitable and easy to access. Thanks again for your time keep visiting this page have a great day ahead We have published more than 80 videos which are covering ms excel basic to advance. We also provide free ms excel certification which you add in your resume or CV . which creates value for your career . We share excel expertise on this channel ( #QuickExcelHacks , #ExcelTips, #MsExcelTraining , #MsExcel and #MsOffice Guide ) Free of cost (

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 @