Excel Part 2

Ace your homework & exams now with Quizwiz!

The adjusted cell references in a copied and pasted formula are called _____ cell references. A. Alternative B. Related C. Relative D. Pasted

Relative

Which of the following patterns extends the fill series to 757,550,525? A. 680, 580 B. 650, 600 C. 625, 600 D. 500, 475

625, 600

All of the following are valid excel arithmetic operators except _____. A. ^ B. * C. % D. >

>

Which of the following Auto Fill options is the same as the fill series option? A. Fill Months B. Copy Cells C. Fill Without Formatting D. Fill Formatting Only

Fill Months

A _____ is a prewritten formula that is built into excel. A. Calculation B. Feature C. Task D. Function

Function

The _____ function determines the lowest number in a range. A. LOW B. BASE C. LEAST D. MIN

MIN

To print a range of cells in the active worksheet, click _____ in the settings area in the print gallery. A. Print active sheets B. Print selection C. Print entire workbook D. None

Print Selection

A company or department may standardize with a specific _____ so that all of their documents have a similar appearance. A. gallery B. style C. theme D. scheme

Theme

When you decrease the row height to _____, the row is hidden. A. 3 B. 2 C. 1 D. 0

0

If you do not assign a format to a cell or cells in a column, the column width will remain _____ characters. A. 9.43 B. 11.65 C. 8.43 D. 7.52

8.43

Which of the following calculations multiplies 23 by .01? A. =23 + .01 B. =23% C. =23 D. 24-.01

=23%

Which of the following is the path to the copy and paste buttons? A. (HOME tab | Clipboard group) B. (HOME tab | Formulas group) C. (HOME tab | Copy group) D. (HOME tab | Paste group)

(HOME tab | Clipboard group)

Which of the following is the path to the conditional formatting button? A. (STYLES tab | Formatting group) B. (FORMATTING tab | Styles group) C. (HOME tab | Editing group) D. (HOME tab | Styles group)

(HOME tab | Styles group)

Which of the following is the path to the Zoom button? A. (ZOOM tab | View group) B. ( HOME tab | Zoom group) C. (VIEW tab | Zoom group) D. (INSERT tab | Zoom group)

(VIEW tab | Zoom group)

The _____ button assigns a fixed dollar sign to the numbers in a selected range, with the dollar sign to the far left with spaces between it and the first digit in the cell. A. Currency style format B. Comma Style format C. Accounting number format D. Percent style format

Accounting number format

You can click the _____ button to undo an automatic correction. A. Paste Options B. Auto Fill Option C. AutoCorrect Options D. Trace Error

AutoCorrect Options

To copy cell contents, you can select the cell and then press the _____ keys. A. CTRL+ C B. CTRL+ X C. CTRL+ B D. CTRL+ V

CTRL+ C

You can open the format cells dialog box by pressing the _____ keys. A. SHIFT +TAB B. CTRL +1 C. ALT+1 D. SHIFT+F1

CTRL+1

In the context of copying a range of cells to a nonadjacent location, an alternative to clicking the paste button is to press the _____ key. A. ALT B. ENTER C. SHIFT D. CTRL

ENTER

A(n) _____ circular reference occurs when a formula in a cell refers to another cell or cells that include a formula that refers back to the original cell. A. Indirect B. Contiguous C. Indexed D. Direct

Indirect

The default view in Excel is called _____ view. A. Basic B. Values C. Standard D. Normal

Normal

When more than one arithmetic operators is involved in a formula, Excel follows the same basic order of _____ that you use in algebra. A. Operations B. Positioning C. Placement D. Selections

Operations

_____ view allows you to create or modify a worksheet while viewing how it will look in printed format. A. Page break preview B. Normal C. Full screen D. Page Layout

Page Layout

You can use the _____ to check which cells are referenced in the formula assigned to the active cell. A. Function Finder B. Range Finder C. Formula Finder D. Calculation Finder

Range Finder


Related study sets

Study Module 7: Membrane Structure and Function

View Set

GL19 U7 (PowerPoint) CH01 Concepts Exam

View Set

MBL103 Chapter 12 Workers Compensation & Disability Automotive Insurance

View Set

CITI Privacy and Confidentiality SBE

View Set

Chapter 1: Modern Project Management

View Set