Microsoft Excel 2010 Basics Vocabulary

Microsoft Excel 2010 Basics Vocabulary

You start Excel from the Start menu in Windows. Click the Start button, click All Programs, click Microsoft Office, and then click Microsoft Excel 2010. The Excel program window has the same basic parts as all Office programs: the title bar, the Quick Access Toolbar, the Ribbon, Backstage view, and the status bar. PROFITT Curriculum Module # 5 – Introduction to Excel 2010 Basic Computer Skills Module 5-1 Basic Computer Skills Module 5 Introduction to Microsoft Excel 2010 Summary Goals: Identify spreadsheet terms. Create and manipulate Delivery Methodworksheets and workbooks. Enter formulas and functions into a worksheet. Format cells within worksheets. Formula tutorial Download template  Make your first PivotTable Download template  Get more out of PivotTables Download template  Other versions. Excel 2013 training. LinkedIn Learning Excel training. Excel templates. Office templates. Microsoft Store. Account profile; Download Center. Microsoft Excel 2010 is one of the most popular software applications worldwide and is part of the Microsoft Office 2010 productivity suite. This course will help you switch to Excel 2010 from a previous version of the software, and will give you a thorough knowledge and understanding of Excel and its applications if you have never used it before. Start studying Career Prep - Microsoft Excel 2010 Basics. Learn vocabulary, terms, and more with flashcards, games, and other study tools.
Microsoft Excel Basics Pdf
Microsoft Excel 2010 Basics Vocabulary Examples
Lesson 7: Worksheet Basics
/en/excel2010/creating-simple-formulas/content/
IntroductionEvery Excel workbook contains at least one or more worksheets. If you are working with a large amount of related data, you can use worksheets to help organize your data and make it easier to work with.
Microsoft Excel Basics PdfIn this lesson, you will learn how to name and add color to worksheet tabs, as well as how to add, delete, copy, and move worksheets. Additionally, you will learn how to group and ungroup worksheets and freeze columns and rows in worksheets so they remain visible even when you're scrolling.
Introduction to worksheetsWhen you open an Excel workbook, there are three worksheets by default. The default names on the worksheet tabs are Sheet1, Sheet2, and Sheet3. To organize your workbook and make it easier to navigate, you can rename and even color code the worksheet tabs. Additionally, you can insert, delete, move, and copy worksheets.
Optional: You can download this example for extra practice.
To rename worksheets:Right-click the worksheet tab you want to rename. The worksheet menu appears.
Select Rename.Selecting the Rename command
The text is now highlighted by a black box. Type the name of your worksheet.
Click anywhere outside the tab. The worksheet is renamed.Renamed worksheet
To insert new worksheets:Click the Insert Worksheet icon. A new worksheet will appear.
You can change the setting for the default number of worksheets that appear in Excel workbooks. To access this setting, go into Backstage view and click Options.
To delete worksheets:Worksheets can be deleted from a workbook, including those containing data.
Select the worksheets you want to delete.
Right-click one of the selected worksheets. The worksheet menu appears.
Select Delete. The selected worksheets will be deleted from your workbook.Deleting a worksheet
To copy a worksheet:Right-click the worksheet you want to copy. The worksheet menu appears.
Select Move or Copy.
The Move or Copy dialog box appears. Check the Create a copy box.Checking the Create a copy box
Click OK. Your worksheet is copied. It will have the same title as your original worksheet, but the title will include a version number, such as January (2).
To move a worksheet:Click the worksheet you want to move. The mouse will change to show a small worksheet icon .
Drag the worksheet icon until a small black arrow appears where you want the worksheet to be moved.Moving a worksheet
Release your mouse, and the worksheet will be moved.
To color code worksheet tabs:You can color worksheet tabs to help organize your worksheets and make your workbook easier to navigate.
Right-click the worksheet tab you want to color. The worksheet menu appears.
Select Tab Color. The color menu appears.
Select the color you want to change your tab.Changing the worksheet tab color
The tab color will change in the workbook. If your tab still appears white, it is because the worksheet is still selected. Select any other worksheet tab to see the color change.
Switching between worksheetsIf you want to view a different worksheet, you can simply click the tab to switch to that worksheet. However, with larger workbooks this can sometimes become tedious, as it may require scrolling through all of the tabs to find the one you want. Instead, you can simply right-click the scroll arrows in the lower-left corner, as shown below.
A dialog box will appear with a list of all of the sheets in your workbook. You can then double-click the sheet you want to jump to.
Watch the video below to see this shortcut in action.
Grouping and ungrouping worksheetsYou can work with each worksheet in a workbook individually, or you can work with multiple worksheets at the same time. Worksheets can be combined into a group. Smartglass xbox one not connecting. Any changes made to one worksheet in a group will be made to every worksheet in the group.
To group worksheets:Select the first worksheet you want in the group.Selecting the first worksheet to group
Press and hold the Ctrl key on your keyboard.
Select the next worksheet you want in the group. Continue to select worksheets until all of the worksheets you want to group are selected.
Release the Ctrl key. The worksheets are now grouped. The worksheet tabs appear white for grouped worksheets.
While worksheets are grouped, you can navigate to any worksheet in the group and make changes that will appear on every worksheet in the group. If you click a worksheet tab that's not in the group, however, all of your worksheets will become ungrouped. You will have to group them again.
To ungroup all worksheets:Right-click one of the worksheets. The worksheet menu appears.
Select Ungroup. The worksheets will be ungrouped.
Freezing worksheet panes

