Excel 1 Test

what character does excel consider numbers

0 1 2 3 4 5 6 7 8 9 + - ( ) / . % $ E e

what are the shortcut keys for bolding a font

CTRL + B

what is an embedded chart

a chart that is brawn on the same worksheet as the data table

excel worksheet

a computerized spreadsheet. allows data easily to be summarized and charted

BTW box

a number can be between approx. -1 x 10308 and 1 x 10308 this means it can be between a negative 1 followed by 308 zeros and a positive 1 followed by 308 zeros to enter a number such as 6,000,000,000,000,000 or you can type 6E15 with translates to 6 x 1015

range

a series of two or more adjacent cells in a column or row or a rectangular group of cells example: B4 B5 B6 B7 and B8 is called a range

END

end mode

what does the auto correct feature do

works behind the scenes, correcting common mistakes when you complete a text entry in a cell there are 3 types of corrections: 1. corrects two initial capital letters by changing the second letter to lower case 2. capitalizes the first letter in the names of days 3. replaces commonly misspelled words with their correct spelling

An Excel _________ allows data easily to be summarized and charted. A. worksheet C. document B. workbook D. presentation

worksheet

what is the Auto calcuate area of the status bar

you can obtain a total, an average, or other information about the numbers in a range

what does formatting do for a worksheet

you format a worksheet to emphasize certain entries and make the worksheet easier to read and understand -increase the font size of cells -change the font color of cells -center the worksheet titles, subtitles, and column headings

how many of your actions does excel store that can be undone

your last 100 actions

what is the comma style format

(also known as the thousands separator) in Excel 2010 often accompanies the Accounting number format. ... Select the cells containing the numbers you want to format. On the Home tab, click the Number dialog box launcher.

SHIFT+RIGHT ARROW

Highlights one or more adjacent characters to the right

what key on the keyboard toggles between insert mode and over type mode

INSERT key

what box do you hit to CANCEL the entry

click the cancel box

what is a relative cell reference

each adjusted cell reference

INSERT

to put in text

When entering numeric data in Excel, you should enter only the numeric data. That means it is best to not enter the dollar signs or the commas or trailing 00 (if there is no cents in the dollar amount). True or False

true

How many chart types does Excel offer? A. 5 C. 29 B. 11 D. 50

11

how many chart types are in excel

11

By default, Excel opens how many worksheets with each new workbook?

3

To enter a number such as 6,000,000,000,000 you can type that or you can type__________. A. 6,000T C. 6Q B. 6K000 D. 6E15 6E15

6E15

what are the keyboard short cut keys to get to cell A 1 from anywhere in the worksheet

CTRL + HOME

CTRL+F

Displays the Find dialog box.

which key moves the insertion point to the END of data in a cell

END

To cancel an entire entry before entering it into the cell, press the _________key. A. ALT C. CTRL B. ESC D. TAB

ESC

what is the shortcut key on the keyboard to edit a cell

F2

which key moves the insertion point to the BEGINNING of data in a cell

HOME

ALT+PAGE DOWN

Moves one screen to the right in a worksheet.

In Excel, a number can contain the characters___________. A. 0123456789 C. . $%Ee B. + - () , / D. all of the above

all the above

what are your choices in the Auto Fill Options menu

allows you to choose whether you want to copy the values from the sources area to the destination area with formatting, do so without formatting, or copy only the format. to view the available fill options, click the auto fill options button. the auto fill options button disappears when you begin another activity in excel such as typing data in another cell or apply formatting to a cell or range of cells

