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.
161 To Print a data on the center of the page, on the page setup dialog box under Margins tab select-
A. In the Center on page section check mark Horizontally
B. In the Center on page section check mark Vertically
C. In the center on the page section check mark both Horizontally and Vertically
D. The data can not be printed on the center of the page
162 Which function in Excel tells how many numeric entries are there?
A. COUNT()
B. SUM()
C. ISNUMBER()
D. COUNTA()
163 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
164 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
165 Which function in Excel cannot be performed through Subtotal in a sheet?
A. Average
B. Product
C. Max
D. Percentage
166 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
167 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