/30 Your time is finish. So please submit your document. Advance Excel Exam 2026 Dear student read carefully. This is real time online exam. You can’t skip this page. You get only 30 Minutes for 30 question. Each question have 1 marks. You must be submit within a time. Enter Password 1 / 30 MS Excel provides the default value for step in Fill Series dialog box 10 0 1 5 2 / 30 In MS Excel, the keyboard shortcut “Ctrl+S” can be used to_ Switch between opened tab Save As Start new workbook Save 3 / 30 Which tool you will use to join some cells and place the content at the middle of joined cell? From Format Cells dialog box select the Centered alignment From Format Cells dialog box choose Merge and Center check box From Format Cells dialog box click on Merge Cells check box Click on Merge and Center tool on formatting toolbar 4 / 30 Each Excel workbook can contain multiple worksheets. True False 5 / 30 Which of the following option is not available in Paste Special dialog box? Add Divide Subtract SQRT 6 / 30 Ctrl + D shortcut key in Excel will None of above Open the font dialog box Apply double underline for the active cell Fill down in the selection 7 / 30 Which Excel function is used to calculate the future value of an investment? PV FV NPV IRR 8 / 30 Microsoft Excel 2019 has column limit of ____ 16384 18634 84163 13684 9 / 30 Name the keyboard shortcut to use to switch between open Excel windows. CTRL + TAB None ALT + TAB CTRL + ALT + TAB 10 / 30 What cloud service does the excel 2016 implements? One drive 4shared Google drive Cloud drive 11 / 30 What will be the output if you format the sale containing 5436.8 as ‘#,##0.00’? 5436.8 5436.80 5430 6.8 12 / 30 Edit > Delete command Deletes the content of a cell Deletes Formats of cell Deletes the comment of cell Deletes selected cells 13 / 30 If user Input in A1 cell = 45 and B1 cell =50. So which formula used for get result IN C1 cell as 45. =MAXIMUM(A1:B1) =AVERAGE(A1:B1) =MIN(A1:B1) =MAX(A1:B1) 14 / 30 Where can you change automatic or manual calculation mode in Excel? Go to File > Options > Formulas > Calculation Option – and mark the corresponding radio button Both of above None of above Double CAL indicator on status bar 15 / 30 Microsoft Excel was first time launched in 1985 by the Microsoft Corporation False True 16 / 30 How can you round a number to the nearest whole number in Excel? =CEILING() =ROUNDUP() =ROUNDDOWN() =ROUND() 17 / 30 Which of the following is not the correct method of editing the cell content? Click the formula bar Double click the cell Press the Alt key Press the F2 key 18 / 30 The Name box on to the left of formula bar Shows the name of workbook currently working on Shows the name of cell or range currently working on Shows the name of worksheet currently working on None of above 19 / 30 What is the intersection of a column and a row on a worksheet called ? Address Column Cell Value 20 / 30 MS Excel file can NOT be directly exported as ______ PDF TXT PPT CSV 21 / 30 Formulas in Excel start with ________ = + * / 22 / 30 What type of chart will you use to compare performance of sales of two products ? Pie Chart Line Chart Both A and B Column Chart 23 / 30 What does COUNTA () function do? Counts cells having number Counts empty cells Counts non-empty cells Counts cells having alphabets 24 / 30 What do you use to create a chart? Data Wizard Excel Wizard Chart Wizard Pie Wizard 25 / 30 When all the numbers between 0 and 100 in a range should be displayed in Red Color, apply Apply Conditional Formatting command on Format menu All of above Select the cells that contain number between 0 and 100 then click Red color on Text Color tool Use =if() function to format the required numbers red 26 / 30 How can you update the values of formula cells if Auto Calculate mode of Excel is disabled? F11 F9 F10 F8 27 / 30 Why is the =COUNTIF function in Excel used? Counts cells as specified Returns values based on a TRUE or FALSE condition Counts cells with numbers in a range Counts blank cells in a range 28 / 30 You want to set such that when you type Baishakh and drag the fill handle, Excel should produce Jestha, Aashadh and so on. What will you set to effect that? Custom List Auto Fill Options Fill Series Fill Across Worksheet 29 / 30 To remove the content of selected cells you must issue ______ command Delete Clear Delete Clear Contents Clear All 30 / 30 Tab scroll buttons are place on Excel screen Towards the bottom left corner Towards the top right corner Towards the bottom right corner Towards the top left Submitted Successfully
