Deck 11: Excel: Introduction to Access

Question 1

An Output Area (as it applies to Excel 2010)is defined as

A) a range of cells containing results based upon manipulation of the variables in the input area.
B) displays the name of a worksheet within a workbook.
C) a range of cells containing values for variables used in formulas.
D) displays the content of the active cell.

Answer 1

A

Question 2

A worksheet is defined as

A) the background color of a cell.
B) the current cell location of the insertion point as indicated by a dark border.
C) a single spreadsheet that often contains formulas, functions, values, text, and visual aids.
D) an unfinished project.

Answer 2

C

Question 3

A Value (as it applies to Excel)

A) controls the sequence in which Excel performs arithmetic operations.
B) is a number that represents a quantity and can be the basis of calculations.
C) includes letters, numbers, and spaces.
D) is a combination of cell references, operators, values, and / or functions used to perform calculations.

Answer 3

B

Question 4

A workbook is defined as

A) similar to a spreadsheet but bound rather than electronic.
B) an un-editable "picture" of data.
C) the address of the current cell.
D) a file containing related worksheets.

Question 5

You should use cell references in formulas instead of constant values so

A) you can easily include letters, numbers, and spaces.
B) it is easier to debug the errors.
C) you can change the input values without changing the formulas.
D) you can control the sequence in which Excel performs arithmetic operations.

Question 6

The Formula Bar (as it applies to Excel 2010)

A) displays the name of a worksheet within a workbook.
B) is at the intersection of a column and a row.
C) identifies the address of the current cell.
D) displays the content of the active cell.

Question 7

AutoComplete (as it applies to Excel)

A) adds all the numbers in the row automatically.
B) searches for and displays any other similar label in the current column as you begin to type.
C) adds all the numbers in the columns automatically.
D) is a number that represents a quantity and can be the basis of calculations.

Question 8

A spreadsheet PROGRAM is defined as

A) a software application used to create and modify spreadsheets.
B) a software application used to create and modify text-based documents.
C) a software application used to create and modify video presentations.
D) a software application used to create and modify a database.

Question 9

A spreadsheet

A) is the core of a slide presentation.
B) is an electronic file that is used to write text and graphics on the web.
C) is an electronic file that contains a grid of columns and rows for related data.
D) is another word for a letter written on a computer.

Question 10

The active cell (as it applies to Excel 2010)

A) is where all the functions of the database perform the calculations.
B) is the cell that always holds the current date.
C) is the location of the insertion point as indicated by a dark border.
D) is where all the formulas of the workbook do the math.

Question 11

The Name Box (as it applies to Excel 2010)

A) is located at the intersection of a column and a row.
B) displays the name of a worksheet within a workbook.
C) identifies the address of the current cell.
D) displays the content of the active cell.

Question 12

A Formula (as it applies to Excel 2010) is

A) a number that represents a date and can be the basis of calculations.
B) a combination of cell references, operators, values, and / or functions used to perform calculations.
C) a number that represents a quantity and can be the basis of calculations.
D) should be used in each column of a workbook.

Question 13

To put a long text label on two or more lines within a single cell

A) type the first line, then hit "Enter".
B) insert a line break with the "Alt + Enter" key combination.
C) type the second line then use the Backspace key.
D) insert a text box using F4.

Question 14

A cell (as it applies to Excel 2010)

A) must have formulas entered into it.
B) cannot be used for labels or headings.
C) must have text entered into it.
D) is the intersection of a column and a row.

Question 15

To insert the current date into an active cell use

A) F4.
B) Ctrl + Alt + Delete.
C) The Ctrl + D key combination.
D) The Ctrl and semicolon key combination.

Question 16

A cell address (as it applies to Excel 2010)

A) identifies the electronic "neighborhood" of a spreadsheet.
B) identifies a cell by a column letter and a row number.
C) searches for and displays similar labels as you type.
D) is a number that represents a quantity and can be the basis of calculations.

Question 17

The data type "Text" (as it applies to Excel)

A) should be entered into every cell of the spreadsheet.
B) includes letters, numbers, and spaces not used in calculations.
C) includes formulas, functions, and formatting.
D) is of little concern to Excel because Excel does calculations on numbers.

Question 18

A sheet tab (as it applies to Excel 2010)

A) displays the content of the active cell.
B) conceals the applicable formulas for the workbook.
C) identifies the address of the current cell.
D) displays the name of a worksheet within a workbook.

