Question 1

in excel, the electronic spreadsheet you work work in is called a ______ A) tablet B) databook C) numericsheet  D) worksheet

Accepted Answer

D) worksheet

Question 2

in excel, a worksheet is contained in a file is called  A) workbook B) workpad  C) notebook  D) datapad

Accepted Answer

A) workbook

Question 3

you can use the spreadsheet to _____ by using variable values to investigate and sample different outcomes  A) represent values graphically  B) organize data  C) create what-if data scenarios  D) perform calculations

Accepted Answer

C) create what-if data scenarios

Question 4

all excel formulas begin with the ____ A) + B) * C) =  D) slash

Accepted Answer

C) equal sign

Question 5

Excel recognizes any entry as a value if it is a number or it begins with _____ A) + B) = C) $ D) all of the above

Accepted Answer

D) all of the above

Question 6

you can use the _____ key(s) on the keyboard to navigate a worksheet  A) [Ctrl] B) zoom C) arrow D) [enter]

Accepted Answer

C) arrow

Question 7

to move one screen to the left press _____  A) [Ctrl][Home] B) [Atl][Page Up] C) [Ctrl][Page Left] D) [Alt][Page Down]

Accepted Answer

B) [Atl][Page Up]

Question 8

to quickly jump to the last cell in a worksheet press ____ A) [Alt][Page Down] B) [Shift Down] C) [Page Down] D) [Ctrl][End]

Accepted Answer

D) [Ctrl][End]

Question 9

the Undo button allows you to reverse up to ____ previous actions, one at a time A) 1 B) 10 C) 100 D) 1,000

Accepted Answer

C) 100

Question 10

Possible paper orientations for printing a worksheet are landscapes and _____ A) preview  B) portrait C) normal D) page break

Accepted Answer

B) portrait

Question 11

In the formula =(G15-G14)*$M$3/4, which mathematical operation if performed first? A) $M$3/4 B) (G15-G14)*$M$3 C) (G15-G14) D) (G15-G140)/4

Accepted Answer

C) (G15-G14)

Question 12

which method of entering a function requires the user to know the name and initial characters of a function?  A) manually typing the function  B) using the Insert Function button C) using the Sum button D) using the Sum list arrow

Accepted Answer

A) manually typing the function

Question 13

when cells are copied using Excel\'s copy function, what happens to the data in the copied cells?  A) the data is permanently deleted from the copied cells  B) the data is temporarily deleted from the copied cells  C) that data remains in its original function  D) the data is moved to another location and removed from its original location

Accepted Answer

C) the data remains in its original location

Question 14

Which tab and group will allow the insertion of rows and columns in a worksheet?  A) HOME tab, Styles group B) PAGE LAYOUT tab, Page Format group C) HOME tab, Cells group D) PAGE LAYOUT tab, Cells group

Accepted Answer

C) HOME tab, Cells group

Question 15

to insert cells, click the Insert list arrow in the Cells group on the _____ tab, then click Insert Cells  A) HOME B) CELLS C) INSERT D) TOOLS

Accepted Answer

A) HOME

Question 16

an Excel user should use a relative cell reference when it is important to ____. A) preserve the relationship to the formula location  B) never change the formula  C) preserve the exact cell address in a formula  D) memorize the formula

Accepted Answer

A) preserve the relationship to the formula location

Question 17

which formula contains a mixed cell reference?  A) =(A6=A7)*.20 B) =($A$6+A7)*.20 C) =($A$6+$A$7)*.20 D) =($A6+$A$7)*.20

Accepted Answer

D) +($A6+$A$7)*.20

Question 18

A(n) ____ cell reference tells excel to substitute new cell references within the copied formulas as necessary.  A) mixed B) absolute C) relative D) parameter

Accepted Answer

C) relative

Question 19

Which of the following is NOT a Paste list arrow option? A) pasting values only  B) pasting values with number formatting  C) pasting cell selectors  D) pasting formulas only

Accepted Answer

C) pasting cell selectors

Question 20

t0 continue a sequence in adjacent cells, such as months of the year, use the ____ feature of Excel.  A) SUM function B) redo C) fill handle  D) copy/paste

Accepted Answer

C) fill handle

Question 21

Excel templates make a creating a professional looking spreadsheet easier by including all of the following EXCEPT ____ in the template A) formulas B) formatting C) labels D) data

Accepted Answer

D) data

Question 22

the file extension .xltx indicates what type of Excel file? A) excel template  B) excel workbook C) excel worksheet D) excel formulas only worksheet

Accepted Answer

A) excel template

Question 23

the default file extension for an Excel 2013 workbook is ____ A) .xltx B) .xslx C) .xlsx D) .xlts

Accepted Answer

C) .xlsx

Question 24

the ____ of a cell determines how the labels and values look.  A) value B) formula C) label D) format

Accepted Answer

D) format

Question 25

the default Accounting number format adds dollar signs and ____ decimal places to the data  A) one B) two C) three D) four

Accepted Answer

B) two

Question 26

to apply a table style, select the data to be formatted or click anywhere within the intended range (Excel can automatically detect a range of cells), click the Format as Table button in ____ group on the HOME tab, and the clock a style in the gallery.  A) Alignment  B) Styles C) Cells  D) Editing

Accepted Answer

B) Styles

Question 27

In the _____ window you can search for online pictures (or Clip Art) in Office.com, through the Bing search engine, or on your SkyDrive.  A) Find Images B) Insert Pictures  C) Add Clip Art D) Add Images

Accepted Answer

