Explore a treasure trove of past Excel question papers that serve as your ultimate guide to mastering Microsoft Excel. Delve into a rich archive of real-world Excel challenges and scenarios, meticulously designed to sharpen your skills. These time-tested papers cover a wide spectrum of topics, from basic functions to advanced data analysis and charting techniques. Whether you're a student preparing for an exam or a professional aiming to enhance your Excel prowess, these question papers offer invaluable practice and insights. Excel like a pro, tackle any spreadsheet challenge, and excel in your Excel journey with these curated old question papers.
51 How do you rearrange the data in ascending or descending order?
A. Data , Sort
B. Insert, Sort
C. Home, Sort
D. None of the Above
52 From which command sections both superscript and subscript to be added to Quick Access Toolbar?
A. All Commands
B. Popular Commands
C. 1 & 2 Both are Correct
D. 1 & 2 Both are Incorrect
53 Ram has Consolidated three sheets in a new worksheet using function as SUM from the Consolidate dialog box, but he observed that when he changes data values in any of the three worksheets, the value is not getting updated in his new worksheet. What has he missed while using Consolidate tool?
A. He missed to use Reference box
B. He missed to Check 'Top row' Checkbox
C. He missed to Check 'Left Column' Checkbox
D. He missed to Check 'Create links to source data' Checkbox
54 Which shortcut key is used to remove all borders?
A. Shift +_
B. Shift + F1
C. Ctrl+Right Arrow key
D. Ctrl + Shift +_
55 How to print a specific range in Excel?
A. Select a range in the sheet File Tab Print Choose Print Selection Print
B. Select a range in the sheet Page Layout Tab Print Area Set Print Area
C. s 1 and 2
D. None of the above
56 If you just want to move the chart as an object to an existing worksheet of current workbook, which is suitable for that?
A. Object in:
B. New Sheet:
C. Current Sheet
D. New Object
57 You can find Solver Tool under-
A. Under the Data tab on the Ribbon.
B. Under the Formulas tab on the Ribbon.
C. Under the Review tab on Ribbon
D. Under the Insert tab on the Ribbon.
58 The following are the steps to change the date format in Excel. What is the right order?
A. 1.2.3.4
B. 1.4.3.2
C. 4.3.2.1
D. 3.4.1.2
59 What are the ways of viewing an excel document in Print Preview?
A. Click on File Tab and click Print
B. Press Ctrl + P on the Keyboard
C. Both s 1 & 2
D. None of the above
60 Amit wants to add a title line on an Excel Spreadsheet, He Should-
A. Click on Insert Tab > Text> Header & Footer > Add a text to appear as Title
B. Click on Insert Tab > Text > Text Box > Add a text to appear as Title
C. Click on Insert Tab > Text > WordArt
D. All of the above