Online Examination 20200% 0 TIME 15 minute Created on August 27, 2025 By ICL Computer Private LimitedCLASS TEST EXCEL 2019 NameEmailRoll_no 1 / 40How do you rearrange the data in ascending or descending order? Data, Form Data, Sort Data, Table Data Subtotals 2 / 40Which function counts the number of cells that contain numeric as well as text COUNTA ( ) None of the These COUNTBLANK ( ) COUNT ( ) 3 / 40What is the default extension of Excel 2019 files? DOC .DOC .xlsx XLX 4 / 40What is the correct way to refer the cell A10 on sheet3 from sheet1? A10 sheet1!A10 sheet3!A10 Sheet3.A10 5 / 40Which Chart can be created in Excel? All of the these Area Line Pie 6 / 40If a formula with relative reference is copied the cell references used in the formula remain unchanged. TRUE FALSE 7 / 40In MS-Excel value used in a formula that does not change is called a Cell address Function None of these Constant 8 / 40Which area in an Excel window allows entering values and formulas? Title Bar Formula Bar Status Bar Name Box 9 / 40A typical worksheet has ___ number of columns 16384 256 32767 1048576 10 / 40Which cell alignment is assigned to most values by default? RIGHT CENTRE LEFT DECIMAL 11 / 40How do you display current date and time in MS Excel? date() Time() Today() Now() 12 / 40Which is an example of a function? =SUM(A1:A2) =add(A1:A2) A1+A2 =A1+A2 13 / 40What is the result of this formula: =1+2*3-1? 10 6 4 6 14 / 40If you key 1.2385 and format the cell for two decimal places, what will be displayed in the formula bar? 1.238 1.2385 1.2 1.23 15 / 40How do you tell one cell from another? By its address By letters By numbers by color 16 / 40How many worksheets can a workbook have by default? 3 1 2 4 17 / 40Which of these references is an example of a relative reference? AB1 B1 $B$1 $B1 18 / 40Which of these references is an example of a mixed reference? A1B $B1 B1 $B$1 19 / 40Microsoft Excel is a powerful……….. Spreadsheet package Communication S/W Package Word processing package Word processing package 20 / 40What is the short cut key to highlight the entire column? Ctrl+Space Bar Ctrl+Page up Ctrl+Enter Ctrl+C 21 / 40Which of the following is not a valid data type in Excel? Character Label Number Date/Time 22 / 40A worksheet range is a A group of cells A command used for data modeling A group of worksheets range of values such as from 23 to 234 23 / 40Which is an example of a formula? =A1+A2 =add (A1:A2) SUM(A1:A2) A1+A2 24 / 40To perform calculation on database we use the following formula =DFUNCTION(database, criteria, field). FALSE TRUE 25 / 40A database is an organized collection of records. FALSE TRUE 26 / 40 In MS-Excel which is used to perform what if analysis? Scenario Manager Name Manager Solver All of these 27 / 40How do you display current date only in MS Excel? Date( ) Now( ) Time( ) Today( ) 28 / 40Comments put in cells are called ….. Cell Tip Smart Tip Web Tip Soft Tip 29 / 40To select an entire column in MS-EXCEL, press? CTRL + Arrow key CTRL + S CTRL + C None of the these 30 / 40It is possible to use Sum, Average and Count Function together in a single Subtotal operation FALSE TRUE 31 / 40What would be the result of =SUM(A1,250), if A1=25? 225 6250 275 270 32 / 40In the formula, which symbol specifies the fixed columns or rows? % @ $ & 33 / 40 In MS-Excel what does SUMIF function do? Both (a) & (b) Adds all the numbers in a range of cells Returns a subtotal in a list or database Adds up cell values based on a condition 34 / 40What does COUNTA () function do? counts cells having alphabets counts empty cells counts non-empty cells counts cells having number 35 / 40The first cell in EXCEL worksheet is... A5 A1 A2 A11 36 / 40The last cell in EXCEL worksheet is XFD1048576 Z1048576 XFD16384 A16384 37 / 40A formula does not always start with = sign FALSE TRUE 38 / 40Excel displays the current cell address in the ………. Status Bar Name BOX Formula bar Title Bar 39 / 40Which of the following is not a term of MS-Excel? Cells Columns Rows Document 40 / 40An Excel Workbook is a collection of ……. Worksheets Worksheets and Charts Workbooks Charts Exit Dear Students Best of Luck For Examination.Enter your Name & Roll number carefully in the examination form otherwise your Exam will be rejected . For Examination Result check your email or contact ICL COMPUTER PVT LTD.
