Microsoft Excel 2016 Exam Review

Pataasin ang iyong marka sa homework at exams ngayon gamit ang Quizwiz!

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.

AVERAGE

The ________ button assigns a fixed dollar sign to the numbers in a selected range, with the dollar sign to the far left spaces between it and the first digit in the cell.

Accounting Number Format

The Percent Style button instructs Excel to display a value as a percentage, determined by multiplying the cell entry by 100, rounding the result to the nearest percent, and adding a percent sign.

True

The most common error when entering a formula is to reference the wrong cell in the formula.

True

To add a pie chart, first select the data to be charted and then tap or click the Insert Pie or Doughnut Chart button (INSERT tab - Charts group)

True

To select a number format, you can choose a category in the Number tab in the format Cells dialog box and then select the number of decimal places, whether or not dollar sin should be displayed, and how negative numbers should appear.

True

When text is longer than the width of a column, Excel displays the overflow characters in adjacent cells to the right as long as those adjacent cells contain no data.

True

You can press the RIGHT ARROW or LEFT ARROW keys to position the insertion point during in-cell editing.

True

The ______ button allows you to erase recent cell entries.

Undo

Charts can either be embedded in a worksheet or placed in a separate _________.

chart sheet

A _______ is text and graphics that print at the bottom of every page.

footer

You _____ a worksheet to emphasize certain entries and make the worksheet easier to read and understand.

format

A ______ function is a prewritten formula that is built into Excel.

function

__________ refers to cells not wide enough to display the entire entry

#####

If formulas located in other cells reference cells in a deleted row or column, Excel does not adjust these cell references but instead displays the _____ error message.

#REF!

What effect does the Accounting Number Format have on the selected cells.

Displays cell contains with two decimal places that align vertically.

What effect does the Comma Style format have on the selected cells?

Displays cell contents with two decimal places and commas as thousands separators

Which of the following happens when you enter the formula =G15 into a cell?

Excel assigns the value in cell G15 to the active cell

A thin red border indicates the active cell.

False

An asterisk (*) following a cell reference in a formula is the arithmetic operator that directs Excel to prefrom the division operation.

False

The underline format underlines the entire cell, not just the characters in the cell.

False

When you magnify a worksheet, Excel enlarges the view of the characters on the screen and displays more rows and columns.

False

You can select nonadjacent ranges using the SHIFT key.

False

You cannot format an entire column at once.

False

The _______ AutoComplete list contains those functions that alphabetically match the letters you type following the equal sign.

Formula

A ______ chart provides a simple way to show trends and variations in a range of data within a single cell.

Sparkline

Which of the following is an extension of the fill pattern Sunday, Tuesday>

Thursday, Saturday, Monday

A relative cell reference instructs Excel to adjust the cell reference as it copies it to the destination area.

True

Excel attempts to guess which cells you want to include in the function by looking for ranges that are adjacent to the selected cell and that contain numeric data.

True

Excel has more than 400 functions that preform just about every type of calculations you can imagine.

True

The equal sign (=) precedes a formula.

True

Which of the following formulas contains an absolute cell reference?

=$b$4

When assigned to a cell, the _____ function returns the current date and time formatted as a date and time.

NOW

The default view in Excel is called ______ view.

Normal

_______ view allows you to create or modify a worksheet while viewing how it will look in printed format.

Page Layout

To print a range of cells in the active worksheet, click ______ in the Settings area in the Print gallery.

Print Selection

The Sum button menu allows you to enter one of five often-used functions easily into a cell.

False

The range automatically selected by Excel is always correct.

False

You should press the SPACEBAR to clear a cell.

False

A _______ is text and graphics that print at the top of each page.

Header

The _____ function is useful when you want to assign a value to a cell based on a logical test.

IF

The ______ function displays the highest value in a range.

MAX

The _____ function determines the lowest number in a range.

MIN

You can enter the correct range in a function by typing the beginning and ending cell references separated by a ______/

Colon (:)

When you set up a worksheet, you should use cell references in formulas whenever possible, rather than ______ values.

Constant

Excel can display characters in only three font colors: black, red, and blue.

False

Combining two or more selected cells into one is called ____ cells.

merging

When more than one arithmetic operator is involved in a formula, Excel follows the same basic order of _______ that you use in algebra.

operations

The INCREASE INDENT button indents the contents of a cell to the right by _____ spaces each time you click it.

two

An Excel ______ allows data to be summarized and charted easily.

worksheet


Kaugnay na mga set ng pag-aaral

Needed are Hard & How to Overcome Them

View Set

General insurance practice questions

View Set

Chapter 11 Legal Environment of Business

View Set

Chapter 22 Test Review-Civil War-Davis

View Set

Dosage Calculations Assignment Quiz

View Set

Insurance Policies Common to All Lines

View Set

Exam 1 Botany 201 Chapter 1, 4, 5

View Set

OS Installation & Upgrade Methods core 2

View Set