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