Electronic Spreadsheet – Set 5 January 28, 2025 by aasi Home › Computer › MS Excel MS Excel Electronic Spreadsheet – Set 5 📝 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 5 Dear ! This is Electronic Spreadsheet – Set 5 Quiz and it contains 50 questions. Keep Learning! 1 / 50 1) If you require more than two conditions or if you want to analyze a list using Excel 2003’s database functions , you must define which filter ? Advance Criteria Filter Advantage Filter Update Filter Auto Filter 2 / 50 2) ………..function in excel calculates the average of the cells in a supplied range, that satisfy a given criteria ? Average A Average IFS Average IF Avrerage 3 / 50 3) A quick way to return to a specific area of a worksheet is to type in the —– Zoom box Formula bar Name box None of these 4 / 50 4) What is the symbol for multiplying ? * > / ! 5 / 50 5) what is represented by the small , black square in the lower right corner of an active cell or range ? Border Copy handle Fill handle Insert handle 6 / 50 6) Which of the following is not a database function in Excel? DAverage DStDev DVarP DisCount 7 / 50 7) you want to report experiment information and create a chart that shows the rate of crystal growth over a period of time . the best application to use would be: graphics Word processing database spreadsheet 8 / 50 8) In order to arrange the countries from those with the highest population to those with the lowest , you need to sort on the population field in ……….. random order ascending order descending order alphabetical order 9 / 50 9) what are the tabs that appear at the bottom of each workbook called ? Location tabs Sheet tabs Position tabs Reference tabs 10 / 50 10) ……………are used in excel to present information contained in worksheet in a graphic format? Clip art Graph Diagram Chart 11 / 50 11) The function used to determine the maximum or minimum value of one cell by changing more than one cell is? Solver Scenario Goal seek Auto editing 12 / 50 12) The Cancel and Enter buttons appear in the : Sheet tabs Formula bar Menu bar Title bar 13 / 50 13) Which is an example of a formula ? A1+A2 SUM(A1:A2) =A1+A2 =add(A1:A2) 14 / 50 14) ……facility helps to take single output of multiple sheets? Pivot table Table summery Consolidation Group table 15 / 50 15) Comments can be added to cells using……..? Edit>Comments File>Comments Insert>Comment View>Comments 16 / 50 16) In a report , you need to show the monthly rainfall in Nepal . The best way to do this is to insert a database of rainfall calendar chart showing rainfall amounts Photograph of rainfall 17 / 50 17) Which menu option can be used to split windows into two? View>Window>Split Format>Window View>Split Window>Split 18 / 50 18) In order to perform a calculation in a spreadsheet , you need to use a : formula field Variable table 19 / 50 19) Give me an example of a cell address . A21 911 41A 11 25 20 / 50 20) The……….function returns a prediction of a future value based on existing values provided ? Trend Forecast Intercept Correl 21 / 50 21) The spelling tool is placed on_____toolbar? Reviewing Drawing Standard Formatting 22 / 50 22) ………denotes an interactive table that quickly summarises or cross tabulates, large amount of data? Group table Pivot table Table summery Consolidation 23 / 50 23) Which is an example of function ? =A1+A2 =add(A1:A2) =SUM(A1:A2) A1+A2 24 / 50 24) Which of the following is not a valid Zoom percentage in Excel? 10 100 300 500 25 / 50 25) Ms EXCEL can be used to automate Any of there Transaction registers , inventory control Financial statement , business forecasting Accounts receivable , accounts payable 26 / 50 26) Total number of columns in Excel? 1024 265 256 65536 27 / 50 27) If you want all of the white cats grouped together in the database , you need to sort by —– Pet Type , then Color Color , then Gender Pet Type , then Gender Color , then Pet Name 28 / 50 28) In Excel, the AutoSum feature is available in? Data tab Sheet tab Home tab View tab 29 / 50 29) Where a row and a column meet , what do you call that ? A block None of these A box A cell 30 / 50 30) The box on the chart that contains the name of each individual record is called the ——– title legend axis cell 31 / 50 31) Which keyword shortcut opens the Go to dialog box ? Ctrl + B Ctrl + shift + B F5 F2 32 / 50 32) How do you tell one cell from another By letter By its address by color By number 33 / 50 33) you accidentally erased a record in the sheet . what command can be used to restore it immediately ? Insert Undo Replace Copy 34 / 50 34) What happens when dollar signs($) are entered in a cell address ? An absolute cell address is created The sheet tab is changed The status bar does not display the cell address cell address will change when it is copied to another cell 35 / 50 35) ……….key provides a chart immediately ? F1 F5 F11 F10 36 / 50 36) When you use the fill effects in the format data series dialog box, you can not? Select a pattern Select a fore ground color Select a background color Rotate text on the chart 37 / 50 37) Which of the following is not a logical function ? AND NOT OR IF 38 / 50 38) You can active a cell by? Clicking the cell Pressing the tab key All of these Pressing an arrow key 39 / 50 39) B7:B9 indicates None of these Cells B7 and cell B9 only Cells B7 through B9 Cell B8 only 40 / 50 40) NOT, AND, OR, and XOR are Arithmetic Operator Relational operators Logical Operators None of these 41 / 50 41) Total number of rows in Excel? 256 1024 None of these 65536 42 / 50 42) you are editing a worksheet that you had previously saved . if you want to save the edited sheet without losing the original one , which command should you use ? save As Save New Edit 43 / 50 43) What is the symbol for dividing ? / # & % 44 / 50 44) The first cell in EXCEL worksheet is labeled as A1 AA Aa A0 45 / 50 45) Chart in Excel is available in……..Tab? Data Tab Home tab Insert Tab View Tab 46 / 50 46) Comments put in cells are called……? Wab Tip Web Tip Cell Tip Smart tip 47 / 50 47) If you want to have a blank line after the title in a worksheet , what is the best thing for you to do ? Use the spacebar Insert a row Re format the spreadsheet Increase the column width 48 / 50 48) First column in excel sheet is …….and column is…..? A,IV A,Z A1,Z1 A,ZZ 49 / 50 49) Which of the following is not a valid data type in Excel? Date/Time Number Character Label 50 / 50 50) …………is a quick and easy way to find and work with a subset of data in a excel sheet? Filtering Sorting Grouping Finding 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
