This quiz works best with JavaScript enabled. Home > Class 7 > Class 7 Computer Science Chapter 4 Ms Excel (Spreadsheet) – Quiz 17 🏠 Homepage 📘 Download PDF Books 📕 Premium PDF Books Class 7 Computer Science Chapter 4 Ms Excel (Spreadsheet) Quiz 17 (25 MCQs) Quiz Instructions Select an option to see the correct answer instantly. 1. Which key combination will help you to select the entire row of the active cell? A) Ctrl + Tab. B) Ctrl + Spacebar. C) Shift + Spacebar. D) Alt + Spacebar. Show Answer Correct Answer: C) Shift + Spacebar. 2. 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. 3. 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). 4. What is data? A) Is a graph. B) Is a formula. C) Is the cell address. D) Is information which is entered and used to perform calculations. Show Answer Correct Answer: D) Is information which is entered and used to perform calculations. 5. The meeting between the row and the column in Ms.Excel is called ..... A) Baris (row). B) Kolom (column). C) Sel (cell). D) Range. Show Answer Correct Answer: C) Sel (cell). 6. The horizontal placement of cells in a table or worksheet. A) Range. B) Row. C) Column. D) Cell. Show Answer Correct Answer: B) Row. 7. A program that displays data (text & numbers) in a table called a worksheet is known as ..... A) Workbook. B) Worksheet. C) Spreadsheet. D) Sheet tab. Show Answer Correct Answer: C) Spreadsheet. 8. 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. 9. 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. 10. How to create a new workbook by using the order ..... A) Filet $\rightarrow$ new. B) File $\rightarrow$ new $\rightarrow$ spreadsheet. C) File $\rightarrow$ close. D) File$\rightarrow$ save. E) File $\rightarrow$ exit. Show Answer Correct Answer: A) Filet $\rightarrow$ new. 11. 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. 12. Columns on a spreadsheet are identified by a ..... A) Number. B) Letter. C) Space. D) Smiley face. Show Answer Correct Answer: B) Letter. 13. 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. 14. 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. 15. Which of the following is NOT something we use in Excel? A) Cell. B) Label. C) Value. D) Toy. Show Answer Correct Answer: D) Toy. 16. The button used to type text with capital letters is all ..... A) Space Bar. B) Caps Lock. C) Num Lock. D) Scroll Lock. Show Answer Correct Answer: B) Caps Lock. 17. Full of USB is? A) Universal Serial Bus. B) Universal Serious Bus. C) Universal Serial Black. D) Universal Series Bus. Show Answer Correct Answer: A) Universal Serial Bus. 18. Multiple arguments must be separated by a ..... A) Space. B) Comma. C) Colon. D) Semicolon. Show Answer Correct Answer: B) Comma. 19. Which of these is a label? A) 13. B) 4. C) Red. D) 100. Show Answer Correct Answer: C) Red. 20. If you click on a letter at the top of an Excel spreadsheet, what have you done? A) Selected a cell. B) Selected a range of cells. C) Selected a row of data. D) Selected a column of data. Show Answer Correct Answer: D) Selected a column of data. 21. Filter Option is Available in A) Home Ribbon. B) Data Ribbon. C) Both. D) None. Show Answer Correct Answer: C) Both. 22. How can you sum the values in cells A1 through A10 in Excel? A) =SUM(A1:A10). B) =TOTAL(A1:A10). C) =ADD(A1:A10). D) = Sums (A1:A10). Show Answer Correct Answer: A) =SUM(A1:A10). 23. Which of the following is a formula that will multiply cells A1 and A2? A) A 1*aa. B) = A 1:aa. C) = A 1*aa. D) =Multiply(A1:A2). Show Answer Correct Answer: C) = A 1*aa. 24. Which chart should you use to show changes over time? A) Line. B) Scatter. C) Pie. D) Bar. Show Answer Correct Answer: A) Line. 25. 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 word. B) Ms excel. C) Ms access. D) Ms power point. E) Ms outlook. Show Answer Correct Answer: A) Ms word. ← PreviousNext →Related 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 7Class 7 Computer Science Chapter 4 Ms Excel (Spreadsheet) Quiz 8Class 7 Computer Science Chapter 4 Ms Excel (Spreadsheet) Quiz 9Class 7 Computer Science Chapter 4 Ms Excel (Spreadsheet) Quiz 10 🏠 Back to Homepage 📘 Download PDF Books 📕 Premium PDF Books