Define the meaning of formula. -Technology

Define the meaning of formula. -Technology
by

1 Answer

Answer :

Formula plays a major role in spreadsheet making. If we all needed to do is to put text and numbers in rows and columns, just about any Word processing program would fill the bill. Formula allows us to perform calculations using values from any cells to have the result appear in the formula cell.
by

Related questions

What technology from Formula 1 has made it into mainstream cars?

Description : What technology from Formula 1 has made it into mainstream cars?

Last Answer : what i heard: tyre technology traction control electronic engine management paddle shifters turbochargers high performance carbon ceramic brakes carbonfibre bodies CAD car design use of wind tunnels ... suspension improvements direct fuel injection (AUDI, Le Mans) BMW Active Steering rear diffusers

In a MS_Access database, which component is not present? (a) Formula Bar (b) Tables -Technology

Description : In a MS_Access database, which component is not present? (a) Formula Bar (b) Tables -Technology

Last Answer : (a) MS-Access contains various components, i.e. Tables, Queries, Forms, Reports, Macros and Modules.

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.

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

Write down the formula for adding values of cells A1 to A5. -Technology

Description : Write down the formula for adding values of cells A1 to A5. -Technology

Last Answer : Formula for adding values of cells A1 to A5 would be =SUM(A1 : A5).

In a worksheet, cell K12 has a value. A formula is to be entered in cell K15, such that if the value in cell K12 -Technology

Description : In a worksheet, cell K12 has a value. A formula is to be entered in cell K15, such that if the value in cell K12 -Technology

Last Answer : In cell K15, enter the conditional statement as: = IF (K12 > 300, K12 *1.33, K12 * 1.5). Here, IF condition checks the value at K12, that is, if it is greater than 300, then calculate 1.33 of K12, otherwise 1.5 of K12.

Cell address $5 in a formula means (a) it is a mixed reference -Technology

Description : Cell address $5 in a formula means (a) it is a mixed reference -Technology

Last Answer : (b) $ sign in a formula need to add before row number and column letter for absolute referencing.

While entering a formula, cell address B$5 represents (a) Absolute Referencing -Technology

Description : While entering a formula, cell address B$5 represents (a) Absolute Referencing -Technology

Last Answer : (b) It represents mixed reference because we are using $ sign before 5 only. Hence, as we will drag this only B will change but 5 will remain the same.

Any formula in Excel starts with an …………….. -Technology

Description : Any formula in Excel starts with an …………….. -Technology

Last Answer : Any formula in Excel starts with anequal (=) sign.

For absolute referencing, ……………. sign is used before the parts of formula. -Technology

Description : For absolute referencing, ……………. sign is used before the parts of formula. -Technology

Last Answer : For absolute referencing, is used before the parts of the formula.

…………. are text, number cell references enclosed within parenthesis in a formula. -Technology

Description : …………. are text, number cell references enclosed within parenthesis in a formula. -Technology

Last Answer : Argumentsare text, number cell references enclosed within parenthesis in a formula.

When a cell containing a formula is moved, the cells referring the moved cell show an error value. -Technology

Description : When a cell containing a formula is moved, the cells referring the moved cell show an error value. -Technology

Last Answer : False When a cell containing a formula is moved, the cells referring to the moved cell does not show an error value.

A cell entry can be edited either in the cell or in the formula bar. -Technology

Description : A cell entry can be edited either in the cell or in the formula bar. -Technology

Last Answer : True There are two ways to edit the data which has entered in the cell, i.e. in the cell or in the formula bar.

Define a utility software. -Technology

Description : Define a utility software. -Technology

Last Answer : A utility software is a system software designed to help in the management and tuning of operating systems, computer hardwares and different application softwares.

Describe utility software and also define its types. -Technology

Description : Describe utility software and also define its types. -Technology

Last Answer : It is a system software designed to help in management and tuning of operating systems, computer hardwares and different application softwares.A single piece of utility software is usually called a ... file system which can be mounted by the operating system and treated as an individual drive.

Define the term DBMS. -Technology

Description : Define the term DBMS. -Technology

Last Answer : The full form of DBMS is a Database Management System. It is a computer based record keeping system.

Define primary key with an example. -Technology

