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.
41 In order to arrange the countries from those with the highest population to those with the lowest, you need to sort on the population field in …………
A. Alphabetical order
B. Descending order
C. Random order
D. Ascending order
42 What is the shortcut key to highlight the entire column?
A. Alt + F4
B. F1
C. Shift + F3
D. Ctrl + Space Bar
43 Give me an example of a cell address.
A. Z:1
B. A21
C. D5:E10
D. C;3
44 How many sheets are there in excel workbook by default?
A. 3
B. 10
C. 1
D. 1024
45 What is the symbol for dividing?
A. &
B. %
C. ^
D. /
46 Excel displays the current cell address in the –
A. Function Key
B. Name Box
C. Chart
D. Cell Pointer
47 Which key do you press to check spelling?
A. F4
B. Ctrl + C
C. Shift + F3
D. F7
48 In order to perform a calculation in a spreadsheet, you need to use a
A. Chart Wizard
B. Formula
C. COUNT()
D. VLOOKUP()
49 Which function will you use to enter current time in worksheet cell?
A. VLOOKUP()
B. Now ( )
C. Pivot Table
D. COUNT()
50 How many worksheets can a workbook have?
A. 255
B. 3
C. 1
D. 100