what is numbers app on iphone

Spreadsheet application by Apple Inc.

Numbers game for macOS

Developer(s)	Malus pumila Inc.

Stable let go	11.2 / September 28, 2021; 3 months ago (2021-09-28) ^[1]

OS	macOS 11.0 or later
Typecast	Spreadsheet
License	Proprietary
Website	www.apple.com/mac/Book of Numbers

Numbers for iOS

Developer(s)	Apple Inc.

Stabile release	11.2 / September 28, 2021; 3 months agone (2021-09-28) ^[2]

OS	iOS 14 or later IPadOS 14 or subsequently
Procurable in	31 languages
List of languages English, Catalan, Croatian, Czech, Danish, Dutch, Finnish, Gallic, European country, Balkan state, Religious belief, Hungarian, Indonesian, European country, Asian nation, Korean, Malay, Norwegian, Polish, European country, Roumanian, Russian, Simplified Chinese, Slovak, Spanish, Scandinavian nation, Asian country, Long-standing Chinese, Land, Ukrainian, Vietnamese
Type	Spreadsheet
License	Branded
Website	www.apple.com/ios/numbers

Numbers is a spreadsheet application developed by Apple Inc. as part of the iWork productiveness suite alongside Keynote and Pages.^[3] Numbers is visible for iOS, and macOS Sierra Nevada Mountains surgery newer.^[4] Numbers racket 1.0 happening OS X was declared on 7 Revered 2007, making it the newest application in the iWork suite. The iPad version was released on 27 January 2010.^[5] The app was late updated to support iPhone and iPod Allude.

Numbers uses a free-form "canvas" approach that demotes tables to one of many different media types set on a page. Other media, corresponding charts, graphics and text, are dressed as peers. In comparison, traditional spreadsheets like Microsoft Excel use the table as the primary container, with new media placed within the hold over. Numbers pool besides includes features from the seminal Lotus Improv, notably the enjoyment of formulas based on ranges rather than cells. However, information technology implements these using traditional spreadsheet concepts, as opposed to Improv's role of three-d databases.

Numbers also includes numerous rhetorical improvements in an crusade to improve the visual show of spreadsheets. At its prefatorial demonstration, Steve Jobs pitched a to a greater extent usable port and better control over the appearance and presentation of tables of data.

Verbal description [edit]

Basic model [edit]

Numbers works in a fashion somewhat different from traditional spreadsheets corresponding Microsoft Excel or Lotus 1-2-3. In the traditional model, the put of is the excellent citizen of the system, acting as some the primary interface for work, and A the container for other types of media like charts Beaver State digital images. In effect, the spreadsheet and the table are one and the same. In contrast, Numbers uses a separate "study" as its basic container aim, and tables are among the many another objects that can Be placed inside the canvas.^[6] ^{[N 1]}

This difference is not only a event of syntax. In order to provide a whacking workspace, conventional spreadsheets extend a table in X and Y to organise a very larger grid—ideally infinite, but normally limited to some smaller dimension.^{[N 2]} More or less of these cells, selected by the user, hold information. Data is manipulated using formulas, which are placed in other cells in the same sheet and output signal their results back into the formula cell's display. The rest of the tack is "sparse", currently unused.^[8]

Sheets often grow very coordination compound with stimulant data, intermediate values from formulas and outturn areas, separated by space areas. In ordinate to manage this complexity, Excel allows unity to pelt data that is not of interest,^[9] often average values. Quattro Pro normally introduced the idea of binary sheets in a single book, allowing further subdivision of the data; Excel implements this As a set of tabs along the bottom of the workbook.

In contrast, Numbers does non have an fundamental spreadsheet in the traditional sense, but uses multiple individual tables for this intent.^[6] Tables are an X and Y collection of cells, wish a sheet, but stretch merely to the limits of the data they control. All section of data, or turnout from formulas, can be combined into an existing table, or settled into a new table. Tables can be collected by the user onto single operating room multiple canvases. Whereas a regular Excel sheet has information strewn across it, a Numbers canvas could build the same output through smaller individual tables encompassing the same information.^[10]

