1 A. FILL IN THE BLANKS (relative, formula , Round of digits, mixed, Row Number, absolute, Column Lett
a. A __________is a predefined calculation that uses cell references or hard-coded numbers to calculate a cell value.
b. Cell references are typically written in the form _____________ +__________________ .
c. In Microsoft Excel, there are three main types of cell referencing: _________________ , ____________ , and__________________ .
d. Syntax of round function is =ROUND( Number or celladd,____________).
2 B. STATE TRUE OR FALSE
a. LEN Function is used to calculate the number of cells.
b. In Absolute referencing, both the row and column references are adjusted when you copy or fill a formula to another cell.
c. Equal to "=" sign is not necessary to write formula
d. Max and Min functions returns same output
e. Count function Counts the number of cells containing text in a range
3 C. MATCH THE FOLLOWING
4 D. ANSWER IN 1-2 WORDS
a. Which function returns the current date?
b. Name two functions that perform division.
5 E. SHORT ANSWER QUESTIONS.
a. What is the use of the MOD function? Also write syntax and example.
b. Name the library and Tab of the function wizard
6 F. LONG ANSWER TYPE QUESTIONS
a. What is the difference between formula and function?
b. What do you mean by cell referencing? What are the three types of cell referencing?
c. Differentiate between absolute and relative cell referencing.
7 G. SITUTATIONAL QUESTION
a. Udam das is creating an accounting sheet. He wants one of the references in the formula to be static (must not change). Which type of referencing will he use? i. Relative referencing ii. Absoulte referencing iii. Mixed referencing
b. Mrs Maurice is the class teacher of class 5. She has an excel sheet having the height of all the students in her class. She is asked to calculate the average height of all the students. Which formula should she use? i. SUM ii. MOD iii. AVERAGE
1 A. FILL IN THE BLANKS (Blogging, producer, Jorn Barger, buyer, twitter, Electronic commerce, seller
a. E-commerce stands for ________________
b. ______________ refers to writing, photography and other media that's self- published online.
c. _________________________ is considered the father of blogging.
d. ________________is a microblogging platform for real-time updates and discussions.
e. Three primary roles of E-commerce are __________________, ____________________ and ________________ .
2 B. STATE TRUE OR FALSE
a. The consumer is the person in the market who is responsible to sell the product or services from producer to the customer or user.
b. In C2B e-commerce, individual consumers offer products or services to businesses.
c. Google Drive is a special place on the internet where you can keep your stuff safe and organized.
d. Gmail is a popular messaging app for text, voice and video chats.
3 C. ANSWER IN 1-2 WORDS
a. Write any two examples of B2C commerce.
b. Name 3 free blogging sites.
4 D. SHORT ANSWER QESTIONS
a. Make a note of any two ways in which blogging is advantageous.
b. Write the full form: ii. B2B __________ ii. B2C __________ iii. C2C __________ iv. C2B __________
5 E. LONG ANSWER TYPE QUESTIONS
a. Name and explain the four types of e-commerce.
b. Define blog and blogging.
6 F. SITUTAIONAL QUESTIONS
a. Rony is driving from Mumbai to Pune. Which of the following category of internet service will you advise him? i. Video streaming ii. Online shopping iii. Maps and Navigations
b. Sunigdha does not have portable storage devices to carry her data from one place to another. She has heard about internet storage medium which she can acces from anywhere. Which of the following is the one she is finding? i. Blogging site ii. Google Drive iii. Youtube.
1 A. FILL IN THE BLANKS (Phishing, passwords, Anti malware, Multi-Factor Authentication, Distributed
a. _________________ are moral standards that aim to influence behaviour and prevent harm.
b. __________ is attempt to trick individuals into revealing sensitive information, such as pass, words and financial details
c. DDoS stands for _____________________________
d. Common authentication methods include________________, _____________ and _________________________.
e. Software designed to detect, prevent and remove malicious software is called ________________ software.
2 B. STATE TRUE OR FALSE
a. There are no laws to protect people from cyber crimes.
b. Firewall is used to protect sensitive data during storage, transmission and when it's stored on portable devices.
c. Biometrics are digital devices used for fingerprint identification.
d. Viruses do not damage data, steal information or disrupt system operations.
3 C. ANSWER IN 1-2 WORDS
a. Which term is used for threatening and humiliating a person through the internet?
b. List the terms used interchangeably for illegal activities using computers, network and technology.
4 D. SHORT ANSWER QUESTIONS
a. What do you mean by Intellectual Property Right?
b. Define identity theft.
5 E. LONG ANSWER QUESTIONS
a. What kind of attack is DoS?
b. Explain encryption.
6 F. SITUTATIONAL QUESTION
a. International Futuristic Company has confidential data in its system and company's network. The company wants to keep all its data sercure from unauthorized access and network based attacks. Which among the following should the company install for its data security? ii. Firewall ii. DoS iii. Anti- Malware software
1 A. FILL IN THE BLANKS (40, twitter, Integrated Development learning environment, Phishing, prompt,
a. " >>> " is the python__________.
b. _________________________ involves machines or robots to understand and process the language that humans speak
c. ______________ term describes a period of low consumer, public, and private interest
d. __________ is attempt to trick individuals into revealing sensitive information, such as pass, words and financial details
e. print( 25 * 4/ 5) will give the output ____________.
f. IDLE stands for ___________________________________
g. _________________________ is considered the father of blogging.
h. ________________is a microblogging platform for real-time updates and discussions
2 B. MATCH THE FOLLOWING
3 C. STATE TRUE OR FALSE
a. Narrow AI is a type of intelligence which could perform any intellectual task with efficiency like a human.
b. We are presently working in the era of Super AI
c. The consumer is the person in the market who is responsible to sell the product or services from producer to the customer or user.
d. In C2B e-commerce, individual consumers offer products or services to businesses.
e. Biometrics are digital devices used for fingerprint identification.
f. Viruses do not damage data, steal information, or disrupt system operations.
4 D. ANSWER IN 1-2 WORDS
b. Who developed python?
c. What is the shortcut key to run a program?
d. Who was John Macarthy?
e. Name 3 free blogging sites.
f. List the terms used interchangeably for illegal activities using computers, network and technology.
5 E. SHORT ANSWER TYPE QUESTION
a. What is the use of ? Explain
b. What is meant by the statement" python is case sensitive"?
c. What are the drawbacks of using interactive mode of execution?
d. List all components of AI.
e. Write the full form: ii. B2B ii. B2C
f. What do you mean by Intellectual Property Right?
6 F. LONG ANSWER QUESTIONS
a. What do you mean by attributes?
b. What is meant by statement "python is an open source programming language”
c. Write two differences between script mode and interactive mode.
d. What do you mean by perception?
e. Differentiate between Narrow AI and General AI.
f. Name and explain the four types of e-commerce.
g. Explain encyption.
7 G. SITUATIONAL QUESTION
a. Sudhir is working on HTML as a beginner. He is trying to create his first web page. He has mixed up the sequence of tags. Choose the correct tag sequence for him. i. Head, Title, HTML, body ii. HTML, Body, Title, Head iii. HTML, Head, Title, Body
b. Saurabh is also finding errors in variable declaration. The command he has written to delcare a numeric variable is : 1num = 56. What is the reason for the error? i. Variable is starting with number ii. Variable has a special symbol iii. 1num is a reserved word
c. Mrs Anupama is specialized and certified for Language processing. Which domain can she apply for, in wisdom organisation? i. NLP Enginneer ii. AI Developer iii. Machine Learning engineer
d. Rony is driving from Mumbai to Pune. Which of the following category of internet service will you advise him? i. Video streaming ii. Online shopping iii. Maps and Navigations