The ability to freeze specific rows or columns in your worksheet can be a useful feature in Excel. It is called freezing panes. When you freeze panes, you select rows or columns that will remain visible all the time, even as you are scrolling. This is particularly helpful when working with large spreadsheets.
To freeze rows:Select the row below the rows you want frozen. For example, if you want rows 1 and 2 to always appear at the top of the worksheet even as you scroll, then select row 3.
Click the View tab.
Click the Freeze Panes command. A drop-down menu appears.
Select Freeze Panes.Selecting the Freeze Panes command from the View tab
A black line appears below the rows that are frozen in place. Scroll down in the worksheet to see the rows below the frozen rows.
To freeze columns:Select the column to the right of the columns you want frozen. For example, if you want columns A and B to always appear to the left of the worksheet even as you scroll, select column C.Selecting column C
Click the View tab.
Click the Freeze Panes command. A drop-down menu appears.
Select Freeze Panes.Selecting the Freeze Panes command from the View tab
A black line appears to the right of the frozen area. Scroll across the worksheet to see the columns to the right of the frozen columns.
To unfreeze panes:

The ability to freeze specific rows or columns in your worksheet can be a useful feature in Excel. It is called freezing panes. When you freeze panes, you select rows or columns that will remain visible all the time, even as you are scrolling. This is particularly helpful when working with large spreadsheets.
To freeze rows:Select the row below the rows you want frozen. For example, if you want rows 1 and 2 to always appear at the top of the worksheet even as you scroll, then select row 3.
Click the View tab.
Click the Freeze Panes command. A drop-down menu appears.
Select Freeze Panes.Selecting the Freeze Panes command from the View tab
A black line appears below the rows that are frozen in place. Scroll down in the worksheet to see the rows below the frozen rows.
To freeze columns:Select the column to the right of the columns you want frozen. For example, if you want columns A and B to always appear to the left of the worksheet even as you scroll, select column C.Selecting column C
Click the View tab.
Click the Freeze Panes command. A drop-down menu appears.
Select Freeze Panes.Selecting the Freeze Panes command from the View tab
A black line appears to the right of the frozen area. Scroll across the worksheet to see the columns to the right of the frozen columns.
To unfreeze panes:Click the View tab.
Click the Freeze Panes command. A drop-down menu appears.
Select Unfreeze Panes. The panes will be unfrozen, and the black line will disappear.Selecting the Unfreeze Panes command from the View tab
Challenge!Open an existing Excel 2010 workbook. If you want, you can use this example.
Insert a new worksheet.
Change the name of a worksheet.
Delete a worksheet.
Move a worksheet.
Copy a worksheet.
Try grouping and ungrouping worksheets.
Try freezing and unfreezing columns and rows.
/en/excel2010/printing/content/

