If the data entered in a cell is 546z then, Excel will treat it as a number because it starts with a digit. -Technology

If the data entered in a cell is 546z then, Excel will treat it as a number because it starts with a digit. -Technology
by

1 Answer

Answer :

False It will be treated as non-numeric data because it contains letters along with numbers.
by

Related questions

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.

If = 6 _5 *2 is entered in a cell, then what will be the cell content? -Technology

Description : If = 6 _5 *2 is entered in a cell, then what will be the cell content? -Technology

Last Answer : -4 will be contained in the cell as a result.

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

Which field property sets limits on the data that is entered? -Technology

Description : Which field property sets limits on the data that is entered? -Technology

Last Answer : Fixed Field Length or Field Size property sets the limits on the data entered.

Sana has entered 49+30 in a cell. The worksheet is not displaying 79 in the cell. -Technology

Description : Sana has entered 49+30 in a cell. The worksheet is not displaying 79 in the cell. -Technology

Last Answer : In Excel, every formula must start with a = (equal) sign.Since Sana has not put = sign before 49+30, thus she is not able to see the desired result will be displayed if she will use = (49 + 30) formula.

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.

The simplest way to move data from one location to another in Excel is ……………… -Technology

Description : The simplest way to move data from one location to another in Excel is ……………… -Technology

Last Answer : (d) We can move data using cut and paste and also drag and drop method is the easiest one.

In Excel chart, text displayed at data points to indicate the specific category is called …………….. -Technology

Description : In Excel chart, text displayed at data points to indicate the specific category is called …………….. -Technology

Last Answer : (c) Text displayed at data points to indicate the specific category is called data label.

What happens when text is entered in a Number type field? -Technology

Description : What happens when text is entered in a Number type field? -Technology

Last Answer : When we enter text in a Number field and press Enter or press Tab key, MS-Access displays a message that “The value you entered does not match the Number data type in this column.”

Reena is new to Excel. Her instructor has asked her to open Excel on her PC and questioned about active cell. -Technology

Description : Reena is new to Excel. Her instructor has asked her to open Excel on her PC and questioned about active cell. -Technology

Last Answer : An active cell is a cell with heavy black color boundary.

If you enter 15 + 30 in a cell, Excel will display …………….. -Technology

Description : If you enter 15 + 30 in a cell, Excel will display …………….. -Technology

Last Answer : If you enter 15 + 30 in a cell, Excel will display15 + 30.

In Marks column of ‘Student’ table, for Rollnumber 2, the Class Teacher entered the marks as 45. -Technology

Description : In Marks column of ‘Student’ table, for Rollnumber 2, the Class Teacher entered the marks as 45. -Technology

Last Answer : UPDATE Student SET Marks = 50 WHERE Roll number = 2;

Without the symbol '=' excel will treat the data as ____.

Description : Without the symbol '=' excel will treat the data as ____.  a) Number b) Formula c) Text d) None of the above

Last Answer : Without the symbol '=' excel will treat the data as Text.

In Excel, how many ways are there to express/format a number? -Technology

Description : In Excel, how many ways are there to express/format a number? -Technology

Last Answer : Numbers in Excel can be expressed in many different formats like date, time, percentage or decimals.

A digit in base r will have a range from -Technology

Description : A digit in base r will have a range from -Technology

Last Answer : A digit in base R will have a range from0 to R-1.

What is the use of the COUNT() function in Excel? -Technology

Description : What is the use of the COUNT() function in Excel? -Technology

Last Answer : Excel’s COUNT() function can be used to total the number of cells in a selected range. The COUNT() function will add up the number of cells in a selected range that contains numbers.

How are charts created in Excel? Write the steps. -Technology

Description : How are charts created in Excel? Write the steps. -Technology

Last Answer : Creating a Chart:Here is a worksheet that shows the marks of students in a class subject wise. To create a chart, do the following:1. Select the data that you want to show, including the ... Design tab under Chart Tools, in the Type group, click Change Chart Type and select another chart type.

By default, a workbook in Excel contains how many worksheets? -Technology

Description : By default, a workbook in Excel contains how many worksheets? -Technology

Last Answer : (b) 3 worksheets are present in every workbook by default.

The default page orientation in Excel is (a) Landscape -Technology

Description : The default page orientation in Excel is (a) Landscape -Technology

Last Answer : (c) The default page orientation in Excel is Portrait.

The sample of an Excel worksheet on the screen can be seen by ……………….. -Technology

Description : The sample of an Excel worksheet on the screen can be seen by ……………….. -Technology

Last Answer : (a) Print preview enables you to view the sample of worksheet before printing it on a paper.

