Home > COPA (Computer Operator and Programming Assistant) > Quizzes > COPA Practice Test: Spread Sheet Applications
COPA Practice Test: Spread Sheet Applications
Fast practice, instant feedback. Timer auto-submits when time’s up.
Avg score: 0% Most missed: “Which option is used to change the direction where the cursor moves when you pre…”
COPA Practice Test: Spread Sheet Applications
Time left 00:00
25 Questions

1. What is the maximum limit of rows in MS Excel 2010?
2. Which tab in Excel is used when importing, querying, outlining and subtotalling the data placed into a worksheet’s data list?
3. Which key is used to move the insertion point to the beginning of the current sheet?
4. Which function in Excel is used to find the biggest value in a range?
5. What is the purpose of ‘Enter Key’ in MS Excel?
6. How does the single element in a worksheet known as in Excel?
7. Which bar lies top of the window in Excel Screen?
8. Which one of the following is a text function in MS Excel?
9. Which tab in Excel is used for proofing, protecting, and marking up a spread sheet?
10. Which tab is used for creating, formatting and editing a spreadsheet?
11. What do you mean by A3,B13:B20,C7 reference in Excel?
12. Which tool in MS Office is best for organizing data and making lists?
13. What is the purpose ‘Tab’ key in MS Excel?
14. Which symbol is used to execute formulas in MS Excel?
15. Which view in Excel displays the pages exactly as they appear when printed?
16. Which type of addressing is used to keep rows constant and column changes and vice versa while copying a formula from one area of the worksheet to another in Excel?
17. Which key is used to make multiple lines in a single cell?
18. What type of software is MS Office?
19. How columns are named in MS Excel?
20. Which function key is used to open go to dialogue box in MS Excel?
21. Which one of the following is ‘no argument’ function?
22. How rows are numbered in MS Excel?
23. Which option in Excel is used to rearrange the rows base on the content of a particular column?
24. Which function is used to add the values in a range?
25. Which function is used to count the number of cells that contain numbers in a range?