Electronic Spreadsheet – Set 7 January 28, 2025 by aasi Home › Computer › MS Excel MS Excel Electronic Spreadsheet – Set 7 📝 Model Practice Set ⚡ Instant Answers & Explanation 🎯 Exam Oriented 0% Report a question What’s wrong with this question? You cannot submit an empty report. Please add some details. 1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950 Electronic Spreadsheet – Set 7 Dear ! This is Electronic Spreadsheet – Set 7 Quiz and it contains 50 questions. Keep Learning! 1 / 50 1) Excel is a good application for what IF analysis. Which of the following tool help you for this? Formula Auditing Research Track change Goal seek 2 / 50 2) You can set Excel in Automatic or Manual calculation mode. If it is in manual mode which key you will press to update the formula values? F9 F5 F8 F11 3 / 50 3) Which of the following is tool you will use in Excel to see what must be the value of a cell to get required result ? Formula Auditing Research Track change Goal seek 4 / 50 4) By default excel provides 3 worksheets. you need only two of them , how will you delete the third one ? Right click on sheet tab of third sheet and choose Delete from the context menu Click on Sheet 3 and from Edit menu choose Delete Both of these None of these 5 / 50 5) The command edit >> Fill Across Worksheet is active only when One sheet is selected When many sheets are selected When no sheet is selected None of these 6 / 50 6) Whats is the short cut key to replace a data with another in sheet? Ctrl + R Ctrl + Shift + R Ctrl + H Ctrl + F 7 / 50 7) What happens when you press Ctrl + x after selecting some cells in Excel ? The cell content of selected cells disappear from cell and stored in clipboard The cells selected are marked for cutting The selected cells are deleted and cells are shifted left The selected cells are deleted and cells are shifted up 8 / 50 8) The default font size in Excel worksheet is? 10 Points 12 Points 14 Points None of these 9 / 50 9) When you enter Sunday and fill right, Excel fill in with Monday, Tuesday and so on. From where Excel knows what to fill in next? AutoComplete AutoFormat Custom List Calculation Automatic 10 / 50 10) Which of the following is invalid regarding the protection in Excel? Protect sheet Protect workbook Protect Workspace All of these 11 / 50 11) Which of the following is not true about Find and Replace in Excel you can search for bold and replace with italics you can decide whether to look for whole word or not You can search in formula too you can search by rows or columns or sheets 12 / 50 12) Which of the following is not What IF analysis tool in Excel? Goal seek Scenarios Macros None of these 13 / 50 13) The Trace Dependence in auditing shows Which cells are used in current formula In which formula the current cell is used Which cells are used in this formula and in which formula this cell is used None of these 14 / 50 14) You can move a sheet from one workbook into new book by From Edit menu choose move or copy , mark the Create a copy and Click ok From Edit menu choose Move or Copy then choose (Move to end) and click ok From Edit menu choose Move or Copy then select (new books) from to Book list and click ok None of these 15 / 50 15) The shortcut key Ctrl+R is used in Excel to? Right align the content of cell Remove the cell contents of selected cells Fill the selection with active cells to the right None of these 16 / 50 16) Each file in a MS Excel is known as? Work sheet Data sheet EX Book Work Book 17 / 50 17) If you need to remove only the formatting done in a range (numbers and formula typed there should not be removed), you must Edit menu choose Clear and then formats From Edit menu choose Delete Click on Remove Formatting tool on standard Toolbar Double click the Format painter and then press Esc key in keyboard 18 / 50 18) It is acceptable to let long text flow into adjacent cells on a worksheet when data will be entered in the adjacent cells no data will be entered in the adjacent cells There is no suitable abbreviation for the text there is not time to format the text 19 / 50 19) Which of the following option is not available in paste special dialog box? Add Subtract Divide SQRT 20 / 50 20) When all the number between 0 and 100 in a range should be displayed in Red Color , apply Use = if() function to format the required numbers red Apply Conditional Formatting command on Format menu you can apply Font , border and pattern formats that meets the specified conditions you can delete any condition from conditional Formatting dialog box if it not required 21 / 50 21) Edit>> Delete command ? Delete the content of a cell Deletes formats of cell Deletes the command of cell Deletes selected cells 22 / 50 22) Which tool you will use to join some cells and place the content at the middle of joined cell ? From Format cells dialog box click on merge cells check box From Format Cells dialog box select the Cantered alignment From Format cells dialog box choose merge and centre check box Click on Merge and centre tool on formatting toolbar 23 / 50 23) Long text can be broken down into many lines within a cell. You can do this through ? Wrap Text in Format>> Cells Justify in Edit>>Cells Text Wrapping in Format>>Cells,Layout tab All of these 24 / 50 24) Which of the following Excel screen components can NOT be turned on or off? Formula bar Status bar Tool bar None of these 25 / 50 25) To remove the content of selected cells you must issue ——— command . Edit >> Delete Edit >> Clear >> Content Edit >> clear >> All Data >> delete 26 / 50 26) Where can you set the shedding color for a range of cell in excel ? Choose required color form for a range of cells in excel ? Choose required color on Fill Color tool in Formatting toolbar choose required color on Fill tool in drawing toolbar All of these 27 / 50 27) Which command will you choose to convert a column of data into row? Cut and Paste Edit>>Paste Special>>Transpose Both of these None of these 28 / 50 28) If you need to remove only the formatting done in a range (number and formula typed should not be removed) , you must From Edit menu choose Clear and then Format From Edit menu choose delete Click on Remove Formatting tool on standard Toolbar Double click the Format Painter and then press Esc key in keyboard 29 / 50 29) By default there are……….worksheets in an Excel file? 2 3 4 5 30 / 50 30) MS Excel provides the default value for step in fill series dialog box 1 5 10 31 / 50 31) When a row of data is to be converted into columns Copy the cells in row , select the same number of cells in row and paste Copy the cells in column then choose Edit >> paste Special , then click Transpose and ok Copy the cells then go to Format >> cells then on Alignment tab click Transpose check box and click ok Select the cells then place the cell pointer on new cell and choose Edit >> paste Special , mark Transpose check box and click ok 32 / 50 32) you want to set such that when you type Baishakh and drag the fill handle , excel should produce Jestha , Aashdh and soon . what will you set to affect that Custom List Auto Fill Options Fill Across Worksheet Fill Series 33 / 50 33) Which of the following option is not available to remove arrows of Formula Auditing remove all precedent arrows Remove all dependent arrows Remove all arrows Remove all arrows for this cell 34 / 50 34) Which of the following is invalid statement ? Sheet tabs can be colored Some picture can be applied as a background of a sheet You can sheet the column width automatically fit the amount of text The width of a row and be specified manually or fit automatically 35 / 50 35) Which of the following series type is not valid for fill series dialog box? Linear Growth Auto fill Time X 36 / 50 36) The……..in Excel 2007 replaces the menus and toolbars found in earlier versions of Excel? Office button Ribbon Quick Access toolbar None of these 37 / 50 37) While Finding and Replacing some data in Excel , which of the following statement is valid ? a. you can find and replace within the sheet or workbook b. Excel does not have option to match case for find c. Both(a) and (b) are valid d. None are valid 38 / 50 38) The Trace precedence in auditing shows Which cells are used in current formula In Which formula the current cell is used Which cells are used in this formula and in which formula this cell is used None of these 39 / 50 39) The arrows create by Auditing can be removed by Click on the arrow and press Delete Click on Remove All of arrows on Formula Auditing toolbar Both of these None of these 40 / 50 40) Which of the following action removes a sheet from worksheet ? Select the sheet , then choose Edit >> Delete sheet Select the sheet then choose Format >> Sheet >> Hide Both of these None of these 41 / 50 41) When you start typing the same value as of some cells on same column, Excel automatically shows that text, This feature is known as? AutoFill AutoCorrect AutoComplete AutoFormat 42 / 50 42) Paste special allows some operation while you paste to new cell. Which of the following operation is valid? Squre Percentage Goal Seek Divide 43 / 50 43) Which of the cell pointer indicates you that you can make selection ? Doctors symbol (Big Plus) Small thin plus icon Mouse pointer with anchor at the tip None of these 44 / 50 44) Which of the cell pointer indicate that you can move the content to other cell? Doctors symbol (Big Plus) Small thin plus icon Mouse pointer with anchor at thw tip None of thesw 45 / 50 45) you can auto fit the width of column by Double clicking on the column the name on column header Double click on the cell pointer in worksheet Double clicking on column right border on column header Double clicking on the column left border of column header 46 / 50 46) The default font used in Excel is? Arial Algerial Times New Roman Calibri 47 / 50 47) We can make a cell address an absolute cell address by placing a sign in front of the row and column identifiers? Doctor sign(+) Rate sign (@) Dollar sign ($) Hash sign(#) 48 / 50 48) Paste Special allows some operation while you paste to new cell . which of the following operation is valid ? Square Percentage Goal Seek Divide 49 / 50 49) Ctrl+D shortcut key in Excel will? Open the font dialog box Apply double underline for the active cell Fill down in the selection None of these 50 / 50 50) Which of the following you can paste selectively using Paste Special command? Validation Formats Formulas All of these Your score isThe average score is 0%🎉 Challenge alert! 💡 Share this quiz with your friends and see who scores the highest! 🏆🤩🔥 LinkedIn Facebook Follow Us @ 0% Restart quiz Exit We’d love to hear your thoughts! 📝 Share your valuable review with us. 🙌 🌟 Thank you for your support! Your feedback means the world to us. 🙏💖 Send feedback
