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