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.
131 To move chart to a new worksheet use
A. Cut and Paste (Ctrl + X & Ctrl + V)
B. Move Chart from the Ribbon
C. Both s 1 & 2
D. None of the above
132 What Kind of Excel Templates you can fetch in Excel?
A. Business
B. Calendars
C. Lists
D. All of the above
133 Which Statement just not fit about Moving or Copying?
A. Moving will remove the information from the source
B. Copy Creates a replica of the source to the destination
C. Copying will remove some information from the source
D. For Copying the data we can use CTRL + C Simultaneously
134 Shashank wants to format his numerical data as currency, to do this he should apply which number format to the data?
A. Currency
B. Accounting
C. Both s 1 & 2
D. Data can not be formatted as Currency
135 If you want to display numbers as monetary values, you should format the numbers as
A. Currency
B. Fraction
C. Percentage
D. Number
136 Which of the following describes what you can do with Goal Seek?
A. Find the correct input for the value you want
B. Create different groups of values or scenarios
C. Display the results of multiple inputs at the same time
D. Choose from a list of rules to limit the type of data that people can enter
137 Akshat wants to print Grid lines and Headings as well with his worksheet data. Under which group of Page Layout Tab can he find the for that on the Ribbon?
A. Scale to Fit
B. Page Setup
C. Sheet s
D. Arrange
138 How to insert a Slicer in a PivotTable?
A. Click anywhere in a PivotTable Design Tab > Click Insert Slicer
B. Click anywhere in a PivotTable Analyze Tab > Click Insert Slicer
C. Click anywhere in a PivotTable Insert Tab > Click Insert Slicer
D. Click anywhere in a PivotTable> View Tab > Click View Slicer
139 Subtotal function is only applicable for the _________
A. Text Values
B. Numeric Values
C. Text and Numeric Values
D. All of the above
140 The Sum function is applied to values in a PivotTable by default to summarize them. How can you change this so that values are counted and not summed?
A. Right Click on the Pivot Table Summarize Values By > Count
B. Click any of the cell in Values Field > On the Analyze Tab click Field Setting Under Summarize value field by, choose Count
C. Click anywhere in the PivotTable> On the Pivot Table Field List Select Values Field Choose Value Field Settings >Under Summarize value field by, choose Count
D. All of the above