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.
31 You can edit existing Excel data by pressing the
A. Ctrl + C
B. F4
C. F2
D. F1
32 Excel is a
A. A spreadsheet
B. Data Sheet
C. Chart
D. Function Key
33 What will be the output if you format the cell containing 5436.8 as ?#,##0.00??
A. 5,436.80
B. 5,436.8
C. 5436.8
D. 5436
34 Which of the cell pointer indicates that you can fill series ?
A. Sort
B. Data Tab
C. Formula
D. Fill Handle
35 MS-excel can be used to automate
A. Formulas
B. Charts
C. Macros
D. Tables
36 You accidently erased a record in the sheet. What command can be used to restore it immediately ?
A. Undo
B. Cut
C. Redo
D. Paste
37 You want to record a experiment information and create a chart that shows the rate of crystal growth over a period of time. The best application to use would be :
A. COUNT()
B. VLOOKUP()
C. Spreadsheet
D. AVERAGE()
38 Where a row and a column meet, who do you call that?
A. A range
B. A worksheet
C. A cell
D. A table
39 To return the remainder after a number is divided by a divisor in excel we use the function?
A. COUNT()
B. IF()
C. Chart Wizard
D. MOD()
40 QTR1, QTR2, QTR3 is an example of a
A. Series
B. Formula
C. Function
D. Cell