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.
81 If you are not able to see the SOLVER tool in your excel what steps will you follow to add it?
A. File Tab> s > Add-ins In the Manage: box, change the drop-down to COM Add-ins > Go and choose Solver Add-in
B. File Tab s > Add-ins > In the Manage: box, choose Excel Add-ins -> Go and choose Solver Add-in
C. 1 & 2 Both
D. None of the above
82 When you click on Data Tab > Get Data > From File, to import the data, what do you find here?
A. From Workbook
B. From Text/CSV
C. From Word Document
D. From XML
83 What are the Features of Excel Templates
A. Define the format for the data in Excel output
B. Split hierarchical data across multiple sheets and dynamically name the sheets
C. Create sheets of data that have master-detail relationships
D. All of the Above
84 By using the Data Validation in a worksheet the worksheet users can provide
A. A list of values to choose from for the cell
B. A message about the entry they need to make in the cell
C. A choice of formula
D. All of the above
85 Which one of the following is not right in the context of functions in Excel?
A. An Excel function must begin with sign
B. Function name must be a valid Excel Function name which excel recognizes
C. Function name should not be followed by opening and closing parenthesis
D. Parenthesis contain arguments within it
86 How can you import data from MS Access?
A. Data Tab > Get Data > From Database
B. Data Tab > Get Data > From File
C. Data Tab > Get Data > From Other Sources
D. Data Tab > Get Data > From Azure
87 Which shortcut key is used to Strikethrough the selected text or text in the selected cells?
A. Ctrl + 1
B. Ctrl + 9
C. Ctrl + 5
D. Ctrl + G
88 What can be the extension of an Excel Template file?
A. xlsx
B. xltx
C. xlsm
D. xls
89 How do you remove a background image from a worksheet?
A. Select the whole worksheet and press delete.
B. Click on the Fill Color Gallery button and select White from the s.
C. Change the Theme of the worksheet to No Background Text Only.
D. Click on the Page Layout tab and in the Page Setup group, click Delete Background
90 Correct syntax for AVERAGE function is -
A. AVERAGE(number1, [number2],)
B. AVG(number1, [number2],.)
C. 1 & 2 Both are Correct
D. None of the above