Topics Map > Frequently Asked Questions > Features
Topics Map > Migration > End User
Topics Map > Migration > Support Staff
Account ConsolidationThe process of combining multiple accounts into a single account during the transition to Office 365.Administrative ContactAn organization's administrative point of contact, responsible for assigning staff time to the Office 365 transition. Communicates with the Office 365 Team and their organization's leadership.ActiveSync ProtocolA service -- similar to Exchange, IMAP, and POP3 -- that sends email and calendar information from an Office 365 account to mobile devices.Alternate AddressIn Office 365, any email address associated with your account that is not your primary address.AutodiscoverExchange Autodiscover is a web service that helps Microsoft Exchange administrators configure user profile settings for clients running Outlook and mobile phones running Windows Mobile 6.1 or later.Automatic ReplyAlso known as a vacation message or an out of office message. Automatic reply is a rule that can be set in your Office 365 account that will automatically reply to incoming emails with a preset response for a preset amount of time.CategoriesIs a feature in Outlook and Outlook on the web that allows you to assign a keyword or phrase (and color) to help you keep track of items/events. Using this feature you can easily find, sort, filter, or group different items/events that are located across your different folders/calendars.Cloud ServiceServices made available to users on demand via the Internet from a cloud computing provider's servers as opposed to being provided from a company's own on-premises servers. Cloud services are designed to provide easy, scalable access to applications, resources and services, and are fully managed by a cloud services provider.Collaboration SpaceCollaboration Space is a type of notebook in Office 365's Class Notebook app. It is a notebook for all students and the teacher in the class to share, organize, and collaborate.ContactContacts are like electronic cards that store a person's information. A contact can be as basic as a name and email address, or include more information like a street address, multiple phone numbers, and a photo. 
Contact groupA contact group -- formerly called 'distribution list' -- is a group of contacts that you can send messages, meeting requests and tasks requests.Contact Group/ListA contact group/list is a personal group which is stored in your Contacts folder and can contain entries from your personal Contacts and from the Global Address List (GAL).Content LibraryA Content Library is a type of notebook in Office 365's Class Notebook app. It is a notebook for teachers to share course materials with students. Teachers can add and edit its materials, but for students, the notebook is read-only.
DelegateSomeone granted permission to interact with another person's Office 365 account (email, calendar, address book, etc). This can include reading, writing, modifying, and deleting items.DomainIn email addresses, the domain is the part of an email address comes after the @ symbol. For example, for the email address of 'bbadger@wisc.edu', the domain is 'wisc.edu'.Email AddressAn email address identifies the account that messages should be delivered (e.g., bbadger@wisc.edu). An account can have multiple email addresses. Each account in Office 365 has only one primary address, but an account can have multiple alternate addresses. An account will accept email for any email address on the account. Exchange ProtocolA service -- similar to IMAP, POP3, and ActiveSync -- that works to transfer and synchronize email/calendar information between the server and the end user's client.Free/BusyFree/busy is a determination of whether there is a calendar event in a given time slot. Free designates time slots without events and busy designates time slots that are taken up in a person's calendar. Any account within Office 365 will have the ability to view free/busy information against any other Office 365 account.Full Mailbox PermissionsIn Office 365, this permission allows a delegate to sign in to the user's mailbox and view the contents of the mailbox. However, after this permission is assigned to a delegate, the delegate can't send messages from the mailbox. To allow a delegate to send email from the user's mailbox, you still have to assign the delegate the Send As or the Send on Behalf Of permission. In addition, the delegate will have the ability to create/edit calendar/contacts. For information on how to manage full mailbox permissions for an account, click here.Global Address List (GAL)The Global Address List (GAL) is the address look up feature in Office 365. It contains email addresses for individuals and resources, excluding those that are hidden. Office 365 uses the Global Address List to supply email addresses when you are composing a message or inviting individuals to meetings.GroupA group is a shared workspace for email, conversations, files, and calendar events where group members can conveniently collaborate and quickly get stuff done. 
HyperlinkHighlighted text or picture in a data file or Web page that you can click on with a computer mouse to go to another place in the same or a different document or Web page.IMAP ProtocolInternet Message Access Protocol is a protocol for e-mail retrieval and storage (IMAP).Linked AccountsA 'linked' account is an account that your NetID has been provided access to. For example, after entering your NetID login credentials at the NetID login screen, you will have the option of logging into your primary mailbox or any other mailboxes (accounts) that have been linked to your NetID. A NetID can be 'linked' to any number of other accounts, simplifying the login process for users and providing much needed affiliation between accounts. Linked access to an account also provides other privileges such as consolidating. Instructions for linking an Office 365 service account to your NetID are available here.Migration PartnerAn organization's technical point of contact during their transition to Office 365. Completes and monitors the technical requirements of the transition. To find your organization's Migration Partner, click here. Office 365 (Email and Calendaring System)
Office 365 is a cloud-based service provided by Microsoft. Currently, UW-Madison's implementation includes email, calendar, contacts, tasks, and more collaboration apps. 
Office 365 AccountThe location in the Office 365 system where your email, calendar, task list, and address book are stored. Each Office 365 account has one primary address, but can have many alternate addresses.Office 365 Transition WebsiteLocated at 365transition.wisc.edu, the Office 365 Transition Website is the first stop for those who are interested to know more about the transition. It provides general info on everything from the project history and the business case to the Office 365 Team roster and announcements to campus.Office OnlineOffice Online (previously Office Web Apps) is an online office suite offered by Microsoft, which allows users to create and edit files using lightweight, web browser-based versions of Microsoft Office applications: Word, Excel, PowerPoint and OneNote. The offering also includes Outlook, People, Calendar and OneDrive for Business, all of which are accessible from a unified app switcher (Outlook on the web).Offline Data File (OST)Typically, when you use a Microsoft Exchange Server account (Office 365 account), your email messages, calendar, and other items are delivered to and saved on the server. You can configure Outlook to keep a local copy of your items on your computer in an Outlook data file that is named an offline Outlook Data File (.ost). This allows you to use Cached Exchange Mode or to work offline when a connection to the Office 365 (Exchange) computer may not be possible or wanted. The .ost file is synchronized with the Office 365 (Exchange) computer when a connection is available.OneDrive for BusinessOneDrive for Business (previously SkyDrive, Windows Live SkyDrive and Windows Live Folders) is a file hosting service that allows users to upload and sync files to a cloud storage and then access them from a Web browser or their local device.OneNoteOneDrive for Business -- previously SkyDrive, Windows Live SkyDrive and Windows Live Folders -- is Office 365's file hosting service. It allows users to uplaod and sync files to a cloud storage and then access them from a web browser or their local device. 
Organizational Readiness WebsiteAn online tool used to assess and track an organization's transition progress. It includes the Dashboard, Readiness Checklist, and Census.Outlook for WindowsMicrosoft Outlook is an e-mail client and personal information manager (PIM) that's available as part of Microsoft's Office suite. It is part of the Office suite for Windows and can be used to view email, calendar, contacts, and more.Outlook 2016 for MacMicrosoft Outlook 2016 for Mac is an e-mail client and personal information manager (PIM) that's available as part of Microsoft's Office suite. It is the latest version of Outlook for the Mac OS and can be used to view email, calendar, contacts, and more.Outlook Data File (PST)A Personal Folders file (.pst) is an Outlook data file that stores your messages and other items on your computer. This is the most common file in which information in Outlook is saved by home users or in small organizations. The most common types of accounts are referred to by their Internet protocol names -- POP3 and IMAP. Another type of account is an HTTP or web-based account that works similar to IMAP email accounts. All three account types use a .pst file.Outlook ProfileA profile is what Outlook uses to remember the e-mail accounts and the settings that tell Outlook where your e-mail is stored.Outlook on the webMicrosoft's service for accessing your Office 365 account via web browser.PermissionsIn Office 365, permissions can enable an individual to access another individual's mail, calendars, and contacts. For example, if User A wanted the ability to modify events in User B's calendar, User B would need to assign read/write/modify permissions to User A.POP3/POP Post Office Protocol (POP) is an application-layer Internet standard protocol used by local e-mail clients to retrieve e-mail from a remote server over a TCP/IP connection.Primary AddressIn Office 365, your primary address is the email address associated with your Office 365 account that will appear as your 'From' address on emails and calendar invites. It will also appear as a result in the address look up feature in Office 365. For further information, click here.Resource accountIn Office 365, a resource account is a non-person account that can be classified as either 'room' or 'equipment'. Examples can include meeting/conference rooms, audio-visual equipment, or vacation calendars. Individuals must be granted permissions to interact with a resource account.RulesA feature in Office 365 which allows you to take some action when a message arrives into your account or when you are sending a message. Examples of potential actions include move/copy/delete, mark with a category/read/importance, or forward/redirect.Send AsIn Office 365, this permission allows users other than the mailbox owner to use the mailbox to send messages. After this permission is assigned to a delegate, any message that a delegate sends from this mailbox will appear as if it was sent by the mailbox owner. However, this permission doesn't allow a delegate to sign in to the user's mailbox.Send on BehalfIn Office 365, this permission allows a delegate to use this mailbox to send messages. However, after this permission is assigned to a delegate, the From address in any message sent by the delegate indicates that the message was sent by the delegate on behalf of the mailbox owner.Service AccountOffice 365 accounts that are intended to be used for shared/changing roles (info, secretary, webmaster, newsletter, feedback, etc.) or service/programmatic access (printers, copiers, mailers). These accounts can be accessed via a linked NetID or by using the service account's direct username/password. More information about the types of accounts available in Office 365 can be found hereSharePointSharePoint is a web application framework and platform which integrates intranet, content management, and document management. You can use it as a secure place to store, organize, share, and access information from almost any device. SharePoint is currently not available within UW-Madison's implementation of Office 365.Sub-DomainA sub-domain is a domain that is part of a larger domain; the only domain that is not also a sub-domain is the root domain. For example, doit.wisc.edu and engr.wisc.edu are sub-domains of the wisc.edu domain.Wisc Account Administration siteA web site that allows administrators and end users to manage accounts (NetID and departmental) that access Office 365, and Google Apps.

Microsoft Excel 2010 Basics Vocabulary ExamplesKeywords:Office 365 - Glossary of TermsSuggest keywordsDoc ID:34729
Owner:O365 S.Group:Office 365
Created:2013-10-24 10:10 CSTUpdated:2020-09-09 14:14 CST
Sites:DoIT Help Desk, DoIT Tech Store, Google Apps, Office 365, Wisc Account Admin
Feedback:55CommentSuggest a new document

Keywords:	Office 365 - Glossary of TermsSuggest keywords	Doc ID:	34729
Owner:	O365 S.	Group:	Office 365
Created:	2013-10-24 10:10 CST	Updated:	2020-09-09 14:14 CST
Sites:	DoIT Help Desk, DoIT Tech Store, Google Apps, Office 365, Wisc Account Admin
Feedback:	55CommentSuggest a new document