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.
21 Special category of number tab in format cells dialog box cab be used to apply formats like
A. Format Painter
B. Both of above
C. Multiply
D. Text Only
22 How many recent files you can display on file menu at maximum?
A. 1024
B. 1000
C. 9
D. 256
23 Excel is a good application for what if analysis. Which of the following tool help you for this?
A. Goal seek
B. VLOOKUP()
C. AVERAGE()
D. IF()
24 What is the symbol for multiply?
A. +
B. ^
C. *
D. -
25 To select an entire column in MS-Excel, press?
A. Multiply
B. None of the above
C. Add
D. Text Only
26 Paste special allows some operations when you paste to new cell. Which of the following operations valid?
A. Multiply
B. Subtract
C. Format Painter
D. Divide
27 The cell reference for a range of cells that starts in cell B1 and goes over to column G and down to row 10 is
A. Z1
B. C3
C. D5:E10
D. B1:G10
28 In the formula, which symbol specifies the fixed column or rows?
A. #
B. $
C. &
D. *
29 Ctrl + D Shortcut key in Excel will
A. Delete
B. Undo
C. Fill Down
D. Copy
30 NOT , AND , OR and XOR are
A. Function Key
B. Menu Bar
C. Chart
D. Logical operators