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.
151 Values in a Pivot Table can not be summarized by:-
A. Dividend
B. SUM
C. Average
D. Count
152 Ankit wants to insert current date in cell, he should -
A. Press Ctrl + ;
B. Type =TODAY() and hit Enter
C. Neither 1 nor 2nd option should be used
D. 1 & 2 Both can be used
153 To filter dates on a Pivot Table or Pivot Chart use-
A. Insert Timeline
B. Insert Slicer
C. Insert Filter
D. None of the above
154 Akshita wants to add a background colour to her chart. What option should she choose?
A. Format Chart Area
B. Format Plot Area
C. Format Floor
D. Format Walls
155 What is the Syntax of SEARCH () in Excel?
A. SEARCH( [start_num],find_text,within_text)
B. SEARCH( [within_text,find_text,[start_num])
C. SEARCH(find_text,within_text,[start_num])
D. All of the above
156 You can clear the Conditional Formatting rules-
A. From the selected cells at Once
B. Format the Entire Worksheet at Once
C. One by one from the cells, where the rules are applied
D. Option 1 or 2
157 Which of the following values CANNOT be joined together using concatenate?
A. Names and surnames
B. Dialling codes and telephone numbers
C. Currency symbol and numbers
D. all of the above listed values can be joint together using CONCATENATE
158 Tracing Precedents will audit the cell formula and an arrow appears where ever you check Precedents, which color of arrow show that there is no error?
A. Blue arrow
B. Red arrow
C. Green arrow
D. Orange arrow
159 Which of the following Smart Art layout types is used to create an organizational chart?
A. Cycle
B. Hierarchy
C. Relationship
D. List
160 The cell address in the formula is known as …….
A. Function
B. Cell Reference
C. Name Box
D. Cell