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