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.
1 Which of the following is not a term of MS – Excel
A. Worksheet
B. Document
C. Workbook
D. Cell
2 What happens when you press Ctrl + X after selecting some cells in Excel ?
A. Cells are copied
B. Cells are locked
C. The cells selected are marked for cutting
D. Cells are highlighted
3 We can save and protect the workbook by
A. Hide sheet
B. Password protect
C. Conditional formatting
D. Format cells
4 What happens when dollar signs ($) are entered in a cell address? (ex. $B$2:$B$10)
A. Named range
B. Mixed reference
C. Absolute reference
D. Relative reference
5 You want to set such that when you type Baishakh and drag the fill handle, Excel should produce Jestha, Aashadh and so on . What will you set to effect that?
A. Default list
B. Predefined list
C. Auto fill series
D. Custom list
6 Which is an example of function?
A. =sum (A1:A2)
B. IF()
C. COUNT()
D. Sort
7 Which function is used to calculate depreciation, rates of return, future values and loan payment amounts ?
A. DB
B. VDB
C. SYD
D. SLN
8 Which of the following component displays the contents of active cell?
A. Chart
B. Menu Bar
C. Formula bar
D. Data Sheet
9 The minimum and maximum value you can set for Save Auto Recovery Info in Excel are
A. 1 and 120
B. 5 and 100
C. 10 and 500
D. 1 and 999
10 To record a sequence of keystrokes and mouse actions to play back later we use:
A. COUNT()
B. Macro Recorder
C. Pivot Table
D. Sort