0
Microsoft Excel
Excel is a spreadsheet application developed and distributed by Microsoft Corporation for computers using the Microsoft Windows and Mac OS X operating systems. It features graphing tools, chart wizards, calculations, formatting options, and pivot tables.
9,788 Questions
What key applies the currency style with a floating dollar sign and two decimal places?
Ctrl - Shift 4
How do you snap an embedded chart to the worksheet gridlines?
If you have Excel 2007 or higher, click the shape or object in the worksheet. In Drawing Tools on the Format tab, in the Arrange group, click Align. Then, to position shapes or objects to the closest intersection of the grid, click Snap to Grid or to position shapes or objects to grid lines that go through the vertical and horizontal edges of other shapes or objects, click Snap to Shape.
What is a shortcut to select the table around the cell pointer?
The keyboard shortcut is: Ctrl Shift *(asterisk)
Expound on the three factions of excel as an electronic spreadsheet?
Excels spreadsheets include automated sums, chronicle order options, and formula formatting. These factions all allow the user to properly label, organize and account massive amounts of information timely.
What is the purpose to using functions in Excel?
Functions are in-built formulas to do specific tasks. They are useful for doing specified tasks quickly and simply. Excel has hundreds of functions that can be used. They are categorised for different uses, such a Financial functions or Date and Time functions. If you are writing formulas in Excel you would use a lot of functions. Using Excel without using functions would make things very slow. See the related question below.
Names of Businesses that use Excel?
Any business can use Excel, so there is no specific answer to that question. Spreadsheets can be used for financial analysis, which is something all businesses need to do. We would particularly associate them with people like accountants, but they are not limited just to them. Spreadsheets can be used by organisations and individuals too. Almost anyone can use a spreadsheet as it has many uses.
How do you activate a macro in an excel sheet when a cell equals a predefine value?
Use the control Worksheet_Change. See related links for a sample macro that will trigger a macro when the cell changes. Modify, as needed, to fit your specific situation.
What software should be used to create a gantt chart?
You can use a spreadsheet, but you usually would use project management software.
ALT
In excel what is the correct formula to auto sum column B?
If you have numbers in cells B1 through B134, use the formula: =SUM(B1:B134). You can use auto sum to insert the formula by highlighting the column (you can click on the column letter) and clicking the AutoSum button on the menu.
The database is a collection of data on which we can perform operations such as:
1. Storing data (Save)
2. Manipulating data (Update, Delete, insert, sort)
3. Retrieve data (Whenever necessary, we can see the data in a particular table form, or use selected data, as in a computer program)
Typically a database is made up of many linked tables of rows and columns, each containing specific data (E.g. name, address, location, size, weight, dates).
Field: each column represents a field.
Record: each row represents one record.
Table: collection records.
Database is the collection of data . Or we should say that database is the collection of interrelated data.
Database A database is an organized collection of data, today typically in digital form. The data are typically organized to model relevant aspects of reality (for example, the availability of rooms in hotels), in a way that supports processes requiring this information (for example, finding a hotel with vacancies). The term database is correctly applied to the data and their supporting data structures, and not to the database management system (DBMS). The database data collection with DBMS is called adatabase system. The term database system implies that the data is managed to some level of quality (measured in terms of accuracy, availability, usability, and resilience) and this in turn often implies the use of a general-purpose database management system (DBMS).[1] A general-purpose DBMS is typically a complex software system that meets many usage requirements, and the databases that it maintains are often large and complex. The utilization of databases is now spread to such a wide degree that virtually every technology and product relies on databases and DBMSs for its development and commercialization, or even may have such embedded in it. Also, organizations and companies, from small to large, heavily depend on databases for their operations. Well known DBMSs include Oracle, IBM DB2, Microsoft SQL Server, PostgreSQL, MySQL, WebDNA and SQLite. A database is not generally portable across different DBMS, but different DBMSs caninter-operate to some degree by using standards like SQL and ODBC to support together a single application. A DBMS also needs to provide effective run-time execution to properly support (e.g., in terms of performance, availability, and security) as many end-users as needed. A way to classify databases involves the type of their contents, for example: bibliographic, document-text, statistical, or multimedia objects. Another way is by their application area, for example: accounting, music compositions, movies, banking, manufacturing, or insurance. The term database may be narrowed to specify particular aspects of organized collection of data and may refer to the logical database, to physical database as data content in computer data storageor to many other database sub-definitions. Graphics Graphics (from Greek γραφικός graphikos) are visual presentations on some surface, such as a wall, canvas, screen, paper, or stone to brand, inform, illustrate, or entertain. Examples arephotographs, drawings, Line Art, graphs, diagrams, typography, numbers, symbols, geometric designs, maps, engineering drawings, or other images. Graphics often combine text, illustration, andcolor. Graphic design may consist of the deliberate selection, creation, or arrangement of typography alone, as in a brochure, flier, poster, web site, or book without any other element. Clarity or effective communication may be the objective, association with other cultural elements may be sought, or merely, the creation of a distinctive style. Graphics can be functional or artistic. The latter can be a recorded version, such as a photograph, or an interpretation by a scientist to highlight essential features, or an artist, in which case the distinction with imaginary graphics may become blurred. Computer graphics Computer graphics are graphics created using computers and, more generally, the representation and manipulation of image data by a computer with help from specialized software and hardware. The development of computer graphics has made computers easier to interact with, and better for understanding and interpreting many types of data. Developments in computer graphics have had a profound impact on many types of media and have revolutionized animation, movies and the video gameindustry.]] and the video game industry.
A database is an electronic way of storing information so that it is easily accessible by searching more than one field.
Is a spreadsheet label the intersection of a column and a row?
No. A label is a heading for data in a spreadsheet. It would be in a cell, which is what the intersection of a column and a row is.
What function key is used to recalculate when Excel worksheet is in manual calculation mode?
The F9 key.
What are two ways to cancel an entire entry before entering it into a cell for Excel?
Press the Esc key or click on the Cancel button, which is the red x beside where you are typing your entry.
What are MS Word PowerPoint Excel etc called?
They are all applications. Word is a word processor, Powerpoint is a presentations application and Excel is a spreadsheet. Together they form part of the Microsoft Office suite, along with some other programs, such as Outlook and Access.
What is the purpose behind freezing row and column headings?
It allows people to scroll down or across and maintain the headings on the screen. If you have a lot of rows or columns with headings on them, it can be easy to lose track of which row or column is meant to hold the data you want to enter. Having the headings permanently in view gets rid of that problem.
What does it mean when a cell or cells in a excel include a series of?
A series can refer to values used on a chart. It can also be a set of cells that have some connection, like the days of the week, or months of the year, or a sequence of numbers, or even a mix of text and standard numbers like Quarter 1, Quarter 2, Quarter 3, Quarter 4.
A series can refer to values used on a chart. It can also be a set of cells that have some connection, like the days of the week, or months of the year, or a sequence of numbers, or even a mix of text and standard numbers like Quarter 1, Quarter 2, Quarter 3, Quarter 4.
A series can refer to values used on a chart. It can also be a set of cells that have some connection, like the days of the week, or months of the year, or a sequence of numbers, or even a mix of text and standard numbers like Quarter 1, Quarter 2, Quarter 3, Quarter 4.
A series can refer to values used on a chart. It can also be a set of cells that have some connection, like the days of the week, or months of the year, or a sequence of numbers, or even a mix of text and standard numbers like Quarter 1, Quarter 2, Quarter 3, Quarter 4.
A series can refer to values used on a chart. It can also be a set of cells that have some connection, like the days of the week, or months of the year, or a sequence of numbers, or even a mix of text and standard numbers like Quarter 1, Quarter 2, Quarter 3, Quarter 4.
A series can refer to values used on a chart. It can also be a set of cells that have some connection, like the days of the week, or months of the year, or a sequence of numbers, or even a mix of text and standard numbers like Quarter 1, Quarter 2, Quarter 3, Quarter 4.
A series can refer to values used on a chart. It can also be a set of cells that have some connection, like the days of the week, or months of the year, or a sequence of numbers, or even a mix of text and standard numbers like Quarter 1, Quarter 2, Quarter 3, Quarter 4.
A series can refer to values used on a chart. It can also be a set of cells that have some connection, like the days of the week, or months of the year, or a sequence of numbers, or even a mix of text and standard numbers like Quarter 1, Quarter 2, Quarter 3, Quarter 4.
A series can refer to values used on a chart. It can also be a set of cells that have some connection, like the days of the week, or months of the year, or a sequence of numbers, or even a mix of text and standard numbers like Quarter 1, Quarter 2, Quarter 3, Quarter 4.
A series can refer to values used on a chart. It can also be a set of cells that have some connection, like the days of the week, or months of the year, or a sequence of numbers, or even a mix of text and standard numbers like Quarter 1, Quarter 2, Quarter 3, Quarter 4.
A series can refer to values used on a chart. It can also be a set of cells that have some connection, like the days of the week, or months of the year, or a sequence of numbers, or even a mix of text and standard numbers like Quarter 1, Quarter 2, Quarter 3, Quarter 4.
When the column is not wide enough to display a number Microsoft Excel displays?
It fills the cell with # symbols.
It fills the cell with # symbols.
It fills the cell with # symbols.
It fills the cell with # symbols.
It fills the cell with # symbols.
It fills the cell with # symbols.
It fills the cell with # symbols.
It fills the cell with # symbols.
It fills the cell with # symbols.
It fills the cell with # symbols.
It fills the cell with # symbols.
