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