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