Microsoft Office Final Exam

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

In a formula, which symbol specifies fixed columns or rows?

$

You can use a named range instead of a cell address in a formula (T or F)

true

You use formulas in Excel to perform calculations such as adding, multiplying, and averaging (T or F)

true

The Excel operator for division is _____

/

Possible paper orientations for printing a worksheet are landscape and _____

portrait

The Excel function that returns the arithmetic mean of its arguments

AVERAGE

The default Accounting number format adds dollar signs and _____ decimal places to the data

Two

A named range may begin a letter or number (T or F)

false

According to the order of precedence for arithmetic operators, operations contained within parentheses are performed last (T or F)

false

An Excel workbook has the file extension .xml (T or F)

false

An absolute cell reference changes the cell references when the formula is copied to a new location (T or F)

false

Arguments are Excel's built-in formulas (T or F)

false

Formatting can change the actual data of a cell

false

In an electronic spreadsheet, you need to manually recalculate when you change the entries (T or F)

false

The COUNT function in Excel returns the number of all cells in a range that contain any type of data (T or F)

false

The Format Painter button copies both the cell's content and formatting

false

The Increase Decimal button automatically adds dollar signs and two decimal places to your data

false

Using the order of precedence for arithmetic operators, these two formulas will calculate the same result: =22/2*5 =22/(2*5) (T or F)

false

When you insert a new column, the contents of the worksheet shift to the left from the point of the new column

false

You must apply borders to all the cells in a worksheet; you cannot apply them only to selected cells

false

To continue a sequence in adjacent cells, such as months of the year, use the _____ feature of Excel

fill handle

The _____ size is the physical size of the text

font

The name for a collection of characters (letters, numerals,symbols, and punctuation marks) with a similar, specific design

font

The _____ of a cell determines how the labels and values look

format

The COUNTA function is used to count the number of cells in a range that contain which type of data?

formulas, text and numbers

You can edit the contents of the active cell by _______

just starting to type

What type of cell reference is D$23?

mixed

______ operators perform mathematical calculations such as adding and subtracting

Arithmetic

A dark rectangle that outlines the cell in which you are working

cell pointer

Work done in a virtual environmment

cloud computing

You can use the ______ slider on the status bar to enlarge your view of specific areas of your worksheet

Zoom

Which key to you press to copy while dragging and dropping selected cells?

[Ctrl]

To quickly jump to the last cell in a worksheet press ______

[Ctrl][End]

To quickly jump to the first cell in a worksheet press _____

[Ctrl][Home]

Which key do you press to convert a relative cell reference to an absolute cell reference?

[F4]

The Excel operator for exponent is _____

^

Which type of cell reference preserves the exact cell address in a formula?

absolute

You can change the ____ of labels and values in cells to be left, right, or center

alignment

Excel templates include which of these categories?

all of the above

You can use the ______ key(s) on the keyboard to navigate a worksheet

arrow

Cells and ranges in a worksheet can be formatted ______.

before and after data is entered

Identified by the coordinates of the intersecting column and row

cell address

###### in a cell means that the ________.

column is too narrow to display the value completely

The formatting due to _____ formatting is automatically updated if you change data in the worksheet

conditional

You can use a spreadsheet to _____ by using variable values to investigate and sample different outcomes

creat what-if data scenarios

Excel templates make creating a professional looking spreadsheet easier by including all of the following except _______ in the template

data

A type of conditional formatting that visually illustrates differences among values

data bar

Allows the user to move or copy data from one cell to another without using the Clipboard

drag-and-drop method

You can change, or ______, the contents of an active cell at any time

edit

All Excel formulas begin with the _____

equal sign (=)

You can apply formatting before and after you enter data in a cell or range

true

You can change the font and font size of any cell or range using the Mini toolbar

true

The Excel feature used to selectively copy formulas, values, etc. by choosing options such as "paster formulas only,"

Paste Preview

Has a default value of 8.43 characters, a little less than one inch

column width

A(n) ______ is a built-in formula that uses arguments to calculate information

function

In Excel, MAX and AVERAGE are examples of ______

functions

Normally, you don't need to adjust row heights manually because row heights adjust automatically to accommodate font size changes

