Online FINAL-Examination 20250% 0 votes, 0 avg 112 Report a question What's wrong with this question?You cannot submit an empty report. Please add some details. 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100 Created on September 04, 2025 By ICL Computer Private Limited DIPLOMA IN INFORMATION TECHNOLOGY PLUS (FINAL EXAMINATION) 2025Award of Grade:The Grade of SATISFACTORY requires securing a minimum score of 40% in each internals as well as the final examination& an overall weighted score of 50% An overall weighted score of 60-74% qualifies for CREDIT and >=75% qualifies for DISTINCTION. General information: 1. The examination will comprise of Objective type Multiple Choice Questions (MCQs) 2. All questions are compulsory and each carries One mark. 3. The total number of questions, duration of examination, will be different based on the course, the detail is available on your screen. 4. The Subjects or topics covered in the exam will be as per the Syllabus. 5. There will be NO NEGATIVE MARKING for the wrong answers. Fill in the form in all Capital Letters. Roll_noNameStudent's DOBFather's nameMobile NumberEmailCourse NameCourse NameBIT(4 Months)BIT(6 Months)DIT(9Months)DIT+(12 Months)Tally Prime (3 Months)CCC TESTWORD 2021EXCEL 2021ACCESS 2021Batch Time SelectionBatch Time Selection08:00 to 09:00 AM09:00 to 10:00 AM10:00 to 11:00 AM02:00 to 03:00 PM03:00 to 04:00 PM04:00 to 05:00 PM05:00 to 06:00 PM 1 / 1001) What is the short cut key to highlight the entire column? a) Ctrl+Enter b) Ctrl+Space Bar c) Ctrl+C d) Ctrl+Page up 2 / 1002) The undo command is found where in Access? a) Status bar b) Office button c) Quick Access toolbar d) Home command tab 3 / 1003) To delete records or perform calculations on a table, the best tool to use is a a) form b) query c) filter d) record 4 / 1004) A database is an organized collection of records. a) FALSE b) TRUE 5 / 1005) What is the default extension of Excel 2019 files? a) XLX b) .xlsx c) .DOC d) DOC 6 / 1006) Fiber optics have the advantage of _____. a) being cheaper to install b) having no interference c) being easier to install than twisted wire d) using direct line-of-sight 7 / 1007) To create a new worksheet, select worksheet from the file menu. a) FALSE b) TRUE 8 / 1008) What is the keyboard shortcut to move to the last records in a table? a) [Shift]+[Tab] b) [Tab] c) [Ctrl]+Home] d) [Ctrl]+[End] 9 / 1009) A worksheet range is a a) A group of worksheets b) A command used for data modeling c) range of values such as from 23 to 234 d) A group of cells 10 / 10010) Users can turn off the Format Painter button by pressing the _______________ key. a) Alt b) Esc c) Ctrl d) Tab 11 / 10011) How do you rearrange the data in ascending or descending order? a) Data Subtotals b) Data, Table c) Data, Sort d) Data, Form 12 / 10012) If you key 1.2385 and format the cell for two decimal places, what will be displayed in the formula bar? a) 1.238 b) 1.2 c) 1.2385 d) 1.23 13 / 10013) Which of the following statements about the Undo option in PowerPoint is NOT correct? a) The Undo option can reverse the editing actions after saving a document. b) The Undo option reverses the last editing action. c) Users can specify the number of actions to be undone. d) Users can undo multiple actions at one time. 14 / 10014) To perform calculation on database we use the following formula =DFUNCTION(database, criteria, field). a) TRUE b) FALSE 15 / 10015) How many worksheets can a workbook have by default? a) 1 b) 3 c) 4 d) 2 16 / 10016) How is a spelling error indicated? a) by a green wavy underline b) by a red wavy underline c) with a ScreenTip d) with the Smart Tag 17 / 10017) Which of the following is not a term of MS-Excel? a) Document b) Cells c) Rows d) Columns 18 / 10018) "After a table has been created, which of the following operations cannot be performed?" a) Split the table into two tables b) Insert rows in a table c) Delete and insert columns d) None of the above 19 / 10019) In Word Drop caps applied to a) Words b) None of the above c) Sentences d) Characters 20 / 10020) Status bar shows different types of keys: a) Caps lock key b) Scroll lock key c) All of these d) Num lock key 21 / 10021) What is the symbol for dividing? a) - b) + c) / d) * 22 / 10022) Excel displays the current cell address in the ………. a) Title Bar b) Formula bar c) Name BOX d) Status Bar 23 / 10023) Which area in an Excel window allows entering values and formulas? a) Formula Bar b) Name Box c) Title Bar d) Status Bar 24 / 10024) A set of rules is known as protocol. a) TRUE b) FALSE 25 / 10025) Which symbol displays the text in upper case? a) < b) > c) & d) $ 26 / 10026) It is possible to use Sum, Average and Count Function together in a single Subtotal operation a) FALSE b) TRUE 27 / 10027) A main form can have only one subform. a) TRUE b) FALSE 28 / 10028) A formula does not always start with = sign a) FALSE b) TRUE 29 / 10029) __________ are documents that when filled in create records. a) Queries b) Tables c) Reports d) Forms 30 / 10030) Comments put in cells are called ….. a) Smart Tip b) Web Tip c) Soft Tip d) Cell Tip 31 / 10031) What is the function of the Format Painter tool? a) to copy the format of an object to another object b) to copy only the gradient fill format of an object c) to copy text along with its formatting d) to copy the format of an object, but not the associated default settings 32 / 10032) Which is an example of a formula? a) =A1+A2 b) =add (A1:A2) c) SUM(A1:A2) d) A1+A2 33 / 10033) To have Microsoft Excel always use a specific currency symbol, change the currency symbol selected in Regional Settings in Control Panel before you start Excel. a) FALSE b) TRUE 34 / 10034) To insert a header or footer in a worksheet, select Header and Footer option in the File menu. a) TRUE b) FALSE 35 / 10035) What would I choose to create a pre-formatted style? a) Slide sorter b) Format c) None of These d) Slide layout 36 / 10036) To print the PowerPoint presentation, press a) CTRL + E b) Alt+P c) CTRL + V d) CTRL + P 37 / 10037) Which Chart can be created in Excel? a) Area b) Line c) Pie d) All of the these 38 / 10038) Which cell alignment is assigned to most values by default? a) CENTRE b) DECIMAL c) LEFT d) RIGHT 39 / 10039) In MS-Excel value used in a formula that does not change is called a a) Constant b) Cell address c) None of these d) Function 40 / 10040) In M.S Access 2010 the extension of database is a) .mdb b) .mob c) .moc d) .accdb 41 / 10041) "When you create a formula that contains a function, the Insert Function dialog box helps you enter worksheet functions." a) FALSE b) TRUE 42 / 10042) The field size can vary for text field from a) 1-228 b) 1-25 c) 1-255 d) 1-227 43 / 10043) ISP is a company that provides an Internet connection a) FALSE b) TRUE 44 / 10044) "When you activate the Spelling and Grammar checker," a) it displays the misspelled words in a dialog box. b) All of the above c) it highlights the misspelled words in the document. d) it allows you to either correct the misspelled word manually. 45 / 10045) What does COUNTA () function do? a) counts cells having alphabets b) counts empty cells c) counts cells having number d) counts non-empty cells 46 / 10046) Which of these references is an example of a relative reference? a) AB1 b) $B$1 c) $B1 d) B1 47 / 10047) The __________ is used to access one record at a time. a) form b) query c) report d) filter 48 / 10048) To select an entire column in MS-EXCEL, press? a) None of the these b) CTRL + Arrow key c) CTRL + S d) CTRL + C 49 / 10049) Which of the following data types automatically generates a consecutive number? a) Memo b) text c) Autonumber d) Number 50 / 10050) GUI is used as an interface between a) man and machine b) None of the These c) software and user d) hardware and software 51 / 10051) The table can be related on a command field called. a) foreign key field b) Key field c) Primary Key field d) none of the these 52 / 10052) slide show begins with the _______________. a) current slide b) first slide c) animated slide d) Last slide 53 / 10053) Which is an example of a function? a) =A1+A2 b) =add(A1:A2) c) A1+A2 d) =SUM(A1:A2) 54 / 10054) A command button executes one or more actions on a form. a) TRUE b) FALSE 55 / 10055) What would be the result of =SUM(A1,250), if A1=25? a) 6250 b) 275 c) 225 d) 270 56 / 10056) Microsoft Excel is a powerful……….. a) Spreadsheet package b) Word processing package c) Word processing package d) Communication S/W Package 57 / 10057) When you turn on background printing, you can continue working in PowerPoint while you print. a) FALSE b) TRUE 58 / 10058) The purpose of AutoSum in Excel is to a) add grand totals to a range containing other totals b) total any range that you select c) All of the above d) locate and total the rows or columns in a range nearest to the current cell 59 / 10059) How do you display current date and time in MS Excel? a) Now() b) Time() c) date() d) Today() 60 / 10060) In Datasheet View, what appears at the top of each column? a) Data type b) Primary key c) Description d) Field name 61 / 10061) The form that contains one or more subforms is called the _____ form. a) Main b) Primary c) Head d) Master 62 / 10062) If your text exceeds the size of the placeholder, Microsoft PowerPoint reduces the font size and line spacing incrementally as you type, to make the text fit. a) TRUE b) FALSE 63 / 10063) Pressing [Ctrl]+[M] _______________. a) Pressing [Ctrl]+[M] _______________. b) inserts a new presentation file c) inserts a new paragraph d) inserts a hyperlink 64 / 10064) e-mail is a) Transaction of messages within a computer b) Mail concerning electronics devices c) Transaction of letters, messages and memos over a communications network d) None of these 65 / 10065) A typical worksheet has ___ number of columns a) 1048576 b) 16384 c) 32767 d) 256 66 / 10066) What is the correct way to refer the cell A10 on sheet3 from sheet1? a) A10 b) sheet1!A10 c) sheet3!A10 d) Sheet3.A10 67 / 10067) In MS-Excel what does SUMIF function do? a) Adds up cell values based on a condition b) Both (a) & (b) c) Adds all the numbers in a range of cells d) Returns a subtotal in a list or database 68 / 10068) A filter is used to quickly limit the records you are already viewing in a datasheet or form. a) TRUE b) FALSE 69 / 10069) The last cell in EXCEL worksheet is a) XFD16384 b) XFD1048576 c) Z1048576 d) A16384 70 / 10070) You can enlarge the sheet upto 500% while printing a) FALSE b) TRUE 71 / 10071) Which function counts the number of cells that contain numeric as well as text a) COUNTA ( ) b) COUNTBLANK ( ) c) None of the These d) COUNT ( ) 72 / 10072) The __________ field is used to hold a yes or no answer. a) logical b) OBJECT c) text d) NUMBER 73 / 10073) In the formula, which symbol specifies the fixed columns or rows? a) @ b) % c) & d) $ 74 / 10074) An existing presentation can be saved with a new name using the _________ command. a) Paste b) Copy c) Save d) Save As 75 / 10075) "In Word, print preview command is found under which menu?" a) view b) Edit c) File d) Tools 76 / 10076) Which function key is used to run the spelling checker? a) F2 b) F8 c) F7 d) F5 77 / 10077) Theme effects are most noticeable when? a) theme fonts are used. b) graphics are used. c) color changes are made. d) when viewing a slide show 78 / 10078) An Excel Workbook is a collection of ……. a) Worksheets and Charts b) Workbooks c) Charts d) Worksheets 79 / 10079) In M.S Access the default text field size is....... a) 325 b) 26 c) 66 d) 255 80 / 10080) To print information from a table, the __________ tool is the best choice. a) table b) report c) query d) form 81 / 10081) If a formula with relative reference is copied the cell references used in the formula remain unchanged. a) TRUE b) FALSE 82 / 10082) In MS-Excel which is used to perform what if analysis? a) All of these b) Scenario Manager c) Solver d) Name Manager 83 / 10083) In Word, the ruler is displayed by default. a) FALSE b) TRUE 84 / 10084) When information is keyed for a footer, by default, where will it appear? a) top of notes page or handouts page b) at the right of the slide c) at the left of the slide d) bottom of a slide, notes page, or handouts page 85 / 10085) The value of primary key cannot be a) Null b) All of the above c) Duplicated d) Changed 86 / 10086) The first cell in EXCEL worksheet is... a) A11 b) A2 c) A5 d) A1 87 / 10087) Font size is commonly measured in? a) Points b) Pixels c) Inches d) Rules 88 / 10088) In Excel, once a range has been named, you can go to a range a) by selecting ranges using the name box b) by selecting ranges using the [F5] key c) None of the above d) both a and b 89 / 10089) In which tab is the Header and Footer button found? a) Home b) Insert c) View d) File 90 / 10090) The Default view in MS Power point 2010 a) Outline View b) Slide sorter view c) Slide show view d) Normal view 91 / 10091) In Datasheet View, new records are added to a table _______________. a) in alphabetical order b) at the end of the table c) in numerical order d) at the beginning of the table 92 / 10092) Which function key is used to run the slide show a) F3 b) F5 c) F4 d) F12 93 / 10093) Which of these references is an example of a mixed reference? a) $B1 b) B1 c) $B$1 d) A1B 94 / 10094) How do you tell one cell from another? a) By letters b) By its address c) By numbers d) by color 95 / 10095) How do you display current date only in MS Excel? a) Time( ) b) Now( ) c) Date( ) d) Today( ) 96 / 10096) In addition to the Slides tab in Normal view, which view allows a user to select slides? a) Slide Show b) Outline c) Slide Starter d) Slide Sorter 97 / 10097) SQL stands for __________. a) Standard Query Language b) Simplified Query Language c) Static Query Language d) Structured Query Language 98 / 10098) How many characters can be typed in a single cell in Excel? a) 256 b) 32767 c) 16384 d) 3600 99 / 10099) Memo field is used to the picture. a) TRUE b) FALSE 100 / 100100) Which of the following is not a valid data type in Excel? a) Character b) Number c) Label d) Date/Time Your score is 0% Exit
