Excel Chapter 3
selects the row
Clicking a row heading ________.
paste options
Clicking the Paste arrow opens the ________ gallery.
cell content and cell formatting
Clicking the Paste button places the ________ in the destination cells.
multiplication
Excel evaluates the formula =4-2*6/2+7 and performs ________ first.
7/5/2017
If a date is typed as 7-5-17, Excel will complete it as ________.
the current year will be inserted
If the year is not entered when typing a date into a cell, ________.
clicking the Rename Sheet option of the Format button in the Cells group on the Home tab
One way to rename a worksheet tab is by ________.
alignment
Options in the Themes group on the Page Layout tab include all of the following EXCEPT ________.
text
When Clear Content is selected from the Clear button options, only the ________ is removed from the cell.
surrounded by a moving border
When a selection has been made and the cut button or copy button is clicked, the selection is ________.
its entire tab is filled with the selected color
When a worksheet is inactive, ________.
group
When multiple worksheet tabs are selected, the title bar displays the word ________ after the name of the workbook.
inserts it into all of the worksheets in the group
When multiple worksheets are grouped, inserting a row ________.
upper left
When pasting a range of cells, you only need to select the ________ corner of the paste area.
all worksheets in the group receive the Total style
When the Total style is applied to a group of worksheets, ________.
subtraction
When the formula =(4-2)*6/2+7 is evaluated in Excel, which will be the first mathematical operation performed?
January 1, 1900
Which date is assigned the serial number of 1?
clustered bar
A ________ chart is useful in comparing values across categories.
summary sheet
A ________ is a worksheet that displays and summarizes totals from other worksheets.
detail sheet
A ________ is a worksheet with cells referred to by summary sheet formulas.
clipping
A screen ________ is a picture of a portion of the computer screen that can be inserted into a worksheet.
shot
A screen ________ is an image of the computer screen.
at the end of the Tab group
A worksheet inserted into a workbook using the New Sheet button is inserted ________.
protect sheet
A worksheet tab can be removed from view by right-clicking the tab and selecting ________ from the shortcut menu.
smartart graphic
A(n) ________ gives a visual representation of information that is used to effectively communicate ideas
parentheses; multiplication or division; addition or subtraction
According to operator precedence, the correct order of mathematical operations is ________.
parentheses
According to the rules of operator precedence, expressions using ________ are calculated first.
enter
After typing the new name of a worksheet tab, press the ________ key to accept the name change.
clear error value
All of the following are options of the Clear button EXCEPT ________.
hyperlink
An example of a(n) ________ is http://www.microsoft.com.
a shortcut menu and a mini toolbar
Right-clicking a row heading displays ________.
worksheet tab
Select All Sheets is an option that appears when a(n) ________ is right-clicked.
single-clicking on any worksheet tab
Sheet tab grouping can be canceled by ________.
display worksheet tabs that are not in view
Tab scrolling buttons are used to ________.
right-clicks on a sheet tab
The Select All Sheets option appears when the user ________.
clipboard
The cut and copy commands make use of temporary storage called the ________.
Ctrl + ;
The keyboard shortcut to insert the current date, obtained from your computer, is ________.
quick acess
The small toolbar that contains buttons for commonly used tasks is the ________ Toolbar.
