Computer Courses, Typewriting, Shorthand, Tally Training, Tally erp9 training, Nanganallur Chennai

HOME OFFICE AUTOMATION QUESTIONS

OFFICE AUTOMATION QUESTIONS

OFFICE AUTOMATION ANSWERS

JANUARY 2017 (330)

I.	FILL IN THE BLANKS:

1.	Random Access Memory
2.	Mouse
3.	mv
4.	Ctrl+Enter
5.	Home
6.	Equal to
7.	Excel
8.	Related information
9.	Impress
10.	Video

I.	MATCH THE FOLLOWING:

1.	D
2.	H
3.	F
4.	E
5.	J
6.	C
7.	I
8.	A
9.	G
10.	B

III.	CHOOSE THE BEST ANSWER:

1.	B
2.	D
3.	B
4.	B
5.	Ctrl+N
6.	D
7.	C
8.	C
9.	C
10.	A


IV.	SAY TRUE OR FALSE:

1.	TRUE
2.	True
3.	TRUE
4.	TRUE
5.	True
6.	True
7.	False
8.	False
9.	True
10.	False


V.	WRITE SHORT ANSWERS FOR THE FOLLOWING:

1.	The speed of computer processing depends on the speed of the central processing unit (CPU) in your computer. While other factors are important, if you're interested in computer speed, the most relevant piece of information is the clock speed of the CPU. Clock speed is a big determinant of the number of instructions per second your computer can carry out, but bus speed, the specific type of instruction being carried out, the microprocessor and the amount of random access memory (RAM) available to your CPU also play a role.
2.	Pen drives holds more data and CDs are easy to break It can be used as virtual memory to speed up your computer. It can be used to save and run programs and software.
3.	Multitasking, in an operating system, is allowing a user to perform more than one computer task (such as the operation of an application program) at a time. The operating system is able to keep track of where you are in these tasks and go from one to the other without losing information.
4.	‘pwd‘ stands for ‘Print Working Directory‘. As the name states, command ‘pwd‘ prints the current working directory or simply the directory user is, at present. -L (logical)= Use PWD from environment, even if it contains symbolic links -P (physical)= Avoid all symbolic links –help = Display this help and exit –version = Output version information and exit
5.	Open Office provides a free alternative for users who don’t want to go out and spend money on office software. It allows them to create standard documents, and it works not just on a computer but on many mobile devices as well like smartphones and tablets.
6.	Make sure the document you want to rename is not loaded into Word. ... Click on the Open tool on the toolbar or choose Open from the File menu. ... In the list of files contained in the dialog box, right-click on the one you want to rename. ... Choose Rename from the Context menu. ... Once the document name is changed, press Enter.
7.	7. Open the Find & Replace dialog, click More Options to expand the dialog, and select Values or Notes in the Search in drop-down list. Type the text you want to find in the Search for box. To replace the text with different text, type the new text in the Replace with box.
8.	Alternatively referred to as a cell pointer, current cell, or selected cell, an active cell is a rectangular box, highlighting the cell in a spreadsheet. An active cell helps identify what cell is being worked with and where data will be entered.
9.	To change the width of columns to fit the contents, select the column or columns that you want tochange, and then double-click the boundary to the right of a selected column heading. To change thewidth of all columns on the worksheet, click the Select All button, and then drag the boundary of anycolumn heading.
10.	Applying an advanced filter using a macro is simple (see Listing 8). The cell range containing the filter criteria is used to create a filter descriptor, which is then used to filter the range containing the data.
11.	A primary key is used to ensure data in the specific column is unique. You can only set constraints with primary keys, by setting a foreign key to another column which creates a relationship with the column that has the primary key set. A prime use of a primary key is in the case of a users table.
12.	A slide transition is the effect that happens when one OpenOffice Impress presentation slide ends and another begins. You can add a wide variety of effects as well as add a sound to go along with yourslide transitions.
13.	Microsoft PowerPoint: – Microsoft PowerPoint is used to present documents, performed calculations, analyzed data and reports in slides shows. These three applications are mostly used by everyone in their daily official life.
14.	Used to access any kind of public application on the internet. Such as social media websites. Used to verify people when they subscribed to news later or want to download eBook. Email communication is used by business to promote product and services.
15.	A uniform resource locator (URL) is the address of a resource on the Internet. A URL indicates the location of a resource as well as the protocol used to access it. A URL contains the following information: The protocol used to a access the resource The the location of the server (whether by IP address or domain name) The port number on the server (optional) The location of the resource in the directory structure of the server A fragment identifier (optional)


VI.	WRITE ANSWERS IN DETAIL:

