Electronic Spreadsheet – Set 2 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 2 Dear ! This is Electronic Spreadsheet – Set 2 Quiz and it contains 50 questions. Keep Learning! 1 / 50 1) Which elements of worksheet can be protected accidental modification ? Scenarios Contents All of these Objets 2 / 50 2) What will be the result if you type = A1 = B1 in cell C1 Yes or No Value of A1 True or False Value of B1 3 / 50 3) Excel worksheet cells work very similarly to what common element of the windows graphical user inrerface? Combo boxes List boxes Text boxes Option buttons 4 / 50 4) You can enter which types of data into worksheets cells? Values and formulas but not labels Labe3ls and values but not formulas Formula only Labels,values,and formulas 5 / 50 5) Which of the following is a popular DOS based spreadsheet package ? Lotus 1-2-3 Word Smart cell Excel 6 / 50 6) Which of the following will not cut information ? Pressing Ctrl + C Pressing Ctrl+X Selecting Edit>Cut fr the menu Clicking the cut button on the standard 7 / 50 7) A circular reference is? Always erroneous Geometric modeling tool A cell that points to a drawing object A formula that either directly or indirectly depends on itself 8 / 50 8) You cannot link excel worksheet data to a word document ? With the right drag methods With the copy and paste buttons on the standard toolbar With a hyperlink With the copy and paste special commands 9 / 50 9) You can edit a cell by? Double clicking the cell to edit it in place Selecting Edit>Edit cell from the menu None of these Clicking the formula button 10 / 50 10) Which of the following is a correct order of precedence in formula calculation ? Additon and subtraction,positive and negative values, exponentiation All of these Multiplication and division, positive and negative values, addition and subtraction Multiplication and division, exponential positive and negative values 11 / 50 11) In Excel , by default Numeric values Appears in Center aligned Justify aligned Left aligned Right aligned 12 / 50 12) To hold row and column titles in place so that they do not scroll when you scroll a worksheet click the? Unfreeze panes command on the window menu None of these Hold titles command on the edit menu Freeze panes command on the window menu 13 / 50 13) The name box? Appears to the left of the formula bar Appears below the menu bar Appears below the status bar Shows the location of the previously active cell 14 / 50 14) Each excel file is called a workbook because ? It can contain text and data It can contain many sheets including worksheets and chart sheets You have to work hard to create it It can be modified 15 / 50 15) Which is used to perform what if analysis ? Goal seek Scenario Manager Solver All of these 16 / 50 16) Which of the following is not information you can specify using the solver? Input cells Changing cells constraints Target cell 17 / 50 17) Files created with lotus 1 2 3 have an extension ? WK1 XLS DOC 123 18 / 50 18) Which of the following methods cannot be used to edit the contents of a cell? Press the Alt key Double clicking the cell Clicking the formula bar Pressing the F2 key 19 / 50 19) Without using the mouse or the arrow keys, what is the fastest way of getting to cell A1 in a spreadsheet? Press Shift + home Press Alt + home Press home Press Ctrl + home 20 / 50 20) Right clicking something in Excel? Nothing the right mouse button is there for left handed people Selects the object Deletes the object Opens a shortcut menu listing everything you can do to the object 21 / 50 21) How can you find specific information in a list? Click the find button on the standard toolbar Select Insert>Find from the menu Select Data>Form from the menu to open the Data From dialog box and click the criteria button Select tools>Finder from the menu 22 / 50 22) When you link data maintained in an excel workbook to a word document ? The word document cannot be edit The word document contains a copy of the actual data The word document contains a reference to the original source application The word document must contain a hyperlink 23 / 50 23) Multiple calculations can be made in a single formula using? Standard formulas Array formula Smart formula Complex formulas 24 / 50 24) Which of following is NOT one of Excel’s what if function ? Scenario manager Solver Goal seek Auto Outline 25 / 50 25) Which of the following is not a way to complete a cell entry? Pressing enter Pressing spacebar Pressing any arrow key on the keyboard Clicking the enter bottom on the formula bar 26 / 50 26) The paste Special command let’s you copy and paste? The resulting values of a formula instead of the actual formula Cell comments Multiply the selection by a copied value Formatting option 27 / 50 27) Text formulas? Concatenate and manipulate text Show formula error value Return ASCII values of characters Replace cell references 28 / 50 28) To save a workbook, you? Click save on the windows Start button Click the save button on the standard toolbar from the menu Press Ctrl + F5 Select Edit>Save 29 / 50 29) Which of the following options is not located in the page setup dialog box? Headers and footers Page Break Preview Margins Page Oprientation 30 / 50 30) Which of the following methods cannot be used to enter data in a cell ? Pressing the Esc key Pressing an arrow key Pressing the tab key Clicking on the formula 31 / 50 31) When a label is too long to fit within a worksheet cell, you typically must? Adjust the row height Decease the column width Increase the column width Shorten the lebel 32 / 50 32) When you insert an excel file into a word document. The data are? Use the word menu bar and toolbars Linked Hyperlinked placed in a word table Embedded 33 / 50 33) You can use the drag and drop method to? B.Move cell contents C.Add cell contents D.A and B A.Copy cell contents 34 / 50 34) In Excel ———– may not contain in Formula Number constant Circular Reference All of these Text Constant 35 / 50 35) You want to track the progress of the stock market on a daily basis. Which type of chart should you use? Row chart Pie chart Line chart Column chart 36 / 50 36) All worksheet formula? Return a formula result Manipulate values Use the addition operator Manipulate labels 37 / 50 37) To view a cell comment ? Position the mouse pointer over the cell Click the display comment command oj the window menu Click the edit comment command on the insert menu Click the comment command on the view menu 38 / 50 38) Rounding errors can occur? When you use multiplication, division or exponentiation in a formula Because excel uses hidden decimal places in computation When you use addition and subtraction in a formula When you show the results formulas with different decimal places that the calculated results 39 / 50 39) Which of the following is the oldest spreadsheet package ? VisiCalc Lotus 1-2-3 StarCalc Excel 40 / 50 40) To show/hide the grid lines in Microsoft Excel 2007 Insert > Grid lines > View Page Layout>Grid lines >View View > Grid lines > View Edit > Grid lines > View 41 / 50 41) You can copy data or formulas? All of these With the copy, paste and cut commads on the edit menu With buttons on the standard toolbar With commands on to shortcut menu 42 / 50 42) Excel probably considers the cell entry january 1,2000 to be a ? Value Text string Formula Label 43 / 50 43) You can use the format painter multiple times before you turn it off by? Double clicking the format painter button Pressing the Alt key and clicking the format painter button You can use the format painter only one time when you click it Pressing the Ctrl key and clicking the format painter button 44 / 50 44) Which of the following is not a basic step in creating a worksheet? Save workbook Modify the worksheet Enter text and data Copy the worksheet 45 / 50 45) To copy formatting from one area in a worksheet and apply it to another area you would use? There is no way to copy and apply formatting in Excel-You have to do it manually The Format Painter button on the standard toolbar The Copy and Apply Formatting dialog box, located under the Format>Copy and Apply menu The Edit>Copy Format and Edit>Paste Format commands from the menu 46 / 50 46) To copy cell contents using drag and drop press the? Ctrl key End key Esc key Shift key 47 / 50 47) You can use the horizontal and vertical scroll bars to? Edit the contents of a cell Split a worksheet into two panes View different rows and columns edit the contents of a cell View different worksheets 48 / 50 48) If you begin typing an entry into a cell and then realize that you don’t want your entry placed into a cell,you? Press the Edit Formula button Press the Enter button Press Esc Press the Erase key 49 / 50 49) To create a formula, you first? Select the cell you want to place the formula into Choose the new command from the file menu Enter the formula using any input values and the appropriate mathematical operators that make up your formula Type the equals sign(=)to tell Excel that you're about to enter a formula 50 / 50 50) Which area in an excel window allows entering values and formulas? Formula bar Menu bar Standard toolbar Title bar 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
