Real-Tech Test 8

1.       In MS excel “IFERROR” is a

(1)Financial function               (2) logical function (3) both a or b (4) none of the above

2.       When a format number does not fit within a cell it display

(1)#########                          (2) #$DIV             (3) %%&&                           (4) none of the above

3.       Concatenation of text can be done using

 (1)  =                                             (2) +                       (3) %                                      (4) $

4.       In MS excel formulas and adjacent range is specified by giving the starting and ending

(1)  :                                               (2).                         (3) ;                                        (4) ,

5.       What does the VLOOKUP function do

(1)Looks up text that contain V  (2)checks whether text is the same in one cell as in the next

(3)find related record                  (4)all of the above

6.       If 3/6 is entered in a cell without applying any formats, excel will treat this as

(1)Text                                         (2) formula         (3) date                                (4) fraction

7.       In MS word gutter position can be set in the following positions

(1)Left and right       (2) left and top (3) left bottom                  (4) left only

8.       The feature of word wrap is

(1)Automatically move text to the next line when necessary               

(2)Appears at the bottom of the document

(3)Allow you to type over text                           

(4)Is the short horizontal line indication the end of the document

9.       Which file format can be added to a power point show in window power point 2007

(1).jpg                   (2) .gif                   (3) .wav                                (4) all of the above

10.   If you want any logo in the same position on every slide automatically you will insert that logo in ….

(1)Handout master                 (2) notes master (3) slide master              (4) all of the above

11.   The quickest way to create a power point presentation is

(1)Auto creation wizard (2) auto content wizard (3) auto configure wizard (4) all of the above

12.    Information is?
(1) Summarization process of data   (2) Data Information       (3) form of data (4) Facts and figures

13.   Which of the following is correct?
(1) POWER(2^3)      (2) POWER(2,3) (3) POWER(2#3)                        (4) POWER(2*3)

14.   What is the default font in MS Word?
(1) Gothic Bold        (2) Calibri                      (3) Times new roman                  (4) Arial

15.    ---------- Bar is located at top of WordPad / Notepad /MS Word window.
(1) Title                   (2) Menu                       (3) Format                                 (4) None of these

16.   The vast network of computers that connects millions of people all over the world is called.
(1)LAN                                (2)web                          (3)hypertext                               (4)internet

17.   Which of the following is the key function of a firewall?
(1) Monitoring                      (2) Deleting                   (3) Record                                 (4) Copying 

18.   . In MS Word Key F12 opens ____?
(1) Save dialog box             (2) print dialog box        (3) New dialog box                    (4) Save as dialog  

19.   What is gutter margin?
(1) Margin that is added to the left margin when printing
(2) Margin that is added to right margin when printing
(3) Margin that is added to the binding side of page when printing
(4) Margin that is added to the outside of the page when printing

20.   What do we call the HTML codes written in a text editor to make web pages?
(1) Source code      (2) HTML tags               (3) Source elements                   (4) Roots

21.   IP address contains ........... bits.
(1) 8 bits                 (2)16 bits                      (3) 32 bits                                 (4) 40 bits  

22.   Which key is used to indent a paragraph in MS word ?
(1) Shift                  (2) tab                           (3) Ctrl                                      (4) Esc  

23.   Web layout of a MS word document means

(1)View the document as it would look as a web page            

(2)View the document as it would look as a print out

(3)View the document as it would look in a cell phone           

(4)None of the above

24.   In MS word ……………..is used to create a form letter which you intend to print or  e-mail multiple times sending each copy to a different recipient

(1)Mail Merge               (2) E-mail             (3) Print out                        (4) None of the above

25.   Short cut key to insert a function in MS Excel…

(1)Shift + F3                                (2) Shift + F4       (3) Ctrl + F3                         (4) Shift + F5

26.   Name of the executable file of MS word is-

(1) MS Word                       (2) MS Word .exe          (3) Win Word                 (4) WinWord.exe   

27.   Linux is a (n)______ ______ operating system.
(1) open-source       (2) Microsoft                 (3) Windows                  (4) Mac

28.   Fax machines and imaging systems are examples of
1) bar-code readers             (2) imaging systems      (3) scanning devices      (4) pen-based systems

29.   When writing a document, you can use the _______ feature to find an appropriate word or an alternative word if you find yourself stuck for the right word.
(1) dictionary                       (2) word finder               (3) encyclopedia            (4) thesaurus

30.  A modem that doesn't need to be connected to a telephone line is the ___ modem.
(1) external              (2) internal                     (3) wireless                    (4) DSL

31.  __________________ Applications refers to those applications in which text, sound, graphics, motion video and animation are all combined.
(1) Animation                       (2) Multimedia               (3) Maxmedia                (4) Flash

32.  A VDU is used as 

 (1) Input device only           (2) Output device only   (3) Both (a) & (b)                       (4) Neither (a) nor (b)

33.  Which of the following terms is just the connection of networks that can be joined together ?

(1) virtual private network(2) internet              (3) intranet                     (4) extranet

34.  Servers are computers that provide resources to other computers connected to a ________

(1) network              (2) mainframe                (3) supercomputer         (4) client