Comp 1000 Test 2

Front 1

If the active cell is A1, the cell address A1 displays in the:

Back 1

name box

Front 2

By default, excel spreadsheets have 3

Back 2

worksheets

Front 3

All ________ in Excel begin with an equal (=) sign.

Back 3

formulas

Front 4

Which of the following formulas is referring cells in a correct format?

Back 4

=A6+Z35

Front 5

When new rows are added to an existing worksheet, cell references in formulas:

Back 5

automatically adjust

Front 6

The ________ command uses the fill handle to copy the data in a range of cells.

Back 6

autofill

Front 7

If the active cell is B1 and you insert a new row, where will it be inserted?

Back 7

above B1

Front 8

The ________ command is used to center text within one cell so that it displays appropriately across the content of a worksheet.

Back 8

merge and center

Front 9

To modify the appearance of a range of cells, utilize commands on the ________ dialog box.

Back 9

format cells

Front 10

Excel spreadsheets display rows and columns which are made up of individual:

Back 10

cells

Front 11

________ Row Height adjusts the height of selected rows to fit the contents in the cells.

Back 11

auto fit

Front 12

To ensure that the reference to a specific cell does not change, use ________ cell referencing.

Back 12

absolute

Front 13

To change a relative cell reference to an absolute cell reference, use the ________ key.

Back 13

F4

Front 14

If you double-click a cell with a formula, Excel ________ the formula for easy editing.

Back 14

highlights

Front 15

To easily select predefined functions in Excel, select the:

Back 15

function wizard

Front 16

To determine the highest score on a test from among list of student scores, use the ________ function.

Back 16

MAX

Front 17

To determine the middle number in a range of cells, use the ________ function.

Back 17

median

Front 18

A(n) ________ is tested in an IF function to determine if it is true or false.

Back 18

condition

Front 19

To use text as a condition in an IF function, it must be enclosed in:

Back 19

quotation marks

Front 20

The ________ number is the number of the column in the lookup table that contains the return values.

Back 20

column index

Front 21

Parameters in an IF function can be ________, a value, a formula, or a nested function.

Back 21

text

Front 22

There are ________ main steps to creating a chart.

Back 22

6

Front 23

A chart can be placed on a new worksheet or:

Back 23

embedded

Front 24

An embedded chart is a(n) ________ that can be copied, deleted, or resized.

Back 24

object

Front 25

The ________ group contains options to change a chart layout.

Back 25

quick layout

Front 26

To be able to move a chart, it must be selected and pointer must appear as a:

Back 26

4-headed arrow

Front 27

To change a chart type after it has been created, choose the Change Chart Type option in the ________ tab of the Chart Tools.

Back 27

design

Front 28

To preview an Excel worksheet saved as a web page, open the page in a(n):

Back 28

web browser

Front 29

Once a chart has been created, it cannot be enhanced.

Back 29

false

Front 30

If there are certain columns of information that you do not want to be viewed by others, ________ the columns.

Back 30

hide

Front 31

It is possible to set a ________ on a protected sheet to allow users with authority to edit data.

Back 31

password

Front 32

A page break is represented by a ________ line.

Back 32

blue dashed

Front 33

Options for modifying the appearance of table data are in the ________ drop down list.

Back 33

format

Front 34

To organize the records in your table by last name, use the:

Back 34

sort

Front 35

Sorting records put them in order by:

Back 35

values

Front 36

The options to arrange data in ascending or descending order are found in the ________ group.

Back 36

sort and filter

Front 37

A 3x5 table represents ________ and ________.

Back 37

3 columns, five rows

Front 38

When you enter data into a table that you've created, the text:

Back 38

automatically wraps in the cell.

Front 39

When you press the Tab key from the last cell in a table, what happens?

Back 39

a blank row is added

Front 40

When you insert a new row into a table,:

Back 40

you can specify if you want it inserted above or below the current row

Front 41

Use the ________ command on the Layout tab to join two or more cells together.

Back 41

merge cells

Front 42

To change an image to a percentage of its initial size, use the:

Back 42

scale feature

Front 43

Characters such as the ñ and é found in the Spanish language can be entered by selecting the:

Back 43

insert tab, and then symbols

Front 44

Comments that you write are contained inside:

Back 44

markup balloons

Front 45

Where do comments appear in a document?

Back 45

in the right margin

Front 46

Comments display in markup balloons in all of the following views EXCEPT:

Back 46

draft

Front 47

What feature monitors all additions, deletions, and formatting changes in a document?

Back 47

track changes

Front 48

To accept all changes in a document at one time, click the ________ arrow on the ________ tab.

Back 48

accept all; review

Front 49

All of the following EXCEPT ________ are Track Changes options.

Back 49

original

Front 50

If you have several copies of the same document with different reviewer comments, use the ________ feature to view the differences.

Back 50

compare