Question 19

An Input Area (as it applies to Excel 2010) is defined as

A) a range of cells containing results based on the output area.
B) displays the name of a worksheet within a workbook.
C) a range of cells containing values for variables used in formulas.
D) displays the content of the active cell.

Question 20

Which cell becomes active when you press the "Enter" key?

A) Cell A1 .
B) The cell at the bottom of the next column.
C) The next cell down.
D) The cell at the end of the current row.

Question 21

A Border (as it applies to Excel)

A) is data from another cell that is only temporarily residing in the active cell.
B) is a line that surrounds a cell or a range of cells.
C) never prints.
D) is preset and weight cannot be adjusted.

Question 22

Row Height

A) is the adjustable vertical measurement of a row.
B) changes the background color of the selected cells.
C) is controlled by the fill handle of the adjacent cell.
D) is not adjustable so use only smaller fonts for formulas.

Question 23

The order of precedence (as it applies to math operations in Excel)

A) includes letters, numbers, and spaces.
B) controls the sequence in which Excel performs arithmetic operations.
C) is a software application used to create and modify business communications.
D) includes formulas, functions, and formatting.

Question 24

To Transpose Columns and Rows

A) select and copy the original range then click the top left corner of the destination range, click the Paste Arrow, and then click Transpose.
B) save and close the document, then reopen it in "Transpose mode".
C) drag and drop A-Z onto 1-26.
D) drag the range to a new location on the worksheet.

Question 25

Ribbon Commands with arrows indicate

A) a shortcut to cell A1.
B) there are two or more sub-commands related to the command.
C) the next step in the process.
D) directionality.

Question 26

To adjust the column width and / or row height of many cells at once

A) just type longer or taller formulas in some of them.
B) click and drag across the cells to select them and use any sizing method you choose.
C) drag the fill handle across the cells.
D) type A1 in the "Go To" dialog box.

Question 27

Wrap Text (as it applies to Excel)

A) can be downloaded as an add-on .
B) is no longer possible in Excel 2010 due to contract restrictions.
C) is most useful with very short headings.
D) enables data to appear on two or more lines within a cell.

Question 28

When you paste copied data, Excel displays the Paste Options button

A) in the status bar at the left of the screen.
B) in the next set of nonadjacent ranges.
C) on the toolbar.
D) in the bottom right corner of the pasted data.

Question 29

Using the fill handle on a cell containing a formula

A) cannot complete a sequence of dates in a column.
B) changes the background color of the selected cells to yellow.
C) copies the formula in the active cell to other cells and adapts it based upon the type of cell references in the original formula.
D) has two or more sub-commands related to the command.

Question 30

Vertical Alignment (as it applies to Excel)

A) refers to the up-down position of contents in a cell.
B) removes the vertical lines and the tangent lines on the print-out.
C) shows the vertical lines but not the tangent lines on the print-out.
D) refers to the left-right position of contents in a cell.

Question 31

"Copy as Picture" can be a useful command when

A) you do not have a printer available.
B) the formulas, functions, and headings need to be tested.
C) you need an un-edit able "picture" of data to use elsewhere in the workbook or other programs.
D) you need to make changes to the data later.

Question 32

Horizontal Alignment (as it applies to Excel)

A) refers to the up-down position of contents in a cell.
B) removes the vertical lines running through the data.
C) puts a line horizontally through the data.
D) refers to the left-right position of contents in a cell.

Question 33

The fill handle (as it applies to Excel 2010)

A) is the fastest way to type A1 in the name box.
B) helps carry over the fill to the remaining slides.
C) is the same action as pressing "enter".
D) is a small black square at the bottom-right corner of a cell that facilitates fill operations.

Question 34

Fill Color (as it applies to Excel)

A) is handled automatically depending upon the contents of the cell.
B) is not adjustable.
C) is black by default.
D) is the background color of a cell.

Question 35

To select a range in using the name box

A) click in the name box and type the range address such as B15:D25 and then press "Enter".
B) select the name box from the 2010 File menu and choose "Range".
C) position the mouse pointer over the column headings holding the Alt key.
D) click in the first cell of the range, hold the "Ctrl" key, and then click in the last cell of the range.

Question 36

Column width

