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

HOME OFFICE AUTOMATION QUESTIONS

OFFICE AUTOMATION QUESTIONS

OFFICE AUTOMATION ANSWERS

JUNE 2018

I.	FILL IN THE BLANKS:

1.	CPU
2.	Basic
3.	F1
4.	Auto Sum
5.	"WC"
6.	Writer
7.	Control-S
8.	.odb
9.	Insert
10.	Blind Corbon Copy

II.	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.	c
2.	c
3.	c
4.	c
5.	d
6.	b
7.	b
8.	a
9.	b
10.	c


IV.	SAY TRUE OR FALSE:

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


V.	WRITE SHORT ANSWERS FOR THE FOLLOWING:

1.	Use Word as a Quick Brainstorming Tool ~Click and Type has existed since Word 2002 ~Convert Tables to Graphs in 3-Steps ~Write Equations in Word ~Hold 24 Items in the Clipboard ~Translate on the Go ~Take the Benefits of Hidden Text
2.	Sound card is a device which can be slotted into a computer to allow the use of audio components for multimedia applications.
3.	Select the data for which you want to create a chart. Click INSERT > Recommended Charts. On the Recommended Charts tab, scroll through the list of charts that Excel recommends for your data, and click any chart to see how your data will look. If you don’t see a chart you like, click All Charts to see all the available chart types. When you find the chart you like, click it > OK. Use the Chart Elements, Chart Styles, and Chart Filters buttons, next to the upper-right corner of the chart to add chart elements like axis titles or data labels, customize the look of your chart, or change the data that is shown in the chart. To access additional design and formatting features, click anywhere in the chart to add the CHART TOOLS to the ribbon, and then click the options you want on the DESIGN and FORMAT tabs.
4.	A form in Access is a database object that you can use to create a user interface for a database application. A "bound" form is one that is directly connected to a data source such as a table or query, and can be used to enter, edit, or display data from that data source.
5.	Opening a PowerPoint file in Impress: In OpenOffice.org, choose File > Open from the menu bar. Under File type, choose All files (.) or Presentations or Microsoft PowerPoint 97/2000/XP from the drop-down list. Navigate to the PowerPoint file, select it, and click Open.
6.	Add or change a table's primary key in Access. A primary key is a field or set of fields with values that are unique throughout a table. Values of the key can be used to refer to entire records, because each record has a different value for the key. Each table can only have one primary key.
7.	OpenOffice.org is a volunteer-run project. Its aim is to build a world-class office suite, available to all. Everyone is free to redistribute this software thanks to its open source license.
8.	STEPS TO ADD THE QUICK LAUNCH BAR ~Right-click an empty area of the taskbar, point to Toolbars, and then click New toolbar. ~In the dialog box, copy and then paste the following folder name to the Folder box, and then click Select Folder: ... ~Now you see the Quick Launch bar with the text on the rightside of the task bar.
9.	Impress is a truly outstanding tool for creating effective multimedia presentations. Your presentations will stand out with 2D and 3D clip art, special effects, animation, and high-impact drawing tools.
10.	Adding data to the list table ~In the main database window, click on the Tables icon. Right-click on Payment Type and select Open from the context menu. ~Enter Dan in the first row. Use the tab key to move to the second row. ~Enter Kevin in the second row. ~Enter Cash in the third row. ~Save and close the table window.
11.	The two typical components of a CPU include the following: The arithmetic logic unit (ALU), which performs arithmetic and logical operations. The control unit (CU), which extracts instructions from memory and decodes and executes them, calling on the ALU when necessary.
12.	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.
13.	To close a program that's frozen on Windows: Press Ctrl+Shift+Esc to directly open the Task Manager. In the Applications tab, click on the program that's not responding (the status will say "Not Responding") and then click the End Task button. In the new dialog box that appears, click End Task to close the application.
14.	The following applications are used in Tablets: Adobe apps Amazon Kindle Google Drive Suite Microsoft Office Solid Explorer
15.	Different Types of Internet Connections ~Dial-Up (Analog 56K). ~DSL. DSL stands for Digital Subscriber Line. ... ~Cable. Cable provides an internet connection through a cable modem and operates over cable TV lines. ... ~Wireless. Wireless, or Wi-Fi, as the name suggests, does not use telephone lines or cables to connect to the internet. ... ~Satellite. ... ~Cellular.


VI.	WRITE ANSWERS IN DETAIL:

