EXCEL UNIT A

In an electronic spreadsheet you need to manually recalculate when you change the entries.

False

An excel workbook has the file extension .xml

False

Charts are updated automatically in excel whenever data changes.

True

Arguments are excels built-in formulas.

False

You use formulas in excel to perform calculations such as adding, multiplying, and averaging.

True

Page layout view focuses on how the worksheet will look when printed.

True

A named range may begin a letter or number.

False

You can use a named range instead of a cell address in a formula.

True

In page layout view, the dotted line indicates the print area.

True

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

D. Spreadsheet

In excel, the electronic spreadsheet you work in is called a _____.

A. Worksheet

In excel a worksheet is contained in a file called a ___.

A. Workbook

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

A. Templates

You can use a spreadsheet to ____ by using variable values to investigate and sample different outcomes.

C. Create what-if data scenarios

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

B. Sheet tabs

All excel formulas begin with the___.

D. Equal sign (=)

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

B. Scroll bars

The excel operator for exponent is _____.

C. ^

The excel operator for division is ____.

D. /

A ____ is an entry in a cell that contains text such as "2011 Sales" or "Travel Expenses"

D. Label

A _____ is a built-in formula that uses arguments to calculate information.

D. Function

You can use the ___ keys on the keyboard to navigate a worksheet.

A. Arrow

To quickly jump to the first cell in a worksheet press _____.

B. [Ctrl] [Home]

To quickly jump to the last cell in a worksheet press _____.

C. [Ctrl] [End]

You can edit the contents of the active cell by _____.

D. Just starting to type

Possible paper orientations for printing a workbook are landscape and ____.

A. Portrait

The ____ option helps fit the data on a single page without making changes to individual margins.

B. Scale to fit

You can use the ____ slider on the status bar to enlarge your view of specific areas of your worksheet.

C. Zoom

You can change or ____ the contents of an active cell at any time.

D. Edit

If cell A1 contained 10, cell A2 contained 2 and cell A3 contained =A1/A2 what would cell A3 show on the worksheet.

C. 5

If cell A1 contained 10 cell A2 contained 2 and cell 3 contained =A1^A2 what would cell A3 show on the worksheet?

B. 100

______ operators perform mathematical calculations such as adding and subtracting.

A. Arithmetic

A dark rectangle that outlines the cell in which you are working.

C. Cell pointer

Provides a brief description of the active command or task in progress.

E. Status bar

Identified by the coordinates of the interesting column and row

D. Cell address

Displays the active cell address.

B. Name box

Work done in a virtual environment

A. Cloud computing