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