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.
121 To hold row and column titles in place so that they do not scroll when you scroll a worksheet click
A. View Tab Freeze Panes
B. Review Tab > Allow Users to Edit Ranges
C. View Tab Switch Windows
D. 1 & 2 Both
122 When you create a new excel template and want to save it on the PC, by default, excel tends to save templates in-
A. Documents Custom Office Templates
B. This PC > Drive D
C. This PC > Pictures
D. Any Location you prefer
123 What is the keyboard Shortcut of applying percent format?
A. Ctrl + Shift + %
B. Alt + Shift + %
C. Shift-%
D. Alt+%
124 MIN and MAX functions belong to the category of _______________functions
A. Text
B. Statistical
C. Math & Trig
D. Logical
125 Can you set 0.5 inch left indentation for a cell in Excel?
A. Excel does not have indentation feature
B. You can specify indentation only if you turn the rulers on
C. Indentation can be set from Format Cells dialog box
D. The indentation can be specified only when printing
126 In the Consolidate dialog box what is the use of reference box?
A. It is used to add or delete selected reference to the list of sheets to merge
B. It is used to select data range from the worksheets you want to consolidate
C. It is used to choose the function and work it properly
D. It is used to create links for the source data
127 When a label is too long to fit within a worksheet cell you should
A. Shorten the label
B. Increase the width of Column
C. Adjust the height of the row
D. Decrease the Width of Column
128 Excel Calendar Template includes useful features like
A. Common holidays
B. Mini previous / next month calendars
C. Highlighted weekends
D. All of the above
129 When you launch Excel 2019 Screen shows different template thumbnails, the template thumbnail which allows you to take a tour and learn several features, is known as
A. Welcome to Excel
B. Charts
C. Blank Workbook
D. Business
130 When you apply AutoFilter to a Data-
A. Filtered data will be deleted
B. Filtered data will be hidden from the view
C. Only first 10 rows will be visible and others will be deleted
D. 2 and 3 Both