# excel

### 90 terms by swirlszz

#### Study  only

Flashcards Flashcards

Scatter Scatter

Scatter Scatter

## Create a new folder

healthclaim

d. conditional

d. point mode

b. Range Finder

d. parentheses

b. condition

a. formula

c. warmer

a. theme

a. 8.43

### the ___ is the order in which arithmetic operators are calculated a. order of values b. order of operations c. order of signs d. order of calculations

b. order of operations

a. cooler

b. double-click

a. inbetween

d. function

### ____ allows you to create or modify a worksheet while viewing how it will look in printed format a. Normal View b. Page Layout View c. Print Preview d. Review

b. Page Layout View

a. Insert Option

b. pixel

c. function

a. Normal View

a. zero

d. 0.file

b. destination

a. insert

### the ___ is a blinking vertical line that indicates where the next type character will appear a. lnsertion point b. key tip c. active cell d. ribbon

a. Insertion point

c. workseets

### You view the portion of the worksheet displayed on the screen though an a. Active window b. worksheet window c. cell d. active cell menu

b. worksheet window

c. normal

a. Cell refernce

b. Block arrow

b. merging

c. #

c. embedded

### The number of workseets that you can add to a workbooks is a. 100 b. 256 c.1,067,456 d. limited by the amount of memory on the computer

d. limited by the amount of memory on the computer

d.1,045,567

c. ALT

a. AutoCorrect

d. apostrophe

a. format

a. ALT

a. Count

C: paintbrush

### An alternative to clicking the Paste button is to _______. A: click the Drop button B: click the Move butto0n C: press the Enter key D: press the down arrow

C: press the Enter key

A: exploded

B: Zoom slider

A: data series

C: CTRL

### A cell reference with only one dollar sign before either the column or the row is called a(n)_______. A: mixed cell reference B: relative cell reference C: absolute cell reference D: incomplete cell reference

A: mixed cell reference

C: 90 degree

C: Nested IF

C: dollar sign

A: Copy

B: Now

### When creating panes in a worksheet, the bar going up and down the middle of the window is called the ___. A: horizontal split bar B: vertical split C: scroll bar D: vertical ruler

A: horizontal split bar

C: +(plus sign)

A: offsetting

B: Delete

### Excel allows you to control the rotation angle, elevation, perspective, height, and angle of the axes of a chart by using the ____. A: Chart Painter dialog box B: Pie Chart Control box C: Control tab D: Format Chart Area dialog box

D: Format Chart Area dialog box

C: drag and drop

### Using the ___ button on the Ribbon, you can format a cell quickly by copying a cell's format to another cell or range of cells. A: Formatter B: Format Painter C: Copy D: Layout

B: Format Painter

D: Paste

a. #####

### Data can be arranged in ascending or descending order by using a. Sort command from Table menu b. Sort command from Data menu c.Sort command from Tools menu d.None of these

b. Sort command from Data menu

### 3. Red triangle at the top right corner of a cell indicates a.. There is an error in the cell b. There is a comment associated with the cell c.The font color of the text in cell is red d.The cell can't accept formula

b. There is a comment associated with the cell

b. 3

a. Ctrl+PgUp

c. Paranthesis

a. freezing

b. panes

### To keep specific rows and columns from scrolling off the screen you first must position the cell pointer a.to the right oftbe column you want to remain on the screen b.below the row you want to remain on the screen c. on the row you want to remain on the screen d. both below and right of the row and column you want to remain on the screen

d. both below and right of the row and column you want to remain on the screen

### . If you wanted to sort an employee me so that they would be listed alphabetically by last name and first name within individual zip codes (smallest to largest), which of the following would be the correct order of the sort? a. zip codes (ascending), then last name (ascending), then first name (ascending) b.last name (ascending), then first name(ascending), then last name (ascending) c.zip codes (descending), then last name(ascending), then first name(ascending) d.last name (descending), then first name (descending), then last name (descending)

a. zip codes (ascending), then last name (ascending), then first name (ascending)

a. Name box

d. F5

### If you wanted to sort an employee file so that they would be listed alphabetically by last name and first name within individual zip codes (smallest to largest), which of the following would be the correct order of the sort? a)zip codes (ascending), then last name (ascending), then first name (ascending) b. last name (ascending), then first name(ascending), then last name (ascending) c.zip codes (descending), then last name(ascending), then first name(ascending) d.last name (descending), then first name (descending), then last name (descending)

a)zip codes (ascending), then last name (ascending), then first name (ascending)

d. grid line

c. *and ?

c. red

a. Ctrl+G

### To centre workseet titles across a range of celll, you must ____ a. Used merge and center button to center the text across multiple cells b. wident the columns c. checks whether text is the same in one cell as in the next d. all of these choices

a. Used merge and center button to center the text across multiple cells

b. #Name?

### What is a circula reference? a. Geometric modeling tool b. a cell that points to a drawing object c. a formual that either directly or indirectly depends on itself d. always erroneous

c. A formula that either directly or indirectly depends on itself

D. Tools

d. F11

a. Nested

a. constant

### To select several cells or ranges that are not touching each other, you would ____ wile selecting a. Hold down the control button b. hold down the shift key c. hold down the control key d. hold downt eh control and shift key

a. Hold down the control button

b. Ctrl + PgUp

### YOu want to track the progress of the opening and closing price of a stock. Which type of chart should you use? a. Pie Chart b. Bubble c. Stacked Colum d. High Low Close Open

d. High Low Close Open

b. 30

Example: