Electronic Spreadsheet – Set 1 January 28, 2025 by aasi Home › Computer › MS Excel MS Excel Electronic Spreadsheet – Set 1 📝 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 1 Dear ! This is Electronic Spreadsheet – Set 1 Quiz and it contains 50 questions. Keep Learning! 1 / 50 1) To protect a worksheet, you can choose protection and the pretect sheet from the…..menu? Tools Format Edit Data 2 / 50 2) Concatenation of text cam be done using? Apostrophe(') Ampersand(&) Exclamation(!) Hash(#) 3 / 50 3) Which functions will calculate the number of workdays between 6/9/2004 and 8/12/2004? All of these Network days Workday Date 4 / 50 4) This term , used to describe a database that occupies magnetic storage in the terabyte range , describe a database that contains billions of table rows Cold Fusion giant holographic storage Very Large database 5 / 50 5) At this level of normalization , each column in a table that is not a determiner of the contents of another column , must itself be a function of the other columns in the table . 2NF 1NF 3NF DKNF 6 / 50 6) Which of the following setup options cannot be set in the page setup dialog box? Row and column titles Printer selection Orientation Vertical or horizontal placement 7 / 50 7) Data can be arranged in a worksheet in a easy to understand manner using? Auto formatting Applying styles Changing fonts All of these 8 / 50 8) Charts tips can? A.Show the formatting of a data label D.B and C C.Show the value of data point B.Show the name of a data series 9 / 50 9) In a worksheet you can press Shift+Space to select entire? Worksheet Column Row All of these 10 / 50 10) To hold row and column titles in places so that they do not scroll when you scroll a worksheet, click the? Split command on the window menu Hold titles command on the edit menu Unfreeze panes command on the window menu Freeze panes command on the window menu 11 / 50 11) When you link data maintained in Excel workbook to a word document ? The word document contains a copy of the actual data The word document cannot be edited The word document must contains a hyperlink The word document contains a reference to the orginal source application 12 / 50 12) This is a family of relational database management system product from IMB that server a number of different operating system platforms Cognos Universal Data Access DB2 ADO 13 / 50 13) How many characters can be typed in a single cell Excel? 32000 256 1024 65535 14 / 50 14) Which types of charts can excel produce ? Bar chart, line graphs and pie charts Only line graphs Bar chart and line graphs only Line graphs and pie charts only 15 / 50 15) How do you change column width to fit the contents ? Single click the boundary to the left to the column heading Press Alt and single click anywhere in the column All of these Double click the boundary to the right of the column heading 16 / 50 16) When you copy a formula ? Excel doesn't adjust relative cell references Excel edits cell references in the newly copied formula Excel adjusts absolute cell references Excel erases the orginal copy of the formula 17 / 50 17) What symbol is used before a number to make it a label? _(underscore) "(quote) '(apostrophe) =(equal) 18 / 50 18) Which technology was Microsoft’s first attempt at an object – oriented database interface ? ADO DAO MQ Series UDA 19 / 50 19) Getting data from a cell located in a different sheet is called? Referencing Accessing Updating Functioning 20 / 50 20) This is a common standard language used to update and get information from a database TMQL VB SQL PHP 21 / 50 21) What term refers to a specific set of values saved with the workbook? Range What if analysis Scenario Trend line 22 / 50 22) When you group worksheets? D.B and C A.You can enter variable data on multiple worksheets at one time B.You can print more than one worksheet at a time C.You can enter common data, formats, and formulas on multiple worksheets at one time 23 / 50 23) A data map is helpful ? To show a geographic distribution of data To compare data points To show changes in data over time When you have too much data to chart 24 / 50 24) What does the VLOOKUP function do? Looks up text that contain 'v' Finds related records Check whether text is the same in one cell as in the next All of these 25 / 50 25) Which of the following methods cannot be used to edit the content of cell? Press the Alt key Pressing F2 Clicking the formula bar Double clicking the cell 26 / 50 26) When creating a vertical page break? The active cell can be anywhere in the worksheet The active cell must be A1 The active cell must be in row 1 The active cell must be in column Aa 27 / 50 27) The chart wizard term data series refers to? A set of values you plot in a chart A data label A collection of chart data markers A chart legend 28 / 50 28) You can use drag and drop to embed excel worksheet data in a word document ? By dragging a range of excel data to the word button on the taskbar while pressing Ctrl key By dragging a range of excel data to the word button on the taskbar while pressing Shift key None of these By dragging a range of excel data to the word button on the taskbar while pressing Alt key 29 / 50 29) A typical worksheet has………Number of columns ? 128 256 1024 512 30 / 50 30) Tab scrolling button? Allow you to view additional sheets tabs Allow you to view additional worksheet rows down Allow you to view a different worksheet Allow you to view additional worksheet columns to the right 31 / 50 31) When you see a cell with a red triangle in the top right corner, what does this signify? The font color for text in the cell is red A formula cannot be entered into the cell There is an error in the cell There is a comment associated with the cell 32 / 50 32) How should you print a selected area of a worksheet, if you’ll want to print a different area next time? On the view menu, click custom views, then click add On the file menu, click print, and the click selection under print what On the file menu, point to print area, and then click set print area. All of these 33 / 50 33) You can open the scenario Manager dialog box by choosing scenarios from the ….menu? Format Tools View Insert 34 / 50 34) This method of online analytical processing stores data in both a relational and a multi- dimensional database . DIMM ROLAP OLAP HOLAP 35 / 50 35) This is a file format that contains the values in a table in which column values separated by a common and each rows starts a new line . virtual organization CSV file None ASCII 36 / 50 36) The chart wizard term data categories refers to; The organization of individual values with a charts data series A horizontal axis The data range that supply chart data A chart plot area 37 / 50 37) A worksheet can have a maximum of……..Number of rows? 1024 32000 65535 256 38 / 50 38) A numerical value can be treated as a label value if it precedes with? Apostrophe(') Ampersand(&) Hash(#) Exclamation(!) 39 / 50 39) Which of the following is the latest version of Excel? Excel 2000 Excel XP Excel ME Excel 2002 40 / 50 40) What is the name given to the database management system which is able to handle full text data , image data , audio & video multimedia full media text database Relationship 41 / 50 41) In a relational database , this is the data structure that holds a single piece of data , such as first name or phone number . field catalog entity object 42 / 50 42) Which of the following is a correct order of precedence in a formula calculation? None of these Multiplication and division, exponential positive and negative value Addition and subtraction, positive and negative values, exponentiaton Multiplication and division, positive and negative values, addition and subtraction 43 / 50 43) This is a standard interactive and programming language for getting information from and updating a database . Enlarge programming language dynamic data exchange Structured Query Language ASCII 44 / 50 44) To center worksheet titles across a range of cell, you must? Select the cells containing the title text and use the fill handle to center the text across a range of cells Widen the column Widen the columns Select the cells containing the title text and use the fill handle to center the text across a range of cells 45 / 50 45) This type of software is similar to an accountant’s worksheet? Database Spreadsheets Graphics Word processing 46 / 50 46) What function displays row data in a column or column data in row? Rows Transpose Hyperlink Index 47 / 50 47) You can zoom a worksheet? With the zoom command on the view menu All of the above With the zoom button on the print preview toolbar With the mouse pointer in print preview 48 / 50 48) When intergrating Ms Word and Excel, Word is usually the ? Server Source None of these Client 49 / 50 49) You xan open the consolidate dialog box by choosing consolidate from the……menu? Insert Format Tools Data 50 / 50 50) This is an organized selection of data from a database that allows you to look at it from a particular perspective view splay tree Gantt chart Venn diagram 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