To enter a number as text, precede it with a(n) ___________. A. quotation mark (") C. plus (+) B. colon (:) D. apostrophe(')

apostrophe

The ______ area on the status bar displays common calculations, such as SUM or AVERAGE, for selected numbers in the worksheet. A. AutoFormat C. AutoFunction B. AutoComplete D. AutoCalculate

auto calculate

The __________feature works behind the scenes, fixing common typing or spelling mistakes when you complete a text entry. A. AutoComplete C. AutoFormat B. AutoCorrect D. AutoTyping

autocorrect

The _________ button allows you to choose whether you want to copy the values from the source area to the destination are with formatting. A. Copy Options C. Formatting Options B. Replace Options D. AutoFill Options

autofill options

what is the accounting number format

causes the cells to be displayed with two decimal places to that decimal places in cells below the selected cells align vertically

To enter data in a cell, you must first select or activate the _____________. A. row C. column B. worksheet D. cell

cell

To remove an embedded chart, you should _________ it and press the DELETE key. A. move C. hide B. drag D. click

click

how do you separate a range while manually typing a formula

click insert function button in the formula bar, select SUM in select a function list, click OK button, select range, click OK button

what key on the keyboard do you hit to cancel an entire entry before entering it into a cell

click the cancel box in the formula bar or press the escape (ESC) key

how do you remove an embedded chart

click the chart to select it then press the DELETE key

what box do you hit to COMPLETE an entry

click the enter box

You can enter the correct range in a function by typing the beginning and ending cell references separated by a ________. A. semi-colon (;) C. period (.) B. colon (:) D. none of the above

colon

what does the comma style format do when added to numbers

commas are added

Pressing the ________ keyboard shortcut key(s) selects A1. A. CRTL+HOME C. HOME B. CRTL+END D. END

crtl+ home

BACKSPACE

deletes the character to the left of the insertion point

The cell being copied is called the source area (or copy area). The range of cells receiving the copy is called the ________. A. receiver call C. receiving range B. final cell D. destination area (or paste area)

destination area

what is the cell that is being copied TO called

destination area or paste area

What effect does the Comma Style format have on the selected cell? A. Converts decimals to commas within a cell B. Converts decimals to commas within merged cells C. Displays cell contents with two decimal places and commas as thousands separators D. Allows for substitution of selected characters

displays cell content with two decimal places and commas as thousands separators

What effect does the Accounting Number Format have on the selected cells? A. Converts alphabetic characters to numbers B. Displays cell contents with two decimal places that align vertically C. Performs tax calculations D. Copies the numbers of one cell to another

displays cell contents with two decimal places that align vertically

A(n)________ chart is drawn on the same worksheet as the data. A. embedded C. embodied B. emboldened D. empowered

embedded

Which of the following keys moves the insertion point to the end of data in a cell? A. HOME C. END B. DELETE D. BACKSPACE

end

Clicking the _________ box completes an entry. A. Cancel C. Enter B. Formula D. Tab

enter

Which of the following keys is an alternative to double-clicking the cell to edit it? A. F1 C. F3 B. F2 D. F4

f2

The _________ is the small black square located in the lower-right corner of the heavy border around the active cell. A. selection handle C. fill handle B. sizing handle D. copy handle

fill handle

what is the fill handle and where is it located (what does it look like)

fill handle- the small black square located in the lower-right corner of the heavy border around the active cell.

You _________ a worksheet to emphasize certain entries and make the worksheet easier to read and understand. A. save C. format B. print D. clear

format

HOME

home

Which of the following keys moves the insertion point to the beginning of data in a cell? A. HOME C. INSERT B. ENTER D. TAB

home

what tab and group is Cell styles in on the ribbon

home tab styles group

what are two ways to complete an entry and activating that adjacent cell to the right

if the next entry you want to enter is in an adjacent cell, use the arrow keys to complete the entry in a cell. When you press an arrow key to complete an entry, the adjacent cell in the direction of the arrow becomes the active cell. If the next entry is in a non adjacent cell, complete the current entry by clicking the next cell in which you plan to enter data. You also can click the enter box or press the enter key and then click the appropriate cell of the next entry

what is included in an excel workbook

include author title and subject

requirements documents

includes a needs statement, a source of data, a summary of calculations, and any other special requirements for the worksheet such as charting and web support

Which of the following keys toggles between Insert mode and Overtype mode? A. INSERT C. TAB B. ENTER D. ALT

insert

The ____________ is a blinking vertical line that indicates where the next typed character will appear. A. scroll box C. insertion point B. sheet tab D. split bar

insertion point

insertion point

is a blinking vertical line that indicated when the next typed character will appear

what alignment does text have in a cell by default

left align

By default, text is ________in a cell. A. left-aligned C. justified B. centered D. right-aligned

left-aligned

The ______ identifies the colors assigned to each bar in the chart on a worksheet. A. color code C. explanation B. identifier D. legend

legend

Combining two or more selected cells into one cell is called _________ cells. A. merging C. combining B. mixing D. spanning

merging

ARROW

moving right/left/up/down

SPACEBAR

oblong key at the bottom of a keyboard which, when pressed, adds a space at the text insertion point

what is the name of the toolbar that the undo button is located on

quick access toolbar

A _________ is a series of two or more adjacent cells in a column or row or a rectangular group of cells, as shown in the accompanying figure. A. range C. nearby cell B. bunch D. neighbor

range

A________ reference is an adjusted cell reference in a copied and pasted formula. A. revised C. recycled B. relative D. retained

relative

The person or persons requesting the worksheet should supply their requirements in a _______________. A. blank C. requirements B. test issue D. certified

requirements

Pressing the __________key to complete an entry activates the adjacent cell to the right. A. RIGHT ARROW C. UP ARROW B. LEFT ARROW D. DOWN ARROW

right arrow

what is the cell that is being copied called

source area or copy area

________ properties are associated with all Microsoft Office documents and include author, title, and subject. A. Automatic C. Replacement B. Hidden D. Standard

standard

what are the standard principles of an excel workbook

standard properties and automatically updated properties

active cell

the cell in the worksheet in which you can type data

what does the accounting number format do when applied to numbers

the format causes cells to be displayed with two decimal places

cell

the intersection of a column and a row in a table or worksheet

what is a chart legend

this tells you what each bar or column or line or pie slice etc. represents on your chart

what character do you use to enter a number and have excel treat that number as a text

to enter a number as text, start the entry with an apostrophe (')

What is the first step in creating an effective work sheet

to make sure you understand what is required. the person or persons requesting the worksheet should supply their requirements in a requirements document

CTRL+HOME

to the beginning of the document

Formatting a worksheet makes the data easier to read and understand. True or False.

true

When you fill a formula down or right, Excel automatically changes the cell reference in that formula so that the formula adds the column or row in which it appears. True or False?

true

In general, use no more than _______ font types in a worksheet. A. two C. six B. four D. eight

two

The ________ button is located on the Quick Access Toolbar, as shown in the accompanying figure. A. Undo C. Bold B. Cell Style D. Increase Decimal

undo

what is the general rule for how many fonts types to use in a worksheet

use no more than two font types in a worksheet because the use of more fonts can make a worksheet difficult to read

how to make the cell active

use the mouse to move the block plus sign mouse pointer to the cell and then click

text

used to place titles such as worksheet titles, column titles, and row titles on the worksheet