Unit 5-8 EXCEL, Unit 9-11 EXCEL, Unit 1-4 EXCEL

If I wanted the cell reference B29 to remain absolute in a formula I would choose

$B$29

Which collection of symbols below reflects the correct Order of Precedence

() ^ / * + -

Excel Workbooks can be saved with the following extensions except

.BDA

From the list below, which file extension could be used for a file you wish to upload to the Internet.

.PDF .HTML .XLSX

From the file types below, which designates a compressed file

.ZIP

Which formula(s) below correctly calculates the mortgage payment of $1,073.64 (a positive number), which is based on a 5% yearly interest rate over 30 years for a $200,000 loan

=-PMT(0.05/12,360,200000) ,=-PMT(0.05/12,12*30,200000), and =-PMT(0.05/12,(12*30),200000)

Which of the nested IF functions below is correct

=IF(A1>=89.5%,"A",IF(A1>=79.5%,"B",IF(A1>=69.5%,"C",IF(A1>=59.5%,"D","F"))))

Given A18=25, B18=23 and B19=35, which IF function below will return the text "Re-Do" in the active cell

=IF(B18>=$A$18,"OK","Re-Do")

Which of the following is a correct SUM function that adds cells A1:A10

=SUM(A1:A10)

Which Function below will return the current date only, into the active cell

=TODAY()

A formula can contain

A Function, Cell references, and Constants

Cells with a triangle-shaped indicator in the upper right corner indicates

A comment has been inserted

A sock is to a drawer as

A file is to a folder

An Operator is defined as

A sign or symbol that specifies the type of calculation to perform within an expression

To access the filtering controls you must

Click on the arrow icon in the Header

Navigating through a Workbook can be done by

Clicking on the desired sheet name and Right clicking the area left of the first sheet and selecting the desired sheet

You can modify commands on the Quick Access toolbar by

Clicking the more arrow at the Quick Access toolbar and From the Backstage view click Options

Which type of chart illustrates data changes over a period of time

Column

The Paste Special feature can be used for all the following except

Column Height

Data that is arranged in _____________and ____________can be plotted into a chart

Columns / Rows

The difference between move and copy is

Copy leaves the file in the original location whereas move does not

Any version of Excel can open any version of an Excel workbook

False

A Slicer is useful because it clearly indicates what data is shown in your table after you __________ your data

Filter

Using AutoFill to fill cells with data works by

Following a pattern

A quick way to copy formats to other cells is to use the

Format Painter icon

Once you are in Excel online (the Excel Web App) you can edit the workbook in one of two ways

In your Browser or Local Excel application

Using the Wrap Text command does what to a cell

Increases the size of the cell to accept multiple lines of text

When you create a formula that contains a function you can use the ____________ dialog box

Insert Function

By right-clicking any worksheet you can

Insert a new worksheet, Change the worksheet tab color, and Hide a worksheet

Comments added to a shared Excel workbook can be

Inserted, Deleted, Viewed, Edited and Printed

If only two individuals are sharing a workbook, using the email/attachment approach is probably the easiest. However, if more than 2 users need to share/update a workbook a business __________ may be used.

Intranet

Hyperlinks in Excel 2013 can be used to

Jump to any cell in a workbook, Access the Internet, and Jump to any cell in a worksheet

Manipulating window views of the same worksheet is very useful when dealing with

Large amounts of data in the worksheet

The Name box is located to the

Left of the Formula bar

A Cell reference will contain the following

Letter and Number in that order

By default when you protect a worksheet all the cells on the worksheet are

Locked

The purpose of making a cell reference absolute is to

Maintain the original cell reference even after the formula is copied

The Name command is used to

Make formulas easier to understand and maintain

The Ribbon across the top of the Workbook

May be modified from the Ribbon itself and May be modified from the Ribbon itself

Applying a Background to a worksheet

Might enhance the readability

Using Fill Series can

Save time when entering data, Prevent mistakes in typing, and Start with a value of your choice

One way of displaying the actual formulas on a worksheet is to

Select Show Formulas icon from the FORMULAS tab

Creating a Drop-down list from which users can select from is started by

Selecting DATA then Data Validation

Excel 2013 allows the user to access external sources of data by

Selecting the DATA tab from the Ribbon then Get External Data icon

Workbook views can be changed by

Selecting the appropriate command from the Ribbon and Selecting the appropriate icon on the bottom right of the Workbook

To simultaneously share/update a workbook the owner must first label the workbook as sharable by clicking the ______________ icon in the _______________ group under the ________ tab on the Ribbon

Share Workbook / Changes / Review

If you double-click a file with xlsx as the extension the Excel application should open

True

When displaying multiple views or windows of a worksheet any change to one window is reflected in the others

True

To put data on multiple lines within a cell you can

Use the Wrap Text command and Depress the Alt + Enter key

The order of worksheets can be changed by

Using Drag and Drop

Constants can be added, subtracted, multiplied and divided to cells by

Using Formulas, Using Functions, Using Paste Special

All formulas in Excel start with

an = sign

To open the Name Manager dialog box use the following procedure

