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.
11 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
12 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
13 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
14 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
15 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
16 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
17 Which of the following Smart Art layout types is used to create an organizational chart?
A. Cycle
B. Hierarchy
C. Relationship
D. List
18 The cell address in the formula is known as …….
A. Function
B. Cell Reference
C. Name Box
D. Cell
19 To Print a data on the center of the page, on the page setup dialog box under Margins tab select-
A. In the Center on page section check mark Horizontally
B. In the Center on page section check mark Vertically
C. In the center on the page section check mark both Horizontally and Vertically
D. The data can not be printed on the center of the page
20 Which function in Excel tells how many numeric entries are there?
A. COUNT()
B. SUM()
C. ISNUMBER()
D. COUNTA()