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.
111 Which is the shortcut key to Open a Workbook in Excel?
A. Ctrl + O
B. Ctrl + Shift + O
C. Alt + O
D. Shift + O
112 Which is the shortcut key to Save a Workbook in Excel?
A. Ctrl + S
B. Alt + S
C. Shift + S
D. Ctrl + Shift + S
113 Which is the shortcut key to Edit a Cell in Excel?
A. F2
B. Ctrl + E
C. Shift + F2
D. Alt + Enter
114 Which is the shortcut key to Insert Current Date in Excel?
A. Ctrl + D
B. Ctrl + ; (semicolon)
C. Ctrl + : (colon)
D. Shift + ; (semicolon)
115 Which is the shortcut key to Insert Current Time in Excel?
A. Ctrl + Shift + ; (semicolon)
B. Ctrl + : (colon)
C. Ctrl + ; (semicolon)
D. Alt + Shift + T
116 Which is the shortcut key to insert a New Sheet in Excel?
A. Shift + F11
B. Ctrl + N
C. Ctrl + F11
D. Alt + Shift + F11
117 How to Delete a Named Range?
A. Click Formulas -> Name Manager -> New Name
B. Click Formulas -> Name Manager -> Delete
C. Click Formulas -> Define Name
D. Click Formulas -> Create from Selection
118 What are the benefits of creating Named Ranges in Excel?
A. Instead of giving cell references, you can give a name to the data range to improve understandability.
B. If you need to give same cell reference in multiple formulas, you can just give the name instead of cell reference.
C. With Named Ranges, Formulas are more understandable and usable.
D. All of the above
119 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
120 In Excel what does SUMIF function do?
A. Adds up cell values based on a condition
B. Adds all the numbers in a range of cells
C. Returns a subtotal in a list or database
D. All of the above