Formulas and functions [edit]

A newly created Numbers written document is styled to indicate suggested header areas in newspaper column A and row 1. Note that the put over Michigan in the lour decently of the screen, which can be resized with the widget in the corner.

After adding information and headers, Numbers racket has mechanically created named ranges over the data. The ranges were utilised to create a chemical formula that has populated column D. Note that the synoptic formula prat be used for the entire column—the quarrel issue is not required.

The table has been resized to show only the used area, moved into the centre of the canvas, and styled. A graph has been added above the table. The pane in the upper left shows an object tree, with the "canvas" objects existence shown in a hierarchy of each flat solid, all plane can live collapsed or expanded to show the canvass fabric physical object contained within that sheet.

Consider a simple spreadsheet existence used to calculate the normal value of all gondola sales in a month for a given year. The sheet might contain the month number Oregon name in column A, the number of cars sold in chromatography column B, and the total income in column C. The user wishes to complete the task of "calculate the mean income per auto oversubscribed by divisional the total income by the number of cars sold, and place the resulting average in column D". From the user's perspective, the values in the cells have semantic message, they are "cars sold" and "total income", and they want to manipulate this to develop an output value, "mediocre price".

In tralatitious spreadsheets, the linguistics value of the numbers is lost. The issue in cadre B2 is not "the number of cars sold in the month of January", but simply "the value in cell B2". The formula for calculating the average is supported the manipulation of the cells, in the form =C2/B2. Eastern Samoa the spreadsheet is unaware of the exploiter's desire for D to be an production editorial, the user copies that chemical formula into all of the cells in D. However, as the formula refers to information happening different rows, it essential be modified as IT is copied into the cells in D, dynamic it to pertain to the correct row. For instance, the formula in D4 would read =C4/B4. Surpass automates this subsequently task by using a relative referencing organisation that works as long as the cells keep back their location relative to the rule. Nonetheless, this system requires Excel to track any changes to the layout of the sheet and adjust the formulas, a process that is far from foolproof.^[11]

During the exploitation of Improv, the Nymphaea lotus team discovered that these sorts of formulas were some difficult to habituate, and resistant to future changes in the spreadsheet layout.^[12] Their solution was to make water the drug user explicitly define the semantic capacity of the sheets—that the B editorial contained "cars sold". These data ranges were known atomic number 3 "categories". Formulas were written by referring to these categories by name, creating a new category that could be (if craved) placed in the sheet for reveal. Using the railway car example, the chemical formula in Improv would Be average per car = total income / cars oversubscribed. Changes to the layout of the sheet would not affect the formulas; the data cadaver defined no matter where it is moved. It also meant that formulas scheming intermediate values did not have to Be placed in the sheet and ordinarily did non take up room. The downside to Improv's approach is that it demanded more information from the user up-front, and was considered less suitable for "quick and dirty" calculations or basic list building.^[13]

Numbers uses a cross approach to the creation of formulas, load-bearing the employment of named data like Improv, but implementing them in-piece of paper corresponding Excel. In basic surgical process, Numbers racket potty be used just like Excel; data can be written anywhere and formulas stool make up created by referring to the data away its cadre. However, if the user types a header into the table, something one normally does as a matter of course, Numbers uses this to automatically construct a named range for the cells on that quarrel or column. For instance, if the user types "month" into A1, and so types the name calling "January", "Feb", etc. into the cells below information technology, Numbers constructs a named range for the cells A2 through with A13 and gives it the name "calendar month". The same is reliable when the user types in the figures for "sales" and "income". The exploiter can and then indite the averaging formula in a category-like school tex formatting, = total income / cars sold. The formula will happen the pertinent data and calculate the results independent of the course.^[14] Corresponding Improv, this formula does not refer to the physical localization of the data in the sheet, so the sheet of paper can be dramatically modified without causing the formula to fail.^[14]

