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.
71 Where you can find the Watch Window in excel?
A. On the Formulas tab, in the Formula Auditing group, click Watch Window.
B. On the Insert tab, in the Value Auditing group, click Watch Window.
C. On the Home tab, in the Formula Auditing group, click Watch Window.
D. None of the above
72 Which statement does not fit about Moving or Copying?
A. Moving will remove the information from the source
B. Copy Creates a replica of the source to the destination
C. Copying will remove some information from the source
D. For Copying the data we can use CTRL C Simultaneously
73 Geeta has created a New Cell Style, From where she can use this latest created style to her Data?
A. Home Tab> Cell Styles> under Styles group >Choose Style Name> under Custom
B. Home Tab> Cell Styles >under Cells group >Choose Style Name> under Custom
C. Home Tab> Format >under Cells group >Choose Style Name> under Format Cells
D. Home Tab Cell Styles under Styles group Choose New Cell Style and Choose Style Name
74 Assuming you select cell D5 which contains a formula Which of the following commands will show you the cells that rely on D5 for their calculations?
A. Trace Precedents
B. Error Checking
C. Trace Dependents
D. All of the above
75 What is the purpose of CONCATENATE() function?
A. Join text together
B. Separate text
C. Split the sentence
D. None of the above
76 Which of the following cannot be used for lookup value in MATCH VLOOKUP and HLOOKUP functions?
A. Numbers and Text
B. Cell References
C. Logical values
D. None of the above
77 How to add Header and Footer from Page Setup dialog box in a worksheet while printing?
A. On the Page Setup dialog box Header/Footer Tab Choose your Header and Footer from Header & Footer s List
B. On the Page Setup dialog box Sheet Tab Check Row and column headings check box
C. On the Page Setup dialog box Sheet Tab Click s > Choose Header & Footer
D. 1 and 3 both
78 Which of the following s is not available to remove arrows of Formula Auditing?
A. Remove Precedent Arrows.
B. Remove Dependent Arrows
C. Remove Arrow's
D. Remove all Arrows for Cell
79 The tool in the excel, which works similarly like Goal Seek Tool is -
A. SOLVER
B. Subtotal
C. Scenarios
D. What-if Tool
80 Which chart to be used from the Ribbon to graphically summarize the data and explore complicated data?
A. Maps
B. PivotChart
C. Recommended Charts
D. Pie Charts