In help menu of Excel, which of the following tabs are found?


Options: Contents tab B. Answer Wizard tab C. Index tab D. all of the above.

Ans:– D ,


Description: mcqquestions

Asked in: KCC-2018   |   JOA 556-2018  |  HRTC JTO-2017

Hits Today: 7940 | Level: Moderate


******************************************************

Want to see where do you stand among other aspirants in "Computer" category?

Click Here to take quick 10 mins MCQ test to find out.




Got some suggestion about this question or to make this site better? Please leave your comments below.




More MS-Excel Related questions:


.   The size of an organization chart object
Options: a. Is determined by the presentation design and cannot be changed b. Is determined by the presentation design but can be changed in PowerPoint c. Is dependent on the amount of text within the organization chart d. B and c

Ans:5 – D ,5 – D


Which of the following is not the responsibility of the utilities component of DBMS software?
Options: creating the physical and logical designs,    removing flagged records for deletion,    creating and maintaining the data dictionary,    monitoring performance

Ans:A ,A


How many types of keys in Database Design?
Options: a. Candidate key b. Primary key c. Foreign key d. All of these

Ans:– d ,


When MS-DOS formats a disk, it automatically creates the main directory on your disk, which is called the _____ directory.
Options: main,    root,    area,    border

Ans:B ,B


A database server is responsible for which of the following?
Options: Database storage,    Data processing logic,    Data presentation logic,    All of the above.

Ans:A ,A


. Which of these toolbars allows changing of Fonts and their sizes?
Options: a. Standard b. Formatting c. Print Preview d. None of these

Ans:–  B,–  B


A flat-bed plotter uses a pen which moves in two directions across a piece of paper fixed on a flat-bed. Can you tell who controls the movements of this pen?
Options: microfilm,    microfiche,    film card,    COM

Ans:C ,C


An optical input device that interprets pencil marks on paper media is
Options: O.M.R,    Punch card reader,    Optical scanners,    Magnetic tape

Ans:A,(Aanswer


. Which one is true for unconditional disk formatting?
Options: a. Destroys every byte of data on a disk by overwriting itwith with blank spaces b. Do not check/scan surface after format c. Transfer system files after format d. All of above

Ans: a, a


. To edit data in an embedded Excel worksheet object in a Word document
Options: a. Use the Excel menu bar and toolbars inside the word application b. Edit the hyperlink c. Edit the data in a Excel source application d. Use the Word menu bar and toolbars

Ans:– a,– a


You have a Cisco mesh network. What protocol allows multiple APs to connect with many redundant connections between nodes?
Options: LWAPP,    AWPP,    STP,    IEEE

Ans:B ,B


You were installing an application in Windows 95, and the computer crashes, what do you do?
Options: press alt + Ctrl + delete, twice,    press alt + Ctrl + delete, and end task,    press the reset button on the computer,    turn off computer and boot from a floppy disk

Ans:D ,D


In LISP, the function assigns the symbol x to y is
Options: (setq y x),    (set y = 'x'),    (setq y = 'x'),    (setq y 'x')

Ans:D ,D


. The value of each bead in earth is
Options: A) 1 B) 3 C) 5 D) 7

Ans:A,A


An instruction that transfers program control to one or more possible paths is known as
Options: Utility program,    System software,    Broadband channel,    Application program

Ans:C,C


Which of the following is not an Schema?
Options: Database Schema B. Physical Schema C. Critical Schema D. Logical Schema

Ans:– C ,


. Clear the contents by pressing “DELETE” key from a keyboard will clear
Options: Text Only B. Format Only C. Contents Only D. Both Contents and Format

Ans:– C ,


Binary numbers need more places for counting because
Options: They are always big numbers,    Any no. of 0's can be added in front of them,    Binary base is small,    0's and l's have to be properly spaced apart

Ans:C ,C


. In a datasheet, what does each row represent?
Options: a. Record b. Field c. Database d. Table

Ans:– a,– a


Which of the following is(are) true of the EDP auditors?
Options: they should have computer expertise,    they will be replaced by traditional auditors in the near future,    two of the above,    currently, there is a very high demand for them, particularly from firms that use personal computers

Ans:A ,A


An anticipated result from multiprogramming operations is:
Options: reduced computer idle time,    the handling of more jobs,    better scheduling of work,    All of the above

Ans:D ,D


When creating a new table which method can be used to choose fields from standard databases and tables
Options: a. Create table in Design View b. Create Table using wizard c. Create Table by Entering data d. None of above

Ans:ndash; b,ndash; b


. Booting means
Options: a. Restarting computer b. Installing program c. Removing errors d. Switch off

Ans:7 – a ,7 – a


