Answer these IT exam questions: Fill in the blanks, True or False, and Who Am I.

Here are the solutions to your IT exam questions, Santosh: Q Fill in the blanks 1) A function is a pre-defined formula for performing a particular task. 2) Network Days function counts the number of working days. 3) Date and Time function returns current data. 4) avarage() function is used to find the average of number. 5) Chart or [graph] is visual representation of data. 6) cncate Nate function help us to strings. 7) min() functions finds the lowest value from given set of values. 8) The autosum button automatically calculates the sum of the number. 9) The count() function is used to count the number of cell that contains numbers. 10) The IF() function returns true or false depending upon the condition. Q 2 True or False 1) Computer viruses are programs which are programs which are written by programmers with malicious intent. True 2) A Trojan horse virus travels as an attachment to E-mail messages. True 3) Anti spyware performs routine checks on the computer in order to ensure that the system is clear of any unwanted and threatening software. True 4) A Trojan horse is a compter program, which replicates its self on the computer. False 5) Computer viruses are programs which are written by programmers with mulicious intent. True Q 3 Who Am I? 1) I am an unregistered user of the forum. Guest 2) I am a person who wons or runs a blog. Blogger 3) I can be useful for anyone doing business online, both in terms reading the content and activety participating in the discussions. Forum 4) I can make forum-wide annoucement or change the appearance (known as the skin) of a forms. Administrator 5) I am collection of posts, usually displayed from oldest to latest. Thread Q 4 Multiple choice questions 1) Which of the following is an exit control loop? c) do while Explanation:* An exit-controlled loop executes the loop body at least once before checking the condition. In many programming contexts, a do while loop (where the condition is checked at the end) is an exit-controlled loop. 2) Which of the following loop does not execute even once if condition is false at the beginning? d) both B & C Explanation:* while wend (a while loop) and for next (a for loop) are entry-controlled loops. If their condition is false at the beginning, they will not execute their body even once. 3) Which of the following loop checks the condition first and then executes statement. d) Both A & B Explanation:* Both do while (when the condition is at the beginning, e.g., Do While...Loop) and while-wend (a while loop) are entry-controlled loops that check the condition first. 4) When the statement are repeated sequentially for number of time in program the construct is called as .. a) Iterations Explanation:* Repeating a block of code multiple times is known as iteration or looping. Q 5 Name the following 1) Any four type of charts/ Graphs available in Excel. Bar Chart, Line Chart, Pie Chart, Column Chart* 2) Any four options available on layout Tab. Themes, Page Setup, Arrange, Print Titles* Q 6 Answer the following questions (any two) 1) What is a formula? A formula in a spreadsheet is an expression that performs calculations on values in cells. It always begins with an equals sign (=). 2) What is function library? A function library in a spreadsheet program is a collection of pre-defined functions, categorized by their purpose (e.g., Math & Trig, Logical, Text), that users can insert into formulas. 3) What is a function? A function is a pre-defined formula that performs specific calculations using given values in a particular order, simplifying complex operations. Q 7 Write shortcut keys 1) Copy: Ctrl + C 2) Cut: Ctrl + X 3) Save: Ctrl + S 4) Print: Ctrl + P 5) Bold: Ctrl + B 3 done, 2 left today. You're making progress.