Description : Define primary key with an example. -Technology

Last Answer : A field which uniquely identifies each record in a table is known as the primary key. e.g. emp id is the primary key of the Employee table.

Define query in the context of database. -Technology

Description : Define query in the context of database. -Technology

Last Answer : A query is an inquiry into the database using the SELECT statement. These statements give you filtered data according to your conditions and specifications indicating the fields, records, and summaries which a user wants to fetch from a database.

Define forms and what is the need of using them? -Technology

Description : Define forms and what is the need of using them? -Technology

Last Answer : In a database, a form is a window or a screen that contains numerous fields or spaces to enter data. Forms can be used to view and edit your data. It is an interface in the user-specified ... like a paper form. People generally prefer to enter data into a well-designed form, rather than a table.

Define RDBMS. -Technology

Description : Define RDBMS. -Technology

Last Answer : RDBMS is a type of DataBase Management System that stores data in the form of relations (tables). Relational databases are powerful, so they require few assumptions about how data is related or how, it will be extracted from the database.

Define database management system. Write two advantages of using database management system for school. -Technology

Description : Define database management system. Write two advantages of using database management system for school. -Technology

Last Answer : Database Management System (DBMS) is a collection of programs that enable users to create, maintain database and control all the access to the database. The primary goal of the DBMS is to ... centralized location.2. It provides security to the personal information of the school, stored in it.

Is it necessary to define a field type for a field in MS_Access? -Technology

Description : Is it necessary to define a field type for a field in MS_Access? -Technology

Last Answer : Yes, it is necessary to define a type of a field while entering data into a field.

Define the term Wi_Fi hotspot. -Technology

Description : Define the term Wi_Fi hotspot. -Technology

Last Answer : A hotspot is a site that offers Internet access over a WLAN via a router connected to a link from an Internet Service Provider (ISP).

Define the AutoNumber data type in MS_ Access. -Technology

Description : Define the AutoNumber data type in MS_ Access. -Technology

Last Answer : AutoNumber data type starts with a number for the first record and it automatically increases the number by a set of amount for each record.

Define primary key. How do you set it in MS_Access? -Technology

Description : Define primary key. How do you set it in MS_Access? -Technology

Last Answer : Primary key is the key which is used to uniquely identify the records into the table. To set the primary key you have to follow the steps given below:Step 1 Select the field that you want ... 2 Click Primary Key button from the Design tab.orRight click on the selected field and select Primary Key.

When you define a field for a table, which of the following parameters do Access always consider optional? -Technology

Description : When you define a field for a table, which of the following parameters do Access always consider optional? -Technology

Last Answer : (d) Description field of the table is optional, as it depends on the databasedesigner that he/she wants to describe a field or not.

The ………… tag is used to define basic font size for the HTML page. -Technology

Description : The ………… tag is used to define basic font size for the HTML page. -Technology

Last Answer : Thetag is used to define basic font size for the HTML page.

<Head> tag is used to define document body. -Technology

Description : tag is used to define document body. -Technology

Last Answer : False tag is used to define the document head.

Define height and width attributes of <img> tag. -Technology

Description : Define height and width attributes of tag. -Technology

Last Answer : The width and height attributes tell the dimension of an image to the browser. Both (height and width) attributes require integer values (dimension of the image in terms of either pixels or percentage of its actual size).

Define various alignments of align attribute with example. -Technology

Description : Define various alignments of align attribute with example. -Technology

Last Answer : There are some values of image alignment attribute as follows:Middle AlignmentThis alignment is different in both Internet Explorer and Mozilla Firefox. In Internet Explorer, this alignment aligns the image ... effect reproduction, usually by providing a mechanism for the union of sperm with eggs.

Define the Maximize button. -Technology

Description : Define the Maximize button. -Technology

Last Answer : The Maximize button in Windows is the middle button with square. It allows the user to enlarge a window, usually making it fills the entire screen.

Define Status bar. -Technology

Description : Define Status bar. -Technology

Last Answer : The bottom line of any window is called Status bar in which an application can display various kinds of status information such as current window’s state, background tasks (such as printing, scanning etc) or other contextual information (such as selection, etc).

Define cellspacing. -Technology

Description : Define cellspacing. -Technology

