Home > Articles > Home & Office Computing > Other Applications

This chapter is from the book

Entering Information

Now that you know how to navigate, you’re ready to start entering information into a notebook. The basic process involves selecting the cell into which you want to enter information and then typing.

Entering Text and Numbers

Entering text into a spreadsheet is a straightforward matter. Select the cell in which you want the text to appear and start typing. As you type, whatever you type appears in two places in the spreadsheet: the cell into which you are entering text and the Input Line (see Figure 3.4).

Figure 3.4

Figure 3.4 As you type text, Quattro Pro displays the text both in the cell and in the Input Line.

A vertical insertion point in the cell marks the location where letters or numbers appear as you type; you won’t see any indicator in the Input Line.

You store the information you typed in the cell by pressing the Enter key on the keyboard or by using the mouse to click the check mark at the left edge of the Input Line. If you change your mind as you enter the information, you can press the Escape key (Esc) on your keyboard or you can click the X at the left edge of the Input Line, and Quattro Pro won’t store any of the information you typed in the cell.

You enter numbers the same way that you enter text: Select the cell where you want the number to appear, type the number, and press Enter or click the check mark at the left edge of the Input Line.

Suppose that you type "Quarter One Sales" in cell A2 and then type a dollar amount—$25,000—in cell A3. A portion of the Quarter One Sales will seem to disappear (see Figure 3.5). In reality, the information is still stored in cell A2; look at the Input Line. The width of Column A isn’t large enough to accommodate the entry you made. In Chapter 8, "Formatting Notebooks," I’ll tell you how to widen the column.

Entering Formulas

Formulas are combinations of numbers that include a mathematical operator. In Quattro Pro, a formula can include numbers, cell addresses, or both. In this section, I focus on the basics of using numbers in formulas; in Chapter 10, "Working with Calculations," you’ll find a more in-depth exploration of using formulas that contain numbers, formulas that contain cell addresses, and using functions as well as formulas.

Figure 3.5

Figure 3.5 Although text seems to disappear when a column width isn’t long enough to accommodate it, you can see the text in the Input Line.

You use the symbols shown in Table 3.2 to represent the appropriate mathematical operator when you create a formula.

Table 3.2 Mathematical Operators

Symbol

Purpose

+

Addition

Subtraction

*

Multiplication

/

Division

Quattro Pro helps you identify cells containing formulas by marking them with a blue triangle in the bottom-left corner of the cell. You may have trouble seeing the blue triangle until you move the cell selector out of the cell containing the formula (see Figure 3.6).

When you record a formula in a cell, Quattro Pro does math the same way you learned in high school: Quattro Pro performs multiplication and division before performing addition and subtraction. In high school math, you used parentheses to group numbers together; the rule is that you perform the calculations inside the parentheses before you perform the calculations outside the parentheses.

Quattro Pro works the same way. In Figure 3.5, you saw two cells containing formulas; in fact, both cells contain the same formula, but I used parentheses in cell C5 to change the order of calculation. In Figure 3.7, I’ve displayed the formulas I used so that you can see how I grouped the portion of the formula using addition and subtraction to force Quattro Pro to perform that calculation before any other.

Filling a Range

Suppose that you need to enter sales numbers for two products—widgets and gadgets—for each month of the year. You know that your column headings will be Widgets and Gadgets and your row headings will be the months January through December. Although you could just type all that information into your spreadsheet, you could save some time by using the QuickFill feature in Quattro Pro to automatically enter month names into the range that will store the names of the months. You can fill any range using lists of common entries such as months or weekdays. You can even create your own lists.

Figure 3.6

Figure 3.6 Quattro Pro marks cells containing formulas with a small blue triangle in the lower-left corner of the cell.

Figure 3.7

Figure 3.7 Quattro Pro performs calculations in a cell using the same rules you used in high school math.

Select the range of cells that you want to fill with month names; in Figure 3.8, I selected A2.A13. Quattro Pro will fill all the cells you select so, in this example, if you select more than 12 cells, Quattro Pro will start over with January when it reaches the 13th cell.

Then, open the Edit menu, point to the Fill command, and click QuickFill. Quattro Pro displays the QuickFill dialog box shown in Figure 3.9.

Open the Series Name list box and select the type of information you want Quattro Pro to fill into the selected cells. Table 3.3 shows you the predefined lists available in Quattro Pro.

Figure 3.8

Figure 3.8 Select the cells that you want Quattro Pro to fill.

Figure 3.9

Figure 3.9 Use this dialog box to identify the information you want Quattro Pro to enter into the selected cells.

