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.
91 To move a chart to a different, existing sheet in the same workbook, determine whether the following steps are correct?
A. Yes
B. No
C. Partially Correct
D. Cannot be determined
92 What are the type of forms which can be saved as a Template in Excel?
A. Data with text formattings such as font or font color or size can be saved as a template
B. Text data only can be stored as a template
C. Formats of numbers and dates with formulas can be saved as template
D. All of the above
93 How to launch Sort dialog box-
A. Pressing Alt + D + S on the Keyboard
B. Pressing Alt+A+S+S on the Keyboard
C. Data Tab Under Sort & Filter group, click Sort
D. All of the Above
94 What are the benefits of creating Named Ranges in Excel?
A. Instead of giving cell references, Named Ranges makes it easy to refer to data sets in Excel
B. If you need to give same cell reference again and again, you need not to go back to the data set, just use the Named Ranges. It Saves the time
C. With Named Ranges, Formulas can be made dynamic
D. All of the above
95 While creating Subtotal you need to remember that
A. You need to always Sort your data by Column, to use the Subtotal effectively
B. Each column you want to subtotal includes a label in the first row
C. 1 & 2 Both
D. Subtotal cannot be applied without following the condition mentioned in 1 & 2
96 If we need to use DSUM function with OR criteria, we need to mention criteria on field
A. Different Row
B. Same Row
C. Same Cell
D. Field
97 In Excel 2019 what are the functions which are better flexible alternatives of CONCATENATE function?
A. CONCAT
B. TEXTJOIN
C. ISTEXT
D. 1 & 2 Both
98 Data Validation Rule in a field will
A. Display the values in specified format when user leaves the field
B. Check the values entered when user leaves the field
C. Defines the appearance for the text when user leaves the field
D. None of the above
99 Remove Duplicates tool always considers each row in a data set as a
A. Duplicate Value
B. Record
C. Command
D. Entry
100 Which is the shortcut key to Open 'Find and Replace' dialog box in Excel?
A. Ctrl + R
B. Ctrl + F
C. Ctrl + H
D. Both B and C