Computer Fundamental MCQ Questions on Excel (Spreadsheet [PDF]

Tech Talim Home t

IDB Questions t

Make Money Online

Blogging

Facebook

SEO

Android

Windows 8

Computer Fundamental MCQ Questions on Excel (Spreadsheet): Module 4

Templates

Giveaways

Total Pageviews Like 0

Labels

1. Each Excel file is called a workbook because a. It can contain text and data b. It can be modified c. It can contain many sheets including worksheets and chart sheets d. You have to work hard to create it 2. In an MS Excel worksheet the active cell is indicated by … e. A dark wide boarder

Popular Posts

f. A dotted border g. A blinking border h. None of above 3. All worksheet formula in MS Excel ? a. Manipulate values b. Manipulate labels c. Return a formula result d. Use the addition operator 4. The advantage of using a spreadsheet is : – a. Calculations can be done automatically b. Changing data automatically updates calculations c. More flexibility d. All of the above 5. There are three types of data found in a spreadsheet. These are –* a. Data, words, numbers b. Numbers, formulas, labels c. Equations, data, numbers d. Words, numbers, labels 6. A worksheet can have a maximum of__________ number of rows a. 256 b. 1024 c. 1048576 d. 32000 7. Which of the following symbol is used before a number to make it a label? a. “(Quote) b. = (equal) c. _ (underscore) d. ‘(Apostrophe) 8. The default numeric data aligned within a cell of MS Excel Worksheet is – a. Left b. Right c. Centre d. Justify

9. The default text data aligned within a cell of MS Excel Worksheet is – a. Left b. Right c. Centre d. Justify 10. Which of the following symbols is used to write a formula in MS Excel? a. = b. + c. ( d. @ 11. The cell reference for a range of cells that starts in cell B1 and goes over to column G and down to row 10 is…… a. B1-G10 b. B1.G10 c. B1:G10 d. B1; G10 12. The Paste Special command lets you copy and paste: a. The resulting values of a formula instead of the actual formula b. Cell comments c. Formatting options d. All of the above 13. Getting data from a cell located in a different sheet is called … a. Accessing b. Referencing c. Updating d. Functioning 14. Which of the following is an absolute cell reference? a. !A!1 b. $A$1 c. #a#1 d. A1 15. The advantage of using a spreadsheet is : – a. Calculations can be done automatically b. Changing data automatically updates calculations c. More flexibility d. All of the above 16. Which of the following formula has not been entered correctly? a. =10+50 b. =B7*B1 c. =B7+14 d. 10+50 17. Which of the following will return the Maximum value of the cells between C19 to C29 in MS Excel? a. =Maximum (C19:C29) b. =Max (C19:C29) c. =Max (C19 to C29) d. MS Excel can’t do this task. 18. Which one of the following stores the whole value entered but only displays the number up to two decimal places? a. General Number b. Fixed c. Standard d. Currency 19. When you enter a formula in a cell and the cell displays #REF! ? It means a. Excel does not recognize text contained in the Formula b. Invalid Column c. A cell reference is invalid d. Contents cannot be displayed correctly as the column is narrow 20. When you enter a formula in a cell and the cell displays #NAME? It means a. Excel does not recognize the text contained in the Formula b. Invalid Column c. Contents cannot be displayed correctly as the column is narrow d. A cell reference is invalid 21. When you put a formula in a cell and the cell displays #######? It means a. Excel does not recognize text contained in the Formula b. A Cell reference is invalid c. Contents cannot be displayed correctly as the column is narrow d. Invalid Column 22. When a label is too long to fit within a MS Excel Worksheet cell, you typically must a. Shorten the label b. Increase the column width c. Decrease the column width d. Adjust the row height 23. What do you mean by this query expression >=#1/1/1999 and