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