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