COPA Mock Test 6 - MS Excel Spread Sheet Application

1. How Cells are named in MS Excel?

A) Alphabetically B) Numerically C) Alphanumerically D) Special Character

2. What is the maximum limit of rows in MS Excel 2010?

A) 1084567 B) 1048567 C) 1048576 D) 1084576

3. What is the maximum limit of columns in MS Excel 2010?

A) 16384 B) 16438 C) 16843 D) 16348

4. Which bar lies at the top of the window in Excel Screen?

A) Status Bar B) Ruler C) Title Bar D) Scroll Bar

5. How are rows numbered in MS Excel?

A) Alphabetically B) Numerically C) Alphanumerically D) Special characters

6. How are columns named in MS Excel?

A) Alphabetically B) Numerically C) Alphanumerically D) Special characters

7. Which tab is used to include pivot table, charts, hyperlinks to a spreadsheet?

A) Insert B) Page Layout C) Data D) Review

8. Which tab in Excel is used when importing, querying, outlining and subtotaling the data placed into a worksheet’s data list?

A) Formula B) Data C) Review D) Insert

9. Which tab in Excel is used for proofing, protecting, and marking up a spreadsheet?

A) Formula B) Data C) Review D) View

10. What type of software is MS Office?

A) Application Software B) Operating System C ) Programming Language D) System Software

11. Which tool in MS office is best for organizing data and making lists?

A) Access B) Excel C) PowerPoint D) Word

12. What is the file extension of Excel 2010?

A) xls B) xlsb C) xlsm D) xlsx

13. How is the single element in a worksheet known as in Excel?

A) Cell B) Column C) Range D) Row

14. What do you mean by A3, B13:B20, C7 reference in Excel?

A) Range B) Union C) Formula D) General

15. Which type of key should combine with ctrl key to create a macro key in Excel?

A) Numeric B) Alphabetic C) Alphanumeric D) Special characters

16. Which bar is used to display the sheet information and insertion point location in MS Excel?

A) Ruler B) Scroll Bar C) Status Bar D) Title Bar

17. Which function key is used to open the Save As dialogue box in MS Excel?

A) F2 B) F5 C) F7 D) F12

18. Which tab is used to change the display of the worksheet area and the data it contains?

A) Page Layout B) Data C) Review D) View

19. Which view in Excel displays the pages exactly as they appear when printed?

A) Custom View B) Full Screen View C) Page Break View D) Page Layout View

20. Which one of the following will start with "=" sign in Excel 2010?

A) Data B) Text C) Numbers D) Formulas

21. Which tab is used for creating, formatting, and editing a spreadsheet?

A) Data B) Home C) Insert D) Review

22. Which function is used to count the number of cells that contain numbers in a range?

A) Count() B) Countif() C) Sum() D) Sumif()

23. Which function is used to add the values in a range?

A) Count() B) Sum() C) ABS() D) Sumif()

24. Which symbol is used to execute formulas in MS Excel?

A) = B) ' C) # D) "

25. Where does the result display when a formula is entered in Excel?

A) Current Cell B) Next Cell C) Previous Cell D) Formula Bar

26. Which function in Excel is used to find the biggest value in a range?

A) Ceiling B) DMAX C) LEN D) MAX

27. Which one of the following is a text function in MS Excel?

A) MID() B) NOW() C) COUNT() D) SIGN

28. Which one of the following is a 'Date & Time' function in Excel?

A) FIND() B) MOD() C) NOW() D) MID()

29. Which function is used to find the middle number in a range?

A) MEDIAN() B) MID() C) TRIM() D) MODE()

30. What is the purpose of the 'Tab' key in MS Excel?

A) Moves cell pointer to the previous column B) Moves cell pointer to the next column C) Moves cell pointer to the previous row D) Moves cell pointer to the next row

31. What is the purpose of the 'Enter Key' in MS Excel?

A) Moves cell pointer to the previous column B) Moves cell pointer to the next column C) Moves cell pointer to the previous row D) Moves cell pointer to the next row

32. Which function key is used to open the 'Go To' dialogue box in MS Excel?

A) F2 B) F5 C) F7 D) F11

33. Which option in MS Excel is used to display the rows that meet certain conditions?

A) Find B) Filter C) Format D) Sort

34. Which option in Excel is used to rearrange the rows based on the content of a particular column?

A) Find B) Filter C) Sort D) Format

35. Which type of addressing is used to keep rows constant and columns change and vice versa while copying a formula from one area of the worksheet to another in Excel?

A) Mixed B) General C) Relative D) Absolute

36. Which one of the following is a 'no argument' function?

A) Now() B) Lower() C) Max() D) IF()

37. Which key is used to move the insertion point to the beginning of the current sheet?

A) Page Up B) Home C) Ctrl + Page Up D) Ctrl + Home

38. Which sequence of operation is used to insert the hidden formula bar in Excel worksheet?

A) View → Show/Hide → Formula Bar B) Insert → Show/Hide → Formula Bar C) Data → Show/Hide → Formula Bar D) Home → Show/Hide → Formula Bar

39. Which option is used to change the direction where the cursor moves when you press the Enter key in Excel?

A) Excel options Advance Enable auto-complete for cell values B) Excel options Advance → Extend data range formats C) Excel options Advance choose direction by clicking down arrow next to check box D) Excel options Advance → Enable fill handle and cell drag and drop

40. Which key is used to make multiple lines in a single cell?

A) Alt + Enter B) Tab + Enter C) Ctrl + Enter D) Shift + Enter