Same to Improv, formulas can be represented As icons in Numbers, allowing them to be dragged about the sheets. Same noteworthy exercise of this is a sidebar which contains the sum, average and otherwise alkaline calculations for the current selection in the brisk table. These serve a social function similar to the sum that appears at the bottom of the windowpane in Excel. However, the user can drag single of the run icons from the sidebar into the tabloid to make the reckoning appear at that place.^[14] In another nod to Improv, the Recipe List shows all of the formulas in the spreadsheet in a separate area, and allows edits in place or easy navigation to their use in the sheets.

Numbers '09 contains 262 built-in functions that fire be used in formulas.^[15] This contrasts with Excel 2007's 338 functions.^[16] Many of the functions in Numbers are isotropous to those in Excel; missing ones tend to be enate to statistics, although this area was greatly improved in Numbers '09.^[17]

Numbers '09 includes a system for categorizing data similar to pivot tables. Pivots were introduced in Improv and were manipulated by dragging the category headers,^[17] allowing the exploiter to quickly rotate rows into columns or vice versa. Although Numbers has synonymous draggable objects representing formulas, they are not used for this feature and the direct use is missing. As an alternative, Numbers places pop fly menus in the column headers allowing the drug user to collapse multiple rows into totals (sums, averages, etc.) supported information that is common crosswise rows. This is similar functionality to a pivot postpone, only lacks the informality of re-arrangement of the Improv model and other advanced features. Numbers 5.2, released on Sept 17, 2018,^[18] promote improves on these features aside adding Saucy Categories, allowing the user to "chop-chop organize and summarize tables to gain new insights".^[19]

Swivel tables were later added to Numbers 11.2 on September 28, 2021.^[20]

Layout and display [edit]

As Numbers game uses the canvas tent as the basis for the text file, media is not tied to the tables; i could build a Numbers canvas with a collection of photographs and no tables. In typical use of goods and services, unrivalled operating theater more tables are placed on the canvas and sized and styled to evidenc alone the information of interest. Charts and labels are commonly positioned around the tables. Other media, like photographs or illustrations, john be added as well.^[21] Numbers pool' reveal-centrical model has been referred to A a "page layout and presentation app covert every bit a spreadsheet app".^[22]

Equal other products in the iWork suite, Numbers racket includes a diversity of styles and layouts designed by line of work illustrators. Opening an Excel sheet in Numbers results in a presentation with smooth fonts, and clean layout and discolor selections. These keister then be modified, optionally using one of the supplied templates, and reclaimed KO'd to Excel format again with these styles intact. Numbers also allows sheets to be emailed in Stand out format in a single step, or shared through Numbers for iCloud.

Reception [edit]

Numbers has been well received in the press, notably for its text-supported formulas, unsoiled looks and ease of use.^[23] ^[24] ^[25] Macworld has acknowledged it high marks, especially newer versions, awarding Numbers '09 four mice impermissible of five. They did point out a number of common issues, especially problems exporting to Excel and the inability to "lock" cells to prevent them moving when the table is scrolled.^[17] Numbers for the iPhone and iPad have standard same favorable reviews.^[26]

However, version 3.0 of Numbers game created an gush of complaints due to the loss of evidential business features,^[27] ^[28] with the Apple accompaniment biotic community showing a 10 to 1 ratio of dissatisfied users with the newer version of Numbers. Versions 4 and 5 of the software lay out many of these features back likewise As adding many an new features and functionalities.^[29] In their review of Version 5, MacWorld concluded that "Numbers 5 for Mac advances the app, fashioning IT more useful for Sir Thomas More purposes with less effort, but it's still a shadow of full-lineament business spreadsheet programs."^[30]

Some other notable features [edit]

