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