Excel Mod 2 Quiz

Réussis tes devoirs et examens dès maintenant avec Quizwiz!

When Excel follows the order of operations, the formula, 8*3+2 equals _____. a. 48 b. 13 c. 26 d. 40

26

A _____ is text and graphics that print at the bottom of every page. a. footer b. toe c. margin d. stopper

Footer

A _____ is text and graphics that print at the top of each page. a. crown b. margin c. header d. topper

Header

All of the following are valid Excel arithmetic operations EXCEPT _____. a. * b. > c. % d. ^

I think it is %...

The _____function displays the highest value in range. a. MIN b. AVERAGE c. SUM d. MAX

MAX

The _____ function determines the lowest number in a range. a. LOW b. MIN c. LEAST d. BASE

MIN

The adjusted cell references in a copied and pasted formula are called _____ cell references. a. alternative b. relative c. pasted d. related

relative

When you decrease the row height to _____, the row is hidden. a. 0 b. 1 c. 2 d. 3

0

A _____ is a prewritten formula that is built into Excel. a. function b. feature c. calculation d. task

function

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. 7.52 c. 11.65 d. 8.43

8.43

Which of the following calculations multiplies 23 by 0.01? a. =24-.01 b. =23 c. =23% d. =23+.01

=23%

The _____ function sums the numbers in the specified range and then divides the sum by the number of cells with numeric values in the range. a. AVERAGE b. DIVSUM c. RANGEAVG d. MAX

AVERAGE

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. Percent style format c. Comma style format d. Accounting number format

Accounting number format

Which of the following Option buttons gives options for filling cells following a fill operation? a. insert options b. paste options c. auto fill options d. auto correct options

Auto Fill Options

You can click the _____ button to undo an automatic correction. a. Auto Fill options b. Paste Options c. AutoCorrect Options d. Trace Error

AutoCorrect Options

A(n) _____ circular reference occurs with a formula in a cell refers to another cell or cells that include a formula that refers back to the original cell. a. direct b. indirect c. contiguous d. indexed

Indirect

The default view in Excel is called _____ view. a. Standard b. Values c. Normal d. Basic

Normal

_____ view allows you to create or modify a worksheet while viewing how it will look in printed format. a. Page Layout b. Full Screen c. Page Break Preview d. Normal

Page Layout

You can use the _____ to check which cells are referenced in the formula assigned to the active cell. a. Function Finder b. Formula Finder c. Calculation Finder d. Range Finder

Range Finder

Excel automatically appends the _____ to complete the AVERAGE function when you click the Enter box or press the ENTER key. a. right bracket b. right parenthesis c. left bracket d. left parenthesis

Right parenthesis


Ensembles d'études connexes

Graphing Two-Variable Linear Inequalities Assignment

View Set

Exam 3: Instructional Objectives

View Set

Periodic Table of Elements: Groups 3-7

View Set

Questions and answers using the verb -ir

View Set

Chapter 6: The Nature of Management

View Set