MS Excel MCQ 2 5%Question 1 of 201. Which of the cell pointer indicates you that you can make selection?Mouse Pointer with anchor at the tipDoctor’s symbol (Big Plus)Small thin plus iconNone of aboveQuestion 1 of 20Question 2 of 202. _________function in MS Excel worksheet represents the total number(s) of entries in the cell(s).SUMAVGCOUNTTOTALQuestion 2 of 20Question 3 of 203. Which of the following is not the correct method of editing the cell content?Press the Alt keyPress the F2 keyClick the formula barDouble click the cellQuestion 3 of 20Question 4 of 204. The advantage of using a spreadsheet is :calculations can be done automaticallychanging data automatically updates calculationsmore flexibilityall of the aboveQuestion 4 of 20Question 5 of 205. Which of the cell pointer indicates that you can fill series?Doctor’s symbol (Big Plus)Small thin plus iconMouse Pointer with anchor at the tipNone of aboveQuestion 5 of 20Question 6 of 206. __________is NOT a Function in Microsoft Excel spreadsheets.HYPERLINKCOUNTIFMINAVGQuestion 6 of 20Question 7 of 207. Which of the cell pointer indicates that you can fill series? Doctor’s symbol (Big Plus)Small thin plus iconMouse Pointer with anchor at the tipNone of aboveQuestion 7 of 20Question 8 of 208. When you print preview a worksheet the entire worksheet is displayedthe selected range is displayedthe active portion of the worksheet is displayed a, b and cQuestion 8 of 20Question 9 of 209. Which of the cell pointer indicate that you can move the content to other cell?Doctor’s symbol (Big Plus)Small thin plus iconMouse Pointer with anchor at the tipNone of aboveQuestion 9 of 20Question 10 of 2010. In MS Excel spreadsheet, Data can be sorted using ________.Filter functionARRAY function Lookup functionOperator functionQuestion 10 of 20Question 11 of 2011. The __ feature of ms excel quickly completes a series of data.Auto FilterAuto CompleteAuto Fill Auto SumQuestion 11 of 20Question 12 of 2012. Long text can be broken down into many lines within a cell. You can do this throughWrap Text in Format > CellsJustify in Edit > Cells Text Wrapping in Format > CellsAll of aboveQuestion 12 of 20Question 13 of 2013. Each excel file is a workbook that contains different sheets. Which of the following can not be a sheet in workbook? worksheetmodule sheetdata sheetNone of theseQuestion 13 of 20Question 14 of 2014. You can auto fit the width of column byDouble clicking on the column name on column headerDouble click on the cell pointer in worksheetDouble clicking on column right border on column headerDouble clicking on the column left border of column headerQuestion 14 of 20Question 15 of 2015. You can auto fit the width of column byDouble clicking on the column name on column headerDouble click on the cell pointer in worksheetDouble clicking on column right border on column headerDouble clicking on the column left border of column headerQuestion 15 of 20Question 16 of 2016. In MS Excel_________feature makes it easier to add repetitive data to a worksheet AutosumSortFilterAutocompleteQuestion 16 of 20Question 17 of 2017. Which of the following series type is not valid for Fill Series dialog box?LinearGrowthAutofillTimeQuestion 17 of 20Question 18 of 2018. In Excel which of these is a quick way to copy formatting from a selected cell to two other cells on the same worksheet?Use Ctrl to select all three cells, then click the paste button on the standard toolbarCopy the selected cell, then select the other two cells, click style on the Format menu, then click ModifyClick format painter on the Formatting toolbar twice then click in each cell you want to copy the formatting to All of aboveQuestion 18 of 20Question 19 of 2019. Long text can be broken down into many lines within a cell. You can do this throughWrap Text in Format > CellsJustify in Edit > CellsText Wrapping in Format > CellsAll of aboveQuestion 19 of 20Question 20 of 2020. In MS Excel, Page border option is available under _______ tab.InsertPage LayoutViewNone of the aboveQuestion 20 of 20 Loading...