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