Practice Exam #3-MS Excel and Integration

Excel templates make creating a professional looking speadsheet easier by including all of the following except ___ in the template.

data ?

Each value in a cell selected for a chart is called a ____.

data point

all Excel formulas begin with the ___

equal sign (=)

in a worksheet, the ___ is called the formula prefix.

equal sign (=)

A named range can begin with a letter or number.

false

An Excel 2016 workbook has the file extension .xml.

false

The area inside the horizontal and vertical axes is the legend.

false

The font size is measured in units called pixels.

false

You can change header and footer information using the Margins Design tab that opens on the Ribbon when a header or footer is active.

false

a bar chart and column chart are equivalent chart types in excel.

false

a cell reference that does not change when it is copied is called a(n) relative cell reference.

false

according to the order of precedence for arithmetic operators, operations contained within parentheses are performed last.

false

achart must be located n a specific cell or at a specific address range.

false

an absolute cell reference changes the cell references when the formula is copied to a new location.

false

chart annotations are labels that further describe you data.

false

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

false

wordart can be created using the chart tools format tab.

true

you can close the Office Clipboard pane by clicking the dialog box launcher in the clipboard group

true

functions can be entered for formulas using all of the following methods except ____ .

typing the function argument

you can create an absolute cell reference by placing a ___ in front of both the column letter and the row number of the cell address.

$

the default file extension for an Excel 2016 workbook is ___.

.xlsx

the ____ sheet button allows you to add worksheets to a workbook.

New

which keyboard short cut turns on Edit mode?

[F2]

The Excel operator for exponent is ___.

^

a pie chart _______.

compares sizes of pieces as part of a whole

the horizontal axis is also called the value axis.

false

the increase decimal button automatically adds dollar signs and two decimal places to you data.

false

you can ___ the chart title text to select it

right-click ?

a chart sheet is a sheet in a workbook that contains only a chart, which is linked to the workbook data.

true

a(n) mixed reference means that either the column or row reference in the formula is absolute, but not both.

true

An Excel complex formula uses more that one arithmetic operator.

true

To print the formulas in a worksheet, click the Formulas tab, the click the Show Formulas button in the Formula Audition group

true

=D8+E8*0.5 is a complex formula.

true

In excel, a worksheet is contained in a file called a ___.

workbook

Who is the best student?

you are!

Predefined formulas in Excel are called functions and can be accessed using the insert function button.

true

Printing gridlines makes data easier to read.

true

You are in Edit mode any time you are entering or changing the contents of a cell.

true

You use formulas in Excel to perform calculations such as adding, multiplying , and averaging

true

according to the order of precedence, the formula =(2585)/5 would calculate the result of 10.

true

any data changed in the worksheet is automatically updated in the chart.

true

dragging the fill handle across a range of cells copies the contents of the first cell into the other cells in the range.

true

excel includes a(n) scenario manager where you can name and save different what-if versions of your worksheet.

true

one of the ways to change your view of the worksheet window is by using the view tab on the Ribbon

true

the chart elements button makes it easy to add, remove, and modify individual chart objects,

true

the z-axis of 3-D charts is used for comparing data across both categories and values.

true

using the mouse, you can drag or double-click the right edge of a column heading to change the column width.

true

when you change a theme, cell styles are automatically updated.

true

with Excel, you can adjust the width of one or more columns by using the mouse.

true

with auto fill, dragging the fill handle on a cell copies the cell's contents or continues a series of data into adjacent cells.

true

you can add words to the dictionary of the spelling checker.

true

you can apply formatting before or 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

you can create multiple charts based on the same worksheet data.

true

you can format the text in a chart object using the home tab or the mini toolbar.

true

you can print a chart by itself or as part of the worksheet,

true

you can use a named rang instead of a cell address in a formula.

true

you can use buttons on the insert tab of the ribbon to create a chart.

true

the default accounting number format adds dollar signs and ___decimal places to the data.

two

you can change column chart to a clustered bar chart using the _____dialog box.

Change Chart Type

to display gridlines on a worksheet, click the Gridlines check box in the ____ group on the view tab.

Show

to quickly jump to the last cell in a worksheet press____.

[Ctrl][End]

you can use the ___ key(s) on the keyboard to navigate a worksheet.

arrow

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.

to remove all formatting for a selected range, click the _______button in the editing group on the home tab.

clear

a(n) ____ chart compares distinct object levels using vertical bars; it is the Excel default.

column

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

column is too narrow to display the value completely

you can use a spreadsheet to ____ by using variable values to investigate and sample different outcomes.

create what-if data scenarios

In an electronic spreadsheet, you need to manually recalculate when you change the entries

false

Labels are numbers, formulas, and functions that can be used in calculations.

false

Office Lite includes simplified version of the apps found in the Office 2016 suite.

false

double-clicking the right edge of a column heading activates the autosize feature which automatically resizes the column to accommodate the widest entry in the column.

false

in a pie chart, you can emphasize one data pint by plotting, or pulling that slice away from, the pie chart.

false

table styles are organized in four categories: Black & white, light, medium, and Dark.

false

the count function in Excel returns the number of all cells in a range that contain any type of data.

false

tick marks appear on the horizontal axis of a chart.

false

to insert the AVERAGE function into a cell, click the cell, click the Function Options list arrow in the Editing group on the Home tab, and then click Average.

false

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

false

Charts are updated automatically in Excel whenever data changes

true

all functions begin with the formula prefix ____.

= (equal sign)

which formula contains a mixed cell reference?

=($A$6+$A$7)*0.20 ?

Excel reconizes an entry as a value if it is a number or it begins with ____.

All of the above

a collection of related data points is called a _____.

data series

a chart that is inserted directly in the current worksheet is called a(n) ________chart.

embedded

After you use the fill handle to copy cell contents, the quick copy options button appears, which can be used to fill the cells with only specific elements of the copied cell, if you wish.

false

to hid a selected column, click the ______ button in the cells group on the Home tab.

format

While you are entering a formula in a cell, the cell references and arithmetic operators appear in the ___

formula bar

a(n) ___ is a built-in formula that uses arguments to calculate information.

function

in Excel, MAX and AVERAGE are examples of ________

functions

to insert cells, click the Insert list arrow in the Cells group on the ____ tab, then click insert cells.

insert

you can edit the contents of the active cell by ___

just starting to type

a small, ____triangle appears in the upper right corner of a cell containing a comment.

red

a (n) ____ cell reference tells Excel to substitute new cell references with in the copied formulas as necessary.

relative

the spelling button is found n the proofing group on the _____ tab on the Ribbon.

review

to format a cell or range, first you select it, and then you apply the formatting using the ____, the mini toolbar, or a keyboard shortcut.

ribbon

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

scroll bars

A combo chart can add a(n) ____ axis to chart related data.

secondary

An electronic ____ is an application you use to perform numeric calculations and to analyse and present numeric data.

spreadsheet

Font ___ are formats such as bold, italic, and underlining that you can apply to affect the way text and numbers look in a worksheet.

styles

you can use predesigned, formatted files called _______________ to create new worksheets quickly.

templates

once th office clipboard reaches its maximum of 24 items, how does it handle new items that are copied or cut?

the clipboard automatically deletes the oldest item on the clipboard