For selecting the entire worksheet in Excel, you need to press ………………. -Technology

Description : For selecting the entire worksheet in Excel, you need to press ………………. -Technology

Last Answer : (b) You need to press Ctrl + Shift + Spacebar for selecting the entire worksheet in Excel.

Excel is a ………………. software package. -Technology

Description : Excel is a ………………. software package. -Technology

Last Answer : Excel is aspreadsheetsoftware package.

You cannot open two different workbooks in Excel simultaneously. -Technology

Description : You cannot open two different workbooks in Excel simultaneously. -Technology

Last Answer : False You can open two different workbooks in Excel simultaneously.

What key do you use to erase an entire entry in a cell and then reenter the data from the beginning with Excel?

Description : What key do you use to erase an entire entry in a cell and then reenter the data from the beginning with Excel?

Last Answer : You can press the Delete key. However, if you just select a celland start typing, it will replace what is in the cell, so it is notnecessary to press the Delete key first.

The unordered list starts with ………….. tag. -Technology

Description : The unordered list starts with ………….. tag. -Technology

Last Answer : The unordered list starts with tag.

Which tag tells, where a link starts? (a) <1> (b) <start> -Technology

Description : Which tag tells, where a link starts? (a) (b) -Technology

Last Answer : (c) tag specify that a link starts, in which, href create a hyperlink.

A virus is a harmful program, which one entering a computer, starts creating copies of itself. -Technology

Description : A virus is a harmful program, which one entering a computer, starts creating copies of itself. -Technology

Last Answer : True Virus is a malicious program that is designed to make a system sick, just like a real virus.

Convert Excel cell data to a column header?

Description : Convert Excel cell data to a column header?

Last Answer : answer:From your question it's not entirely clear to me what you want to do. Obviously you want to differentiate one product (Product ID) from another. So, do you just want to change a listing that ... the Find text with , leaving you with only the product ID values. Was that what you wanted?

In Excel, a data series is define as what? a. A type of chart b. A cell reference c. A collection of related data d. A division of results

Description : In Excel, a data series is define as what? a. A type of chart b. A cell reference c. A collection of related data d. A division of results

Last Answer : c. A collection of related data

In Excel, a data series is define as what? a. A type of chart b. A cell reference c. A collection of related data d. A division of results

Description : In Excel, a data series is define as what? a. A type of chart b. A cell reference c. A collection of related data d. A division of results

Last Answer : c. A collection of related data

The basic unit ofa worksheet into which you enter data in Excel is called a– (A) tab (B) cell (C) box (D) range (E) None of these

Description : The basic unit ofa worksheet into which you enter data in Excel is called a– (A) tab (B) cell (C) box (D) range (E) None of these

Last Answer : cell

The basic unit of a worksheet into which you enter data in excel is called a ______: a) Tab b) Cell c) Box d) Range e) None of The Above

Description : The basic unit of a worksheet into which you enter data in excel is called a ______: a) Tab b) Cell c) Box d) Range e) None of The Above

Last Answer : b) Cell

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.

I entered some data into the "fields of expertise", "hobbies", and "places you've lived" data entry fields. Did I not submit it correctly, or am I awaiting moderator approval? lol thanks?

Description : I entered some data into the "fields of expertise", "hobbies", and "places you've lived" data entry fields. Did I not submit it correctly, or am I awaiting moderator approval? lol thanks?

Last Answer : I just tested it and it seems to work fine. Are you sure you hit the save button?

Which of the following will happen when data is entered into a memory location? A) It will add to the content of the location B) It will change the address of the memory location C) It will erase the previous content D) It will not be fruitful if there is already some data at the location

Description : Which of the following will happen when data is entered into a memory location? A) It will add to the content of the location B) It will change the address of the memory location C) It will erase the previous content D) It will not be fruitful if there is already some data at the location

Last Answer : Answer : C

The output unit coverts the data entered by the user into computer understandable form. a) True b) False

Description : The output unit coverts the data entered by the user into computer understandable form. a) True b) False

Last Answer : Answer: b Explanation: The Output unit is responsible for converting the computer obtained data into user understandable format. The Input Unit is responsible for converting the data in computer understandable format

Any data and instruction entered in the memory of a computer is__________ A. Storage B. Output C. Input D. Information

Description : Any data and instruction entered in the memory of a computer is__________ A. Storage B. Output C. Input D. Information

Last Answer : C. Input

An insulation resistance test is performed on a particular piece of electric equipment. In addition to the resistance reading, what information listed below should be entered in the electrical log? A. The maximum allowable operating temperature of the machine. B. The temperature of the machine at the time the resistance reading was taken. C. The normal temperature rise of the machine. D. The complete nameplate data from the resistance test instrument used to obtain the reading.

