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