Computer part 2

The Excel Function that helps to count cells that are not blank in specific range called - COUNTA 

( Format Painter ) in Microsoft word helps to copy the formating information of a text and apply in multiple place 

E-mail service provider - Yahoo 

Router - used to connect more number of  LANs 

Unicode - Universal Coding Standard 

In Microsoft Excel the error message display on the cell is always preceded by (#symbol )

Ctrl + down arrow (key in MS Excel used to go to the last row of a table) 

Ctrl + Home key in (Word Document to jump to the 1st line in word document) 

FORTRAN - language used primarily for numeric and scientific computing 

Botnet stand for - Robot Network 

Shutdown Computer - Alt + F4

Reload Webpage - F5

F7 - Spelling 

Shift + F7 = Theasure 

Shift + F3 = Change Case 

Ctrl + F2 = Print Pre 

ISP - Internet Service Provider 

Vishing stand for - Voice Phishing 

Smishing stand for - SMS Phishing 

Ctrl + J = Justify a paragraph in a word 

Antivirus is a software that detect, protect and take action against Computer Virus

Bit means Binary Digit 

Combining two or more cells into one cell is called -Merge 

( Word Wrap helps in ) Microsoft word to automatically moves to next line while reaching the end of current line 

Facebook is a popular social networking side 

Domain name used in university website (•edu) 

255 maximum number of sheet that can be added to an Excel Workbook 

Alt + entered in Windows explorer allow to view properties 

(In MS word) to make all capital /all small letters in paragraph feature will be - Change Case 

Social networking site for business community - Linkedln

Linkedln For hiring employees is called - Social Media Hiring 

Recently visited website URLs are stored under (History) option on the browser 

DSL - Digital Subscriber Line 

Excel displays (Pound) symbol on the cell if the number is too large to fit in the cell 

Valid Internet website URL - www.gmail.com

In a website ,the text such as "Click here " appears between the hyperlink tags is called - Anchor text 

DNS - Domain Name System 

To shutdown computer - select power then start menu then select shutdown 

The object of visited websites are stored in the local disk in (Cache ) folder 

Ctrl + C = Copy 

Ctrl + V = Paste

UPS - Uninterruptible Power Supply 

                      In MS word 

Shift + Enter  = line break 

Ctrl + Enter = Page Break 

Enter = New paragraph 

Frequently visited websites are saved under (Bookmarks Bar) for quick access 

Google Ad words is google's tool for creating paid advertising in social media 

Print head - Prints a dot in an impact printers 

Black Hat Hackers are also called as Crackers

Formula write in worksheet begin with (=sign)

If I write (winword.exe) in the Run Dialog box it will open (MS word) 

F5 - start powerpoint presentation from starting slide 

Shift + F5 - suppose I am at 10numbers slide of powerpoint then it will start presentation from (not from starting but from 10 number slide) 

Podcast is a digital format contain series of audio file for downloading or listening over internet 

Algorithms is a sequence of well - defined instruction written in English language to solve the problem 

The allocation and Deallocation of memory managed by MMU - (memory management Unit) 

The process of starting a computer by initiating through hardware such as a button press or by a software command is - Booting 

The breaking up of a large packet into smaller 

Ones for fitting into a network is called - Fragmentation 

Using (Hyperlink ) option in Microsoft word we can create a quick access to web pages with a click 

In Microsoft word the footnote option is found under (Reference tab) 

Meet - video app - developed by google 

The block of text inserted automatically at the end of an email message is called - Email signature 

G2B in e-commerce  is  Government to Business 

Avast and Bitdefender found in Antivirus 

In Microsoft word ,Superscript ,Subscript,Strikethrough are known as - Font effects 

                      Microsoft Word 

F8 - type once give - extended mode on 

If F8 - type 2 times - highlighted word 

If F8 - type 3 times - highlighted sentence 

If F8 - type 4 times - highlighted paragraph 

If F8 - type 5 times - highlighted entire document 

To create a newspaper like layout in

 word document need to select (column option )from layout tab 

Browser used for viewing web pages 

WinZip used to Compress a file to reduce it's size 

( Siri ) is a virtual assistant that is a part of Apple Inc.'s iOS operating system 

B2B in e-commerce - Business to Business .

In Microsoft Word (save, undo, print ) located in Quick access toolbar 

In Microsoft Word Font size default - 8 to 72

Maximum size 16 38 

Maximum column - 63

Maximum row - unlimited 

In Excel to add number we use - SUM 

(Windowkey + e )used  to open file explorer window 

(Subscript )is used to add a symbol or number just below the given normal line in Microsoft word 

POST in computer - Power on self Test 

(Safari) is default browser available on Apple laptops

(Worms ) can travel over the network and spread from the infected machine to the whole network 

All the devices are connected to central hub then the topology is called star topology 

topology refers to the physical or logical arrangement of nodes (devices) and the connections between them

•)Physical Topology: The actual physical layout of hardware, including the location of nodes and the arrangement of cables.

•)Logical Topology: The path that data signals take to travel between devices, regardless of the physical wiring.

Bus topology -All devices share a single communication line (backbone).

Ring Topology: Devices are connected in a closed loop, where each node has exactly two neighbours.

Mesh Topology: Every device is interconnected, providing multiple paths for data.

Tree Topology: A hierarchical structure combining star and bus layouts, where multiple star networks are linked to a central backbone.

Hybrid Topology: A combination of two or more different topologies (e.g., star-bus or star-ring).

3 color Dots make up one color pixel on screen 

BMP -( Bitmap is an image file format) 

