Electronic Spreadsheet – Set 3 January 28, 2025 by aasi Home › Computer › MS Excel MS Excel Electronic Spreadsheet – Set 3 📝 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 3 Dear ! This is Electronic Spreadsheet – Set 3 Quiz and it contains 50 questions. Keep Learning! 1 / 50 1) A smart tag will be removed from a cell when The data in the cell is changed or deleted The cell is hidden The cell is moved The formatting of the cell is changed 2 / 50 2) How do you wrap the next in a cell ? Format, cells , protection Format , cells , alignment format , cells , number format, cells, font 3 / 50 3) What is the shortcut key to hide entire row ? CTRL + H CTRL + CTRL + 9 CTRL + R 4 / 50 4) Excel displays the current cell address in the ………. Title box Formula bar Status bar Name box 5 / 50 5) Which of the following function will return a value of 8 ? =ROUNDDOWN(8.4999,0) = All of these =ROUNDUP(8.4999,0) =AVERAGE(A1:A9,B1:B9) 6 / 50 6) In maximum , how many sheets can be set as default while creating new workbook ? 255 256 No limit 254 7 / 50 7) Which option allows you to Bold all the negative values within the selected cell range Zero Formatting Conditional Formatting Compare Formatting Negative Formatting 8 / 50 8) Which of the following is correct ? =POWER(2#3) =POWER(2,3) =POWER(2^3) =POWER(2*3) 9 / 50 9) How to restrict the value of a cell so that only whole number between 9 and 99 can be entered in a cell The Settings tab under the menu Format > Conditional Formatting The Setting tab under the menu Data > Filter > Advanced Filter The setting tab under the menu Data > Validation The Setting tab under the menu Format >> cells 10 / 50 10) What is the shortcut key to hide entire column ? CTRL + H CTRL + 0 CTRL + C CTRL + – 11 / 50 11) what does COUNTA () function do ? counts empty cells counts not empty cells counts cells having number counts cells having alphabets 12 / 50 12) To select an entire column in MS EXCEL , press ? None of these Ctrl + C Ctrl + s CTRL + Arrow key 13 / 50 13) How do you display current date and time in MS Excel ? date () now () time () Today () 14 / 50 14) Microsoft Excel is a powerful …………… DBMS package Spreadsheet package Word processing package Communication S/W package 15 / 50 15) How to specify cell range from A9 to A99 in Excel ? (A9,A99) (A9 to A99) (A9 – A99) (A9 : A99) 16 / 50 16) you want to record experiment information and create a chart that shows the rate of crystal growth over a period of time best application to use would be: database word processing spreadsheet graphics 17 / 50 17) “New Comment” option can be found under ——— tab Data Insert Review view 18 / 50 18) Which function is not available in the Consolidate dialog box ? Sum Max Pmt Average 19 / 50 19) What is the quickest way to select entire worksheet ? Choose Edit > Select all from the menu click on the first column , press Ctrl , and then click on the last column Click on the first column , press Shift , and then click on the last column Click on the rectangle box on the upper left corner where column headings and row headings meet 20 / 50 20) If the cell B1 contains the formula = $A$1, which of the following statements is true Further changes in value of B1 will affect the value of A1 Further changes in value of B1 will not affect the value of B1 There is an absolute reference to cell A1 There is a relative reference to cell A1 21 / 50 21) Pre made sheet formats like Simple , Classic , Accounting; Colorful etc can be applied from All of these from Format >> Auto format from Format >> Cells from Table >> Auto format 22 / 50 22) How to restrict to run a macro automatically when starting Microsoft Excel ? Hold down the ESC key during startup Hold down the SHIFT key during startup Hold down the ALT key during startup Hold down the Ctrl key during startup 23 / 50 23) What is the shortcut key to insert a new comment in a cell ? Ctrl + F2 F2 Shift + F2 Alt + F2 24 / 50 24) In EXCEL , you can sum a large range of data by simply selecting a tool button called ……. ? AutoFill Auto sum Auto format Auto correct 25 / 50 25) What is the correct way to refer the cell A10 on sheet3 from sheet1 ? sheet3.A10 Sheet1!A10 Sheet3!A10 A10 26 / 50 26) Which is not the function of “Edit, Clear” command ? Delete notes Delete Formats Delete cells Delete contents 27 / 50 27) MS EXCEL is based on …………..? DOS WINDOWS UNIX OS/2 28 / 50 28) What should be added before a fraction to avoid entering it as a date ? Zero Zero Space FR // 29 / 50 29) A numeric value can be treated as label value if ……. precedes it . Exclamation (!) Hash (#) Apostrophe (') Tilde (~) 30 / 50 30) Selecting the Rows 5 & 6 then choose insert > Row what will happen ? 2 Rows will be inserted after Row 6 2 Rows will be inserted after Row 7 2 Rows will be inserted after Row 5 2 Rows will be inserted after Row 4 31 / 50 31) you can merge the main document with data source in Excel . In mail merge operation , word is usually none client server source 32 / 50 32) What is the shortcut key to insert current date in a cell ? CTRL + D CTRL + / CTRL + T CTRL +; 33 / 50 33) Which one is the last column header in Excel 2007 ? XFL XFX XFD XFT 34 / 50 34) In the formula , which symbol specifies the fixed columns or rows ? $ % & * 35 / 50 35) Which of the following shortcuts can be used to insert a new line in the same cell ? Shift + Enter Alt + Enter Enter Ctrl + Enter 36 / 50 36) Which of the following is correct ? = All of these =AVERAGE(A1:A9, B1:B9) =AVERAGE(4,5,6,7) =AVERAGE(A1,B1,C1) 37 / 50 37) Which of the following is correct syntax in Excel ? =IF(LogicalTest, TrueResult) (LogicalTest, FalseResult) =IF(LogicalTest, TrueResult), IF(LogicalTest, FalseResult) =IF(LogicalTest, (TrueResult, FalseResult)) =IF(LogicalTest, TrueResult, FalseResult ) 38 / 50 38) Worksheet can be renamed by Adding? symbol at the end of filename while saving workbook Worksheet cannot renamed Double click on the Worksheet tab and type new name Click on worksheet tab by holding CTRL key and type new name 39 / 50 39) What do you mean by a Workspace ? Group of Workbooks Group of Rows Group of Worksheets Group of Columns 40 / 50 40) What value will display if the formula = “$55.00″+5 is entered into a cell ? $60.00 60 "$55.00"+5 $60 41 / 50 41) you are editing an worksheet that you had previously save if you want to save the edited sheet without losing the original one , which command should you use ? Save Edit Save As New 42 / 50 42) What is the shortcut key to insert new sheet in current workbook ? Ctrl + F11 Shift + F11 F11 Alt + F11 43 / 50 43) To return the remainder after a number is divided by a divisor in EXCEL we use the function ? FACT () DIV () ROUND () MOD () 44 / 50 44) What pivot Table toolbar button updates the data in a pivot Table or pivot Chart report if the source data has changed ? Format Report Pivot Table Refresh Data Show Detail 45 / 50 45) what does the Now() function return ? It returns the serial number of the current time None of these It return the serial number of the current date It returns the serial number of the current date and time 46 / 50 46) How to fit long texts in a single cell with multiple lines ? Use the Wrap text option in the Format > Alignment menu All of these Use the Shrink to fit option in the Format >Cells > Alignments menu Start typing in the cell and press the Enter key to start another line 47 / 50 47) you can use the formula palette to copy a range of cells create and edit formula containing functions format cells containing numbers enter assumptions data 48 / 50 48) Which of the following syntax is correct regarding to SUM function in Excel ? =SUM(A1:B9) =SUM(A1,B1) All of these =SUM(A1:A9, B1:B9) 49 / 50 49) What is the short cut key to highlight the entire column ? Ctrl + Enter Ctrl + space Bar Ctrl + C Ctrl + page Up 50 / 50 50) What is the AutoComplete feature of Excel ? it completes text entries that match an existing entry in the same column it automatically completes abbreviated words it completes text and numeric entries that match an existing entry in the same column it completes text entries that match an existing entry in the same worksheet 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
