This quiz works best with JavaScript enabled. Home > Cbse > Class 7 > Computer Science > Ms Excel Spreadsheet > Class 7 Computer Science Chapter 4 Ms Excel (Spreadsheet) – Quiz 5 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 7 Computer Science Chapter 4 Ms Excel (Spreadsheet) Quiz 5 (60 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. What combines one or more cells? A) Merge. B) Wrap text. C) Cell address. D) None of the above. Show Answer Correct Answer: A) Merge. 2. Select ..... from the functions menu to find the smallest value in a group. A) Average. B) Min. C) Max. D) Sum. Show Answer Correct Answer: B) Min. 3. Which among following first generation of computers had? A) Vaccum Tubes and Magnetic Drum. B) Integrated Circuits. C) Magnetic Tape and Transistors. D) All of above. Show Answer Correct Answer: A) Vaccum Tubes and Magnetic Drum. 4. Double-clicking between two columns will ..... the column. A) Delete. B) Fill. C) Copy. D) Resize. Show Answer Correct Answer: D) Resize. 5. The following is not a Microsoft PowerPoint menu is ..... A) View. B) Animations. C) Edit. D) Home. Show Answer Correct Answer: C) Edit. 6. What is the extension of an Excel file? A) .pptx. B) .xlsx. C) .docx. D) .bmp. Show Answer Correct Answer: B) .xlsx. 7. Data obtained from various data sources directly called ..... A) Primer. B) Seconds. C) Quantitative. D) Qualitative. Show Answer Correct Answer: B) Seconds. 8. Sorting data rising from A-Z is called ..... A) Ascending. B) Shorting. C) Descending. D) Numbering. E) Filtering. Show Answer Correct Answer: A) Ascending. 9. Which of the following methods cannot be used to enter data in a cell A) Clicking on the formula bar. B) Pressing the Esc key. C) Pressing the Tab key. D) Pressing an arrow key. Show Answer Correct Answer: B) Pressing the Esc key. 10. A file in MS Excel is called a ..... A) Workbook. B) Worksheet. C) All the above. D) None of the above. Show Answer Correct Answer: A) Workbook. 11. Microsoft Excel is an application program A) Presentation. B) Spreadsheet. C) Wordprosesor. D) Animation. Show Answer Correct Answer: B) Spreadsheet. 12. PIXLR is a ..... A) Photo editor. B) Spreadsheet. C) Video editor. D) System software. Show Answer Correct Answer: A) Photo editor. 13. You can select the current column in MS-Excel Worksheet by pressing? A) Shift + arrow key. B) Ctrl + Space bar. C) Shift + Space bar. D) F8 + arrow key. Show Answer Correct Answer: B) Ctrl + Space bar. 14. Which of the following is the correct cell address? A) A1. B) Dad. C) AA11. D) None of the above. Show Answer Correct Answer: A) A1. 15. Which of these is a value? A) Cat. B) 8. C) Blue. D) Name. Show Answer Correct Answer: B) 8. 16. Which tab in Excel is used for formatting? A) Home. B) Insert. C) Data. D) None of the above. Show Answer Correct Answer: A) Home. 17. Who is the father of Computers? A) James Gosling. B) Bjarne Stroustrup. C) Dennis Ritchie. D) Charles Babbage. Show Answer Correct Answer: D) Charles Babbage. 18. MS Excel is a popular ..... A) Word processor. B) Presentation software. C) Spreadsheet software. D) None of the above. Show Answer Correct Answer: C) Spreadsheet software. 19. How many columns in Microsoft Excell A) 256 columns. B) 25, 600 columns. C) 2, 560 columns. D) Infinite. Show Answer Correct Answer: A) 256 columns. 20. A spreadsheet is a sheet which is spread in such a way that it divides itself into the various ..... and ..... A) Horizontal columns, vertical row. B) Horizontal cell, vertical table. C) Horizontal table, vertical cell. D) Horizontal row, vertical columns. Show Answer Correct Answer: D) Horizontal row, vertical columns. 21. The built-in Formulae in MS Excel are known as ..... A) Syntax. B) Formulae. C) Functions. D) None of the above. Show Answer Correct Answer: C) Functions. 22. A page of Excel file is called a ..... A) Worksheet. B) Workbook. C) All the above. D) None of the above. Show Answer Correct Answer: A) Worksheet. 23. The bottom of the Excel window appears with A) Tab sheet. B) Sheet work. C) Sheet tab. D) None of the above. Show Answer Correct Answer: C) Sheet tab. 24. Is an intersection of row and column A) Cell address. B) Column. C) Row. D) Cell. Show Answer Correct Answer: D) Cell. 25. The Greater Than sign (>) is an example of ..... operator. A) Logical. B) Conditional. C) Greater. D) Arithmatic. Show Answer Correct Answer: A) Logical. 26. What are predefined formulae in MS-Excel called? A) Parentheses. B) Range. C) Operators. D) Function. Show Answer Correct Answer: D) Function. 27. Which key should be used to move to the left of the cell A) Enter key. B) Tab key. C) Shift+ Tab key. D) Shift+ Enter key. Show Answer Correct Answer: C) Shift+ Tab key. 28. Tameka wants to change the orientation of her spreadsheet from landscape to portrait. On which tab of the Excel ribbon will this command be found? A) Formulas Page. B) Insert Page. C) Page Layout. D) Review. Show Answer Correct Answer: C) Page Layout. 29. A ..... is the intersection of a row and column. A) Box. B) Cell. C) Pointer. D) None of the above. Show Answer Correct Answer: B) Cell. 30. Gridlines and formula bar which tab in MS Excel? A) Data Tab. B) Page Layout. C) Home Tab. D) View Tab. E) Insert Tab. Show Answer Correct Answer: D) View Tab. 31. Which symbol must you use to begin a formula? A) *. B) =. C) +. D) /. Show Answer Correct Answer: B) =. 32. Intersection of a row and a column in excel is called a ..... A) Value. B) Address. C) Cell. D) None of the above. Show Answer Correct Answer: C) Cell. 33. Which is NOT a term used in Excel? A) Document. B) Worksheet. C) Workbook. D) Cell. Show Answer Correct Answer: A) Document. 34. Tables can be made using the format command, Cells followed by ..... A) Protection. B) Pattern. C) Border. D) Font. E) Number. Show Answer Correct Answer: C) Border. 35. Absolute references are created by using A) %. B) #. C) @. D) $. Show Answer Correct Answer: D) $. 36. Which is not included in the components in MS.Excel is ..... A) Subscribe. B) Ribbon menu. C) Column. D) Sel. Show Answer Correct Answer: A) Subscribe. 37. What is name of last column? A) XDF. B) XF. C) XFD. D) XZ. Show Answer Correct Answer: C) XFD. 38. What type of chart is useful for showing trends or changes over time? A) Line Chart. B) Column Chart. C) Pie Chart. D) Dot Graph. Show Answer Correct Answer: A) Line Chart. 39. In Ms Excel you can change the colour of the cell using fill colour tool. A) False. B) True. C) All the above. D) None of the above. Show Answer Correct Answer: B) True. 40. Samantha needs to total the values in cells A1 to A10. What is the most efficient method to find the answer? A) Value. B) Function. C) Label. D) Formula. Show Answer Correct Answer: B) Function. 41. Numbers in Excel are known as ..... A) Values. B) Labels. C) Numbers. D) None of the above. Show Answer Correct Answer: A) Values. 42. What is meant by the basic formula in Excel? A) The formula used to delete data in Excel. B) The formula used to combine cells in Excel. C) The formula used to change the appearance of cells in Excel. D) The formula used to do mathematical calculations or data manipulation in Excel cells. Show Answer Correct Answer: D) The formula used to do mathematical calculations or data manipulation in Excel cells. 43. ..... is an another name of spreadsheet. A) Worksheet. B) Workbook. C) Cell. D) Both (a) and (b). Show Answer Correct Answer: A) Worksheet. 44. To carry on the data over the coloumn we use A) Fill it now feature. B) Fill Handle feature. C) All the above. D) None of the above. Show Answer Correct Answer: B) Fill Handle feature. 45. Which of the following is not a correct cell address? A) May. B) Ah. C) BB15. D) All of the above. Show Answer Correct Answer: A) May. 46. You can select the current row in MS-Excel Worksheet by pressing? A) Shift + Space bar. B) F8 + arrow key. C) Shift + arrow key. D) Ctrl + Space bar. Show Answer Correct Answer: A) Shift + Space bar. 47. Various programs that contain related instructions to operate computers or related hardware are ..... A) Software. B) Touch Pad. C) Hard Disk. D) Hardware. E) Flash Disk. Show Answer Correct Answer: A) Software. 48. What is the default justification for cells formatted as labels? A) Right aligned. B) 1 inch. C) Left aligned. D) Center. Show Answer Correct Answer: C) Left aligned. 49. Full form of URL is? A) Uniform Resource Locator. B) Uniform Registered Link. C) Unified Resource Link. D) Uniform Resource Link. Show Answer Correct Answer: A) Uniform Resource Locator. 50. Excel Function Addition Using Formula ..... A) MAX. B) MIN. C) AVERAGE. D) SUM. Show Answer Correct Answer: D) SUM. 51. What specific format would change 2.5 to £2.50? A) Number. B) Time. C) Date. D) Currency. Show Answer Correct Answer: D) Currency. 52. A range always ..... in shape A) Rectangle. B) Triangle. C) I don't care. D) Square. Show Answer Correct Answer: A) Rectangle. 53. Computer hardware is also called ..... A) Hardware. B) Software. C) Malware. D) Brainware. Show Answer Correct Answer: A) Hardware. 54. Animated ..... are the images that move. A) Video. B) Image. C) GIF. D) Movie. Show Answer Correct Answer: C) GIF. 55. What does the Countif formula return? A) Counts the number of words within a range that meets the given condition. B) Counts the number of columns within a range that meets the given condition. C) Counts the number of letters within a range that meets the given condition. D) Counts the number of cells within a range that meets the given condition. Show Answer Correct Answer: D) Counts the number of cells within a range that meets the given condition. 56. What does HTML stand for A) HyperText Markup Language. B) Hyper Typed Markup Language. C) HyperTenson Markup Language. D) HyperTense Markup Language. Show Answer Correct Answer: A) HyperText Markup Language. 57. MS Word's advanced features that can be used to make the same letter, but have several different components such as names and addresses are ..... A) Copy paste. B) Mail merge. C) Object linking. D) Embedding. E) Cut paste. Show Answer Correct Answer: B) Mail merge. 58. In MS Excel a formula should always start with ..... sign. A) +. B) /. C) =. D) X. Show Answer Correct Answer: C) =. 59. Which tab in Excel has charts and tables? A) Home. B) Insert. C) File. D) Review. Show Answer Correct Answer: B) Insert. 60. Which part displays the location of a cell in a worksheet? A) Title bar. B) Name box. C) Ribbon. D) None of the above. Show Answer Correct Answer: B) Name box. ← PreviousNext →Related QuizzesComputer Science QuizzesClass 7 QuizzesClass 7 Computer Science Chapter 4 Ms Excel (Spreadsheet) Quiz 1Class 7 Computer Science Chapter 4 Ms Excel (Spreadsheet) Quiz 2Class 7 Computer Science Chapter 4 Ms Excel (Spreadsheet) Quiz 3Class 7 Computer Science Chapter 4 Ms Excel (Spreadsheet) Quiz 4Class 7 Computer Science Chapter 4 Ms Excel (Spreadsheet) Quiz 6Class 7 Computer Science Chapter 4 Ms Excel (Spreadsheet) Quiz 7Class 7 Computer Science Chapter 4 Ms Excel (Spreadsheet) Quiz 8Class 7 Computer Science Chapter 4 Ms Excel (Spreadsheet) Quiz 9 🏠 Back to Homepage 📘 Download PDF Books 📕 Premium PDF Books