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

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

1 Answer

Answer :

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

Related questions

When creating a Web document, what format is used to express an image's height and width? -Technology

Description : When creating a Web document, what format is used to express an image's height and width? -Technology

Last Answer : Pixelsis used to express an image's height and width.

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

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

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

How do I convert UK date format to US date format in excel?

Description : How do I convert UK date format to US date format in excel?

Last Answer : answer:Chances are, Excel is seeing those dates as plain text instead of as date objects. You can confirm this by widening the column with the dates are they left-justified? If yes, then ... provide the answer. Or you can see the same instructions online: Convert dates stored as text to dates.

Does Excel allow you to format cells to view in standard form?

Description : Does Excel allow you to format cells to view in standard form?

Last Answer : Change your settings (format->cells) to something that will display easier. It’s currently rounding. I’m not in front of my computer, but you can format the cells to show data any way you like.

The window version of Excel supports programming through Microsoft's Visual Basic for Applications (VBA), which is a dialect of _____: a) Visual Support b) Visual Basic c) Visual Format d) None of These

Description : The window version of Excel supports programming through Microsoft's Visual Basic for Applications (VBA), which is a dialect of _____: a) Visual Support b) Visual Basic c) Visual Format d) None of These

Last Answer : b) Visual Basic

To specify the number of decimal places in a cell the ……………… tab of the Format cells dialog is used. -Technology

Description : To specify the number of decimal places in a cell the ……………… tab of the Format cells dialog is used. -Technology

Last Answer : To specify the number of decimal places in a cell the Fill series tab of the Format cells dialog is used.

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.

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 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.

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.

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.

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.

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 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.

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.

The hard disk is hard to format on different systems. -Technology

Description : The hard disk is hard to format on different systems. -Technology

Last Answer : FalseHard disk is a secondary storage device which can be formatted on another system using boot sector format option.

Facilities offered by databases are (a) The ability to store a large amount of data in a structured format, -Technology

Description : Facilities offered by databases are (a) The ability to store a large amount of data in a structured format, -Technology

Last Answer : (a) Databases have the ability to store a large amount of data in structured format, easy update, sort query, production of reports.

Which data type helps you to handle input that is in boolean format? -Technology

Description : Which data type helps you to handle input that is in boolean format? -Technology

Last Answer : (c) Yes/No will allow boolean value.

Which property is used to add a label to the field to assist the user? (a) Default value (b) Caption (c) Format -Technology

Description : Which property is used to add a label to the field to assist the user? (a) Default value (b) Caption (c) Format -Technology

Last Answer : (b) Caption is used to add a label to the field for assisting to the user.

The Datasheet View displays the data in a table in tabular format. -Technology

Description : The Datasheet View displays the data in a table in tabular format. -Technology

Last Answer : True A datasheet is a simple view of data arranged in rows and columns.

Web browsers display images in the following format (a) XBM (b) JPEG -Technology

Description : Web browsers display images in the following format (a) XBM (b) JPEG -Technology

Last Answer : (d) All of these

It is used to start programs, obtain help, search for files and folders etc. (a) File menu (b) Edit menu (c) Format menu (d) Start button -Technology

Description : It is used to start programs, obtain help, search for files and folders etc. (a) File menu (b) Edit menu (c) Format menu (d) Start button -Technology

Last Answer : (d) Start button is used to start program, obtain helps, search for files and folders etc and also displays the most commonly used programs in a particular context.

Write the HTML code to generate the following table with the contents exactly in the same format as shown within the table: -Technology

Description : Write the HTML code to generate the following table with the contents exactly in the same format as shown within the table: -Technology

Last Answer : The HTML code is

Write the shortcut keys to format the text style bold, italic and underline. -Technology

Description : Write the shortcut keys to format the text style bold, italic and underline. -Technology

Last Answer : Bold – Ctrl+B, Italic – Ctrl+I, Underline – Ctrl+U

The Themes group is presented on ………….. tab. (a) Home (b) Page Layout (c) References (d) Picture Tools Format -Technology

Description : The Themes group is presented on ………….. tab. (a) Home (b) Page Layout (c) References (d) Picture Tools Format -Technology

Last Answer : (b) The Themes group is presented on Page Layout tab.

In the ………….. dialog box, you can change both line and paragraph spacing. (a) Paragraph (b) Line (c) Format Spacing (d) None of these -Technology

Description : In the ………….. dialog box, you can change both line and paragraph spacing. (a) Paragraph (b) Line (c) Format Spacing (d) None of these -Technology

Last Answer : (a) The Paragraph dialog box can be used to make the document effective by using both line and paragraph spacing.

Portrait format changes the page orientation ……….. -Technology

Description : Portrait format changes the page orientation ……….. -Technology

Last Answer : Portrait format changes the page orientationvertically.

Both HTML and XML are markup language used to format data. -Technology

Description : Both HTML and XML are markup language used to format data. -Technology

Last Answer : False XML is used to describe data, while HTML is used to format data.