Table 3.3 Predefined Fill Lists Available in Quattro Pro

Series Name

Information Quattro Pro Fills in the Range

Months

Complete month names, such as January, February, March, and so on

MonthsShort

Abbreviated month names, such as Jan, Feb, Mar, and so on

Quarter1

Quarters in the format Q1, Q2, and so on

Quarter2

Quarters in the format Q.1, Q.2, and so on

Quarter3

Quarters in the format Qtr1, Qtr2, and so on

Quarter4

Quarters in the format Qtr.1, Qtr.2, and so on

Quarter5

Complete quarter names, such as Quarter1, Quarter2, and so on

WeekDays

Complete weekday names, such as Sunday, Monday, and so on

WeekDaysShort

Abbreviated weekday names, such as Sun, Mon, and so on

Click OK, and Quattro Pro fills the information into the selected range (see Figure 3.10).

As a shortcut, you can bypass displaying the QuickFill dialog box if you type the first entry of a list into a cell and then select the range you want to fill, as I’ve done in Figure 3.11.

Figure 3.10

Figure 3.10 Quattro Pro fills the type of information you chose into the selected range of cells.

Figure 3.11

Figure 3.11 To avoid displaying the QuickFill dialog box, type the first entry of a list into a cell and then select the range you want to fill.

When you open the Edit menu, point to Fill, and click QuickFill (or press Ctrl+Shift+L, the shortcut key combination for QuickFill), Quattro Pro simply fills the range with the information associated with the fill series containing the entry you typed.

There’s a hidden advantage to this approach: Quattro Pro is smart enough to fill the selected series starting with the entry you provide as opposed to the first entry displayed when you view the list in the QuickFill dialog box. When Quattro Pro fills the selected cells in Figure 3.10, the months February through December, in order, will appear. Notice that I selected only 11 cells, not 12; had I selected 12 cells, the last cell in the list would contain the entry January.

InformIT Promotional Mailings & Special Offers

I would like to receive exclusive offers and hear about products from InformIT and its family of brands. I can unsubscribe at any time.

Overview


Pearson Education, Inc., 221 River Street, Hoboken, New Jersey 07030, (Pearson) presents this site to provide information about products and services that can be purchased through this site.

This privacy notice provides an overview of our commitment to privacy and describes how we collect, protect, use and share personal information collected through this site. Please note that other Pearson websites and online products and services have their own separate privacy policies.

Collection and Use of Information


To conduct business and deliver products and services, Pearson collects and uses personal information in several ways in connection with this site, including:

Questions and Inquiries

For inquiries and questions, we collect the inquiry or question, together with name, contact details (email address, phone number and mailing address) and any other additional information voluntarily submitted to us through a Contact Us form or an email. We use this information to address the inquiry and respond to the question.

Online Store

For orders and purchases placed through our online store on this site, we collect order details, name, institution name and address (if applicable), email address, phone number, shipping and billing addresses, credit/debit card information, shipping options and any instructions. We use this information to complete transactions, fulfill orders, communicate with individuals placing orders or visiting the online store, and for related purposes.

Surveys

Pearson may offer opportunities to provide feedback or participate in surveys, including surveys evaluating Pearson products, services or sites. Participation is voluntary. Pearson collects information requested in the survey questions and uses the information to evaluate, support, maintain and improve products, services or sites, develop new products and services, conduct educational research and for other purposes specified in the survey.

Contests and Drawings

Occasionally, we may sponsor a contest or drawing. Participation is optional. Pearson collects name, contact information and other information specified on the entry form for the contest or drawing to conduct the contest or drawing. Pearson may collect additional personal information from the winners of a contest or drawing in order to award the prize and for tax reporting purposes, as required by law.

Newsletters

If you have elected to receive email newsletters or promotional mailings and special offers but want to unsubscribe, simply email information@informit.com.

Service Announcements

On rare occasions it is necessary to send out a strictly service related announcement. For instance, if our service is temporarily suspended for maintenance we might send users an email. Generally, users may not opt-out of these communications, though they can deactivate their account information. However, these communications are not promotional in nature.

Customer Service

We communicate with users on a regular basis to provide requested services and in regard to issues relating to their account we reply via email or phone in accordance with the users' wishes when a user submits their information through our Contact Us form.

Other Collection and Use of Information


Application and System Logs

Pearson automatically collects log data to help ensure the delivery, availability and security of this site. Log data may include technical information about how a user or visitor connected to this site, such as browser type, type of computer/device, operating system, internet service provider and IP address. We use this information for support purposes and to monitor the health of the site, identify problems, improve service, detect unauthorized access and fraudulent activity, prevent and respond to security incidents and appropriately scale computing resources.

