Write command for the operations (i) to (iii) based on the spreadsheet below: -Technology

Write command for the operations (i) to (iii) based on the spreadsheet below: -Technology
by

1 Answer

Answer :

1. At cell F2, type =D2*E2 and then copy this formula using mouse Fill handle onto range F3: F5.2. At cell G2, type =IF(C2=”Consumable”, F2*0.07, F2*0.11) and then copy this formula using mouse Fill handle onto range G3: G5.3. At cell G6, type =SUM(G2: G5).
by

Related questions

Help! I'm trying to write something in an excel spreadsheet and it's showing up below as well...

Description : Help! I'm trying to write something in an excel spreadsheet and it's showing up below as well...

Last Answer : answer:Okay, my answer is gonna get moderated, but this drives me nuts. Every company I've ever worked at, managers all want to use Excel as if it was a word processor. Excel is not a word processor! ... column to become wide), or causing the text to continue to the into the next cell to the right.

Which program do you need to write HTML code? (a) Spreadsheet (b) Access -Technology

Description : Which program do you need to write HTML code? (a) Spreadsheet (b) Access -Technology

Last Answer : (c) From the given options, Notepad is useful program to write HTML code.

What is the default alignment of number, text and formula in a spreadsheet? -Technology

Description : What is the default alignment of number, text and formula in a spreadsheet? -Technology

Last Answer : Default alignment of text or label entry is left alignment and for numbers and formula, it is right alignment.

Name the toolbar of spreadsheet which has all the options of changing the font properties. -Technology

Description : Name the toolbar of spreadsheet which has all the options of changing the font properties. -Technology

Last Answer : Formatting Toolbar

In a spreadsheet software, the formula =A1 +$2 was entered in cell A3 and then copied into cell B3. What is the formula copied into B3? -Technology

Description : In a spreadsheet software, the formula =A1 +$2 was entered in cell A3 and then copied into cell B3. What is the formula copied into B3? -Technology

Last Answer : Need Answer

Describe, how the owner of the restaurant could use the spreadsheet for financial modeling? -Technology

Description : Describe, how the owner of the restaurant could use the spreadsheet for financial modeling? -Technology

Last Answer : 1. Decide on a total purchasing need for next night/week/month/year.2. Change figures in spreadsheet.3. Raise/lower/add/delete any value.4. Compare results with predicted/total needed/target results.5. To general use for budgeting like to calculate profit.

A term that is used in spreadsheet which forces a line break in a cell when the cell entry is too large to fit in the cell. -Technology

Description : A term that is used in spreadsheet which forces a line break in a cell when the cell entry is too large to fit in the cell. -Technology

Last Answer : (a) A term that is used in spreadsheet which forces a line break in a cell when the cell entry is too large to fit in the cellWrap.

You have used a spreadsheet to calculate the average marks of a class in Mathematics. -Technology

Description : You have used a spreadsheet to calculate the average marks of a class in Mathematics. -Technology

Last Answer : (b) Marks of each student tor Mathematics will be required for calculating average marks of mathematics.

The Fill handle tool is used for labor intensive entering data in a spreadsheet. -Technology

Description : The Fill handle tool is used for labor intensive entering data in a spreadsheet. -Technology

Last Answer : True Entering data into a spreadsheet can be very labor intensive, but Fill handle tool autofill the entries and save time.

With reference to the above given tables, write commands in SQL for (i) and (ii) and output for (iii) below: -Technology

Description : With reference to the above given tables, write commands in SQL for (i) and (ii) and output for (iii) below: -Technology

Last Answer : (i) select TName, Passenger from Train T, Reservation R where T.TrainId=R.TrainId;(ii) select T.* from Train T, Reservation R where T.TrainId!=R.TrainId;(iii)TrainIdTNameSourceDestination3424Lucknow MailLucknowNew Delhi5400Century ExpressNew DelhiKanpur

Write the HTML command to display the following in your Web page. -Technology

Description : Write the HTML command to display the following in your Web page. -Technology

Last Answer : The HTML command is – A2 + B2

Write the output on the Web page for the following HTML command. -Technology

Description : Write the output on the Web page for the following HTML command. -Technology

