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