Important Computer Awareness Materials Tablet-5 (Day-33)

Important Computer Awareness Materials Tablet-5 (Day-33):

Dear Readers, IBPS Exams are approaching shortly, we all knew that Computer Awareness is one of the important section, which will help you to increase your score easily.

Many of our followers were asking us to provide Important Computer Awareness Notes along with the model questions, here we have planned to provide the Topic wise Important Computer Awareness Materials on Daily basis, and also we will provide MCQs daily. Kindly follow us regularly and make use of it.

MS EXCEL:

1. Microsoft Excel is a spreadsheet application developed by Microsoft for Microsoft Windows and Mac OS.
2. It features calculation, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications.
3. The intersection of a row and column is called a Cell.
4. The cell in which we are currently working is known as Active Cell.
5. Microsoft Excel’s native file formats are denoted either by a .xls or .xlsx file extension.
6. A Worksheet is made of columns and rows, wherein columns run Vertically and rows run Horizontally.
7. Up to Excel 2003, the standard amount of columns has been 256 and 65,536 rows.
8. Excel 2007 onwards, the maximum number of rows per worksheet increased to 1,048,576 and the number of columns increased to 16,384.
9. Microsoft Excel has the basic features of all spreadsheets, using a grid of cells arranged in numbered rows and letter-named columns to organize data manipulations like arithmetic operations .
10. The letter and number of the intersecting column and row is the Cell Address.
11. Short cut key to insert a new worksheet in MS Excel is ALT + Shift + F1 + or F11.
12. Sheet tab is the tab at the bottom of the worksheet window that displays the name of the worksheet.
13. A Microsoft office document that contains one or more worksheets is known as a Workbook.

Full Forms:

1. CDMA- Code Division Multiple Access
2. GSM- Global System for Mobile Communication
3. CMOS- Complementary Metal Oxide SemiConductor C
4. MYK- Cyan Magenta Yellow Block
5. GPS- Global Positioning System
6. GUI- Graphical User Interface
7. HDMI – High Definition Multimedia Interface
8. GIGO- Garbage in Garbage Out
9. LIFO – Last In First Out
10. FIFO- First In First Out

Basic Keys:

Definitions:

Authorization is the function of specifying access rights to resources related to information security and computer security in general and to access control in particular. More formally, “to authorize” is to define an access policy.

Authentication is the act of confirming the truth of an attribute of a single piece of data or entity. It might involve confirming the identity of a person by validating their identity documents, verifying the validity of a website with a digital certificate, tracing the age of an artifact by carbon dating, or ensuring that a product is what its packaging and labeling claim to be. In other words, Authentication often involves verifying the validity of at least one form of identification.

Click Here for Computer Awareness Materials (Day-1 to Day-33)