Unit 1

Question 1

What is Excel

Answer 1

A means to an end

Question 2

Excel is a _________ spreadsheet program that is part of ___________ __________ _________.

Use Excel to ________, ________ & ________ data.

Answer 2

Electronic, Microsoft Office Suite

Organize, calculate & analyze

Question 3

Excel tasks range from a simple ________ to creating elaborate __-__ ________ to managing an ________ ________ for a company.

Worksheets consist of ________ & ________ that ________ to form a ________.

Answer 3

Invoice, 3-D chart, accounting ledger

Rows, columns, intersect, cells

Question 4

Cells contain ________ that you can ________, ________ & ________.

Excel file is called a ________, which by ________ contains __ _______ ________.

Answer 4

Data, format, sort & analyze

Workbook, default, 3, blank, worksheets

Question 5

All spreadsheets have common elements/components:
1.
2.
3.
4.
5.

Answer 5

Row, column, cell, label, value

Question 6

What are Excel row?

How many rows are in an Excel worksheet?

How is a row identified?

Answer 6

Horizontal group of cells in a w/s

More than 1 million

Number

Question 7

What is a column?

How many columns available in an Excel w/s?

Each column is identified by one or more ________.

Answer 7

Vertical group of cells in a w/s

16,000

Letters

Question 8

A cell is an ________ of a ________ and a ________.

Cell is identified by it’s ________ ________and then it’s ________ ________.

Answer 8

Intersection, row, column

Column letter, row #

Question 9

A Label is ________ that identifies ________ in the spreadsheet.

A Value is ________ ________ in a spreadsheet.

Answer 9

Text, information

Raw data

Question 10

An active cell is where the ________ ________ is located.

________ are used to perform calculations.

Answer 10

Insertion point

Formulas

Question 11

How to start Excel?

Answer 11

Click start, choose all programs, Microsoft office yyyy, Excel yyyy

Question 12

Components of Excel window?
1.
2.
3.
4.
5.
6.

Answer 12

Title bar, ribbon, quick access tool bar, formula bar, worksheet, status bar

Question 13

________ ________ displays the name of the workbook.

________ ____ is the default name of the ________ workbook you start with.

Answer 13

Title bar

Book one, 1st

Question 14

What is the main location for menus and tools?

Each ________ contains ________ of related commands or functions.

Answer 14

Ribbon

Ribbon, groups

Question 15

What displays commands for saving the current workbook?

________ ________ ________ is used to undue last ________ & ________ the last action.

Answer 15

Quick access tool bar

Quick access tool bar, action, repeating

Question 16

You can customize the ________ ________ ________ by adding ________ for commands you use _________.

QATB can be moved ________ the ________.

Answer 16

QATB, buttons, frequency

Below, ribbon

Question 17

________ ________ displays the contents of the ________ ________.
Such as: ________, ________ or ________.

Use the ________ ________ to edit the contents of the ________ ________.

Answer 17

Formula bar, active cell
Values, text & formulas

Formula bar, active cell

Question 18

_________ displays ________ & ________ of cells.

________ ________ displays workbook current ________.
Also displays info about ________ ________ or an ________ in progress.

Answer 18

Worksheet, rows, columns

Status bar, status
Selected command, operation

Question 19

Status bar displays tools you can use to switch the ________ of the ________.

Also you can ________ in and out on the document & switch to other ________.

Answer 19

View, document

Zoom, documents

Question 20

Interact with Excel by ________ and by using the mouse to choose ________, make ________, & click ________ & ________.

Answer 20

Typing, commands, selections, buttons, options

Question 21

The ________ is the main location for menus & tools.

When you click a ribbon tab, the ribbon displays ________ ________ of ________ tools.

Answer 21

Ribbon

Separate groups, related

Question 22

Some tools are buttons you click to take ________ ________, while others expand to display ________, ________ or ________ with more options.

Answer 22

Immediate action, menus, lists, galleries

Question 23

A ________ is a collections of ________ options that are represented ________ to provide a simple _________.

Answer 23

Gallery, graphically, preview

Question 24

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 ________, ________ & ________.

Answer 24

File, ribbon, backstage view, commonly, commands, new, open, print

Question 25

You can point to a ________ to display an ________ ________-________.

These provide ________ info about each ________.

Answer 25

Tool, enhanced, screen-tip

Quick, tool

Question 26

When workbook opens it defaults to the ________ tab.

Which contains the ________, ________, ________, ________, ________, ________ and ________ ________.

Answer 26

Home

Clipboard, font, alignment, number, styles, cells & editing groups

Question 27

Screen tips show the ________ name, it’s ________ ________ & a brief ________.

Answer 27

Commands, keyboard shortcut, description

Question 28

Address of active cell appears in ________ ________, left of the ________ ________.

Answer 28

Name box, formula bar

Question 29

Various worksheet navigation methods:
Click a _______ / press an ________ key / press ________ / press ________ + ________ / press ________ + ________ / press ________ + ________ / click ________ arrow / click in the ________ ________ / drag in the ________ ________ / drag ________ on ________ ________

Answer 29

Cell, arrow, tab, shift tab, ctrl home, ctrl end, scroll, scroll bar, scroll bar, scroll bar, slider zoom bar

Question 30

Clicking a cell ________ that cell.

Pressing an arrow key selects an ________ cell.

Answer 30

Selects

Adjacent

Question 31

Pressing tab selects one ________ to the ________.

Pressing ________ + ________ selects one ________ to the ________.

Answer 31

Column, right

Shift + tab, column, left

Question 32

Clicking the scroll arrow moves the view of worksheet ________ ________ or ________.

This ________ change the ________ cell.

Answer 32

One row or column

Doesn’t, active

Question 33

Drag in the scroll bar moves view of worksheet ________ & does not change ________ cell.

Drag ________ on ________ bar ________ in and out on current document.

Answer 33

Quickly, active

Slider, zoom, zoom

Question 34

Tools for quickly locating info you want?
1.
2.
3.

Answer 34

Find
Go to
Go to special

Question 35

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 ________.

Answer 35

Editing, home

Worksheet, workbook

Text, formulas, formats

Question 36

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.

Answer 36

Editing, home, find, select, find
Replace, find
Where, format
Next, instance,find all, list, navigate

Question 37

Use tool ____ ____ when you know the location of the data you want, but don’t want to ________.

Use ____ ____ ________ to jump to ________, ________, ____ ____, cells with special ________.

Answer 37

Go to, search

Go to special, comments, formulas, blank cells, criteria

Question 38

When you first open Excel you’ll see a ________ of ________.

can also see in “________ ________”

Answer 38

Gallery, templates, backstage view

Question 39

A template is a ________ with ________ settings on which you can base new ________.

Templates can contain: ________, ________ ________, ________, ________ & ________ (such as formulas).

Answer 39

Workbook, predetermined, workbooks

Labels, other data, formatting, styles, functionality

Question 40

The ________ workbook is a template.

Excel comes with ________ templates.

Answer 40

Blank

Preinstalled

Question 41

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.

Answer 41

Office.com, hundreds, education

Preview

Question 42

How to create a workbook from a template:

1. Click ________ tab & choose ________.
2. In ________, find and click report to open a ________ of the Template.
3. Click ________ to ________ a workbook from a template.

Answer 42

File, new
Gallery, preview
Create, create