Qz 6 excel
The ________ inserts a thousand comma separator when appropriate, inserts a fixed U.S. dollar sign aligned at the left edge of the cell, applies two decimal places, and provides space for negative numbers to be displayed inside of parentheses. A) General Format B) Comma Style C) Accounting Number Format D) Percent Style
c
Which is the Excel operator for multiplication? A) $ B) ~ C) * D) ^
c
__________ generates and extends a series of values into adjacent cells based on the values of other cells. A) AutoComplete B) AutoFit C) AutoFill D) AutoSum E) either of these
c
a ____ is the intersection of a column and row.
cell
A text value is also referred to as a _____
label
Contents of a cell can be displayed on multiple lines by using the ____ command
not text wrap, Wordwrap?
a ____ is a horizontal group of cells in a worksheet.
row
If text is too long to fit in the current cell and the cell to the right contains data, the text will be _____ or cut off on the display.
truncated
A _____ is formatted as a pattern of uniformly spaced horizontal rows and vertical columns.
worksheet
All Excel formulas begin with a(n) ____
=
a ____ is a vertical group of cells in a worksheet.
Column
A(n) ____ uses one, two, or three letters to uniquely identify a column.
Column Heading
The small black square in the lower right corner of a selected cell is called the ____
Fill Handle
The ____ displays the name of the selected cell, table, chart, or object.
Name box
The _____ displays in the lower right corner of a selected range, which enables you to analyze you data by using Excel tools such as charts, color-coding, and formulas.
Quick Analysis Tool
A group of items that come one after another in succession is called a(n)
Series
An Excel document is called a(n)
Workbook
A data marker, such as a column, dot, or pie slice on a chart, represents a single: A) column B) data point C) row D) series E) neither of these
b
The Current cell mode, the page number, and the view and zoom button display on the: A) range finder B) status bar C) Name Box D) Formula Bar E) neither of these
b
Excel uses __________ to perform basic mathematical operations. A) arithmetic operators B) data markers C) data points D) charts
a
In a cell that contains a formula, the __________ visually indicates which workbook cells are included in a formula calculation. A) range finder B) status bar C) data point D) data marker E) neither of these
a
The __________ feature fills in the remaining characters of a word if what is typed matches an existing entry in the column. A) AutoComplete B) AutoFit C) AutoSum D) AutoFill E) neither of these
a
The data you see in a cell is called the: A) displayed value B) underlying value C) cell address D) underlying formula E) neither of these
a
Which is the Excel operator for exponentiation? A) $ B) ^ C) & D) * E) neither of these
b
__________ are defined as sets of formatting characteristics, such as font, font size, font color, cell borders, and cell shading. A) Cell contents B) Cell styles C) Cell references D) Cell addresses E) neither of these
b
The Formula Bar displays the data known as the: A) cell address B) display value C) underlying value D) calculated value E) neither of these
c
Absolute cell references are indicated by using what symbol in the cell address? A) ^ B) * C) & D) $ E) There is no such thing as an absolute cell reference.
d
The __________, when outlined in black, indicates it is ready to accept data. A) fill handle B) status bar C) data point D) active cell E) neither of these
d
The result of a formula displays in the active cell, and the __________ itself displays in the Formula Bar. A) underlying value B) displayed value C) cell address D) formula E) all of these
d
The individual pages of an Excel document are called ____
not worksheet, Spreadsheet?
