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.
21 Which of the following best describes a Pivot Table in Excel?
A. It is a table formatted in black and white color only
B. It is a tool, which calculates the financial values only
C. It is a table which is known to hold the Pivot data
D. It is a tool which calculates, summarize and analyze the data
22 What is the only way of removing password encryption on an Excel file?
A. Resaving the workbook as a new document or making a copy of it
B. Opening the workbook as Read Only and resaving it without a password
C. Opening the workbook in Protected View and resaving it without a password
D. Entering the password to open the Workbook and then deleting the password created in the Permissions Encrypt with Password box
23 Which function in Excel cannot be performed through Subtotal in a sheet?
A. Average
B. Product
C. Max
D. Percentage
24 The process of arranging the items of a column in some particular squence is known as-
A. Arranging
B. Sorting
C. Auto fill
D. Flash fill
25 Identify the true statement about the Power Pivot?
A. Power Pivot can be simple to use and fast to execute
B. It also can create Powerful and complex calculations, indicators, and formulas
C. Both are correct
D. Both are incorrect