Last Answer : The output on the Web page will be the Atomic weight of O 2

Which tab and command let you insert animations in your slide? Write the steps for applying animations in your presentation. -Technology

Description : Which tab and command let you insert animations in your slide? Write the steps for applying animations in your presentation. -Technology

Last Answer : Animating Text and Objects:We can give sound effects or visual effects, including movement to the text or objects in a presentation. Animation can be used to focus on important points, to control the ... to animate the object.Effects appear in the Custom Animation list in the order that you add them

Write the command using Insert() function to add a new column in the last place(3rd place) named “Salary” from the list Sal=[10000,15000,20000] -Technology

Description : Write the command using Insert() function to add a new column in the last place(3rd place) named “Salary” from the list Sal=[10000,15000,20000] -Technology

Last Answer : EMP.insert(loc=3,column=”Salary”,value=Sal)

(i) Write command to compute sum of every column of the data frame. -Technology

Description : (i) Write command to compute sum of every column of the data frame. -Technology

Last Answer : (i) df1.sum()(ii) df1[‘Rainfall’].mean()(iii) df1.loc[:11, ‘maxtemp’:’Rainfall’].mean( )

Write the Django command to start a new app named ‘users’ in an existing project? -Technology

Description : Write the Django command to start a new app named ‘users’ in an existing project? -Technology

Last Answer : python manage.py startapp users

Write the output of the following SQL command. select round (49.88); (a)49.88 (b)49.8 (c)49.0 (d)50 -Technology

Description : Write the output of the following SQL command. select round (49.88); (a)49.88 (b)49.8 (c)49.0 (d)50 -Technology

Last Answer : The correct answer is : (a) 50

Given the following Series S1 and S2: Write the command to find the sum of series S1 and S2 -Technology

Description : Given the following Series S1 and S2: Write the command to find the sum of series S1 and S2 -Technology

Last Answer : print(S1+S2)

Write the SQL command that will display the current time and date. -Technology

Description : Write the SQL command that will display the current time and date. -Technology

Last Answer : Select now();

Consider the following Series object, S_amt Table 350 Chair 200 Sofa 800 Stool 150 i. Write the command which will display the name -Technology

Description : Consider the following Series object, S_amt Table 350 Chair 200 Sofa 800 Stool 150 i. Write the command which will display the name -Technology

Last Answer : i. print(S_amt[S_amt>250])ii. S_amt.name= 'Furniture'

Write the commands to do the following operations on the dataframes given above : (i) To add dataframes df1 and df2. -Technology

Description : Write the commands to do the following operations on the dataframes given above : (i) To add dataframes df1 and df2. -Technology

Last Answer : import numpy as npimport pandas as pddf1 = pd.DataFrame({'mark1':[30,40,15,40],'mark2':[20,45,30,70]});df2 = pd.DataFrame({'mark1':[10,20,20,50],'mark2':[15,25,30,30]});print(df1)print(df2)(i) ... , inplace=True) print(df1)(iv) df1.rename(index = {0: 'zero', 1:'one'}, inplace = True) print(df1)

Write the SQL functions which will perform the following operations: (i) To display the name of the month of the current date . -Technology

Description : Write the SQL functions which will perform the following operations: (i) To display the name of the month of the current date . -Technology

Last Answer : (i) monthname(date(now()))(ii) trim(“ Panaroma “)(iii) dayname(date(dob))(iv) instr(name, fname)(v) mod(n1,n2)

Answer the following questions based on the database given below: Prod_Id Prod_Name Category -Technology

Description : Answer the following questions based on the database given below: Prod_Id Prod_Name Category -Technology

Last Answer : 1. The primary key of the given table Product will be Prod _Id because no two products have the same Product_Id. So, it will be uniquely identified for each record in the table.2. The suitable data ... = 88. The data type OLE Object is suitable for adding the photograph of the product to the table.

A command tab which allows to create the table in an interactive manner is called (a) Home -Technology

Description : A command tab which allows to create the table in an interactive manner is called (a) Home -Technology

Last Answer : (d) MS-Access provides a command tab named Create which allows creating the table in an interactive manner.