A) is adjustable so you can display more or less characters in a column.
B) is not adjustable so keep the formulas as short as possible.
C) always switches back to default.
D) is best left unchanged unless you absolutely have to.

Question 37

Auto Fill (as it applies to Excel 2010)

A) enables you to copy the contents of a cell or to continue a sequence by dragging the fill handle.
B) is the fastest way to type A1 in the name box.
C) is adjustable so you can display more or less characters in a column.
D) helps carry over the fill to the remaining worksheets.

Question 38

To show a "hidden" row one (1) or a "hidden" column A.

A) type A1 in the name box and then press "Enter"
B) use only a Ribbon command with arrows .
C) scroll to the left.
D) scroll to the right.

Question 39

A nonadjacent range

A) is the best tool to to use to decide which numbers to select.
B) is selected with the "Ctrl + Alt + Delete" key combination.
C) contains two or more cells or ranges that are not touching each other.
D) isn't possible in Excel 2010.

Question 40

A "Range"

A) cannot be selected with the mouse.
B) are the numbers that fall between the smallest and largest in the formula.
C) is another word for the active worksheet.
D) refers to a group of adjacent or contiguous cells.

Question 41

By default new workbooks contain four worksheets.

Question 42

The order of precedence in Excel is the same as the basic order of operations in math.

Question 43

You should plan the structure of the worksheets in a workbook before you begin entering data.

Question 44

Worksheets name "tabs" automatically reflect the contents of the worksheets.

Question 45

In Excel, when you hide a column or row, the data is not deleted, just hidden.

Question 46

Merge and Center is not a good tool for creating titles of headings in Excel.

Question 47

Increase / Decrease Indent tool is a good way to make certain text stand out from a list.

Question 48

In Excel, it is possible to add, delete, or rename worksheets at any time in the process.

Question 49

The Excel Window contains elements that are similar to other Office applications and some that are unique to Excel.

Question 50

To help with Managing your Workbook, worksheets tabs can be assigned unique colors.

Question 51

Changing the Format of a cell changes the value of the number stored in the cell.

Question 52

Excel uses the / symbol to perform multiplication on operands.

Question 53

If the column is too narrow, part of the data you enter in the cell will get deleted.

Question 54

Using Formatting on data makes it difficult to read and tends to obscure meaningful details.

Question 55

To begin a formula in a cell, first type the # symbol.

Question 56

Always key in the numbers of a mathematical operation rather than using the cell address where the number appear.

Question 57

Excel displays the result of a formula in its cell. You can display the formula itself by using the combination of Ctrl and ` (accent) keys at the same time.

Question 58

Use Horizontal alignment to move the data in a cell closer to the top or bottom of the cell.

Question 59

It is possible to rotate the text of a cell to read vertically (up and down) rather than across.

Question 60

Text can be any letters, numbers, and symbols and Excel can use them in calculations.

Question 61

________ is any combination of letters, numbers, etc NOT used for calculations.

Question 62

A ________ is a file containing related one or more worksheets.

Question 63

An ________ area is a range of cells containing results based on manipulating the variables.

Question 64

By default, new workbooks contain ________ worksheets.

Question 65

The ________ box displays the address of the (active) cell currently in use.

Question 66

A ________ is an electronic file that contains a grid of columns and rows.

Question 67

The ________ cell is the current cell, indicated by a dark border.

Question 68

The page setup dialog box Header / Footer tab is one way of adding a header and / or footer to your spreadsheet.

Question 69

The ________ bar displays the contents of the active cell.

Question 70

A cell ________ identifies a cell by a column letter and a row number.

Question 71

While it is common to center a worksheet horizontally on a page, it is not possible to center it vertically on the page in Excel 2010.

Question 72

An ________ area is a range of cells containing values for variables used in formulas.

Question 73

Sheet ________ show the names of the worksheets contained in the workbook.

Question 74

In Excel 2010, there is really no way to tell what a print-out will look like until you print it.

Question 75

A ________ is the intersection of a column and a row.

Question 76

To display another worksheet click the sheet ________ at the bottom of the workbook window.

Question 77

Excel displays data in gridlines of columns and rows. Those grid lines always appear on the printed document.

Question 78

________ is a single spreadsheet that can contain formulas, functions, values, text and visual aids.

Question 79

A ________ program is a computer application used to create and modify spreadsheets.

Question 80

The Page Setup Dialog box contains additional options not found on the Excel "Ribbon".