Excel Chapter 3
a shortcut menu and a mini toolbar
right-clicking a row heading displays ____
worksheet tab
select all sheets is an option that appears when an ____ is right-clicked
single clicking on any worksheet tab
sheet tab grouping can be cancelled by ____
display worksheet tabs that are not in view
tab scrolling buttons are used to ____
=May!B6
the ____ excel formula accurately displays the use of a cell from another worksheet
clipboard
the cut and copy commands make use of temporary storage called the ____
ctrl + ;
the keyboard shortcut to insert the date, obtained from your computer is ____
right clicks on a sheet tab
the select all sheets option appears when the user ____
quick access
the small toolbar that contains buttons for commonly used tasks is the ____ toolbar
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 ____
text
when clear content is selected from the clear button options, only the ____ is removed form the cell
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 cell, you only need to select the ____ corner of the paste area
subtraction
when the formula =(4-2)*6/2+7 is evaluated in excel, which will be the first mathematical operation performed?
all worksheets in the group receive the total style
when the total style is applied to a group of worksheets, ____
january 1, 1900
which date is assigned the serial number of 1?
clustered bar
a ____ is useful in comparing values across categories
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 ____
unhide
a worksheet tab can be removed from view by right-clicking the tab and selecting ____ from the shortcut menu
parentheses
according to operator precedence, expressions using ____ are calculated first
parentheses, multiplication or division, addition or subtraction
according to operator precedence, the correct order of mathematical operation is ____
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 ____ is http://www.microsoft.com
inserts a row above the clicked 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
select the tab's name
double-clicking a worksheet tab will ____
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
SmartArt graphic
a ____ gives a visual representation of information that is used to effectively communicate ideas
summary sheet
a ____ is a worksheet that displays and summarizes total from other worksheets
detail sheet
a ____ is a worksheet with cell referred to by summary sheet formulas