Explain the given command <a href =”wild.html”>Click Here for wild animals</a> -Technology

Description : Explain the given command Click Here for wild animals -Technology

Last Answer : In this command, anchor tag and its href attribute are included. The text (Click Here for wild animals) will appear underlined and indicates that clicking the text activates the hypertext link. The address ... is an URL or Web page address and Click Here for wild animals is the hyperlinked text.

Which command should be use to link a page with HTML page? (a) <a link = “page.htm” > </a> -Technology

Description : Which command should be use to link a page with HTML page? (a) -Technology

Last Answer : (b) page

Sona wants to add her pictures in a Word document. 1. Which tab she should use? 2. Which command she should use to open Insert Picture dialog box? -Technology

Description : Sona wants to add her pictures in a Word document. 1. Which tab she should use? 2. Which command she should use to open Insert Picture dialog box? -Technology

Last Answer : 1. Insert tab2. Picture command in the Illustrations group.3. Yes4. Yes

…….. command is used to move the text to a new page. -Technology

Description : …….. command is used to move the text to a new page. -Technology

Last Answer : Page breakcommand is used to move the text to a new page.

Rehearse Timings command is present on ………………. tab. (a) Animations (b) Review (c) Slide Show (d) View -Technology

Description : Rehearse Timings command is present on ………………. tab. (a) Animations (b) Review (c) Slide Show (d) View -Technology

Last Answer : c) Rehearse Timings command is present on Slide Show tab.

………………. provides a command to change the layout of your slide. -Technology

Description : ………………. provides a command to change the layout of your slide. -Technology

Last Answer : Home tab provides a command to change the layout of your slide.

The Custom Animation command is present on ………………. tab. -Technology

Description : The Custom Animation command is present on ………………. tab. -Technology

Last Answer : The Custom Animationcommand is present on Animationstab.

Which command we use to link a page with an HTML page? -Technology

Description : Which command we use to link a page with an HTML page? -Technology

Last Answer : link textuse to link a page with an HTML page .

What is the function of ALTER command? -Technology

Description : What is the function of ALTER command? -Technology

Last Answer : Alter command is used to change/modify the structure of database object like a table, index, etc.

The command used to give a heading to a graph is .... (a) plt.show() (b) plt.plot() (c) plt.xlabel() (d) plt.title() -Technology

Description : The command used to give a heading to a graph is .... (a) plt.show() (b) plt.plot() (c) plt.xlabel() (d) plt.title() -Technology

Last Answer : (d)plt.title()

Given a Pandas series called Sequences, the command which will display the first 4 rows is .... (a) print(Sequences.head(4)) -Technology

Description : Given a Pandas series called Sequences, the command which will display the first 4 rows is .... (a) print(Sequences.head(4)) -Technology

Last Answer : (a) print(Sequences.head(4))

The ....... command can be used to makes changes in the rows of a table in SQL. -Technology

Description : The ....... command can be used to makes changes in the rows of a table in SQL. -Technology

Last Answer : The update command can be used to makes changes in the rows of a table in SQL.

(1) Prachi has given the following command to obtain the highest marks Select max(marks) from student where group by class; -Technology

Description : (1) Prachi has given the following command to obtain the highest marks Select max(marks) from student where group by class; -Technology

Last Answer : (1)d. Select class, max(marks) from student group by class;(2)b. Both (ii) and (iv)(3)b. select name,max(DOB) from student;

Write Unix command for following: i)create a folder OSY ii) create a file FIRST in OSY folder iii) List/display all files and directories. iv) Write command to clear the screen

Description : Write Unix command for following: i)create a folder OSY ii) create a file FIRST in OSY folder iii) List/display all files and directories. iv) Write command to clear the screen

Last Answer : i) create a folder OSY: $mkdir OSY ii)create a file FIRST in OSY folder: $cd OSY $cat>FIRST or $ touch FIRST iii) List/display all files and directories: $ls iv) to clear screen: $clear

Operations performed on a database are controlled by (a) user (b) hardware -Technology

Description : Operations performed on a database are controlled by (a) user (b) hardware -Technology

Last Answer : (a) Users are those persons, who need the information from the database to perform operations.

