1st Year Computer – Chapter 9 Spreadsheet Software – Online MCQs TestUncategorized 0% Online MCQs Test Chapter 9 Most Important and Board Exam Repeated MCQs 1 / 28 1. The intersection of row and column is called: a) intersection b) cell c) field d) address 2 / 28 2. Built-in formula is known as: a) update b) calculate c) procedure d) function 3 / 28 3. Which if correct formula in MS Excel? a) +D3=D4 b) =D3 ! D4 c) +D3,D4 d) =D3+D4 4 / 28 4. The function that divides sum of the values by their number in MS Excel is: a) AVG() b) Average() c) DIV() d) Division() 5 / 28 5. Which capability of spread sheet can be used to show data graphically? a) Formatting b) Functions c) Formula d) Charts 6 / 28 6. The currently selected cell in spreadsheet is called: a) idel cell b) active cell c) passive cell d) present cell 7 / 28 7. Which feature in spreadsheet software allows users to visually represent data using graphs and charts? a) AutoSum b) Autofilter c) PivotTable d) Conditional Format 8 / 28 8. Which of the following is a valid file extensiion for a spreadsheet file? a) .docx b) .xlsx c) .ppt d) .jpg 9 / 28 9. Calling a cell in MS excel by just their addresses (like, A5) is called: a) Named range b) labeling c) Relative referencing d) Absolute Referencing 10 / 28 10. The vertical dimension of spreadsheet is called: a) field b) record c) row d) column 11 / 28 11. How many worksheet are contained in a workbook by deault? a) 3 b) 4 c) 5 d) 6 12 / 28 12. Which of the following is correct column address a) AA b) 23 c) 5 d) C4 13 / 28 13. A workbook is a group of: a) Tables b) formulas c) sheets d) functions 14 / 28 14. The function that is used to get maximum value is: a) MIN b) MAX c) Minmum d) Maximum 15 / 28 15. Default name of first sheet in any workbook is: a) one b) sheet 1 c) sheet one d) First sheet 16 / 28 16. The default number format assigned to a cell is: a) Currency b) Number c) Text d) General 17 / 28 17. Formula can only be applied on: a) label b) value c) Both A and B d) none of these 18 / 28 18. Which of the following is an absolute address for "C2"? a) $C2 b) C$2 c) $C2$ d) $C$2 19 / 28 19. Which of the following is an absolute address? a) A1$ b) A$1 c) $A$1 d) none of these 20 / 28 20. The actual working area in Microsoft Excel is: a) Workbook b) Worksheet c) Spreadsheet d) Notesheet 21 / 28 21. Which of the following is a spreadsheet? a) MS word b) MS Power Point c) Note Sheet d) MS Excel 22 / 28 22. A formula in Excel always begins with: a) # b) = c) : d) $ 23 / 28 23. The number of argument in SQRT() function in MS excel: a) 1 b) 2 c) 3 d) 4 24 / 28 24. The cell range from A3 to G3 should be written as: a) A3-G3 b) A3,G3 c) A3:G3 d) A3 and G3 25 / 28 25. The function that is used to get the smallest value is: a) MAX b) MIN c) MAXIMUM d) MINIMUM 26 / 28 26. In spreadsheet by default columns are labelled by: a) number b) Letters c) Text d) symbols 27 / 28 27. In spreadsheet by default row are labelled by: a) Letters b) symbols c) Text d) Number 28 / 28 28. Which of the following function is used to get the current date? a) Exact() b) Today() c) Month() d) Year() Your score isThe average score is 75% 0% Restart quiz Helpful? Share with friends
