

McqMate
These multiple-choice questions (MCQs) are designed to enhance your knowledge and understanding in the following areas: Bachelor of Commerce (B Com) .
251. |
Which function will you use to enter current time in a worksheet cell? |
A. | =today() |
B. | =now() |
C. | =time() |
D. | =current Time() |
Answer» C. =time() |
252. |
Pre-made sheet formats like Simple, Classic, Accounting, Colourful etc. can be applied from |
A. | from Format >> Cells |
B. | from Format >> Auto format |
C. | from Table >> Auto format |
D. | All of above |
Answer» B. from Format >> Auto format |
253. |
Which of the following is not true regarding Conditional Formatting? |
A. | You can add more than one condition to check |
B. | You can set condition to look for Bold and apply Italics on them. |
C. | You can apply Font, border and pattern formats that meets the specified conditions |
D. | You can delete any condition from Conditional Formatting dialog box if |
Answer» C. You can apply Font, border and pattern formats that meets the specified conditions |
254. |
By default Excel provides 3 worksheets. You need only two of them, how will you delete the third one? |
A. | Right click on Sheet Tab of third sheet and choose Delete from the context menu |
B. | Click on Sheet 3 and from Edit menu choose Delete |
C. | Both of above |
D. | None of above |
Answer» A. Right click on Sheet Tab of third sheet and choose Delete from the context menu |
255. |
While finding and replacing some data in Excel, which of the following statement is valid? |
A. | You can Find and Replace within the sheet or workbook |
B. | Excel does not have option to match case for find |
C. | Both are valid |
D. | None are valid |
Answer» A. You can Find and Replace within the sheet or workbook |
256. |
What PowerPoint feature will you use to apply motion effects to different objects of a slide? |
A. | Slide Transition |
B. | Slide Design |
C. | Animation Objects |
D. | Animation Scheme |
Answer» D. Animation Scheme |
257. |
The difference between Slide Design and Auto Content Wizard is |
A. | Both are same |
B. | Auto content Wizard is just the wizard version of Slide Design |
C. | Slide Design does not provide sample content but Auto Content Wizard provides sample content too! |
D. | Slide Design asks your choice in steps but Auto Content Wizard does not let you make choices |
Answer» C. Slide Design does not provide sample content but Auto Content Wizard provides sample content too! |
258. |
Which menu provides you options like Animation Scheme, custom Animation, Slide Transition? |
A. | Insert Menu |
B. | Format Menu |
C. | Tools Menu |
D. | Slide Show Menu |
Answer» D. Slide Show Menu |
259. |
What happens if you select first and second slide and then click on New Slide button on toolbar? |
A. | A new slide is inserted as first slide in presentation |
B. | A new slide is inserted as second slide in presentation |
C. | A new slide is inserted as third slide in presentation |
D. | None of above |
Answer» C. A new slide is inserted as third slide in presentation |
260. |
Which of the following font effect is not available in PowerPoint Font dialog box? |
A. | Underline |
B. | Shadow |
C. | Emboss |
D. | Strikethrough |
Answer» D. Strikethrough |
261. |
Material consisting of text and numbers is best presented as |
A. | A table slide |
B. | A bullet slide |
C. | A title slide |
D. | none |
Answer» A. A table slide |
262. |
Which of the following should you use if you want all the slide in the presentation to have the same “look”? |
A. | the slide layout option |
B. | add a slide option |
C. | outline view |
D. | a presentation design template |
Answer» D. a presentation design template |
263. |
If you have a PowerPoint show you created and want to send using email to another person you can add the show to your email message as a (an) |
A. | Inclusion |
B. | Attachment |
C. | Reply |
D. | Forward |
Answer» B. Attachment |
264. |
Which of the following toolbars provide different options in various master views? |
A. | Common tasks toolbar |
B. | Drawing toolbar |
C. | Formatting toolbar |
D. | Standard toolbar |
Answer» A. Common tasks toolbar |
265. |
---------- is a method to find a specific value of cell by adjusting the value of another cell. |
A. | Goal seek |
B. | Scenario manager |
C. | Data table |
D. | Macro |
Answer» A. Goal seek |
266. |
Discussion groups may have a __________ who monitors the postings and enforces the site’s rules. |
A. | judge |
B. | sysop |
C. | narrator |
D. | censor |
Answer» B. sysop |
267. |
_______ refers to using the small portable and hand held computing devices such as PDA laptops mobile phones MP3 players digital cameras tablet PC and Palmtops in a wireless enabled network. |
A. | Personal computing |
B. | Digital computing. |
C. | Network computing. |
D. | Mobile computing. |
Answer» D. Mobile computing. |
268. |
A___________ identifies a user’s personal preferences and settings and allows the web site's server to retrieve your information from its database. |
A. | Cookie. |
B. | View history. |
C. | Prototype. |
D. | Profile. |
Answer» A. Cookie. |
269. |
A_____ room or online forum allows users to communicate through typed messages which are displayed almost instantly. |
A. | Mail. |
B. | Buddy. |
C. | Chat. |
D. | Message. |
Answer» C. Chat. |
270. |
DSA stands for______________. |
A. | Digital Signature Algorithm. |
B. | Digital System architecture. |
C. | Digital system analysis. |
D. | Digital Signature Authentication. |
Answer» A. Digital Signature Algorithm. |
271. |
ISDN stands for ____. |
A. | Integrated Standard Digital Network. |
B. | Integrated Service Digital Networking |
C. | Integrated Service Digital Network. |
D. | Independent Standard Digital Network. |
Answer» C. Integrated Service Digital Network. |
272. |
ATM is a service that can run over____. |
A. | SONET. |
B. | SDH. |
C. | B-ISDN. |
D. | ISDN. |
Answer» C. B-ISDN. |
Done Studing? Take A Test.
Great job completing your study session! Now it's time to put your knowledge to the test. Challenge yourself, see how much you've learned, and identify areas for improvement. Don’t worry, this is all part of the journey to mastery. Ready for the next step? Take a quiz to solidify what you've just studied.