Excel Test

Excel displays the error message ___ in cells not wide enough to display the entire entry.

#####

If you type "5" into A1 and use auto fill down to A5 without clicking anything else...

5 will appear in A5

You have selected the entire column B. If you choose "insert" what will happen?

A new column will be added to the left of it.

A group of cells that runs from the top of the page to the bottom; identified by letters in Excel.

Column

If you want the dollar sign to appear immediately to the left of the 1st digit with no spaces for money, use...

Currency style

If you type "January" into A1, and then use autofill down to A12, what will be in the cell? Answer streak 9

December

A workbook is part of a worksheet.

False (other way around)

To create an absolute cell reference (such as $A$1), click the key combination

Fn/F4

The ___ function is used to determine the lowest number in a given range of numbers.

MIN

_____ allows you to combine a cell with adjacent empty cells to create one large cell.

Merging Cells

A __ is a series of 2 or more adjacent cells in a column or row or a rectangular group of cells

Range

This icon indicates that the cursor will be able to...

Resize a row, changing its height

_____ will automatically modify a cell's row height, allowing cell contents to be displayed on multiple lines

Text-wrapping cells

When you sort data in a database, you should typically choose all the data.

True

To use the same cell reference in a formula when you autofill, you'll need to use a

absolute reference

A preceding ___ alerts Excel that you are entering a formula or function and not text.

equal sign

An Excel __ chart provides a simple way to show changes over time.

line graph

B1:F12 is an example of a ______.

range

Formulas with a __cell reference tell Excel to adjust the reference according to the location of the cursor.

relative

When you enter numeric data in a cell, Excel recognizes them as numbers and ____the values.

right-aligns