1a.	The Network allows computers to connect and communicate with different computers via any medium. LAN, MAN and WAN are the three major types of the network designed to operate over the area they cover. There are some similarities and dissimilarities between them. One of the major differences is the geographical area they cover, i.e. LAN covers the smallest area; MAN covers an area larger than LAN and WAN comprises the largest of all. There are other types of Computer Networks also, like : PAN (Personal Area Network) SAN (Storage Area Network) EPN (Enterprise Private Network) VPN (Virtual Private Network)
1b.	Data communications (DC) is the process of using computing and communication technologies to transfer data from one place to another, and vice versa. It enables the movement of electronic or digital data between two or more nodes, regardless of geographical location, technological medium or data contents. There are several different types of computer networks. Computer networks can be characterized by their size as well as their purpose. The size of a network can be expressed by the geographic area they occupy and the number of computers that are part of the network. Some of the different networks based on size are: ~ Personal area network, or PAN ~ Local area network, or LAN ~ Metropolitan area network, or MAN ~ Wide area network, or WAN Some of the different networks based on their main purpose are: ~ Storage area network, or SAN ~ Enterprise private network, or EPN ~ Virtual private network, or VPN
2a.	In computing, an icon is a pictogram or ideogram displayed on a computer screen in order to help the user navigate a computer system. The icon itself is a quickly comprehensible symbol of a software tool, function, or a data file, accessible on the system and is more like a traffic sign than a detailed illustration of the actual entity it represents.^[1] It can serve as an electronic hyperlink or file shortcut to access the program or data. The user can activate an icon using a mouse, pointer, finger, or recently voice commands. Their placement on the screen, also in relation to other icons, may provide further information to the user about their usage.^[2] In activating an icon, the user can move directly into and out of the identified function without knowing anything further about the location or requirements of the file or code. Icons as parts of the graphical user interface of the computer system, in conjunction with windows, menus and a pointing device (mouse), belong to the much larger topic of the history of the graphical user interface that has largely supplanted the text-based interface for casual use.
2b.	Linux Operating System has primarily three components Kernel − Kernel is the core part of Linux. It is responsible for all major activities of this operating system. It consists of various modules and it interacts directly with the underlying hardware. Kernel provides the required abstraction to hide low level hardware details to system or application programs. System Library − System libraries are special functions or programs using which application programs or system utilities accesses Kernel's features. These libraries implement most of the functionalities of the operating system and do not requires kernel module's code access rights. System Utility − System Utility programs are responsible to do specialized, individual level tasks. Following are some of the important features of Linux Operating System. Portable − Portability means software can works on different types of hardware in same way. Linux kernel and application programs supports their installation on any kind of hardware platform. Open Source − Linux source code is freely available and it is community based development project. Multiple teams work in collaboration to enhance the capability of Linux operating system and it is continuously evolving. Multi-User − Linux is a multiuser system means multiple users can access system resources like memory/ ram/ application programs at same time. Multiprogramming − Linux is a multiprogramming system means multiple applications can run at same time. Hierarchical File System − Linux provides a standard file structure in which system files/ user files are arranged. Shell − Linux provides a special interpreter program which can be used to execute commands of the operating system. It can be used to do various types of operations, call application programs. etc. Security − Linux provides user security using authentication features like password protection/ controlled access to specific files/ encryption of data.
3a.	MS Office and Open Office are popular software that users prefer. Though both of the software offers the same functionality to the users, they have many differences between them. 1. MS Office is used more than Open Office. 2. Unlike Open Office, MS Office is not free. 3. Open Office comes only in a single version. On the other hand, MS Office has many versions, such as, Professional, Home and Student. 4. Open Office offers support for all MS Office document formats. However, only new MS Office supports Open Office documents. 5. Older MS Office versions, like MS Office 2003, had a menu-based system which was similar to Open Office. Today, MS Office uses a ribbon-like interface. 6. Updates in Open Office are free whereas it is not like that with MS Office updates. 7. Open Office Impress is better then MS PowerPoint.
3b.	MS Word allows you to insert many symbols that you can't type directly through keyboard. The procedure is useful especially when you require to insert symbols such as ® (Registered Mark), © (Copyright Mark) and so on. Follow the procedure below to insert symbols in your MS Word document: Place the insertion line where you wish to insert symbol Click on Insert tab to open up its ribbon Toward the end of Insert Ribbon you'll find Symbol group. Click the Symbol drop down button to produce the symbol panel. Click the required symbol from the panel if it is available there. Otherwise you can click on More Symbols... menu there. From the resulting Symbols dialog box, choose required font, Subset and choose the symbol you wish to insert. Click on Insert button and then Close button to get rid of the dialog box. Additionally, you can configure the Auto correct feature or assign shortcut key for the symbol if it is frequently required. Once you set them up, you can insert the symbol directly by typing associated keystrokes on keyboard. Double-click anywhere on the header or footer to unlock it. ... Click the Page Number command. ... Page numbering will appear. ... To edit the font, font size, and alignment of page numbers, select a page number and click the Home tab. ... When you're finished, press the Esc key.
4a.	Sorting data is an integral part of data analysis. You might want to arrange a list of names in alphabetical order, compile a list of product inventory levels from highest to lowest, or order rows by colors or icons. Sorting data helps you quickly visualize and understand your data better, organize and find the data that you want, and ultimately make more effective decisions. Sort Two or More Columns Select all the cells in the list. This is the safest approach to sorting. ... On the Excel Ribbon, click the Data tab. In the Sort & Filter group, click the Sort button. Click the Add Level button, to add the first sorting level. From the Sort by dropdown, select the first column you want to sort.
4b.	To create a form in Access 2013 or 2016: On the left navigation pane, click the table or query that contains the data for your form From the `Create` tab on the Ribbon, click `Form` This creates a form based on the table or query that you selected from the navigation pane. You can modify the form as required. You can also create a blank form (using the `Blank Form` button) or you can use the Form Wizard to create a form.
5a.	~ Open the Navigation pane. ~ Click the table or query on which you want to base your report. ~ Activate the Create tab. ~ Click the Report button in the Reports group. Access creates your report and displays your report in Layout view. You can modify the report. To create a simple one-table query: ~ Select the Create tab on the Ribbon, and locate the Queries group. ~ Click the Query Design command. ~ Access will switch to Query Design view. ... ~~ Click Add, then click Close. ~ The selected table will appear as a small window in the Object Relationship pane.
5b.	i. On your computer, sign in to My Maps. Open or create a map. Maps have the following size limits: Up to 10,000 lines, shapes, or places Up to 50,000 total points (in lines and shapes) Up to 20,000 data table cells Click Draw a line Add line or shape. Select a layer and click where to start drawing. A layer can have 2,000 lines, shapes or places. Click each corner or bend of your line or shape. To move the map, click and hold the mouse. When you’re finished drawing, double-click or complete the shape. Give your line or shape a name. When you’re done, click Save. ii. Skype (/skaɪp/) is a telecommunications application software product that specializes in providing video chat and voice calls between computers, tablets, mobile devices, the Xbox One console, and smartwatches via the Internet and to regular telephones.^[7] Skype additionally provides instant messaging services. Users may transmit both text and video messages, and may exchange digital documents such as images, text, and video. Skype allows video conference calls.
6a	i. On your computer, sign in to My Maps. Open or create a map. Maps have the following size limits: Up to 10,000 lines, shapes, or places Up to 50,000 total points (in lines and shapes) Up to 20,000 data table cells Click Draw a line Add line or shape. Select a layer and click where to start drawing. A layer can have 2,000 lines, shapes or places. Click each corner or bend of your line or shape. To move the map, click and hold the mouse. When you’re finished drawing, double-click or complete the shape. Give your line or shape a name. When you’re done, click Save. ii. Skype (/skaɪp/) is a telecommunications application software product that specializes in providing video chat and voice calls between computers, tablets, mobile devices, the Xbox One console, and smartwatches via the Internet and to regular telephones.^[7] Skype additionally provides instant messaging services. Users may transmit both text and video messages, and may exchange digital documents such as images, text, and video. Skype allows video conference calls.
6b	Uploading website files is one of the very first steps users have to take in order to publish their creation on the Internet. Before you begin this guide you’ll need the following: Access to the control panel of your hosting account Your website’s files (preferably compressed in a .zip or .tar.gz format archive) (Optional) An FTP client and FTP login details of your hosting account 1. Navigate to your control panel’s Files category and open File Manager 2. After that, go to the public_html directory, which is the root directory of your domain (for example: http://www.domainname.com/). Your files should be uploaded there. The directory may also be changed depending on what URL you want it be accessed from. In case you want the content to show up on http://www.domainname.com/something/ your content would need to be located on public_html/something directory. 3.To start uploading, right-click with your mouse and select Upload files option. Find your compressed backup via Select Files section, press Upload to proceed and wait for the transfer to finish. 4. To unzip your archive, right-click it and press Extract. You will then need to select the extraction directory. In this example, the installation will be uploaded to public_html/test directory. To relocate your files, select them all, right-click and press Move. In this example, we have moved the content from public_html/test to public_html. Once the content is located in your desired location, you will be able to access it using any browser.