Excel Chapter 3

Lakukan tugas rumah & ujian kamu dengan baik sekarang menggunakan Quizwiz!

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


Set pelajaran terkait

kinesiology 370 statistics chapter 1-4 test bank

View Set

Chapter 3 - Life Insurance Policies

View Set

Chapter 17: Breasts and Regional Lymphatics

View Set