Web Analytics

Pearson may use third party web trend analytical services, including Google Analytics, to collect visitor information, such as IP addresses, browser types, referring pages, pages visited and time spent on a particular site. While these analytical services collect and report information on an anonymous basis, they may use cookies to gather web trend information. The information gathered may enable Pearson (but not the third party web trend services) to link information with application and system log data. Pearson uses this information for system administration and to identify problems, improve service, detect unauthorized access and fraudulent activity, prevent and respond to security incidents, appropriately scale computing resources and otherwise support and deliver this site and its services.

Cookies and Related Technologies

This site uses cookies and similar technologies to personalize content, measure traffic patterns, control security, track use and access of information on this site, and provide interest-based messages and advertising. Users can manage and block the use of cookies through their browser. Disabling or blocking certain cookies may limit the functionality of this site.

Do Not Track

This site currently does not respond to Do Not Track signals.

Security


Pearson uses appropriate physical, administrative and technical security measures to protect personal information from unauthorized access, use and disclosure.

Children


This site is not directed to children under the age of 13.

Marketing


Pearson may send or direct marketing communications to users, provided that

  • Pearson will not use personal information collected or processed as a K-12 school service provider for the purpose of directed or targeted advertising.
  • Such marketing is consistent with applicable law and Pearson's legal obligations.
  • Pearson will not knowingly direct or send marketing communications to an individual who has expressed a preference not to receive marketing.
  • Where required by applicable law, express or implied consent to marketing exists and has not been withdrawn.

Pearson may provide personal information to a third party service provider on a restricted basis to provide marketing solely on behalf of Pearson or an affiliate or customer for whom Pearson is a service provider. Marketing preferences may be changed at any time.

Correcting/Updating Personal Information


If a user's personally identifiable information changes (such as your postal address or email address), we provide a way to correct or update that user's personal data provided to us. This can be done on the Account page. If a user no longer desires our service and desires to delete his or her account, please contact us at customer-service@informit.com and we will process the deletion of a user's account.

Choice/Opt-out


Users can always make an informed choice as to whether they should proceed with certain services offered by InformIT. If you choose to remove yourself from our mailing list(s) simply visit the following page and uncheck any communication you no longer want to receive: www.informit.com/u.aspx.

Sale of Personal Information


Pearson does not rent or sell personal information in exchange for any payment of money.

While Pearson does not sell personal information, as defined in Nevada law, Nevada residents may email a request for no sale of their personal information to NevadaDesignatedRequest@pearson.com.

Supplemental Privacy Statement for California Residents


California residents should read our Supplemental privacy statement for California residents in conjunction with this Privacy Notice. The Supplemental privacy statement for California residents explains Pearson's commitment to comply with California law and applies to personal information of California residents collected in connection with this site and the Services.

Sharing and Disclosure


Pearson may disclose personal information, as follows:

  • As required by law.
  • With the consent of the individual (or their parent, if the individual is a minor)
  • In response to a subpoena, court order or legal process, to the extent permitted or required by law
  • To protect the security and safety of individuals, data, assets and systems, consistent with applicable law
  • In connection the sale, joint venture or other transfer of some or all of its company or assets, subject to the provisions of this Privacy Notice
  • To investigate or address actual or suspected fraud or other illegal activities
  • To exercise its legal rights, including enforcement of the Terms of Use for this site or another contract
  • To affiliated Pearson companies and other companies and organizations who perform work for Pearson and are obligated to protect the privacy of personal information consistent with this Privacy Notice
  • To a school, organization, company or government agency, where Pearson collects or processes the personal information in a school setting or on behalf of such organization, company or government agency.

Links


This web site contains links to other sites. Please be aware that we are not responsible for the privacy practices of such other sites. We encourage our users to be aware when they leave our site and to read the privacy statements of each and every web site that collects Personal Information. This privacy statement applies solely to information collected by this web site.

Requests and Contact


Please contact us about this Privacy Notice or if you have any requests or questions relating to the privacy of your personal information.

Changes to this Privacy Notice


We may revise this Privacy Notice through an updated posting. We will identify the effective date of the revision in the posting. Often, updates are made to provide greater clarity or to comply with changes in regulatory requirements. If the updates involve material changes to the collection, protection, use or disclosure of Personal Information, Pearson will provide notice of the change through a conspicuous notice on this site or other appropriate way. Continued use of the site after the effective date of a posted revision evidences acceptance. Please contact us if you have questions or concerns about the Privacy Notice or any objection to any revisions.

Last Update: November 17, 2020