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