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 7 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 7 Computer Science Chapter 4 Ms Excel (Spreadsheet) Quiz 7 (60 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. Where can you enter or edit data, functions, and formulas in Excel? A) Name Box. B) Men's menu. C) Title Bar. D) Formula Bar. Show Answer Correct Answer: D) Formula Bar. 2. The list contains an overview of a number of information data that is usually in the form of words and numbers arranged with a barrier as a column, namely ..... A) Function. B) Diagram. C) Table. D) Formula. E) Database. Show Answer Correct Answer: C) Table. 3. Proses Freeze berada pada butang ..... dalam Menu Bar Excell. A) DATA. B) REVIEW. C) VIEW. D) FORMULAS. Show Answer Correct Answer: C) VIEW. 4. The total number of rows in Ms.Excel ..... A) 65535. B) 65636. C) 65536. D) 66535. Show Answer Correct Answer: C) 65536. 5. By default, the text is: A) Center Aligned. B) Left Aligned. C) Justify. D) Right Aligned. Show Answer Correct Answer: B) Left Aligned. 6. Which step is to replace the correct sheet name ..... A) Double click on the file then rename. B) Select Ms.Office Select MS.Excel select Rename. C) Double click on sheet 1 then change the name sheet. D) Select Sheet 1 Right Click Copy. Show Answer Correct Answer: C) Double click on sheet 1 then change the name sheet. 7. The number processing application program worksheet is ..... A) Table. B) Worksheet. C) Grid. D) Word Document. Show Answer Correct Answer: B) Worksheet. 8. The feature to center text across several cells is called: A) Wrap Text. B) Merge and Center. C) Shrink to Fit. D) Number Formatting. Show Answer Correct Answer: B) Merge and Center. 9. A document consisting of several sheets in MS.Excel is called ..... A) Worksheet. B) Workbook. C) Sheet. D) Spreadsheet. Show Answer Correct Answer: B) Workbook. 10. Which function calculates the average of a given set of numbers? A) SUM(). B) Average(). C) AVG(). D) All. Show Answer Correct Answer: B) Average(). 11. In a cell reference, for example B2, what does the letter refer to? A) The spreadsheet the cell is in. B) The column the cell is in. C) The worksheet the cell is in. D) The row the cell is in. Show Answer Correct Answer: B) The column the cell is in. 12. A formula in a spreadsheet always starts with which symbol? A) /. B) +. C) =. D) (. Show Answer Correct Answer: C) =. 13. What is the keyboard shortcut to save a workbook in Excel? A) Ctrl + O. B) Ctrl + S. C) Ctrl + P. D) Ctrl + N. Show Answer Correct Answer: B) Ctrl + S. 14. How can we type special number in cell A) Type hulk the strongest avenger. B) Using apostrophe. C) Using caps lock. D) Using colon. Show Answer Correct Answer: B) Using apostrophe. 15. Which option in Excel allows you to make better decisions and create beautiful, interactive reports? A) Pivot Chart. B) Pivot Table. C) Power View. D) Sparklines. Show Answer Correct Answer: C) Power View. 16. Cells that run horizontally on a spreadsheet are know as A) Row. B) Range. C) Column. D) Workbook. Show Answer Correct Answer: A) Row. 17. What is a sheet in Excel? A) A single spreadsheet that typically contains labels, values, formulas, functions, and graphical representations of data. B) A single document that typically contains labels, values, formulas, functions, and graphical representations of data. C) A single file that typically contains labels, values, formulas, functions, and graphical representations of data. D) None of the above. Show Answer Correct Answer: A) A single spreadsheet that typically contains labels, values, formulas, functions, and graphical representations of data. 18. Which function is used to count the numeric values in a range? A) Add( ). B) Total ( ). C) Count( ). D) Count numbers( ). Show Answer Correct Answer: C) Count( ). 19. What symbol is used to divide? A) +. B) /. C) *. D) -. Show Answer Correct Answer: B) /. 20. MS EXCEL IS A SPREADSHEET PROGRAM THAT ALLOWS YOU TO ..... , ..... AND ..... INFORMATION. A) ANALYZE-FORMAT-STORE. B) EDIT-DELETE-FORMAT. C) STORE-ORGANIZE-ANALYZE. D) PRESENT-STORE-EDIT. Show Answer Correct Answer: C) STORE-ORGANIZE-ANALYZE. 21. No. of Columns in Excel 2016 A) 16384. B) 65636. C) 16000. D) 256. Show Answer Correct Answer: A) 16384. 22. A line chart is consists of a circle divided with a number of segments which represent the value of the data A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: B) False. 23. The area where the writing excel formula is called ..... A) Formula bar. B) Toolbar. C) Bar menu. D) Tittle bar. Show Answer Correct Answer: A) Formula bar. 24. The predefined keywords to do mathematical calculations are A) The cell address. B) Functions. C) Formula. D) Formatting. Show Answer Correct Answer: B) Functions. 25. When we are working with Excel, descriptions of pages, lines, columns and others can be seen on ..... A) Format Bar. B) Status Bar. C) Men's menu. D) Toolbar. Show Answer Correct Answer: B) Status Bar. 26. In MS-Excel, how many rows per sheet? A) One million forty-eight thousand four hundred seventy-six. B) One million forty-eight thousand five hundred seventy-six. C) One million forty-eight thousand six hundred seventy-six. D) One million forty-eight thousand seven hundred seventy-six. Show Answer Correct Answer: B) One million forty-eight thousand five hundred seventy-six. 27. A header is printed in the ..... margin A) Top. B) Bottom. C) Right. D) Left. Show Answer Correct Answer: A) Top. 28. Group of cells that runs horizontally. A) Row. B) Cell address. C) Cell. D) Column. Show Answer Correct Answer: A) Row. 29. No. of Rows in Excel 2016 A) 65636. B) 256. C) 1048576. D) 104856. Show Answer Correct Answer: C) 1048576. 30. This symbol must be typed first to use a formula. A) Function. B) FX. C) Plus Sign. D) Equal Sign. Show Answer Correct Answer: D) Equal Sign. 31. The following is a way that we can use to integrate Word and Excel applications, except ..... A) Clipboard. B) Cut, Copy, Paste. C) Object Linking. D) Insert Chart. Show Answer Correct Answer: A) Clipboard. 32. Which key combination will help you to select the entire row of the active cell? A) Ctrl + Spacebar. B) Alt + Spacebar. C) Ctrl + Tab. D) Shift + Spacebar. Show Answer Correct Answer: D) Shift + Spacebar. 33. What key should you use to take you to the cell to the right A) Tab key. B) Right arrow key. C) Just click in it. D) None of the above. Show Answer Correct Answer: A) Tab key. 34. What would be a correct formula for sum in excel? A) = Sum (B3:B9). B) = Small+Bass. C) Sum (B3:B9). D) = Number (Baa:Bass). Show Answer Correct Answer: A) = Sum (B3:B9). 35. The meeting between the row and the column in Ms.Excel is called ..... A) Baris (row). B) Range. C) Kolom (column). D) Sel (cell). Show Answer Correct Answer: D) Sel (cell). 36. The horizontal placement of cells in a table or worksheet. A) Range. B) Row. C) Cell. D) Column. Show Answer Correct Answer: B) Row. 37. A program that displays data (text & numbers) in a table called a worksheet is known as ..... A) Sheet tab. B) Worksheet. C) Spreadsheet. D) Workbook. Show Answer Correct Answer: C) Spreadsheet. 38. To get Rows and Columns in Microsoft Word we need to choose: A) Table and insert. B) Insert and Symbol. C) Tools dan Customize. D) Format and position. Show Answer Correct Answer: A) Table and insert. 39. Microsoft originally marketed spreadsheet program called ..... A) Multiplan. B) Built in functions. C) Arguments. D) None of the above. Show Answer Correct Answer: A) Multiplan. 40. How to create a new workbook by using the order ..... A) File$\rightarrow$ save. B) File $\rightarrow$ close. C) Filet $\rightarrow$ new. D) File $\rightarrow$ new $\rightarrow$ spreadsheet. E) File $\rightarrow$ exit. Show Answer Correct Answer: C) Filet $\rightarrow$ new. 41. What are the vertical ranges of cells that are labeled by letters? A) Row. B) Column. C) Menus. D) None of the above. Show Answer Correct Answer: B) Column. 42. Columns on a spreadsheet are identified by a ..... A) Letter. B) Number. C) Space. D) Smiley face. Show Answer Correct Answer: A) Letter. 43. Formulas are user defined instructions to perform calculations. A) True. B) False. C) All the above. D) None of the above. Show Answer Correct Answer: A) True. 44. We can enter ..... types of data in a worksheet. A) Two. B) Three. C) Four. D) None of the above. Show Answer Correct Answer: B) Three. 45. Which of the following is NOT something we use in Excel? A) Cell. B) Value. C) Toy. D) Label. Show Answer Correct Answer: C) Toy. 46. The button used to type text with capital letters is all ..... A) Caps Lock. B) Space Bar. C) Scroll Lock. D) Num Lock. Show Answer Correct Answer: A) Caps Lock. 47. Multiple arguments must be separated by a ..... A) Colon. B) Space. C) Comma. D) Semicolon. Show Answer Correct Answer: C) Comma. 48. Which of these is a label? A) Red. B) 4. C) 100. D) 13. Show Answer Correct Answer: A) Red. 49. If you click on a letter at the top of an Excel spreadsheet, what have you done? A) Selected a range of cells. B) Selected a cell. C) Selected a row of data. D) Selected a column of data. Show Answer Correct Answer: D) Selected a column of data. 50. Filter Option is Available in A) Home Ribbon. B) Data Ribbon. C) Both. D) None. Show Answer Correct Answer: C) Both. 51. How can you sum the values in cells A1 through A10 in Excel? A) =TOTAL(A1:A10). B) =ADD(A1:A10). C) = Sums (A1:A10). D) =SUM(A1:A10). Show Answer Correct Answer: D) =SUM(A1:A10). 52. Which of the following is a formula that will multiply cells A1 and A2? A) =Multiply(A1:A2). B) = A 1*aa. C) = A 1:aa. D) A 1*aa. Show Answer Correct Answer: B) = A 1*aa. 53. Which chart should you use to show changes over time? A) Line. B) Bar. C) Scatter. D) Pie. Show Answer Correct Answer: A) Line. 54. Make letters, make tables, make writing with various variations (word art), enter images, and make documents.This can be completed using the application ..... A) Ms power point. B) Ms word. C) Ms excel. D) Ms access. E) Ms outlook. Show Answer Correct Answer: B) Ms word. 55. The following are features of social media, except ..... A) The message delivered tends to be faster than the others. B) The recipient of the message that determines the time to interact. C) Social media is a closed information media. D) Messages delivered free without going through filters. Show Answer Correct Answer: C) Social media is a closed information media. 56. It is known that in a column A table contains NO, column B contains names, column C contains theory value, column D contains the value of practical, column E containing the amount.To calculate the number of students taking the computer exam from the table is ..... A) = Connea (Ba Pur). B) = Fasting (Akh h). C) = Contef (Ba ). D) = Am (BZ bst). E) =COUNT(B3 B7). Show Answer Correct Answer: A) = Connea (Ba Pur). 57. The application program used for processing numbers, tables and graphics is called ..... A) Of the. B) Ms-Excel. C) Ms-Word. D) Ms-Office. E) Windows. Show Answer Correct Answer: B) Ms-Excel. 58. Shortcut that works for storing data is ..... A) Ctrl + U. B) Ctrl + O. C) Ctrl + S. D) Ctrl + P. Show Answer Correct Answer: C) Ctrl + S. 59. In Excel, which one denoted a range from B1 through E5 A) B1-E5. B) B1 to e5. C) B1:E5. D) B1 $ E5. Show Answer Correct Answer: C) B1:E5. 60. The spreadsheet worksheet section identified using the letter A-XFD is called ..... A) Cell. B) Sheet. C) Line. D) Column. Show Answer Correct Answer: D) Column. ← 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 5Class 7 Computer Science Chapter 4 Ms Excel (Spreadsheet) Quiz 6Class 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