Operating system refers to the core software components of a computer system that manages internal operations and hardware. -Technology

Description : Operating system refers to the core software components of a computer system that manages internal operations and hardware. -Technology

Last Answer : TrueOperating system is a set of programs that control internal computer operations and make best use of hardware.

Describe the basic operations of mouse button. -Technology

Description : Describe the basic operations of mouse button. -Technology

Last Answer : Some basic mouse operations are as follows:1. Pointing Pointing to an item on the screen means moving a pointer to a certain location. When you point to some object, a small box often appears, that ... Right click an item, point to the item that you want perform and then, click the left button.

The ………….. and …………… operations copies data from source range to target range and erases it from the source range. -Technology

Description : The ………….. and …………… operations copies data from source range to target range and erases it from the source range. -Technology

Last Answer : The cut and paste operations copy data from the source range to a target range and erase it from the source range.

Write the full forms of: (i) URL (ii) <LI> (iii) <TD> (iv) HTML -Technology

Description : Write the full forms of: (i) URL (ii) (iii) (iv) HTML -Technology

Last Answer : Uniform Resource LocatorList ItemTable DataHyper Text Markup Language

Write the HTML code to create the exact table which is given below: ADMNO SNAME NAME DOB -Technology

Description : Write the HTML code to create the exact table which is given below: ADMNO SNAME NAME DOB -Technology

Last Answer : The HTML code is ADMNO SNAMENAMEDOB1110MANJITRANJIT4-MAR-1998

Write the HTML code to generate the following table on a Web page with the contents and alignment exactly as shown below: -Technology

Description : Write the HTML code to generate the following table on a Web page with the contents and alignment exactly as shown below: -Technology

Last Answer : The HTML code is

Write the HTML code to generate the following web page with the given below specifications: -Technology

Description : Write the HTML code to generate the following web page with the given below specifications: -Technology

Last Answer : Income Tax Slabs 2017-18INCOME TAX SLABS 2017-18S.No.Income RangeTax%10-250000NIL2250001-50000010%3500001-100000020%4>100000030%Next Page

In a Bank’s database, there are two tables ‘Customer’ and ‘Transaction’ as shown below. Write a query to display customer’s name who has -Technology

Description : In a Bank’s database, there are two tables ‘Customer’ and ‘Transaction’ as shown below. Write a query to display customer’s name who has -Technology

Last Answer : (i) Select cust_name from customer c,transaction t where c.Acc_No=t.Acc_No and Transaction_Type= 'Debit';(ii)Select cust_name, t.* from customer c, transaction t where c.Acc_No=t.Acc_No;(iii) ... total amount of all type of transactions, it will only display the total of credit transactions only.

Write a code to plot the speed of a passenger train as shown in the figure given below: -Technology

Description : Write a code to plot the speed of a passenger train as shown in the figure given below: -Technology

Last Answer : import matplotlib.pyplot as pltimport numpy as npx = np.arange(1, 5)plt.plot(x, x*1.5, label='Normal')plt.plot(x, x*3.0, label='Fast')plt.plot(x, x/3.0, label='Slow')plt.legend()plt.show()

Write a python code to create a data frame with appropriate headings from the list given below : -Technology

Description : Write a python code to create a data frame with appropriate headings from the list given below : -Technology

Last Answer : import pandas as pd# initialize list of listsdata = [['S101', 'Amy', 70], ['S102', 'Bandhi', 69], ['S104','Cathy', 75], ['S105', 'Gundaho', 82]]# Create the pandas DataFramdf = pd.DataFrame(data, columns = ['ID', 'Name', 'Marks'])# printdataframe. print(df )

Write a small python codeto create a dataframewith headings(a and b) from the list given below : [[1,2],[3,4],[5,6],[7,8]] -Technology

Description : Write a small python codeto create a dataframewith headings(a and b) from the list given below : [[1,2],[3,4],[5,6],[7,8]] -Technology

Last Answer : import pandas as pddf = pd.DataFrame([[1, 2], [3, 4]], columns = ['a','b'])df2 = pd.DataFrame([[5, 6], [7, 8]], columns = ['a','b'])df = df.append(df2)