Extremely table-centric workflow, where lists are well-to-do to structure with headers and summaries.
Checkbox, Pseudemys scripta, and pulldown name cells.
Drag-and-drop of functions from a sidebar into cells.
A Print Trailer that allows all editing functions piece previewing, also A real-time scaling and moving of tables to arrange them freely on the page(s).
Exports to Microsoft Surpass, but lacks certain Excel features, including Visual Rudimentary for Applications (absent in the 2008 version of Office for Mack, although it was reintroduced for the 2011 version) and pivot tables.

Notes [edit]

^ For reasons that are not mentioned in the documentation, canvases are referred to every bit "sheets" within the program.
^ Numbers can handle up to 1,000,000 rows aside 1,000 columns per put over,^[7] versus the latest versions of Excel from Part 2010 onwards having a maximum of 1,048,576 rows aside 16,384 columns. Excel has changed its maximum size many times, originally 16,384 rows by 128 columns, spell strange programs of the same era often compared themselves by crescendo this, e.g. WingZ was 32,768 away 32,768 for illustration.

References [edit]

^ "Book of Numbers". Mac App Store.
^ "Numbers pool". App Store.
^ "Apple - iWork - Numbers - Create perfect spreadsheets in minutes". Orchard apple tree Inc. Retrieved June 13, 2010.
^ "Pages 7.2, Numbers 5.2, and Keynote 8.2". Tidbits . Retrieved November 15, 2018.
^ "Apple - iPad - Groundbreaking spreadsheets in just a hardly a taps". Apple Inc. Retrieved June 13, 2010.
^ ^a ^b "Numbers game, uncrunched.", Apple INC.
^ "About operative with large information sets in Numbers"
^ Josef Stoer and Roland Bulirsch, "Introduction to Numerical Analysis (3rd ed.)", Springer-Verlag, 2002, p. 610
^ David Ringstrom, "Tricks for concealing and unhiding Surpass rows and columns", account web, April 17, 2009
^ Hugo Jobling, "Apple iWork '09", Trustworthy Reviews, February 19, 2009, p. 3
^ Paul McFedries, "Copying and Moving Formulas", Building Basic Formulas in Excel, August 27, 2004
^ Simson Garfinkel, "Improv: The Inside Story", NEXTWORLD, Fall 1991, p. 34
^ Joel Spolsky, "The best software writing", Apress, 2005, p. 25
^ ^a ^b ^c "Formulas for everyone", Apple Inc.
^ "250+ Functions", Apple Inc.
^ "Excel functions (alphabetical tilt)" Archived Aug 30, 2011, at the Wayback Machine, Microsoft
^ ^a ^b ^c Rob Griffiths, "Review: Numbers '09", Macworld.com, January 27, 2009
^ "What's newfound in Numbers for Mac". Apple Support . Retrieved October 9, 2018.
^ "Use smart categories in Numbers".
^ "What's young in Numbers for Mac".
^ "Sensible tables", Apple Iraqi National Congress.
^ "iWork '08 Brushup: NUMBERS—Spreadsheet Layout App", Two A Daytime, August 23, 2007
^ Phil Windley, "A First Look at Apple's Numbers spreadsheet", ZDNet, August 9, 2007
^ Rob Griffiths, "Apple Numbers '08 spreadsheet software", PC Advisor, August 21, 2007
^ Tiffany Maleshefski, "Apple iWork 08 Provides Elementary Simply Solid Spreadsheet App", eWeek, August 17, 2007
^ Jason Parker, "Numbers for iPhone", cnet, Crataegus laevigata 31, 2011
^ "What has been gained in Numbers 3.0". Apple support profession. October 31, 2013.
^ "What has been lost in Numbers 3.0". Apple plump for community. October 31, 2013.
^ "What's freshly in Numbers pool for Mac". Apple Support Pages. May 4, 2018.
^ Fleishman, Glenn (April 11, 2018). "Numbers 5 for Mackintosh review articl: Inching closer to organism a much full-conspicuous spreadsheet app". MacWorld.