Computer Skills Questions

For a ____________ hyperlink, specify the worksheet path. Leave this blank if you want to link to a target in the same spreadsheet.

While using external data dialog, you can automatically update the document every __________ seconds by default

When you open a rich it that is in shared mode, down features are not availableTrue or false.

In further settings in hyperlink dialogue box, ______________ is applicable to HTML documents. It specifies the text that will be added as a NAME attribute in the HTML code behind the hyperlink.

For a ______________, specify whether it is a mail or news link, the receiver address and for email, also the subject.

Return existing text into a link _________________ it before opening the hyperlink dialogue.

One can insert tables from _______________ and _______________from an openoffice.org Calc or Microsoft Excel spreadsheet into a calc spreadsheet.It can be done in two ways. Explain both.

Define range option is available under the _______________________.

The total is a function listed under the ____________________ when you use the function wizard.

For a ________________, specify whether to edit the newly created worksheet immediately (edit now) or just create it (edit later) and enter the filename and the type of worksheet to create. The _____________ button opens a directory picker dialogue.

If you want to use the shared worksheet in unshared mode, you need to ________________________________________________. This creates a copy of the spreadsheet that is not shared.

You can insert or modify links using _______________

_______ in further settings in hyperlink dialogue box specifies the text that will be visible to the user

The _______ section in the bottom right part of the dialogue is common to all hyperlink types, although some choices are more relevant to some types of links.

The hyperlink icon is present in the ________ toolbar.

If you use more than one group then you can also arrange the subtotals according to the choices made on the dialogues ____________ page.

A scenario is essentially a saved set of set values for your calculation. You can easily switch between these sets using the _______________ or _____________which can be shown beside the changing cells.

What is the problem with an interface if you type show interface g0/1 and receive the following message? Gigabit 0/1 is administratively down, line protocol is down A. The keepalives are different times. B. The administrator has the interface shut down.C. The administrator is pinging cable is attached.

You type the following command into the switch and receive the following output: Switch# show fastethernet 0/1 ^ % Invalid input detected at '^' marker.Why was this error message displayed? A. You need to be in privileged mode. B. You cannot have a space between fastethernet and 0/1 . C. The switch does not have a Fastethernet 0/1 interface. D. Part of the command is missing.

Which of the following commands will display the current IP addressing and the layer 1 and 2 status of an interface? (Choose two.) A. show version B. show interfaces C. show controllers D. show ip interface E. show running-config