CSCI Midterm

absolute cell reference

$C4$

How many cells are in the range B2:D7?

18

How many different ways are there to combine absolute and relative references to a single cell?

4

On startup, Excel displays a new blank

Workbook

Spreadsheet formulas start with

=

Conditional formatting

Allows you to display information in more than one way

Which of the following is a valid range of cells

D1:D3

Which of the following is completely relative cell reference?

J4

To get the first characters in a cell you should use the

LEFT () function

The function that retrieves and then displays the date and time from your computer is the:

NOW function

Spreadsheets are great for playing ___, that is, they are useful for putting together various possible senarios?

What if?

The type of cell reference that refers to cells by their fixed position in a worksheet is:

absolute

A cell surrounding by a black border and ready to recieve data is the:

active cell

In spreadsheets, names

are used for cells, are used for cell ranges, can contain an underscore

Cell entries are ____; that is, the computer will not consider any of their constituent parts.

atomic/monodithic

use the ___ function to find the average of a range of cells.

average

Functions and column letter are ___ in formulas

case sensitive if you put a $ in the formulas

Delimited cell entries mean

cell entrys that end with a certain character

Basic spreadsheet principles

clear and easy to use entries, clean layout, logical form.

__ are a good way to explain a spreadsheet formula

comments

____ means "join letter sequences together."

concatenate

What function would you use to change the color of certain cells based on the value stored inside of them?

conditional formatting

__ allows for the application of interpretation to the data in a spreadsheet

conditional formatting.

If the cell does not start with an equal sign then the cell contains

data

A shaded bar that provides a visuals cue about the value of a cell relative to other cells is a:

data bar

Whenever a value in a spreadsheet is changed

everything is recalculated

A spreadsheet can import any kind of data

false

Cells in a spreadsheet are 10 characters wide

false

Column references in cell ranges must be typed using uppercase

false

Copy/paste will duplicate a formula, but it won't utilize relative and absolute cell refrences

false

Text too wide to fit into a cell is truncated

false

The feature that generates and extends values into adjacent cells based on the values of selected cells is:

fill handle

The small box in the lower-right corner of a selected cell is called thw

fill handle

The process of displaying only a portion of the data based on matching a specific value to show only the data that meets the criteria that you specify is called:

filtering

___ allows the selection of certain spreadsheet rows based on specifiec criteria.

filtering

___ allow for programmatic manipulation and analysis of data in spreadsheets

formula

An excel window element that displays the value or formula contained in the active cell is the:

formula bar

The command that enables you to select one or more rows or columns and lock them into place is:

freeze panes

___ are formulas built into a spreadsheet to make it easier to create calculations.

functions

The default format that Excel applies to numbers is the:

general format

__ information that is not currently needed is a good way to make spreadsheet clear and easy to use.

hiding

When you ___ for spreadsheet, you create a symbolic reference for a range of cells.

name a range

An Excel window element that displays the name of the selected cell, table, chart, or object is the:

name box

The PMT () function returns a __ because it's money you owe

negative number

Respectively, rows and columns are designed with

numbers, letters

The excel command that enables you to specify rows and columns to repeat on each printed page is:

print titles

A rectangular group of one or more cells is called an

range

A single cell or a related rectangular group of cells is called a

range

A ___ cell reference automatically transforms a formula when it is pasted or filled

relative

To change the formatting on a chart a chart you should __ on that item to access the appropriate menus.

right click

The ___ is the interface for managing scenarios

scenario manage

A box in the upper left corner of the worksheet grid that selects all the cells in a worksheet

select all box

Using ___ automatically fills and increments values

series

Use the __ function to find with incremtns of a certain type of data

series fill

The label along the lower border of the workbook window that identify each worksheet are the:

sheet tabs

The process of arranging data in a specific order based on the value in each field is called:

sorting

Tiny charts embedded in a cell that give a visual trend summary alongside your data are:

sparklines

A worksheet where totals from other worksheets are displayed are summarized is a:

summary sheet

Defining names for a spreadsheet allows you to refer to cells

symbolically

Data imported into a spreadsheet should generally be

tab-delimited ACSII

A series of rows and columns with related data that is managed independently from other data is a:

table

AutoFiltering can only be used

tables that have column headings

Conditional formatting can change the

text color, text format, cell color

A cell reference cannot contain a relative and an absolute reference at the same time

true

Relative cell references change as associated values change

true

The small box or handle in a selected cell's lower-right corner is used to move the contents of the cell.

true

The data that displays in the Formula Bar is referred to as the:

underlying value

Spreadsheets recalculate

whenever a cell is changed

"Explain everything" in a spreadsheet means

you should easily be able to tell what every cell means