click FORMULAS then Name Manager on the Ribbon

Exported data that is linked from an Excel Workbook

Can be changed from the originating point impacting the destination point

Once cells are Merged they

Can be un-merged

Multiple window views of a worksheet can be arranged by

Cascading

The Name command in Excel is a word or string of characters that represents a

Cell or range of cells, Formula, and Constant value

One way to modify a cell is to use the ____________ group under the __________ tab on the Ribbon

Cells / HOME

Merging cells is a way to

Center the contents of a cell across multiple cells

A formula that contains a relative cell reference____________ as you copy it from one cell to another

Changes

When creating an Excel table if you do not check My table has headers in the Create Table dialog box

Default header names will be assigned

You can define a name for a cell range by using the

Define Names in the FORMULA tab

If you only wanted to print a section of a worksheet you would

Define the selection by selecting the cell range and then select Print area then Set Print Area from the PAGE

Individual Mouse pointers or shapes that appear while manipulating a Workbook include all but

Delete Cell

With a worksheet active, selecting the Format icon from the Cells group in the HOME tab allows the user to do all but

Delete a worksheet

With any worksheet active depressing the Ctrl + Tilde key will

Display any formulas or functions

Excel workbook files can be opened by

Double clicking on the file itself, and Starting Excel and opening the file from there

To pin an application icon to the Task bar you can

Drag the icon down to the Task bar (left or right mouse button), and Right-click the application icon and select Pin to Task bar

From the Backstage view you can select Protect Document allowing you to

Encrypt with a password

The Backstage view in Excel may be used to do all the following except

Enter data into a worksheet

Graphics cannot be inserted in an Excel workbook because

Excel only recognizes numbers, Excel only recognizes formulas, and Excel is not a text processor None of the above

Users can save Excel Workbooks in many different file formats by

Exporting the file and Using the Save As function from the Backstage

The order in which Excel performs operations (Order of Precedence) in formulas is _______________

Extremely important

To see how your workbook would look when it is printed you should be in

Page Layout view

The Order of Precedence can be correctly changed by using

Parentheses

Clip Art is nothing more than ____________ and _____________ that can be used to ____________ your workbook

Pictures / illustrations / enhance

______ charts show the size of items in one data series, proportional to the sum of the items

Pie

A quick way to widen a Column or Row is to

Place the cursor over a Column/Row boundary and drag to the correct size

Selecting Transpose as a Paste option does what

Reverses Column and Row headings

The Vertical scrollbar appears on the _______side of the Workbook and the Horizontal scrollbar appears on the _______side

Right / Bottom

The order in which Excel performs operations may be called

Calculation order, Operator precedence, and Order of Precedence

An Active cell is designated by

A thick border around the cell

Testing whether conditions are true or false and making logical comparisons between expressions can be done with which Functions below

AND, OR functions, NOT, and IF

Double-clicking the Format Painter icon in the Clipboard group on the HOME tab does the following

Activates the Format Painter command and keeps it activated until you depress the Esc key

Sorting can only be performed on data in Table format in Excel. In other words data in a simple range cannot be sorted.

Always False

When you depress the PrtSc key on the keyboard the following events happen

An image of all open windows are copied into the Windows Clipboard

When you put a data range into a table, filtering controls called ____________ are added to the table headers automatically

AutoFilter

The Worksheet names appear across the

Bottom of the Workbook

The Conditional Formatting Rule Manage dialog box allows you to

Create a New Rule, Edit or Delete Rule, and Re-order Rules

Microsoft Windows Explorer can be used to do all but

Create documents

Cell data can be manipulated by using

Cut and Paste, Copy and Paste, Drag and Drop

Conditional formatting is a great way to quickly focus on a cell or cell range. You can use the following to format the cells

Data Bars, Color Scales, and Icon Sets

Data ranges in Excel can be converted to an Excel table by

Formatting the range as a Table

It is a good idea to apply a Number Format to cells that you will be using in a

Formula

To keep an area of a worksheet visible while you scroll through the worksheet you can use the

Freeze Panes command

Excel Workbook properties can be viewed

From any worksheet but only when the Show Documents properties panel is selected

From the Backstage Options tab the user can access

General options for working with Excel and Language preferences and The Trust Center

You can go directly to any location in a Workbook by using the

Go To command

To delete an Excel Worksheet you can do the following

Highlight the sheet and select Delete from the HOME tab then Delete Sheet

If you just wanted to print the Formula and not the results you

Must first make the formula visible by selecting FORMULAS then Show Formulas from the Ribbon

Entering data into a worksheet is usually done in

Normal view

The Quick Access Toolbar is located

On the top left of the Workbook

Gridlines in an Excel Worksheet

Outline Cell borders

In MS Excel 2013 the Ribbon commands can be accessed via Keyboard Shortcuts by doing the following

Pressing the Alt key

excel 2013 allows the user to export data as _________ and ___________ data

Static / Dynamic

The Ribbon appears across the top of an Excel Workbook and it contains the following

Tabs containing major workbook commands and Groups or categories with sub-commands

A Windows Folder can contain the following

