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.
61 To Move Chart in excel worksheet, under Chart Tools on Design Tab Select
A. Select Chart
B. Change Chart Type
C. Move Chart
D. New Sheet
62 In MS-Excel formulas can be created
A. Using Built-in Functions
B. Using Mathematical Operators
C. Using Built in Functions and Mathematical Operators both
D. Using Built-in Functions or Mathematical Operators but not both at the same time
63 Which of the following is NOT an argument you will find in a SUMIFS function?
A. sum_range
B. criteria_range
C. value_if_true
D. criteria1
64 The 'LEN' function in MS-Excel belongs to which of the following categories?
A. Financial
B. Logical
C. Text
D. Math & Trig
65 On Home tab on which group can you find Flash Fill?
A. Cells
B. Number
C. Editing
D. Styles
66 How can I specify that I want users of my worksheet to be able to change and apply formatting when the worksheet is protected?
A. Tick the boxes for Format Cells, Format Columns and Format Rows Protect Sheet dialogue box.
B. Select only the Structure and Windows s in the Protect Workbook dialogue box.
C. Select pre-set formatting s from the Cell Styles Gallery under Home tab in the Styles group.
D. All of the s listed above are incorrect.
67 In MS Excel, One can add the numbers very easily in a large continuous range by using
A. Auto Fill
B. Auto Correct
C. Format Painter
D. Auto Sum
68 In Excel what does IFERROR function do
A. Captures errors in the formula
B. Returns an alternative result or formula when an error is found
C. Both s 1 & 2
D. None of the above
69 If Cell is blank then LEN() function will return-
A. #VALUE!
B. 0
C. 1
D. None of the above
70 A function must be written in a specific way so that it can work correctly, This specific way of writing function is known as
A. Syntax
B. Formula
C. Substitute
D. None of the above