Which button do you click to add up a series of numbers?
Options: a. The autosum button b. The Formula button c. The quicktotal button d. The total button

Ans:#8211; a,#8211; a


. Which of the following function will use to find the highest number in a series of number?
Options: a. MAX(B1:B3) b. MAXIMUM (B1:B3) c. HIGH (B1:B3) d. HIGHEST(B1:B3)

Ans:– a,– a


. Superscript, subscript, outline, emboss, engrave are known as
Options: a. font styles b. font effects c. word art d. text effects

Ans: – B , – B


Which memory is nonvolatile and may be written only once?
Options: RAM,    EE-ROM,    RAM,    PROM

Ans:D ,D


The 32-bit internet address 10000000 00001010 00000010 00011110 will be written in dotted decimal notation as
Options: 128.10.2.30,    210.20.2.64,    164.100.9.61,    148.20.2.30

Ans:A ,A


73. Ctrl + E
Options: a. Exit Application b. Select All c. Clear All d. Align Center

Ans:–  D ,–  D


On PC power supplies, the wire attached to pin one is usually:
Options: blue or red,    blue or white,    red or black,   white or orange

Ans:white or orange,D


. Signals can be analog or digital and a computer that processes the both type of signals is known as
Options: A) Analog computer B) Digital Computer C) Hybrid Computer D) Mainframe Computer

Ans:C,C


Which command is used to delete the directory and all its contents in one step?
Options: DEL *.*,    RD,    DELTREE,    CD

Ans:C ,C


Computers with 80286 microprocessor is
Options: A) XT computer B) AT comptuers C) PS/2 computer D) None of above

Ans:-B,-B


. The option group ____ describes the contents of the entire option group.
Options: a. event b. frame c. label d. value

Ans:– c,– c


What is bytecode?
Options: Machine-specific code,    Java code,    Machine-independent code,    None of the above is correct.

Ans:C ,C


. Which of the following is a storage device?
Options: A) Tape B) Hard Disk C) Floppy Disk D) All of the above

Ans:D,D


Which option is used with cmp command to give a detailed list of the byte number and the differing bytes in octal for each character that differs in both the files?
Options: -l,    -d,    -r,    -b

Ans:A ,A


. Which is the highest form?
Options: A) Data B) Information C) Knowledge D) All of above

Ans:C,C


Telecommunication networks frequently interconnect an organization with its customers and suppliers. Select the best fit for answer:
Options: Bandwidth alternatives,    Switching alternating,    Inter organizational networks,    Extranets

Ans:C ,C


. switching between portrait and landscape modes involves the:
Options: a. header and footer toolbar b. print layout view c. page setup dialog box d. none of the above

Ans:–  C,–  C


A partitioned data set is most used for
Options: a program or source library,    storing program data,    storing backup information,    storing ISAM files

Ans:A ,A


Ctrl + H
Options: Open Find and Replace Dialog box with activating Replace Tab B. Open Format Dialog box activating Insert Hyper Link tab C. Open Insert Dialog box activating Insert Hyper Link Tab D. Open Insert Hyper Link Dialog box

Ans:– A ,


. Which of the following can be used to divide a web page into areas?
Options: a. frames b. theme c. table of contents d. none of the above

Ans: –  A , –  A


Which of the following memory unit that processor can access more rapidly
Options:  Main Memory B.  Virtual Memory C.  Cache memory D.  Read Only Memory

Ans:– C ,


Which of the following symbol sets would be most likely to contain a mathematical symbol such as a degree sign, greater than or equal to, or a Greek letter?
Options:  A) Wingdings, B) Wingdings 3, C) Webdings, D) Symbol,

Ans:-D,-D


Using the illustration from the previous question, what would be the IP address of S0 if you were using the first subnet? The network ID is 192.168.10.0/28 and you need to use the last available IP address in the range. Again, the zero subnet should not be considered valid for this question.
Options: 192.168.10.24,    192.168.10.62,    192.168.10.30,    192.168.10.127

Ans:C ,C


Demodulation is a process of
Options: converting analog to digital signals,    converting digital to analog signals,    multiplexing various signals into one high speed line signals,    performing data description.

Ans:A ,A


What is the shortcut key for Spelling Check in document?
Options: F7 B. Shift + F7 C. Ctrl + F7 D. Alt + F7

Ans:– A ,


The NOT EXISTS keyword will be true if:
Options: any row in the subquery meets the condition.,    all rows in the subquery fail the condition.,    both of these two conditions are met.,    neither of these two conditions is met.

Ans:B ,B


The total number of messages handled by a computerized telephone system on a daily basis is an example of:
Options: Frequency,    Updating,    Volume,    All of the above

Ans:C ,C

www.000webhost.com