Excel

Question 1

An electronic ____ is an application you use to perform numeric calculations and to analyze and present numeric data.

Answer 1

spreadsheet

Question 2

In Excel, the electronic spreadsheet you work in is called a ____.

Answer 2

worksheet

Question 3

In Excel, a worksheet is contained in a file called a ____.

Answer 3

workbook

Question 4

You can use predesigned, formatted files called ____ to create new worksheets quickly.

Answer 4

templates

Question 5

You can use a spreadsheet to complete all the task below EXCEPT ________________ .

Answer 5

create what-if data scenarios

Question 6

You can use ____ to move around in a document that is too large to fit on the screen at once.

Answer 6

scroll bars

Question 7

____ below the worksheet grid let you switch from sheet to sheet in a workbook.

Answer 7

sheet tabs

Question 8

All Excel formulas begin with the ____.

Answer 8

equal sign (=)

Question 9

The Excel operator for divide is ____.

Answer 9

/

Question 10

If cell A1 contained 10, cell A2 contained 2 and cell A3 contained =A1/A2, what would cell A3 show on the worksheet after it is worked out?

Answer 10

5

Question 11

Local applications are stored on your computer’s hard drive. (true or false)

Answer 11

True

Question 12

A common feature of an app is it shown in PDF. (true or false)

Answer 12

False

Question 13

PayPal is an example of a banking app.
(true or false)

Answer 13

True

Question 14

The operating system installed on PCs is Windows (true or false)

Answer 14

True

Question 15

For projects requiring repetitive calculations such as budgeting, maintaining a grade book, calculating loan payments and more, you should use a Word Processing software. (true or false)

Answer 15

False

Question 16

Worksheet

Answer 16

The electronic spreadsheet you work in is

Question 17

Name Box

Answer 17

This box displays the active cell address.

Question 18

Cell

Answer 18

The intersection of a column and a row

Question 19

Status Bar

Answer 19

This bar is located at the bottom of the Excel window.

Question 20

Cell Pointer

Answer 20

dark rectangular line outlines the cell you are working in

Question 21

Sheet tabs

Answer 21

This tab allows you to switch from sheet to sheet in a workbook.

Question 22

Scroll Bars

Answer 22

This button allows you to move around in a worksheet that is too large to fit on a screen at once.

Question 23

Formula Bar

Answer 23

allows you to enter or edit data in the worksheet

Question 24

Formula

Answer 24

An equation in a worksheet

Question 25

Labels

Answer 25

Entries that contains text and numerical information not used in calculations

Question 26

Values

Answer 26

Numbers, formulas, and functions that can be used in calculation

Question 27

Editing

Answer 27

To be able to make changes

Question 28

Mode Indicator

Answer 28

This button in the lower left corner of the status bar provides additional information about certain tasks.

Question 29

Active Cell

Answer 29

he highlighted cell that is being worked on in a spreadsheet

Question 30

Cell Adress

Answer 30

A cell unique location

Question 31

Function

Answer 31

A built- in formula

Question 32

Formula Prefix

Answer 32

Formulas in an Excel worksheet start with an equal sign

Question 33

Range

Answer 33

A selection of two or more cells

Question 34

Argument

Answer 34

Information necessary to calculate an answer

Question 35

Insertion Point

Answer 35

The blinking vertical line

Question 36

Orientation

Answer 36

Direction which contents of page will print

Question 37

Normal view

Answer 37

Default view in Excel

Question 38

Which feature could be used to print a very long worksheet on a single sheet of paper?

Answer 38

scale to fit

Question 39

In which area can you see a preview of your worksheet?

Answer 39

Printer setup