Muliple Choice Questions - Excel

Question 1

Horizontal Alignment (as it applies to Excel)
Select one:
a. refers to the left-right position of contents in a cell.
b. puts a line horizontally through the data.
c. removes the vertical lines running through the data.
d. refers to the up-down position of contents in a cell.

Answer 1

refers to the left-right position of contents in a cell..

Question 2

Excel displays a green arrow in the top left corner of a cell if it detects a
Select one:
a. rule that governs components of functions.
b. predefined formula that performs a calculation.
c. potential error.
d. cell reference or a value.

Answer 2

potential error..

Question 3

The active cell (as it applies to Excel 2010)
Select one:
a. is where all the functions of the database perform the calculations.
b. is the cell that always holds the current date.
c. is where all the formulas of the workbook do the math.
d. is the location of the insertion point as indicated by a dark border.

Answer 3

is the location of the insertion point as indicated by a dark border..

Question 4

A nested function
Select one:
a. contains another function embedded inside one or more of its arguments.
b. looks up a value and returns a related result from the lookup table.
c. is the lowest value for a specific category or series in a lookup table.
d. contains data for the basis of the lookup and data to be retrieved.

Answer 4

contains another function embedded inside one or more of its arguments..

Question 5

Column width
Select one:
a. is adjustable so you can display more or less characters in a column.
b. is best left unchanged unless you absolutely have to.
c. always switches back to default.
d. is not adjustable so keep the formulas as short as possible.

Answer 5

is adjustable so you can display more or less characters in a column..

Question 6

To change the data source of a chart, you must
Select one:
a. click Switch Row/Column in the Data group.
b. use the Select Data Source dialog box from the Select Data button.
c. use a different chart type.
d. change the numbers in the spreadsheet.

Answer 6

use the Select Data Source dialog box from the Select Data button..

Question 7

A data label
Select one:
a. is a horizontal or vertical line that extends from the horizontal or vertical axis through the plot area.
b. is a visual representation of numerical data.
c. is a line used to depict trends and forecast future data.
d. is the value or name of a data point.

Answer 7

is the value or name of a data point..

Question 8

A bubble chart shows
Select one:
a. how to adjust the size of the chart using the mouse.
b. a single chart and no spreadsheet data.
c. relationships among three values by using bubbles.
d. a miniature chart contained in a single cell.

Answer 8

relationships among three values by using bubbles..

Question 9

A function Screen Tip
Select one:
a. is a small pop-up description that displays the arguments for a function as you enter it.
b. calculates the total of values contained in two or more cells.
c. automatically inserts formulas such as =B4+C4.
d. automatically inserts functions such as SUM (B4:C4).

Answer 9

is a small pop-up description that displays the arguments for a function as you enter it..

Question 10

A chart sheet
Select one:
a. is a miniature chart contained in a single cell.
b. enables you to adjust the size of the chart.
c. contains a single chart and no spreadsheet data.
d. is a label that describes the chart.

Answer 10

contains a single chart and no spreadsheet data..

Question 11

A Value (as it applies to Excel)
Select one:
a. is a combination of cell references, operators, values, and/or functions used to perform calculations.
b. includes letters, numbers, and spaces.
c. is a number that represents a quantity and can be the basis of calculations.
d. controls the sequence in which Excel performs arithmetic operations.

Answer 11

is a number that represents a quantity and can be the basis of calculations..

Question 12

AutoComplete (as it applies to Excel)
Select one:
a. searches for and displays any other similar label in the current column as you begin to type.
b. adds all the numbers in the row automatically.
c. is a number that represents a quantity and can be the basis of calculations.
d. adds all the numbers in the columns automatically.

Answer 12

searches for and displays any other similar label in the current column as you begin to type..

Question 13

A sheet tab (as it applies to Excel 2010)
Select one:
a. identifies the address of the current cell.
b. displays the content of the active cell.
c. displays the name of a worksheet within a workbook.
d. conceals the applicable formulas for the workbook.

Answer 13

displays the name of a worksheet within a workbook..

Question 14

A spreadsheet PROGRAM is defined as
Select one:
a. a software application used to create and modify a database.
b. a software application used to create and modify spreadsheets.
c. a software application used to create and modify text-based documents.
d. a software application used to create and modify video presentations.

Answer 14

a software application used to create and modify spreadsheets..

Question 15

To adjust the column width and/or row height of many cells at once,
Select one:
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. type A1 in the “Go To” dialog box.
d. drag the fill handle across the cells.

Answer 15

click and drag across the cells to select them and use any sizing method you choose..

Question 16

A “Range”
Select one:
a. refers to a group of adjacent or contiguous cells.
b. cannot be selected with the mouse.
c. are the numbers that fall between the smallest and largest in the formula.
d. is another word for the active worksheet.

Answer 16

refers to a group of adjacent or contiguous cells..

Question 17

Semi-selection or pointing
Select one:
a. indicates a cell’s relative location from the cell containing the formula.
b. creates an Equals (=) sign.
c. indicates a cell’s specific location and the reference does not change when you copy the formula.
d. is the process of using the mouse to select cells while building a formula.

Answer 17

is the process of using the mouse to select cells while building a formula..

Question 18

The COUNTBLANK function
Select one:
a. tallies the number of blank cells in a range.
b. displays the current date.
c. displays the current date and time.
d. tallies the number of cells in a range that are not empty.

Answer 18

tallies the number of blank cells in a range..

Question 19

An area chart
Select one:
a. emphasizes magnitude of changes over time by filling in the space between lines with a colour.
b. shows the high, low, and close prices for individual stocks over time.
c. trends using two dimensions on a continuous curve.
d. shows a relationship between two variables.

Answer 19

emphasizes magnitude of changes over time by filling in the space between lines with a colour..

Question 20

A formula in Excel must begin with
Select one:
a. both an absolute and a relative cell reference.
b. a cell's relative location.
c. a cell's specific location.
d. an Equals (=) sign.

Answer 20

an Equals (=) sign..