Unit 1 Flashcards
What is Excel
A means to an end
Excel is a _________ spreadsheet program that is part of ___________ __________ _________.
Use Excel to ________, ________ & ________ data.
Electronic, Microsoft Office Suite
Organize, calculate & analyze
Excel tasks range from a simple ________ to creating elaborate __-__ ________ to managing an ________ ________ for a company.
Worksheets consist of ________ & ________ that ________ to form a ________.
Invoice, 3-D chart, accounting ledger
Rows, columns, intersect, cells
Cells contain ________ that you can ________, ________ & ________.
Excel file is called a ________, which by ________ contains __ _______ ________.
Data, format, sort & analyze
Workbook, default, 3, blank, worksheets
All spreadsheets have common elements/components: 1. 2. 3. 4. 5.
Row, column, cell, label, value
What are Excel row?
How many rows are in an Excel worksheet?
How is a row identified?
Horizontal group of cells in a w/s
More than 1 million
Number
What is a column?
How many columns available in an Excel w/s?
Each column is identified by one or more ________.
Vertical group of cells in a w/s
16,000
Letters
A cell is an ________ of a ________ and a ________.
Cell is identified by it’s ________ ________and then it’s ________ ________.
Intersection, row, column
Column letter, row #
A Label is ________ that identifies ________ in the spreadsheet.
A Value is ________ ________ in a spreadsheet.
Text, information
Raw data
An active cell is where the ________ ________ is located.
________ are used to perform calculations.
Insertion point
Formulas
How to start Excel?
Click start, choose all programs, Microsoft office yyyy, Excel yyyy
Components of Excel window? 1. 2. 3. 4. 5. 6.
Title bar, ribbon, quick access tool bar, formula bar, worksheet, status bar
________ ________ displays the name of the workbook.
________ ____ is the default name of the ________ workbook you start with.
Title bar
Book one, 1st
What is the main location for menus and tools?
Each ________ contains ________ of related commands or functions.
Ribbon
Ribbon, groups
What displays commands for saving the current workbook?
________ ________ ________ is used to undue last ________ & ________ the last action.
Quick access tool bar
Quick access tool bar, action, repeating
You can customize the ________ ________ ________ by adding ________ for commands you use _________.
QATB can be moved ________ the ________.
QATB, buttons, frequency
Below, ribbon
________ ________ displays the contents of the ________ ________.
Such as: ________, ________ or ________.
Use the ________ ________ to edit the contents of the ________ ________.
Formula bar, active cell
Values, text & formulas
Formula bar, active cell
_________ displays ________ & ________ of cells.
________ ________ displays workbook current ________.
Also displays info about ________ ________ or an ________ in progress.
Worksheet, rows, columns
Status bar, status
Selected command, operation
Status bar displays tools you can use to switch the ________ of the ________.
Also you can ________ in and out on the document & switch to other ________.
View, document
Zoom, documents
Interact with Excel by ________ and by using the mouse to choose ________, make ________, & click ________ & ________.
Typing, commands, selections, buttons, options
The ________ is the main location for menus & tools.
When you click a ribbon tab, the ribbon displays ________ ________ of ________ tools.
Ribbon
Separate groups, related
Some tools are buttons you click to take ________ ________, while others expand to display ________, ________ or ________ with more options.
Immediate action, menus, lists, galleries
A ________ is a collections of ________ options that are represented ________ to provide a simple _________.
Gallery, graphically, preview
The ________ tab works differently than the other tabs of the ________.
The file tab opens the “________ ________” which displays a menu of ________ used file management ________, such as ________, ________ & ________.
File, ribbon, backstage view, commonly, commands, new, open, print
You can point to a ________ to display an ________ ________-________.
These provide ________ info about each ________.
Tool, enhanced, screen-tip
Quick, tool
When workbook opens it defaults to the ________ tab.
Which contains the ________, ________, ________, ________, ________, ________ and ________ ________.
Home
Clipboard, font, alignment, number, styles, cells & editing groups
Screen tips show the ________ name, it’s ________ ________ & a brief ________.
Commands, keyboard shortcut, description
Address of active cell appears in ________ ________, left of the ________ ________.
Name box, formula bar
Various worksheet navigation methods:
Click a _______ / press an ________ key / press ________ / press ________ + ________ / press ________ + ________ / press ________ + ________ / click ________ arrow / click in the ________ ________ / drag in the ________ ________ / drag ________ on ________ ________
Cell, arrow, tab, shift tab, ctrl home, ctrl end, scroll, scroll bar, scroll bar, scroll bar, slider zoom bar
Clicking a cell ________ that cell.
Pressing an arrow key selects an ________ cell.
Selects
Adjacent
Pressing tab selects one ________ to the ________.
Pressing ________ + ________ selects one ________ to the ________.
Column, right
Shift + tab, column, left
Clicking the scroll arrow moves the view of worksheet ________ ________ or ________.
This ________ change the ________ cell.
One row or column
Doesn’t, active
Drag in the scroll bar moves view of worksheet ________ & does not change ________ cell.
Drag ________ on ________ bar ________ in and out on current document.
Quickly, active
Slider, zoom, zoom
Tools for quickly locating info you want?
1.
2.
3.
Find
Go to
Go to special
The find tool is located in the ________ group on the ________ tab.
You can search a single ________ or an entire ________.
You can look for ________, ________ or even a particular ________.
Editing, home
Worksheet, workbook
Text, formulas, formats
Process of find tool:
1. In ________ group of the ________ tab, click ________ + ________ icon & choose ________. 2. In find and ________ dialog box, verify the ________ is active. Type the search term you are looking for, you can also specify ________ to look, or a particular ________. 4. Click find ________ to find 1st ________ of the search item or format. Click ________ ________ to generate a ________ of all instances of search criteria. You can use this list to ________ to each instance of the found data.
Editing, home, find, select, find
Replace, find
Where, format
Next, instance,find all, list, navigate
Use tool ____ ____ when you know the location of the data you want, but don’t want to ________.
Use ____ ____ ________ to jump to ________, ________, ____ ____, cells with special ________.
Go to, search
Go to special, comments, formulas, blank cells, criteria
When you first open Excel you’ll see a ________ of ________.
can also see in “________ ________”
Gallery, templates, backstage view
A template is a ________ with ________ settings on which you can base new ________.
Templates can contain: ________, ________ ________, ________, ________ & ________ (such as formulas).
Workbook, predetermined, workbooks
Labels, other data, formatting, styles, functionality
The ________ workbook is a template.
Excel comes with ________ templates.
Blank
Preinstalled
If you have an internet connection, you have access to ________.____ from which you can download ________ more ________ for business, ________, and personal use.
You can ________ any template.
Office.com, hundreds, education
Preview
How to create a workbook from a template:
- Click ________ tab & choose ________.
- In ________, find and click report to open a ________ of the Template.
- Click ________ to ________ a workbook from a template.
File, new
Gallery, preview
Create, create
