MS Excel Questions Latest MS Excel MCQ Objective Questions India's #1 Learning Platform. Reber teers Start Complete Exam Preparation raed CaaS) pacar aa kad ay Preset D> Download App Question 1: Vv. The Excel function to remove decimal or fractional part of the number is: 1. AVG 2. REPLACE 3. TRUNC 4. ABS ICES emcee nome Tetsu Under One Roof et Answer (Detailed Solution & ) Option 3: TRUNCMS Excel Question 1 Detailed Solution The correct answer is TRUNC. © Key Points + TRUNC function is used to remove the fractional part of a number, es itto an integer. + It does not perform any rounding, it simply cuts off the decimal part. + The syntax for the TRUNC function is TRUNC(number, [num_digits]). + It can also truncate the number to a specified number of decimal places if the num_digits, arguments provided. " » Important Points 53 + The TRUNC function is differ! ‘the ROUND function, as ROUND performs rounding based on the decimal part, while | ly cuts it off. + Using TRUNC can be useful in s¢eriarios where only the integer part of a number is needed without any rounding. + Itis a useful function in data analysis, financial calculations, and other areas where precision control is required. + TRUNC can be combined with other functions to achieve more complex calculations. Be Additi f ‘ + AVG: The AVG function caloulates the average (mean) of a group of numbers. It is commonly used in data analysis to determine the central tendency of a data set + REPLACE: The REPLACE function is used to replace part of a text string with a different text string. It is useful for text manipulation and formatting. + ABS: The ABS function returns the absolute value of a number, which is the number without its sign. It is useful in mathematical calculations where negative values are not desired. rd eee ci Start Complete Exam Preparation ered ae Cres ear Eats Download App Question 2: View this Question Online > In Microsoft Excel, key combination can be used to display the formulas entered ina cell. 41. Ctrl key +) symbol 2 TR symbol 3. Ctrl key+* symbol 4, Ctrlkey+* symbol Answer (Detailed Solution Below) Option 3: Ctrl key +" symbol MS Excel Question 2 Detailed Solution The correct answer is Ctrl key +* symbol © Key Points + The “Ctrl key + * symbol" combination Is used to toggle the display of formulas in Excel. + This feature helps in auditing and debugging formulas entered in the worksheet. + The ° symbol is ustallyjlagazed on the same key as the ~ symbol, under the Esc key on most keyboards. + When formulas are displal \¢ Celis show the actual formula instead of the resulting value. ©: Additi f 4 * Ctrl key +] symbol: This combination is used to select all cells that directly depend on the active cell's value. + Ctrl key +* symbol: This combination is used to select the current region around the active cell, whichis useful for working with large data sets, & oer Sela mee Cec cla) tie PO ier cores Download App iG ee eed ey Seay Question 3:View this Question Online > In Microsoft Excel, you can record the mouse and keyboard actions and use them later using ‘option. 1. “* - 2. Macro 3. Micro 4, Snapshot Answer (Detailed Solution Below) Option 2: Macro MS Excel Question 3 Detailed Solution The correct answer is ‘~ © KeyPoints + Macros in Excel are used to record sequences of actions performed by the user. + These actions can include mouse clicks, keystrokes, and other operations. + Once recorded, a macro can be played back to repeat the sequence of actions automatically. + This feature is particularly useful for repetitive tasks, as it can save time and reduce errors. eee area Becca! ae Start Complete Exam Preparation Gipees -e Need Diener} LJ 5 pas Download App Question 4: View this Question Online >What will be the output of the following MS-Excel function? =ROUNDUP(213.456, 0) 1, 214 “’ 3. 220 4. 210 5. None of the above Answer (Detailed Solution Below) Option 1: 214 MS Excel Question 4 Detailed Solution The correct answer is 214 © Key Points % + The output of the Excel function =ROUNDUP(213.456, 0) will be 214. + The ROUNDUP function s rourids Up the number. + By specifying 0, we're a! to round up to the nearest whole number. So the correct choice is: 214 ;OUNDUP(213.456, 0) Ceara parcia) eee Start Complete Exam Preparation apa Crea radDownload App Question 5: View this Question Online > Which shortcut key is used In MS Excel to "insert aNew Chart’? 1. Alt+ Ctrl +F2 = 2. Alt+ FT ft + F2 5. None of the above & D 2 s S g Option 2: Alt+F1 MS Excel Question 5 Detailed Solution The correct answer is Alt+ F1. + To insert a new chart in MS Excel, the shortcut key Alt+ Fl isusedi) > + Key attributes of Microsoft Excel: = One may add new worksheets whenever theychoose. » Shortcut keys that save time. 7 » Obtain the Quick Sum of Numbers. of » Data filtering. = Special Feature, pasts. é © Type ina random ni ‘ » Add some arbitrary jal numbers. » Tool for Goal Seek Analy B an f . + Alt+ Ctrl + F2: » This key does "File Open Dialog Box" is displayed.° MEET Fhe » This key reduces or increases the ribbon's size. + Alt+ Shift + F2: » This key saves the worksheet. Top MS Excel MCQ Objective Questions Fa India’s #1 Learning Platiorm Start Complete Exam Preparation Pe ested Wis Pcie Cases Dato Download App Question 6 View this Question Online > Which of the following is nota valid function in MS Excel? 1. SUM() 2. COUNT() NG « 3. SUBTRACT() os 4. COUNTAQ Answer (Detailed Solution Below) Option 3: SUBTRACT() MS Excel Question 6 Detailed Solution The correct answer is SUBTRACT(). © Key Points SUBTRACT() is nota valid function in MS Excel ‘Subtract two or more numbers in a cell :1. Click any blank cell, and then type an equal sign (=) to start the formula. 2. After the equal sign, type a few numbers that are separated by a minus sign (+). for example, 100-50-30. s- 3. Press RETURN, then the result is 20. ©: Additional Information ‘SUMO ary + The SUMO adds values. + You can add individual "oR ferences or ranges, or a mix of all three. + For example: =SUM(A2:A 10) Ak 2 values in cells A2:10. + COUNTA- It will allow you to evaluate any gaps the dataset might have without having to reorganize the data, COUNT(, * The COUNT() is generally used to count a range of cells containing numbers or dates excluding blanks COUNTAQ COUNTA() will count everything as numbers, dates, text, or a range containing a mixture of these items, but does not count blank cells. COUNTA stands for the count all. eee eur karen) er Start Complete Exam Preparation & Qui: Prue eacd y) Mock Tests fired Crees Download App ‘Question 7 3 View this Question Online> Which of the following is used to move an active cell to the first column on the current row? : 1. Page up : Ye) 2. Ctrl+Home — -!;!Se ae 4. Home Answer (Detailed Solution Below) Option 4: Home MS Excel Question 7 Detailed Solution The correct answer is Home. © Key Points + The Home key is used to move the active cell to the first column on the current row in spreadsheet applications like Microsoft Excel) + This function is helpful for quickly navigating to the beginning of the row without using the mous: ¥ + Page Up: = This key is used to move the active cell up by one screen. + Ctrl ++ Home: + This key combination moves the active cell to the beginning of the worksheet (cell A1). + Page Down: > This key is used to move the active cell down by one screen. r eee areca pein) - Sle eel ee eed) ee Rect Peas fae f a DS eae researc Download App Est Question 8 Question Online in Microsoft Excel always begins with an equal to sign(=). 1. Numbers2. Formulae 4) Answer (Detailed Solution Below) Option 2: Formulae MS Excel Question 8 Detailed Solution The correct answer is “Formulae”. © key Points ay + MS Excel a » Itis a spreadsheet program for data analysis and documentation. » It contains a number of rows and columns, where the intersection ofa column anda rowis @ “cell”. » Each cell contains one point of data. « Itis developed by Microsoft. = It features calculation, graphing tools, aap Mesite + The function of (=) sign (Starting of Formula) ~ All Excel formulas begin with an equals sign,=, followed by a specific tag denoting the formula. » For example, =B1+B! is a formula that adds up the values in the cells B1 through B3. © Additional Information Function To parform a simple Adgition operation To parform a simple Subtraction operation Comparison Operator(Greater than) eee ane uur Baril) AS ela Orel) Cle eel) tea ee eae 7 | Mock Tests aad Ve Creer Es B Download AnnQuestion 9 View this Question Online > Each table appears as a spreadsheet grid called 1. Record 2. Datasheet 3. Queries \ f e 4. Tables O XO \ snow ils ition Below) am : Datasheet MS Excel Question 9 Detailed Solution The correct answer is Datasheet, © Key Points + Datasheet = Each table that appears as a spreadsheet grid is called a datasheet. Hence, Option 2 is correct. = A datasheet is a useful way of viewing data in Access. A database is a collection of tables. Most importantly, datasheet view allows a user to view many table records at the same time In datasheet view, information is displayed in rows and columns—similar to a spreadsheet. » Records are displayed as rows, so each row is an individual record. = Within each row, columns represent fields within the record. At the top of the datasheet, a window is the title bar, the Quick Access toolbar, and the Ribbon. The bottom of the window has a status bar and on the right side of the windowis a scroll bar as you would expect, Many of the features that are common to spreadsheets are present in Access datashe windows. > Auser can modify row height, column width, font size to change the amount of data that fits without scrolling. y r a - Auser can also change the order of the rows or columns ews dow. » Datasheet views are a common display tool for tables, quer! in Access, There are some irregularities in the functionality er tagsas sheet wi depending on the underlying data sources. > \dows for theseImage of Datasheet View: mom a © Additional Information * Query » Aquery is like a saved filter, It enables us to combine data into a single datasheet from multiple tables. + Record » A record isa row in a table that consists of information about something. + Table » A spreadsheet table, in OpenGL Tablets, is an analog of the Excel tabie with rows, columns, formulas, end calculations as contents. » Spreadsheets can also call decision tables or other executable tables to make decisions on values, and based on those, make calculations. é Perea Cae) Start Complete Exam Preparation Bean urea Crear raed MasterClasses Cree ear Download App Question 10 View this Question Online > What is the shortcut to enable filtering of selected cells in MS-Excel? 1. Ctrl+ shift+L 2. CUlt+F 3. Alt+Click +L 4. Shift+F Piacemeune IT yatallanl Galea Rata’>) aa Option 1: Ctrl + shift +L 0° x eC QO Solution an e S answer is Ctrl+ shift + L. © Key Points Ctrl + shift + Lis the shortcut to enable filtering of selected cells in MS-Excel. ©; Additional Information Shortcuts in Excel: ‘lose a workbook ‘trl+W \Open a workbook [Ctri+0 |Go to the Home tab JAlttH |Save a workbook Cults \copy ietr+c Paste tr+V |Undo (Ctrl+Z Remove cell contents [Delete (Choose a fill colour JAlt+H, H cut etx [Go to the Insert tab Alten, Bold trH+B [Center align cell contents JAIt+H, A, C [Go to the Page Layout tab JAlt+P. }0 to the Data tab AltAGo to the View tab JAlt+W |shift+F10, 07 Open context menu ontext key \Add borders JAI+H, B Delete column JAlt+H, D,C Go to the Formula tab JAlt+M Hide the selected rows tr+9 Hide the selected columns(Ctrl+0 India's #1 Learning Platform Start Complete Exam Preparation Cee a er cal} Prue Pee i) Dead pCi reser Download App Pacts Question 11 View this Question Online > Whats the value of the following MS-Excel function? =FLOOR(14, 4)Answer (Detailed Solution Below) Option 4: 12 MS Excel Question 11 Detailed Solution © Key Points Excel FLOOR function: The FLOOR function in Excel is used to round @ given number down, to the nearest multiple of a specified significance. ‘Syntax: FLOOR(number, oonh he) Number- the number you want to round. ‘Significance - the multiple to which you wish to round the number. FLOOR(14, 4) = 12 Here 4 rounds down the nearest multiple of 4 (4 x 3 = 12 is nearer) Hence the correct answer is 72. is Pee ea Elam ee yi (Ce Clue Ld) Re an ue ost a Pears ered ea a MasterClasses ere earud Download App Gi Question 12 View this Question Online > A Doughnut chart in Excel in similar to: 1. Bubble chart : a 2. Barchart 3. er chart, we= 4, Pie chart Answer (Detailed Solution Below) Option 4: Pie chart MS Excel Question 12 Detailed Solution The correct answer is Pie chart. + Doughnut Chart: a © Data that is arranged in columns or rows only on a worksheet can be a ina doughnut chart. i > The doughnut chart is similar to a pie chart. » Just like a pie chart, a doughnut chart shows the restora tt to.a whole. * A doughnut chart can contain more than one data series. Example of Chart: om tl What's your favoriteice cream flavor? $ Ro Tear ies) Start Complete Exam Preparation Cee are ossWe ras ES Download App Question 13 ‘ae View this Question Online > In MS Excel, to add numeric values in column D, fiom rows D10 to 15, the formula that should be usedis : .- 1 =SUM (D10,D15) * ee “ > 2. =COUNT:(010;D15) A. (010:D15) 4. Options 1 and 3 are correct ‘Answer (Detailed Solution Below) Option 3: =SUM (D10:015) MS Excel Question 13 Detailed Solution The correct answer is Option 3 is correct. © Key Points * The SUM function adds values. + You can add individual values, cell references or ranges, or a mix of all three. + For example: =SUM (A2: Ai10) Adds all the values in cells A2: A10. + =SUM (A2, A10) Adds the respected values in cells A2, A10. + To add numeric values in column D, from rows D10 to D1, the formula that should be used is : =SUKD10:015) @ J | =SUM(D10:D15) orB ti f . Important functions used in MS Excel: + AVERAGE() - To calculate the average of the range of the cells. + CONCATENATE - Combine text, numbers, dates, and more from multiple cells into one. + COUNTA- It will allow you to evaluate any gaps the dataset might have without having to reorganize the data. + ROUND - It returns the rounc-off value of the decimals ee eee ane poeta) Start Complete Exam Preparation Ree Dare tg ca Pree eau Mock Tests Etro reer Execs Download App Question 14 . > View this Question Online > What is the maximum height of a row in MS Excel 2010? 1. 255 points at > 2. 100points) =) 2 Oh 4, 128 points Answer (Detailed Solution Below)Option 3 : 409 points MS Excel Question 14 Detailed Solution The correct answer is 409 points + Rows can have a maximum height of 409 points. + This number represents how many one-seventy seconds of an inch the row can hold. + The default size of an “" is 15, Which correlates to 20 pixels or about one-fifth of an inch. »* Important Points Worksheet and workbook specifications and limits: © Key Points ) + Total number of rows and columns on a worksheet - 1,048,576 rows by 16,384 columns + Column width - 255 characters + Page breaks - 1,026 horizontal and vertical + Row height - 409 points Een Ee lay “aap ae Start Complete Exam Preparation ea) aor cies fan pa ied Download App Question 15 # . . View this Question Online > In Excel, tiny charts placed in single cells are called 1. Spark Lines = 2. Data Tray 3. ee 4. Filters:Answer (Detailed Solution Below) Option 1 : Spark Lines MS Excel Question 15 Detailed Solution cy The correct answer is Spark Lines. Noe + Asparkline isa tiny chart in a worksheet cell that provid avis resentation of data. + Use sparklines to show patterns in a progressit ample, occasional increments or diminishes, financial cycles, ximum and minimum values. + Sparklines are locate inse + A sparkline is a tiny worksheet cell that gives a visual portrayal of information. + Position a sparkline close ‘0 Its information for the most prominent effect.