Last Answer : The cellspacing is used to create space between different cells in a table.

Define the <th> and <tr> tags. Are these two tags similar? If yes, how? -Technology

Description : Define the and tags. Are these two tags similar? If yes, how? -Technology

Last Answer : tag stands for Table Header. It is used to give headings to the various columns in our table. tag stands for Table Row. It is used to create a row in a table. and tags are not similar. ... . Since, also defines a data cell, which is taken as heading to the columns and the data is boldfaced.

Define MS_Word 2007. -Technology

Description : Define MS_Word 2007. -Technology

Last Answer : MS-Word 2007 is a Word processing software package, which allows you to easily create a variety of professional looking documents like letters, reports and other documents using features such as Themes, Styles, SmartArt and more. It is a powerful tool chat you can use to create effective documents.

How will you define an element in DTD contain plain text? -Technology

Description : How will you define an element in DTD contain plain text? -Technology

Last Answer : If an element should contain plain text, you define the element using #PCDATA. PCDATA stands for Parsed Character Data and is the way you specify non-markup text in your DTDs.

Which document is used to define the style of an XML document? -Technology

Description : Which document is used to define the style of an XML document? -Technology

Last Answer : CSS is a text document (or stylesheet) that is commonly used to define the style and layout of an XML document.

Define prolog and data instance. -Technology

Description : Define prolog and data instance. -Technology

Last Answer : The prolog is a preface or introduction to XML document. It can contain upto five optional components. The grammar structure of the XML document is defined under prolog. The data instance consists of real data and its description through elements. It is also known as body of XML document.

Define CSS. How to create a CSS file? -Technology

Description : Define CSS. How to create a CSS file? -Technology

Last Answer : CSS is a simple design language intended to simplify the process of making Web pages presentable. CSS is a type of stylesheet and this stylesheet consists of a list of rules. You can include a CSS in multiple XML ... name as well as by code like green color may be written as #008000 or rgb(0,128,0).

Define the term Mail Merge. -Technology

Description : Define the term Mail Merge. -Technology

Last Answer : Mail Merge is a useful tool that allows you to produce multiple letters, labels, envelopes by linking a main (common) document to a set of data or data source. The main document is linked to the ... be the letter informing the person that they have won money, or their car service time has arrived.

……… is used to define the structure of an XML document. -Technology

Description : ……… is used to define the structure of an XML document. -Technology

Last Answer : DTDis used to define the structure of an XML document.

……… is a text document that is commonly used to define the style and layout of an XML document. -Technology

Description : ……… is a text document that is commonly used to define the style and layout of an XML document. -Technology

Last Answer : CSS is a text document that is commonly used to define the style andlayout of an XML document.

XML is used to define other languages. -Technology

Description : XML is used to define other languages. -Technology

Last Answer : True XML is a meta-language, which is used to define other languages.

Define virus. -Technology

Description : Define virus. -Technology

Last Answer : A virus is a harmful program, which on entering a computer, starts creating copies of itself. It then attacks by corrupting the executable files and folders saved on the computer.

Define information security. -Technology

Description : Define information security. -Technology

Last Answer : Information security is all about protecting and preserving information. It’s all about protecting and preserving the confidentiality, integrity, authenticity, availability, and reliability of information.

Define the term workbook. -Technology

Description : Define the term workbook. -Technology

Last Answer : A workbook is a collection of worksheets. By default, there are three worksheets in every workbook.

Define the term plagiarism. -Technology

Description : Define the term plagiarism. -Technology

Last Answer : Stealing someone else’s ideas or information and presenting them as your own is called plagiarism.

Define staffing. -Technology

Description : Define staffing. -Technology

Last Answer : Staffing is the process of recruitment and selection of human resources for an organization.

Define cell padding and cell spacing with respect to tables in HTML. -Technology

Description : Define cell padding and cell spacing with respect to tables in HTML. -Technology

Last Answer : CELLSPACING controls the space between table cells and CELLPADDING sets the amount of space between the contents of the cell and the cell wall.

Define container & empty tags in HTML -Technology

Description : Define container & empty tags in HTML -Technology

Last Answer : Container tags are tags which have both opening as well as closing tag like .....whereas empty tags are tags which have only opening tag like , .