Description : An insulation resistance test is performed on a particular piece of electric equipment. In addition to the resistance reading, what information listed below should be entered in the electrical log? A. ... D. The complete nameplate data from the resistance test instrument used to obtain the reading.

Last Answer : Answer: B

Which of the following will happen when data is entered into a memory location? a. It will add to the content of the location b. It will change the address of the memory location c. It will erase the previous content d. It will not be fruitful if there is already some data at the location

Description : Which of the following will happen when data is entered into a memory location? a. It will add to the content of the location b. It will change the address of the memory location c. It will erase the previous content d. It will not be fruitful if there is already some data at the location

Last Answer : It will erase the previous content

When speaking of computer input and output, input refers to - 1) any data processing that occurs from new data input into the computer 2) data or information that has been entered into the computer 3) the transmission of data that has been input into the computer 4) Both (C) and (D) above.

Description : When speaking of computer input and output, input refers to - 1) any data processing that occurs from new data input into the computer 2) data or information that has been entered into the computer 3) the transmission of data that has been input into the computer 4) Both (C) and (D) above.

Last Answer : 4) Both (C) and (D) above.

The energy data entered into____ a) spreadsheet. b) bar chart c) histogram d) all of the above

Description : The energy data entered into____ a) spreadsheet. b) bar chart c) histogram d) all of the above

Last Answer : spreadsheet

When speaking of computer input and output, input refers to - 1 any data processing that occurs from new data input into the computer 2 data or information that has been entered into the computer 3 the transmission of data that has been input into the computer 4 Both (C) and (D) above.

Description : When speaking of computer input and output, input refers to - 1 any data processing that occurs from new data input into the computer 2 data or information that has been entered into the computer 3 the transmission of data that has been input into the computer 4 Both (C) and (D) above.

Last Answer : 4 Both (C) and (D) above.

What are some of the types of input media on which data may be indirectly entered?

Description : What are some of the types of input media on which data may be indirectly entered?

Last Answer : Punched cards, paper tape, magnetic tape, or magnetic disk.

Which of the following will happen when data is entered into a memory location? a. It will add to the content of the location b. It will change the address of the memory location c. It will erase the previous content d. It will not be fruitful if there is already some data at the location

Description : Which of the following will happen when data is entered into a memory location? a. It will add to the content of the location b. It will change the address of the memory location c. It will erase the previous content d. It will not be fruitful if there is already some data at the location

Last Answer : c. It will erase the previous content

Which of the following will happen when data is entered into a memory location? a. It will add to the content of the location b. It will change the address of the memory location c. It will erase the previous content d. It will not be fruitful if there is already some data at the location

Description : Which of the following will happen when data is entered into a memory location? a. It will add to the content of the location b. It will change the address of the memory location c. It will erase the previous content d. It will not be fruitful if there is already some data at the location

Last Answer : c. It will erase the previous content

According to the principles of ICH GCP what should be recorded, handled, and stored in a way that allows its accurate reporting, interpretation and verification? A. Data entered into the case report form B. Source information C. All clinical trial information D. Essential documents

Description : According to the principles of ICH GCP what should be recorded, handled, and stored in a way that allows its accurate reporting, interpretation and verification?  A. Data entered into the case report form  B. Source information  C. All clinical trial information  D. Essential documents

Last Answer : C. All clinical trial information 

In Unix operating system, special files are used to : (A) buffer data received in its input from where a process reads (B) provide a mechanism to map physical device to file names (C) store list of file names plus pointers associated with i-nodes (D) store information entered by a user application program or utility program

Description : In Unix operating system, special files are used to : (A) buffer data received in its input from where a process reads (B) provide a mechanism to map physical device to file names (C ... pointers associated with i-nodes (D) store information entered by a user application program or utility program

Last Answer : (B) provide a mechanism to map physical device to file names 

Registers in which data is entered or taken out in serial form are referred as

Description : Registers in which data is entered or taken out in serial form are referred as   (A) left shift register (B) right shift register (C) shift registers (D) none of the above

Last Answer : Registers in which data is entered or taken out in serial form are referred as shift registers

Because of its with Belgium Great Britain entered world war 1?

Description : Because of its with Belgium Great Britain entered world war 1?

Last Answer : Germany refused a British demand not to invade Belgium (apex

Because of its with Belgium Great Britain entered world war 1?

Description : Because of its with Belgium Great Britain entered world war 1?

Last Answer : Germany refused a British demand not to invade Belgium (apex