Excel chapter 3
Clicking the paste button places the what in the destination cells
Cell content and cell formatting
All of the following are options of the clear button except
Clear error value
One way to rename a worksheet tab is
Clicking the rename sheet option of the format button in the cells group on the home tab
The cut and copy commands make use of temporary storage called
Clipboard
The keyboard shortcut to insert the current date is
Ctrl + ;
Tab scrolling buttons are used to
Display worksheet tab that are not in view
After typing the new name of a worksheet tab, press the ____ to accept the name change
Enter key
=B6!May
Excel formula accurately displays the use of a cell from another worksheet
SmartArt graphic
Gives a visual representation of information that is used to effectively communicate ideas
When multiple worksheet tabs are selected, the title bar displays the word _______ after the name of the workbook
Group
Example of a hyperlink
Http://www.microsoft.com
Screen shot
Image of the computer screen
When multiple worksheets are grouped, inserting a row
Inserts it into all of the worksheets in the group
When a worksheet is inactive
It's entire tab is filled with the selected color
Which date is assigned the serial number of 1
January 1, 1900
Excel evaluates the formula =4-2*6/2+7 and performs
Multiplication first
According to the rules of operator precedence, expressions using ______ are calculated first
Parentheses
According the operator precedence, the correct order of mathematical operations is
Parentheses, multiplication or division, addition or subtraction
Clicking the paste arrow opens the
Paste options gallery
Screen clipping
Picture of a portion of the computer screen that can be inserted into a worksheet
The sect all sheets option appears when the user
Right clicks on a sheet tab
Clustered bar chart
Useful in comparing values across categories
Select all sheets is an option that appears when _____is tight clicked
Worksheet tab
Summary sheet
Worksheet that displays and summarizes totals from other worksheets
If a date is typed as 7-5-17, excel will complete it as
7/5/2017
Detail sheet
A worksheet with cells referred to by summary sheet formulas
Options in the themes group on the page layout tab include all of the following except
Alignment
When the total style is applied to a group of worksheets
All worksheets in the group receive the total style
Right clicking a row heading displays
An options button
A worksheet inserted into a workbook using the new sheet button is inserted
At the end of the tab group
Double clicking a worksheet tab will
Select the tabs name
Clicking a row heading
Selects the row
Sheet tab grouping can be canceled by
Single clicking on any worksheet tab
Quick Access Toolbar
Small Toolbar that contains buttons for commonly used tasks
When the formula =(4-2)*6/2+7 is evaluates in excel, the first mathematical operation performed is
Subtraction
When a selection has been made and the cut button is clicked, the selection is
Surrounded by a moving border
If the year is not entered when typing a date into a cell
THe current year will be inserted
When clear content is selected from the clear button options, only the what is removed from the cell
Text
A worksheet tab can be removed from view by right clicking the tab and selecting
Unhide
When pasting a range of cells, you only need to select the
Upper left corner of the paste area