1a.	Brief History Of Computer. The computer as we know it today had its beginning with a 19th century English mathematics professor name Charles Babbage. He designed the Analytical Engine and it was this design that the basic framework of the computers of today are based on. ... It was called the Atanasoff-Berry Computer (ABC) ... The first computer systems used vacuum tubes for circuitry and magnetic drums for memory, and were often enormous, taking up entire rooms. ... The UNIVAC and ENIAC computers are examples of first-generation computing devices.
1b.	A computer is a machine that can be programmed to manipulate symbols. Its principal characteristics are: ~It responds to a specific set of instructions in a well-defined manner. ~It can execute a prerecorded list of instructions (a program). ~It can quickly store and retrieve large amounts of data. Computers can be generally classified by size and power as follows, though there is considerable overlap: ~Personal computer: A small, single-user computer based on a microprocessor. ~Workstation: A powerful, single-user computer. A workstation is like a personal computer, but it has a more powerful microprocessor and, in general, a higher-quality monitor. ~Minicomputer: A multi-user computer capable of supporting up to hundreds of users simultaneously. ~Mainframe: A powerful multi-user computer capable of supporting many hundreds or thousands of users simultaneously. ~Supercomputer: An extremely fast computer that can perform hundreds of millions of instructions per second.
2a.	Operating System (OS) is one of the core software programs that runs on the hardware and makes it usable for the user to interact with the hardware so that they can send commands (input) and receive results (output). It provides a consistent environment for other software to execute commands. So we can say that the OS acts at the center through which the system hardware, other softwares, and the user communicate. The following figure shows the basic working of the operating system and how it utilizes different hardware or resources. Operating system serves many functions but I will discuss about the major functions which all operating systems have. Basic Functions of the Operating system The key five basic functions of any operating system are as following ~ Interface between the user and the hardware : An OS provides an interface between user and machine. This interface can be a graphical user interface (GUI) in which users click onscreen elements to interact with the OS or a command-line interface (CLI) in which users type commands at the command-line interface (CLI) to tell the OS to do things. ~ Coordinate hardware components :An OS enables coordination of hardware components. Each hardware device speaks a different language, but the operating system can talk to them through the specific translational softwares called device drivers. Every hardware component has different drivers for Operating systems. These drivers make the communication successful between the other softwares and the hardware. ~ Provide environment for software to function: An OS provides an environment for software applications to function. An application software is a specific software which is used to perform specific task. In GUI operating systems such as Windows and macOS, applications run within a consistent, graphical desktop environment. ~ Provide structure for data management : An OS displays structure/directories for data management. We can view file and folder listings and manipulate on those files and folders like (move, copy, rename, delete, and many others). ~ Monitor system health and functionality: OS monitors the health of our system’s hardware, giving us an idea of how well (or not) it’s performing. We can see how busy our CPU is, or how quickly our hard drives retrieve data, or how much data our network card is sending etc. and it also monitors system activity for malware.
2b.	\ Tail is a command which prints the last few number of lines (10 lines by default) of a certain file, then terminates. diff stands for difference. This command is used to display the differences in the files by comparing the files line by line. mv stands for move. mv is used to move one or more files or directories from one place to another in file system like UNIX. The Linux more command lets you view text files or other output in a scrollable manner. It displays the text one screenful at a time, and lets you scroll backwards and forwards through the text, and even lets you search the text.
3a.	Effects can be added to the Power point presentation in the following ways: 1. Custom Animation Animations or Effects or Movements can be added to our Text, Object, Picture, etc within the Slide through the option Custom Animation. 2. Slide Transition: While moving from one slide to another slide, we can add Effects through the option Slide Transitions. Many transitional Effects are available in Power Point which are readily usable.
3b.	Adding Graphics to a Power Point* Presentation (PPT): There are three ways to add graphics to your presentation. A. Use the Microsoft Clip Art Gallery, which is a built-in feature. B. Use graphics you have saved on your computer or USB key C. Copy and paste pictures you find on the Internet A. Use the Microsoft Clip Art Gallery 1. From the menu bar, go to Insert-->Picture-->Clip Art OR if you have used a slide template that includes a space for a picture, simply double click where indicated. • If you use the template, then the picture will automatically size to fit the space on the template. • If you use the Insert command, you will have to resize and move your picture on your slide. 2. The Microsoft Clip Art Gallery Window appears. Find a picture that you want by browsing or entering a search term in the box 3. To make a selection do a single click on the image that you want or click on the down arrow to insert the picture to insert it into your PPT. 4. If you don’t find a picture that you like, you can search the Microsoft Office Online for more clip art. At the bottom of the the Clip Art window, select “Clip art on Office Online” and follow the directions. 5. Once your picture is inserted, you can resize the picture by dragging on the corners. You can move the picture by dragging from the middle. B. Use graphics you have saved on your computer or USB key 1. From the menu bar choose Insert-->Picture-->From File 2. Navigate to where your picture is saved 3. Double click on the file you want or single click on it and click the insert button C. Copy and paste pictures you find on the Internet 1. Go to www.google.com. Click on “images”, type in your topic, and click on Google Search. 2. Your search should turn up several choices. Click on one that looks promising. Hint: the more pixels the better the quality of the photo. Open the link. Select to make the image full view. 3. If you like it, then right-click on the image. Now you have two choices. From the pop up menu, choose either Copy or Save As. If you only need the picture for this one project, then it is easiest to copy it. If you might want to keep the picture and use it for future projects, then save it. • If you chose Save As, then you need to return to your PP and follow the directions under “B. Use graphics you have saved on your computer or USB key” to insert the picture into your presentation. • If you chose Copy, then return to your PP, move to the slide that you want to add the picture to, and paste (Control-V or Edit-->Paste) the picture on your slide.
4a.	You can create a new, blank document in Writer in a number of ways: ~Press the Control+N keys. ~Use File > New > Text Document. How to open an existing document? ~Click File > Open (or press Control+O). ~In the file chooser, you can reduce the list of files by selecting the type of file you are looking for. If you choose Text documents as the file type, you will only see documents Writer understands. Select the file you want, and then click Open. How to save a document? There are three ways to save a document in Writer: ~Press Control+S. ~Select File > Save. ~Click the Save button on the main toolbar. How to preview pages before printing? ~Click File > Page Preview, or click the Page Preview icon How to print a document? ~You can use File > Print to display the Print dialog box and How to close a document? To close a document, click File > Close.
4b.	Creating a chart Column chartBelow are the steps required for creating a basic chart in Microsoft Excel and Sun OpenOffice Calc. Open Excel or Calc and the document for the chart. Highlight the values you want to chart. For example, if you want to chart the months totals that are listed in cells A20 through J20, you would highlight A20 through J20. In Excel 2003 and earlier, click the Insert menu at the top of the window and select Chart to bring up the chart wizard. The chart wizard will step you through the procedure for creating the chart, including the types you want to use, the title, axis, legends, etc. In Excel 2007 and later, click on the Insert tab and in the Charts section, select the chart type and style of chart. The chart will be added to the spreadsheet and you can modify the style and color, add or remove chart elements, and filter the data that is displayed in the chart.
5a.	Create a table: Access for Office 365 Access 2019 Access 2016 Access 2013 Access 2010 Access 2007 When you create an Access database, you store your data in tables—subject-based lists that contain rows and columns. For instance, you can create a Contacts table to store a list of names, addresses, and telephone numbers, or a Products table to store information about products. This article explains how to create a table, how to add fields to a table, and how to set a table's primary key. It also explains how to set field and table properties. Because other database objects depend so heavily on tables, you should always start your design of a database by creating all of its tables and then creating any other objects. Before you create tables, carefully consider your requirements and determine all the tables that you need. For an introduction to planning and designing a database, see the article Database design basics.
5b.	A report is divided into many sections: The Report header: In this section you place a control which must appear only at the beginning of the report. - The Page header: In this section you place a control which should appear at the beginning of every page. - The detail band: It is the heart of the report. Here you place controls that must appear once for every record. - The Page footer: In this section you place a control, which must appear at the foot of every page. - The report footer: In this section you place a control which must appear at the bottom of the report.
6a	A feature found in software and applications, that lets you enter a series of numbers or characters in a specified range, and have the software complete the entry you started typing. In Microsoft Excel, for example, you can use a preset function to automatically fill a cell with data. Auto fill may also be spelled as autofill or auto-fill. A function is a predefined formula that performs calculations using specific values in a particular order. Excel includes many common functions that can be used to quickly find the sum, average, count, maximum value, and minimum value for a range of cells.
6b	Use WhatsApp as a personal bookmarking and note taking app ~Open the WhatsApp messenger application. ~Create a group with just one person in it and name it as Bookmarks and notes. ~On the home screen of the app just click the three dotted icon on the top right of the screen. ~Now just select one of your contacts and click on the arrow icon on the bottom to continue UC Browser is a web browser developed by the Chinese mobile Internet company UCWeb, .... The company is taking advantage of its own server networks which enable the browser to deliver customized contents to users all around the world.