30 terms

Excel Study(Chapter 1)

STUDY
PLAY

Terms in this set (...)

A) Alignment
The position of data between the cell margines
B) Auto fill
Enables you to copy the contents of a cell or cell range or to continue a sequence by dragging the fill handle over an adjacent cell or range of cells
C) Cell
The intersection of a column and row
D) Column Width
The horizontal measurement of a column
E) Fill color
The background color appearing behind data In a cell
F) Fill handle
A small green square at the bottom-right corner of a cell
G) Formula
A combination of cell references, operations, values, and/or functions used to perform a calculations
H) Formula Bar
Displays the content (text, value, date, formula) in the active cell
I) Input Area
A range of cells containing values for variables used in formulas
J) Name Box
Identifies the address of the current cell
K) Order of Operations
Rules that control the sequence in which Excel performs arithmetic operations
L) Output Area
A range of cells containing results based on manipulating the variables
M) Range
A rectangular group of cells
N) Row Height
The vertical measurement of a row
O) Sheet Tab
Display the name of a worksheet within a workbook
P) Text
Includes letters, numbers, symbols and spaces
Q) Value
A number that represents a quantity or an amount
R) Workbook
A file containing related worksheets
S) Worksheet
A spreadsheet that contains formulas, functions, values, text and visual aids
T) Wraptext
Formatting that enables a label to appear on multiple lines within the current cell
1) Which step is not part of planning a worksheet design
A) decide what inputs values are need
B) state the purpose of the worksheet
C) decide what output are needed to achieve the purpose
D) enter labels, values and formulas
D) enter labels, values and formulas
2) You just copied a range of data containing formulas, however you want to preserve the formula results and the original number and text formatting in the pasted range which paste option would you select
A) Formulas
B) Keep source formatting
C) Values and source formatting
D) Values and number formatting
C) Values and source formatting
3) Given the formula =B1*B2+B3/B4^2, what operation is calculated first
A) B1*BC
B) B2+B3
C) B3/B4
D) B4^2
D) B4^2
4) How can you display formulas within the cells instead of the cell results
A) Press Ctrl+G
B) Press Ctrl+'
C) Press cell references on the home tab
D) Press Ctrl+C
B) Press Ctrl+'
5) What is the fast way to aply several formats at one time
A) Click each one individually
B) Apply a cell style
C) Use auto fill
D) Use copy and paste options
B) Apply a cell style
6) Which of the following is not an alignment option
A) Increase indent
B) Merge and center
C) Fill color
D) Wrap text
C) Fill color
7) Which of the following characteristics is not applicable to the accounting number format
A) Dollar sign immediately on the left side of the value
B) Commas to separate thousands
C) Two decimals places
D) Zero values displayed as hyphens
A) Dollar sign immediately on the left side of the value
8) You selected and copied worksheet data containing formulas. however you want the pasted copy to contain the current formula results rather than formulas, what do you do?
A) Click paste in the clipboard group on the home tab
B) Click the paste arrow in the clipboard group and elect formulas
C) Click The paste arrow in the clipboard group and select values and source formatting
D) Display the paste special dialog box and select formulas and number formatting
C) Click The paste arrow in the clipboard group and select values and source formatting
9) Assume that the data on a worksheet consume a whole printed page and a couple of columns on a second page you can do all pg the following except what to force the data to print all on one page
A) Decrease the scale values
B) Increase the left and right margins
C) Predecease the column width if possible
D) Select a smaller range as the print area
B) Increase the left and right margins
10) What should you do if you see pound signs (###) instead of values or results of formulas
A) Increase the zoom percentage
B) Delete the column
C) Adjust the row height
D) Increase the column width
D) Increase the column width