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