कंप्यूटर अवेयरनेस टेस्ट - 20

Ans.(a)
Sol. IF function allows you to make logical comparisons between a value and what you expect. It returns some value on meeting a condition. 

Ans.(c)
Sol. An excel workbook can contain many sheets including worksheets and chart sheets.

Ans.(c)
Sol. Excel has many charts including Bar charts, line graphs and pie charts.

Ans.(c)
Sol.  Data in an excel spreadsheet are organised as Rows and Columns

Ans.(b)
Sol.  LOOKUP function can be used when you need to look in a single row or column and find a value from the same position in a second row or column.

Ans.(a)
Sol. A function inside another function is called a nested function.

Ans.(b)
Sol. User can select an area and then print the selected section by clicking on print selection in the print settings

Ans.(d)
Sol.  MS Office is an application suite consisting many application software such as MS Word, PowerPoint, Excel, Outlook etc.

 Ans.(d)
Sol. Font grammar is not related with font. 

Ans.(a)
Sol. Layout tab in the ribbon has commands for Margin, Orientation, Size etc.

 Ans.(b)
Sol. Alpha was android version 1.0 released on 23rd September 2008. Android is continually developed by Google and the Open Handset Alliance (OHA), and has seen a number of updates to its base operating system since the initial release.

Ans.(a)
Sol. Ctrl+F is the short cut key combination that can be used to search in Windows Explorer.

Ans.(d)
Sol. The very first device that had fundamentally the same functionality as a router does today was the Interface Message Processor (IMP); IMPs were the devices that made up the ARPANET, the first TCP/IP network.

 Ans.(c)
Sol. ASCII is abbreviation for American Standard Code for Information Interchange. It is encoding standard used to represent letters and characters.

Ans.(c)
Sol. Adobe Acrobat can be used to read documents on Windows and Mac PC.

 Ans (b)
Sol. Peer-to-peer (P2P) computing or networking is a distributed application architecture that partitions tasks or workloads between peers.

Ans (d)
Sol. An algorithm is a self-contained step-by-step set of operations to be performed. Algorithms perform calculation, data processing, and/or automated reasoning tasks.

Ans (a)
Sol. Swapping concept comes in terms of process scheduling. Scheduler removes process from CPU for duration and reduces the degree of multiprogramming. And after some time these process can again be reintroduced into main memory.

Ans (d)
Sol. A hierarchical database model is a data model in which the data is organized into a tree-like structure. The hierarchical database model mandates that each child record has only one parent, whereas each parent record can have one or more child records.

Ans (b)
Sol. Clicking undo button in this context will not end bulleting.

Ans. (b)
Sol. The first computer was programmed using Machine Language.

Ans.(c)
Sol. Multi-programming started in third generation

Ans. (c)

Sol. Most modern semiconductor memory devices are implemented allowing random access

 Ans. (d)

Sol.  A byte contains a combination of total eight 0s or 1s

 Ans. (d)

Sol. Microsoft Office is an Application suit.

Ans. (d)

Sol. There is nothing such as font grammar.

Ans. (e)

Sol. Workbook is a collection of worksheet in MS Excel

Ans. (c)

Sol. From sheet tab you can move from one worksheet to another in MS Excel.

Ans. (d)

Sol. In a spread sheet, a value is a number you will use in a calculation

Ans. (a)

Sol. In print preview mode you can preview all the pages of the document.