true

Predefined formulas in Excel are called functions and can be accessed using the Insert Function button (T or F)

true

T or F. Page Layout View focuses on how the worksheet will look when printed

true

Which formula contains a mixed cell reference?

=($A6+$A$7)*0.20

A ______ is an individual media file, such as art, sound, animation, or a movie

Clip

In Excel, the electronic spreadsheet you work in is called a _____

worksheet

How can the order of precedence in this formula, =C12+C13*F4, be changed so that cells C12 and C13 are added together as the first operation that occurs?

=(C12+C13)*F4

All functions begin with the formula prefix ____

=(equals sign)

Absolute cell reference

$G$6

Mixed cell reference

$G6

In the formula =(G15-G14)*$M$3/4, which mathematical operation is performed first?

(G15-G14)

If cell A1 contained 10, cell A2 contained 2 and cell A3 contained =A1^A2, what would cell A3 show on the worksheet?

100

If cell A1 contained 10, cell A2 contained 2 and cell A3 contained =A1/A2, what would cell A3 show on the worksheet?

5

Double-clicking the column line to the right of a column activates the ____ feature for the column

AutoFit

In the formula =D1+C1/F3, which calculation will be performed first?

C1/F3

The Excel function that returns the number of cells in a range containing numeric data

COUNT

When cells or rows are inserted or deleted in an Excel worksheet, how are cell references affected by the insertion or deletion?

Cell references are automatically adjusted

You can apply attributes and alignment options using the ______ dialog box

Format Cells

You can apply attributes and alignment options using the _____ tab of the Ribbon

Home

A(n) _____ is an entry in a cell that contain text such as "2011 Sales" or "Travel Expenses"

Label

Displays the active cell address

Name box

To prevent round-off errors, use the ______ function

ROUND

To format a cell or range, first you select it, and then you apply the formatting using the _____ or a keyboard shortcut

Ribbon

The ______ option helps fit the data on a single page without making changes to individual margins.

Scale to Fit

You can use ______ to move around in a document that is too large to fit on the screen at once.

Scroll bars

_______ below the worksheet grid let you switch from sheet to sheet in a workbook.

Sheet tabs

Provides a brief description of the active command or task in progress

Status bar

In Excel, a worksheet is contained in a file called a ______.

Workbook

Equal to 1/72 of an inch

point

An Excel user should use a relative cell reference when it is important to ______

preserve the relationship to the formula location

This type of cell reference used to preserve the relationship to the formula location

relative

The Spelling button is found in the Proofing group on the ______ tab on the Ribbon

review

An electronic _____ is an application you use to perform numeric calculations and to analyze and present numeric data

spreadsheet

Predesigned workbook files that contain labels, values, formulas, and formatting

template

You can use predesigned, formatted files called ____ to create new worksheets quickly

templates

When cells are copied using Excel's copy function, what happens to the data in the copied cells?

the data remains in its original location

In the formula =ROUND(D4:F4,0), what does the zero indicate?

the number of decimal places in the rounded number

An Excel user may paste a range of cells in which of the following locations

the same worksheet where the cells were copied and a different worksheet

A predefined set of attributes that gives your Excel worksheet a professional look

theme

Charts are updated automatically in Excel whenever data changes (T or F)

true

In page layout view, the dotted line indicates the print area (T or F)

true

Using the CUT command completely removes data from its original location, whole the COPY command leaves information in its original location (T or F)

true

Using the Fill Handle to copy formulas prevents the Excel user from having to retype formulas in adjacent cells (T or F)

true

You can add words to the dictionary of the spelling checker

true


Ensembles d'études connexes

(intro) 11. Credit and Debt Management

View Set

Chapter 8 - Analyzing Systems Using Data Dictionaries

View Set

nine common decision making biases

View Set

Chapter 8 - Assessing Achievement and Aptitude: Applications for Counseling

View Set

Voc & Grammar 2nd Quarter 2013 G-720/360

View Set

Supply Chain Management: Exam 2: Chapter 5

View Set

Upper Respiratory Conditions(Exam 3)

View Set

Illinois Statutes and Requirements Pertinent to Life Only

View Set