MS Excel MCQ 3 5%Question 1 of 201. In Microsoft Excel cells, function must start with ________$= ” “ FQuestion 1 of 20Question 2 of 202. Which of the following Excel screen components can NOT be turned on or off? Formula BarStatus BarTool BarNone of aboveQuestion 2 of 20Question 3 of 203. Which function Is not available In the Consolidate dialog box?PmtMaxSumNone of theseQuestion 3 of 20Question 4 of 204. MS Excel provides the default value for step in Fill Series dialog box01510Question 4 of 20Question 5 of 205. In MS Excel, Workbook can be closed using keyboard shortcut ______Ctrl+CCtrl+WEsc Ctrl+EQuestion 5 of 20Question 6 of 206. Which of the following you can paste selectively using Paste Special command?ValidationFormatsFormulasAll of aboveQuestion 6 of 20Question 7 of 207. Which of the following will not cut information?Pressing Ctrl + CSelecting Edit >Cut from the menuClicking the Cut button on the standardPressing Ctrl + XQuestion 7 of 20Question 8 of 208. When a row of data is to be converted into columnsCopy the cells in row, select the same number of cells in row and paste Copy the cells in column then choose Paste Special, then click Transpose and OKCopy the cells then go to Cells then on Alignment tab click Transpose check box and click OKSelect the cells then place the cell pointer on new cell and choose Paste Special, mark Transpose check box and click OKQuestion 8 of 20Question 9 of 209. In MS Excel, keyboard shortcut keys to create a new workbook is _____Tab+NFn+NAlt+NCtrl+NQuestion 9 of 20Question 10 of 2010. Paste Special allows some operation while you paste to new cell. Which of the following operation is valid?SquarePercentageGoal SeekDivideQuestion 10 of 20Question 11 of 2011. In Excel to select a column the easiest method is toDouble click any cell in the columnDrag from the top cell in the column to the last cell in the columnClick the column headingClick the column labelQuestion 11 of 20Question 12 of 2012. Ctrl + D shortcut key in Excel willOpen the font dialog boxApply double underline for the active cellFill down in the selectionNone of aboveQuestion 12 of 20Question 13 of 2013. What happens when you press Ctrl + X after selecting some cells in Excel?The cell content of selected cells disappear from cell and stored in clipboardThe cells selected are marked for cutting The selected cells are deleted and the cells are shifted leftThe selected cells are deleted and cells are shifted upQuestion 13 of 20Question 14 of 2014. When the formula bar is active, you can seeThe edit formula buttonThe cancel buttonThe enter button All of the aboveQuestion 14 of 20Question 15 of 2015. The shortcut key Ctrl + R is used in Excel toRight align the content of cell Remove the cell contents of selected cellsFill the selection with active cells to the rightNone of aboveQuestion 15 of 20Question 16 of 2016. In MS Excel, Ctrl+S can be used to_______ SaveSave AsSwitch between opened tab Start New WorkbookQuestion 16 of 20Question 17 of 2017. Which of the following option is not available in Paste Special dialog box?AddSubtractDivideSQRTQuestion 17 of 20Question 18 of 2018. Which tool you will use to join some cells and place the content at the middle of joined cell?From Format Cells dialog box click on Merge Cells check boxFrom Format Cells dialog box select the Centered alignmentFrom Format Cells dialog box choose Merge and Center check boxClick on Merge and Center tool on formatting toolbarQuestion 18 of 20Question 19 of 2019. The command Edit > Fill Across Worksheet is active only whenOne sheet is selectedWhen many sheets are selectedWhen no sheet is selectedNone of aboveQuestion 19 of 20Question 20 of 2020. Edit > Delete commandDeletes the content of a cell Deletes Formats of cellDeletes the comment of cellDeletes selected cellsQuestion 20 of 20 Loading...