Text Files, Graphic Images, and Other Folders

Depending on the type of data that is in your table you can sort/filter on

Text, Numbers, and Cell Color

To make a cell reference Absolute one must

The $ symbol

From the Print command in the Backstage view you can print

The Active worksheet only, Pre-selected portions of an active worksheet, and An entire workbook

Excel Workbook properties can be configured from

The Backstage view

Excel Templates may be accessed from

The Backstage view then selecting New

When you print a worksheet containing Formulas what is printed by default is/are

The Results of the Formula

Headers and Footers can be placed on Worksheets from

The Ribbon and the Backstage view

Headers and Footers can only be Modified/Customized from

The Ribbon and the Backstage view

Page Setup may be accessed from

The Ribbon and the Backstage view

Print Orientation refers to

The way the page is presented/printed either Portrait or Landscape

A Digital Signature provides assurances about the ____________ and ___________ of a digital document

Validity / Authenticity

What is the purpose of the Split screen/pane function in Excel

View portions of a very large worksheet/spreadsheet in the same screen

In Excel a name is a(n) __________________ that represents a cell, range of cells, formula or constant value

Word or string of characters

The difference between an Excel Workbook and Worksheet is

Workbooks contain Worksheets

Selecting Print Titles for a Worksheet is useful when the

Worksheet is large and spans multiple pages

One way to share Excel files with other users is to send the Excel Workbook over email as an attachment with the following extensions

.PDF .XPS and .XLSX

Which Excel formula below yields 21 as the answer

=(5+2)*3

Which formula(s) below will return the correct average of cells A1, A2 and A3

=AVERAGE(A1:A3)

To prevent a user from changing data in a worksheet or workbook you can protect the worksheet or workbook with or without

A Password

A workbook's structure can be protected requiring a password before

Adding worksheets, Deleting worksheets, and Hiding worksheets

The Merge cells icon is found in the __________ group on the __________ tab

Alignment / HOME

Comments can be printed as they ______________ on the worksheet or at the _________ of the worksheet

Appear / end

To improve the readability of Excel Workbooks one can

Apply Styles to cell ranges, Format cell ranges, and Change Font styles

_______ charts illustrate comparisons among individual items

Bar

When you create tables in Excel the advantages you get are

Built-in filtering

Hiding, locking and protecting workbook and worksheet elements is not intended to

Help secure or protect confidential information

In a ______ chart, category data is distributed evenly along the horizontal axis and all value data is distributed evenly

Line

When you move the cursor over an icon in Excel 2013 in some instances a text message appears which is called

Live Preview

One discussed way to remember the correct Order of Precedence, is to create a

Mnemonic

Hash marks in a cell indicates what

The cell is too small to fit the data

Once a Row or Column is hidden

They can still be deleted

Before you protect a worksheet, you can ________ the ranges that you want users to access

Unlock

Microsoft Excel Web App allows you to

Work on workbooks with users with other versions of Excel

Sometimes it is beneficial to base a new workbook on an existing

Workbook and Template

Formulas can contain cell references, constants and other

Worksheets

The Freeze Panes command is not available when

You are entering data or a formula into a cell

Custom views can be created to save specific display settings such as

Column widths, Row Heights, and Hidden rows and columns

If saved changes to a workbook conflict the user is prompted with a

Conflict resolution dialog box

When you select an image on an Excel worksheet the PICTURE TOOLS tabs becomes visible, this is called

Contextually aware

In order to Hide Rows and Columns they must be contiguous

False

SmartArt is a special type of _______ object that gives you the ability to construct fancy graphical lists and diagrams in your worksheet quickly and easily

Graphic

Excel 2013 has the capability of inserting ____________ without leaving the application

Graphics, Text, and Screenshots

The quickest way to edit multiple worksheets at the same time is to

Group the worksheets

The Alignment group, Number group, Cells group and the Format Painter are all accessed via the _________ tab on the Ribbon

HOME

When formatted data in a cell is deleted by selecting the cell and hitting the delete key or by right-clicking the cell and selecting Clear Contents the following occurs

Only the data in the cell is deleted

Excel provides several ways to protect a workbook by allowing you to require a password to _______ a workbook and or _________ data in a workbook

Open / Change

Functions are ___________ formulas that perform calculations

Predefined

One reason to use Charts in an Excel Workbook is to

Present information visually

Rows and Columns on a worksheet can be hidden from view for

Printing reasons

To ensure that a worksheet is printed on one page the following can be done

Reduce the font size row height and column width, Select Fit Sheet on One Page from the Scaling box in the Backstage view, and Reduce the margins

There are four different types of calculation operators: arithmetic, comparison, text concatenation and

Reference

By default a cell reference is _________________

Relative

Cell references can be

Relative, Mixed, and Absolute

A formula that contains an absolute cell reference _____________ as you copy it from one cell to another

Remains the same as far as the Absolute cell reference is concerned

A _____________ is a very small chart that is typically drawn without axes or coordinates

Sparkline

Your Microsoft OneDrive (formerly called SkyDrive) can be accessed from

The Backstage view