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