Electronic Spreadsheet – Set 6 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 6 Dear ! This is Electronic Spreadsheet – Set 6 Quiz and it contains 50 questions. Keep Learning! 1 / 50 1) How many sheets are there in excel workbook by default ? 3 2 4 5 2 / 50 2) What term describes a background that appears as a grainy , non – smooth surface gradient solid texture pattern 3 / 50 3) To apply Goal Seek command your cell pointer must be in The Result Cell Where formula is entered None of these The changing cell whose value you need to find The cell where your targeted value is entered 4 / 50 4) How do you rearrange the data in ascending or descending order ? Data , Table Data , Sort Data , Form Data Subtotals 5 / 50 5) The auto fill features Extends a sequential series of data Automatically adds a range of cell values None of these Applies a boarder around selected cells 6 / 50 6) The number of row in a worksheet is 256 36500 65536 64536 7 / 50 7) What is an expression that tells how the number in a determined set of cells are to be calculated ? Field Query Formula Data 8 / 50 8) What feature enables you to adjust or back solve the value in a cell to reach a desire outcome in a formula ? Goal seek Scenario Summary report Trend line Forecasting 9 / 50 9) “Qtr 1, Qtr 2 , Qtr 3” is an example of a F1 key F2 key F4 key F3 key 10 / 50 10) you can quickly change the appearance of your work by choosing Auto Format from the …….. Menu Edit Format Tools Data 11 / 50 11) To move to the previous worksheet press Ctrl+PgDn Ctrl+PgUp Shift+Tab Ctrl+Tab 12 / 50 12) What is the keyword shortcut(button or buttons to be pressed ) for creating a chart from the selected cells F11 F3 F7 F5 13 / 50 13) If you press …… the cell accepts your typing as its contents Ctrl + Enter TAB Insert Enter 14 / 50 14) To select multiple non adjacent cells in a worksheet you will click them holding Shift key ALT key Ctrl + Shift key CTRL key 15 / 50 15) In Excel financial function, PMT means? Payment Present Money Transaction None of these Past Monitory Transaction 16 / 50 16) A user wishes to remove a spreadsheet from a workbook. which is the correct sequence of events that will do this ? None of these Go to File Save As – Save As Type – Excel worksheet Right click on the spreadsheet tab and select DELETE Right click on the spreadsheet and select Insert – Entire Column 17 / 50 17) The default font size in Excel worksheet is 14 points 12 points None of these 10 points 18 / 50 18) …………In Excel is used to get a particular result when you’re not too sure of the starting value? Marco Scenario Forecast Goal seek 19 / 50 19) If you wanted to sort an employee file so that they would be listed alphabetically by last name and first name within individual zip codes (smallest to largest) , which of the following would be the correct order of the list last name (descending) , then first name (descending) , then last name(descending) last name(ascending), then first name (ascending) , then last name (ascending) Zip codes (ascending), then last name (ascending), then first name (ascending) zip codes (descending) , then last name (descending) , then last name(descending) 20 / 50 20) To copy all content using drag and drop , press the End key None of these Shift key Esc key 21 / 50 21) Which of the following is concatenating operator ? Apostrophe(') Hash(#) Ampersand(&) Exclamation(!) 22 / 50 22) You can edit existing Excel data by pressing the F2 key F4 key F3 key F1 key 23 / 50 23) Which of the following is not a worksheet design criterion Clarity Description Audit ability Efficiency 24 / 50 24) What pivot Table toolbar button updates the data in a pivot table or pivot chart report if the source data has changed ? Refresh Data Format report Pivot Table Show Detail 25 / 50 25) …………calculates the interest paid during a specific period of an investment ? IPMT NPV ISPMT PMT 26 / 50 26) Red triangle at the top right corner of a cell indicates The cell can't accept formula There is a comment associated with the cell There is an error in the cell The font color of the text in cell is red 27 / 50 27) What happens if you remove the check mark from Row and Column headers on options dialog box ? This will remove row heading and column heading of your data This will remove row and column heading of chart This will remove the column heading (A,B,C, This will remove row and column heading of table 28 / 50 28) To create an interactive pivot Table for the Web , you use a Microsoft office web component called HTML Pivot Table List pivot Table Report Pivot Table Field List 29 / 50 29) In Excel financial function, NPER is? Net Past Earning Net Present Earning rate Net Permanent Rate Number of Periods 30 / 50 30) Cell E23 has a data value and you wish to place that date on an invoice prefaced with the text located in B15 . what is the command to do that ? =join(B15&E23) =proper(B15)&" "&text(E23,"mmmm dd , yyyy" =B15&E23 B15&" " &E23 31 / 50 31) Which of the following cannot be hidden from Tools >> Options then View tab ? Startup Task pane Formula bar Status bar Scroll Bar 32 / 50 32) The minimum and maximum value you can set for save AutoRecovery Info in Excel are 0 and 120 minutes 1 and 120 minutes 1 and 10 minutes 2 and 60 minutes 33 / 50 33) To protect a worksheet , you can choose protection and the protect sheet from the menu Format Edit Data Tools 34 / 50 34) The accounting style shows negative numbers in Bold Paranthesis Quotes Brackets 35 / 50 35) How many recent files you can display on file menu at maximum ? 12 4 6 9 36 / 50 36) Data can be arranged in ascending or descending order by using Sort command from Data menu Sort command from Tools menu None of these Sort command from Table menu 37 / 50 37) Which of the following component displays the content of active cell ? Menu bar Formula bar Status bar Name box 38 / 50 38) ………function is used to calculate the amount paid as interest on a loan during a period of the lifetime of a loan or an investment ? NPV ISPMT PMT IMPT 39 / 50 39) When you create two or four separate windows containing part of the spreadsheet that can be viewed , you have created sections views subsheets panes 40 / 50 40) When a formatted number does not fit within a cell , it displays #DIV@ #DIV/0 ##### None of these 41 / 50 41) A……….in Excel offers you different ways to view a set of figures, and allows you to switch between them quite easily ? Forecast Scenario Goal seek Marco 42 / 50 42) Which of the following is not a statistical function in Excel? DSUM INTERCEPT COVAR CORREL 43 / 50 43) To keep specific rows and columns from scrolling off the screen you first must position the cell pointer below the row you want to remain on the screen on the row you want to remain on the screen both below and right of the row and column you want to remain on the screen to the right of the column you want to remain on the screen 44 / 50 44) You can open the highlight changes dialog box by choosing track changes from the menu Edit Insert Format Tools 45 / 50 45) The default and maximum number of sheets for a new worksheet in Excel 2003 is 1 and 256 3 and 255 3 and 256 1 and 255 46 / 50 46) By default the cell pointer moves down when you press Enter . From where can you change this setting ? Tool >> Option >> Edit Tab Tools >> Options >> Calculation tab Tool >> Option >> Transition tab Tool >> Options >> View tab 47 / 50 47) Which of the following is not an option in the spelling dialog box ? Ignore Edit Ignore all Change 48 / 50 48) The cell reference for a range of cells that starts cell B1 and goes over to column G and down to row 10 is ….. B1:G10 B1;G10 B1,G10 G1 G10 49 / 50 49) The process of identifying specific rows and columns so that certain columns are always visible on the screen is called fixing freezing locking selecting 50 / 50 50) What symbol is used to enter number as text ? + = ' " 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