The Drawing Tools Format tab appears at the bottom of the Word document window. -Technology

Description : The Drawing Tools Format tab appears at the bottom of the Word document window. -Technology

Last Answer : FalseDrawing Tools Format tab appears at the top of the Word document window.

Which file format can be added to a PowerPoint show? (a) .jpg (b) .gif (c) .wav (d) All of these -Technology

Description : Which file format can be added to a PowerPoint show? (a) .jpg (b) .gif (c) .wav (d) All of these -Technology

Last Answer : d) .jpg and .gif are file extensions for images and .wav is an extension for video file. Hence, all these formats are supported in PowerPoint.

A ………………. is a pre_designed format of text and color scheme. -Technology

Description : A ………………. is a pre_designed format of text and color scheme. -Technology

Last Answer : A templateis a pre-designed format of text and color scheme.

Briefly explain the two broad categories of a newspaper format giving suitable examples. -Technology

Description : Briefly explain the two broad categories of a newspaper format giving suitable examples. -Technology

Last Answer : The analysis of newspaper content suggests two broad categories of newspaper formatBroadsheet Press (quality or serious press)…. Explanation with examplesTabloid Press (Popular or sensational press)… Explanation with examples

………… elements help to express emotions or feelings in E_mail or text messages. -Technology

Description : ………… elements help to express emotions or feelings in E_mail or text messages. -Technology

Last Answer : Emoticon elements help to express emotions or feelings in E-mail or text messages.

When creating a Web document, which unit is used to express an image’s height and width? (a) Centimetres (b) Pixels -Technology

Description : When creating a Web document, which unit is used to express an image’s height and width? (a) Centimetres (b) Pixels -Technology

Last Answer : (b) Image’s height and width unit are expressed in pixels or in percent form.

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.

Is there any way to get my pictures back when the file format is changed?

Description : Is there any way to get my pictures back when the file format is changed?

Last Answer : It sounds as if the file may have gotten corrupted in its native file format, whatever that may be for your camera. I suggest you contasct support for the camera manufacturer and ask them if they have any tips for recovery, because steps are going to be specific to the camera’s native file format.

How to upload, play & edit .MTS format video?

Description : How to upload, play & edit .MTS format video?

Last Answer : answer:I don't have much experience with digital cameras, but I can that that Any Video Converter has worked pretty well for me in the past. It should be able to change the .mts files to .avi, .wmv, ... Luck! [edit] and .mts is listed as a supported format, so you really shouldn't have any trouble.

Should I download YouTube videos in FLV or MP4 format?

Description : Should I download YouTube videos in FLV or MP4 format?

Last Answer : MP4 is certainly the most versatile of the two. FLV requires another step to make it readable by video players, whereas MP4 files are already encoded and ready to watch.

How do you change the VOB (dvd recorded format) into AVI or other editable formats?

Description : How do you change the VOB (dvd recorded format) into AVI or other editable formats?

Last Answer : Try Handbrake and convert it to something else. Are they vob files?

Does anyone know how to convert DVDs to iPod format on a Mac?

Description : Does anyone know how to convert DVDs to iPod format on a Mac?

Last Answer : handbrake.fr

How long do you think it will be before the mp3 format is superseded?

Description : How long do you think it will be before the mp3 format is superseded?

Last Answer : ogg vorbis..

Do you think about the ways that technology has changed your life?

Description : Do you think about the ways that technology has changed your life?

Last Answer : answer:Positive: I am more informed; I am able to watch TV around my schedule; I can always reach someone if I am out and I need/want something. Negative: I don't remember phone numbers anymore; I spend time ... now, and I am happier now, but whether or not that is due to technology, I can't say.

Pictures can be added to Word documents and they cannot be formatted in various ways. -Technology

Description : Pictures can be added to Word documents and they cannot be formatted in various ways. -Technology

Last Answer : FalsePictures can be formatted in various war’s after adding it to the Word document like changing the shape, adding a border, modifying effects, applying a predefined style and more.

After modifying a document using track changes, in how many ways a document can be viewed? -Technology

Description : After modifying a document using track changes, in how many ways a document can be viewed? -Technology

Last Answer : There are four ways of viewing a document as follows:1. Final Showing Markup2. Final3. Original Showing Markup4. Original

While performing Mail Merge, in how many ways can you select recipients? Explain any one of them. -Technology

Description : While performing Mail Merge, in how many ways can you select recipients? Explain any one of them. -Technology

Last Answer : When you open or create a data source by using the Mail Merge wizard, you are telling Word to use a specific set of variable information for your merge. Use one of the following methods to attach ... this point, you are also saving the data source and attaching the data source to the main document.

Write minimum three ways by which a virus can spread to other systems. -Technology

Description : Write minimum three ways by which a virus can spread to other systems. -Technology

Last Answer : Three ways by which a virus can spread to other systems are as follows:1. When an infected file is copied through the network.2. When a virus file is downloaded from the Internet.3. When an infected file is copied from a floppy disk, USB, DVD etc.