In Excel (TRUNC function ) used to remove decimal or fractional part of the number 

In MS word (Ctrl + F2) = print preview 

blinking symbol on computer screen - Cursor

 CC in email - Carbon Copy 

BCC in email - Blind Carbon Copy 

A number assign to any device connected to the internet is - IP address 

Windowkey + L = lock your desktop 

AVI - Audio Video Interleave (a type of file format) 

The space between the beginning of word document and text you type in MS word is called - Margin 

Microsoft Excel is a powerful -

(spreadsheet package )

An excel workbook is a collection of - worksheets and charts 

In an excel windows (Formula Bar) - allow to enter value and formula 

Formula begin with (=sign) 

To save workbook - Click the save option in file menu 

The first cell in Excel worksheet is labeled as - A1

In A1 (character A are symbolizes for     column) 

(number 1 symbolizes for row) 

Excel display the current cells address in the - name box

The name box appears to the left of Formula Bar 

Ctrl + 9 ( hide entire row) 

A excel worksheet can have maximum number of rows = 10,48,576

A excel worksheet can have maximum number of Columns = 16,384

Replace data within worksheet = Ctrl + H

Find data within worksheet = Ctrl + F

Highlight entire column = Ctrl + Spacebar

Highlight entire row = Shift + Spacebar 

Workspace means - Group of workbooks 

The software which contain row and column is spreadsheet 

SUM function in Excel written as -

•) = SUM (A1,B1)

•) = SUM(A1:B9)

•) = SUM(A1:A9,B1:B9)

Example of Formula (after = sign first letter will be capital) 

= A1+ A2☑️

= add (A1:A2)❌

F7 = spelling and error 

MS Excel contain cell, row, column ☑️

Not document ❌

In Excel (Ctrl + D)  = Fill down in the selection 

In order to perform a calculation in a spreadsheet we need to use - (Formula) 

Spelling dialogue box contain -

* Ignore, *Ignore all, *Add to Dictionary, *Change, Change all ,Auto Correct 

But edit not ❌present in spelling dialogue box 

To add image click Insert

In Excel 

Example of value -350, May 10, 2001, 0.57☑️

Not example of value - Serial number 50771 ❌

Page set up dialogue box include - Page orientation, Margins, Headers and Footers 

Page set up dialogue Not include ❌box include(Page Break Preview) 

Valid data type in (Excel) are - Number, Label, Date /Time 

Not a valid data type in (Excel) are - Character 

In Excel by default Numeric value appears in - Right Aligned 

Ex - 1234 enter (right aligned by default) 

In Excel by default Text appears in -Left Aligned 

Ex - ABC enter (left aligned by default) 

What will be the result if you type = A1 =B1 in cell C1

Ans - True or False 

New comment option found under( review tab )

Maximum (255)sheets can be set as default While creating a new workbook 

32,767 character can be type in a single cell in Excel 

You can active a cell by - pressing the tab key, 

Clicking the cell, pressing an arrow key 

Basic step in creating a worksheet are - save workbook, modify the worksheet, 

Enter text and data 

Not a Basic step in creating a worksheet are- copy the worksheet 

Concatenation of text done by using - (Ampersand &) / and 

When formula bar is activated we can see - Edit formula button, The cancel button, The enter button 

VLOOKUP function is - Find related record (vertically) 

HLOOKUP function is -Find related record (Horizontally)

XLOOKUP function is - Find related record both (vertically and horizontally)

Oldest spreadsheet package - VisiCalc

Popular spreadsheet package -Lotus 1-2-3 Excel

Drag and drop operation perform using (Ctrl  key) 

Excel file is called -Workbook because it can contain many worksheets and Charts 

(The autosum button ) can be click to add up series of numbers 

Current time in a worksheet cell - (Ctrl + Shift + ,)

Current date in a worksheet cell -(Cyril + ,)

Excel valid percentage range is (10 - 400)

Less than 10 invalid 

More than 400 invalid 

Word valid percentage range is (10 - 500)

Less than 10 invalid 

More than 500 invalid 

PowerPoint valid percentage range is (10 - 400)

Less than 10 invalid 

More than 400 invalid 

We can insert a Excel file into word document by linked 

Macros (run or executed from the)-  view menu 

Excel produce - Bar charts , line graphs , pie charts 

' apostrophe ) used before number to make it label 

The active cell must be in row1 

to creating a vertical page break 

To create a formula we can use - value and cell reference 

Excel consider (January 1,2023 ) to be value 

In spreadsheet without using mouse or arrow keys we can directly get cell A1 by using (Press + Ctrl + Home) 

To hold row and column titles in place so that

they do not scroll when you scroll a worksheet click the - (Freeze panes command on the view menu) 

F2 - Edit the selected cell 

F5- Go to the specific cell 

F7 - Checks the spelling 

F11 - Create Chart 

Ctrl + Shift +, (enter the current time) 

Ctrl + , (enter the current date) 

Alt + shift + F1 (enter new worksheet) 

Shift + F3 (open the insert function window)

Shift + F5 ( open find and replace dialogue box with find tab) 

Ctrl + A (select all) 

Ctrl + B (bold highlighted selection)

Ctrl + I (Italic highlighted selection)

Ctrl +K (Insert link)

Ctrl + U (underline the highlighted selection) 

Ctrl + P (Bring up the print dialog box to begin printing)

Ctrl + Z (Undo the last action) 

Ctrl +9 (minimize the current workbook) 

Ctrl + 10 (Maximise the currently selected workbook) 

Ctrk + Y (Redo) 

Shift + Home go to the 1st cell in the current row of Excel