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