B) Insert Pictures

Question 28

you can apply font styles and alignment options using the ____ tab of the Ribbon A) INSERT B) HOME C) PAGE LAYOUT D) VIEW

Accepted Answer

B) HOME

Question 29

You can apply font styles and alignment options using the _____ dialog box  A) format cells  B) insert C) conditional formatting  D) autocorrect

Accepted Answer

A) format cells

Question 30

Font _____ are formats such as bold, italic, and underlining that you can apply to affect the way text and numbers look in a worksheet A) styles B) formats C) fonts D) clip arts

Accepted Answer

A) styles

Question 31

the format painter button is found in the _____ group on the HOME tab of the Ribbon.  A) Alignment  B) Styles  C) Clipboard  D) Font

Accepted Answer

C) Clipboard

Question 32

which of the following removes only the contents of a selected row or column A) the Delete button B) the [Delete] key C) the Delete common on a shortcut menu D) All of the above

Accepted Answer

D) all of the above

Question 33

you insert a comment in a worksheet by using a command on the ____ tab on the Ribbon A) HOME  B) REVIEW C) INSERT D) VIEW

Accepted Answer

B) REVIEW

Question 34

____ shows you how a fill color will look before you apply it A) Sneak Peek  B) Live Preview C) Quick Look D) Advance Look

Accepted Answer

B) Live Preview

Question 35

a theme can be applied using the Themes button in the Themes group on the ____ tab on the Ribbon A) HOME B) DATA C) PAGE LAYOUT D) REVIEW

Accepted Answer

C) PAGE LAYOUT

Question 36

the default format for cells that meet a condition with conditional formatting is  A) dark blue fill with light red text B) light red fill with dark red text  C) light blue fill with dark blue text D) dark red fill with light red text

Accepted Answer

B) light red fill with dark red text

Question 37

if you create a conditional formatting rule you can modify it using the Conditional Formatting _____ A) Rules Options dialog box  B) Rules template C) Rules Wizard  D) Rules Manager

Accepted Answer

D) Rules Manager

Question 38

you can add multiple worksheets to a workbook by clicking the HOME tab on the Ribbon, pressing and holding ____, and then clicking the number of existing worksheet tabs that correspond with the number of sheets you want to add, clocking the Insert list arrow in the Cells group on the HOME tab, then clicking Insert Sheet.  A) [Esc] B) [Shift] C) [F4] D) [Alt]

Accepted Answer

B) [Shift]

Question 39

the spelling button is found in the proofing group on the _____ tab on the Ribbon.  A) HOME  B) PAGE LAYOUT C) REVIEW D) DATA

Accepted Answer

C) REVIEW

Question 40

each value in a cell selected for a chart is called a ____ A) data marker  B) tick mark C) data point  D) data series

Accepted Answer

C) data point

Question 41

A(n) ____ chart compares distinct object levels using vertical bars; it is the Excel default.  A) line  B) area C) column D) pie

Accepted Answer

C) column

Question 42

To show how individual volume changes over time in relation to total volume, us a(n) ______ A) area chart B) bar chart C) column chart D) line chart

Accepted Answer

A) area chart

Question 43

a pie chart ______ A) compares distinct, unrelated objects over time using a horizontal format B) compares trends over even time intervals  C) compares trends over uneven time or measurement intervals  D) compares sizes of pieces as part of a whole

Accepted Answer

D) compares trends over uneven time or measurement intervals

Question 44

a combination chart can add a(n) ____ axis to chart related data  A) combo  B) secondary C) tertiary D) clustered

Accepted Answer

B) secondary

Question 45

In a pipe chart, slices that are pulled away are said to be ____ A) identified  B) exploded C) opened  D) extracted

Accepted Answer

B) exploded

Question 46

a common example of a text delimiter is ____  A) , B) = C) + D) (

Accepted Answer

A) ,

Question 47

the CONCATENATE function joints two or more ___ into one.  A) strings B) formulas C) cells D) function

Accepted Answer

A) strings

Question 48

which excel function averages cells in a range based on a specific condition?  A) AVERAGEIF B) AVERAGE C) COUNTIF D) SUMIF

Accepted Answer

A) AVERAGEIF

Question 49

which button do you click on the Function Library group to select SUMIf from the list of functions?  A) statistical  B) Math & Trig  C) Math Functions  D) Trig & Calculus

Accepted Answer

B) Math & Trig

Question 50

Which error code will display if a formula contains a text error?  A) #NA  B) #NUM! C) #NAME? D) #####

Accepted Answer

C) #NAME?

Question 51

Which error code will display if a value in a formula is not available?  A) #NAME? B) #VAL C) #NONE D) #NA

Accepted Answer

D) #NA

Question 52

which error code will display if a number is used invalidly in a cell?  A) #NUM! B) #VAL C) #VALUE! D) #NAME?

Accepted Answer

A) #NUM!

Question 53

when used in formulas, names become ____ cell references by default.  A) absolute  B) relative C) linked D) unlinked

Accepted Answer

A) absolute

Question 54

which of the following is not a valid named range?  A) Alaska59 B) New quote C) salary D) Top_Sales

Accepted Answer

B) New Quote

Question 55

a condition that can be answered with a true or false response is called a(n) ____  A) logical test B) what-if analysis C) True_False condition  D) IF analysis

Accepted Answer

A) logical test

Microsoft Offie Excel Units A,B,C,D & E – Flashcards

Unlock all answers in this set

Haven't found what you were looking for?

Search for samples, answers to your questions and flashcards