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.
11 To apply Goal Seek command your cell pointer must be in
A. Selected range
B. Active worksheet
C. The cell where your targeted value is entered
D. Target formula cell
12 The first cell in Excel worksheet is labeled as
A. B2:G5
B. F1:H20
C. A1
D. D5:E10
13 The default and maximum number of sheets for a new workbook in excel 2003 is
A. 1 and 255
B. 3 and 256
C. 3 and 100
D. 1 and 3
14 Data can be arranged in ascending or descending order by using
A. Sort command from Data menu
B. Icon Command From Insert
C. Sort command from Home
D. Both A & C
15 The number of rows in a worksheet is
A. 65536
B. 10
C. 256
D. 1000
16 To move to the previous worksheet press
A. Ctrl + V
B. Ctrl + C
C. Ctrl + PgUp
D. F1
17 What is the keyboard shortcut button or buttons to be pressed for creating a chart from the selected cells?
A. F1
B. Shift + F3
C. Ctrl + C
D. F11
18 Which keyboard shortcut opens the GO TO dialog box ?
A. F5
B. Ctrl + V
C. F1
D. F4
19 Which of the following option is not available in paste special dialog box?
A. Tranpose
B. Value
C. SQRT
D. Paste
20 Which chart can be created in Excel?
A. Column
B. Line
C. Pie
D. All of the above