Himachal Pradesh HPTET 817 - Free Online Practice Test

11. Which is NOT a valid cell address in MS-Excel?

Computer

A. $A$1 B. $A1 C. A:1 D. AS1

12. Function to search value in leftmost column and return corresponding value?

Computer

A. FIND() B. VLOOKUP() C. SEARCH() D. INDIRECT()

13. Cell format to display ONLY the month name of a date?

Computer

A. Month B. M C. mmmm D. Mon

14. Tool to calculate, summarize, and analyze data to study patterns?

Computer

A. Line Chart B. Bar Chart C. Mail merge D. Pivot Table

15. Feature to quickly insert consecutive odd numbers in a column?

Computer

A. Insert Table B. Fill -> Series... C. Data Sort D. Insert Object...

16. Value of =A1+A2 if A1=5 and A2=5%?

Computer

A. 0.1 B. 0.055 C. 5.05 D. 0.55

17. Chart that shows numerical data as slices of a single circle?

Computer

A. Bar B. Area C. Scatter D. Pie

18. Feature to record a sequence of keystrokes and play them again?

Computer

A. Format Painter B. Macro C. Pivot Table D. Wrap Text

19. Full form of UDP with reference to TCP/IP?

Computer

A. User Defined Protocol B. Unit Data Packet C. Uniform Data Packet D. User Datagram Protocol

20. Topology where all nodes connect to a central connection point?

Computer

A. Star B. Ring C. Bus D. Mesh