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:
. What is System Analysis?
Options: The design of the screen the user will see and use to enter or display data
B. System analysis defines the format and type of data the program will use
C. System Analysis involves creating formal model of the problem to be solved
D. None of the above
Ans: – C
The system unit of a personal computer typically contains all of the following except:
Options: microprocessor, disk controller, serial interface, modem
When you connect to an online information service, you are asked to provide some kind of identification such as your name, an account number and a password. What is the name given to this brief dialogue between you and the information system?
Ethernet networks can be cabled in a number of topologies, depending on what works best in each environment. As more nodes are added, the efficiency of Ethernet decreases. Select the best answer as to why Ethernet becomes less efficient as size increases.
Options: Network collisions occur, Repeaters cannot increase the signal strength sufficiently, Cable terminators do not reflect the signal properly, Cable terminators do not absorb the signal properly
Options: is always less expensive than flat-rate service, is less expensive than flat-rate service only when the number of calls is large and the duration of each is short, is less expensive than flat-rate service only when the number of calls is small and the duration of each is long, is never less expensive than flat-rate service
Which of the following refers to a cursor type that when the cursor is opened, a primary key value is saved for each row in the recordset; when the application accesses a row, the key is used to fetch the current values of the row?
Two connected routers are configured with RIP routing. What will be the result when a router receives a routing update that contains a higher-cost path to a network already in its routing table?
Options: The updated information will be added to the existing routing table., The update will be ignored and no further action will occur., The updated information will replace the existing routing table entry., The existing routing table entry will be deleted from the routing table and all routers will exchange routing updates to reach convergence.
. What’s the best way to design the layout for your slides?
Options: a. Create layouts for slides, handouts and notes using the Master Layout dialog box in slide master view b. For each new slide, select a layout from the Slide Layout task pane c. Apply templates from the Slide Design task pane d. None of above
. A user wishes to remove a spreadsheet from a workbook. Which is the correct sequence of events that will do this?
Options: a. Go to File-Save As â€“ Save As Type â€“ Excel worksheet b. Right click on the spreadsheet tab and select DELETE c. Right click on the spreadsheet and select Insert â€“ Entire Column d. None of above
Which type of entity cannot exist in the database unless another type of entity also exists in the database, but does not require that the identifier of that other entity be included as part of its own identifier?
Which of the following is not true of a magnetic disk?
Options: It is expensive relative to magnetic tape, It provides only sequential access to stored data, Users can easily update records by writing over the old data, It does not provide an automatic audit trail