We use cookies to give you the best experience possible. By continuing we’ll assume you’re on board with our cookie policy

See Pricing

What's Your Topic?

Hire a Professional Writer Now

The input space is limited by 250 symbols

What's Your Deadline?

Choose 3 Hours or More.
Back
2/4 steps

How Many Pages?

Back
3/4 steps

Sign Up and See Pricing

"You must agree to out terms of services and privacy policy"
Back
Get Offer

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

Hire a Professional Writer Now

The input space is limited by 250 symbols

Deadline:2 days left
"You must agree to out terms of services and privacy policy"
Write my paper
in excel, the electronic spreadsheet you work work in is called a ______
A) tablet
B) databook
C) numericsheet
D) worksheet
D) worksheet
in excel, a worksheet is contained in a file is called
A) workbook
B) workpad
C) notebook
D) datapad
A) workbook
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
C) create what-if data scenarios
all excel formulas begin with the ____
A) +
B) *
C) =
D) slash
C) equal sign
Excel recognizes any entry as a value if it is a number or it begins with _____
A) +
B) =
C) $
D) all of the above
D) all of the above
you can use the _____ key(s) on the keyboard to navigate a worksheet
A) [Ctrl]
B) zoom
C) arrow
D) [enter]
C) arrow
to move one screen to the left press _____
A) [Ctrl][Home]
B) [Atl][Page Up]
C) [Ctrl][Page Left]
D) [Alt][Page Down]
B) [Atl][Page Up]
to quickly jump to the last cell in a worksheet press ____
A) [Alt][Page Down]
B) [Shift Down]
C) [Page Down]
D) [Ctrl][End]
D) [Ctrl][End]
the Undo button allows you to reverse up to ____ previous actions, one at a time
A) 1
B) 10
C) 100
D) 1,000
C) 100
Possible paper orientations for printing a worksheet are landscapes and _____
A) preview
B) portrait
C) normal
D) page break
B) portrait
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
C) (G15-G14)
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
A) manually typing the function
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
C) the data remains in its original location
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
C) HOME tab, Cells group
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
A) HOME
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

A) preserve the relationship to the formula location
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
D) +($A6+$A$7)*.20
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
C) relative
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
C) pasting cell selectors
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
C) fill handle
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
D) data
the file extension .xltx indicates what type of Excel file?
A) excel template
B) excel workbook
C) excel worksheet
D) excel formulas only worksheet
A) excel template
the default file extension for an Excel 2013 workbook is ____
A) .xltx
B) .xslx
C) .xlsx
D) .xlts
C) .xlsx
the ____ of a cell determines how the labels and values look.
A) value
B) formula
C) label
D) format
D) format
the default Accounting number format adds dollar signs and ____ decimal places to the data
A) one
B) two
C) three
D) four
B) two
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
B) Styles
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
B) Insert Pictures
you can apply font styles and alignment options using the ____ tab of the Ribbon
A) INSERT
B) HOME
C) PAGE LAYOUT
D) VIEW
B) HOME
You can apply font styles and alignment options using the _____ dialog box
A) format cells
B) insert
C) conditional formatting
D) autocorrect
A) format cells
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
A) styles
the format painter button is found in the _____ group on the HOME tab of the Ribbon.
A) Alignment
B) Styles
C) Clipboard
D) Font
C) Clipboard
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
D) all of the above
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
B) REVIEW
____ shows you how a fill color will look before you apply it
A) Sneak Peek
B) Live Preview
C) Quick Look
D) Advance Look
B) Live Preview
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
C) PAGE LAYOUT
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
B) light red fill with dark red text
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
D) Rules Manager
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]
B) [Shift]
the spelling button is found in the proofing group on the _____ tab on the Ribbon.
A) HOME
B) PAGE LAYOUT
C) REVIEW
D) DATA
C) REVIEW
each value in a cell selected for a chart is called a ____
A) data marker
B) tick mark
C) data point
D) data series
C) data point
A(n) ____ chart compares distinct object levels using vertical bars; it is the Excel default.
A) line
B) area
C) column
D) pie
C) column
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
A) area chart
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
D) compares trends over uneven time or measurement intervals
a combination chart can add a(n) ____ axis to chart related data
A) combo
B) secondary
C) tertiary
D) clustered
B) secondary
In a pipe chart, slices that are pulled away are said to be ____
A) identified
B) exploded
C) opened
D) extracted
B) exploded
a common example of a text delimiter is ____
A) ,
B) =
C) +
D) (
A) ,
the CONCATENATE function joints two or more ___ into one.
A) strings
B) formulas
C) cells
D) function
A) strings
which excel function averages cells in a range based on a specific condition?
A) AVERAGEIF
B) AVERAGE
C) COUNTIF
D) SUMIF
A) AVERAGEIF
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
B) Math & Trig
Which error code will display if a formula contains a text error?
A) #NA
B) #NUM!
C) #NAME?
D) #####
C) #NAME?
Which error code will display if a value in a formula is not available?
A) #NAME?
B) #VAL
C) #NONE
D) #NA
D) #NA
which error code will display if a number is used invalidly in a cell?
A) #NUM!
B) #VAL
C) #VALUE!
D) #NAME?
A) #NUM!
when used in formulas, names become ____ cell references by default.
A) absolute
B) relative
C) linked
D) unlinked
A) absolute
which of the following is not a valid named range?
A) Alaska59
B) New quote
C) salary
D) Top_Sales
B) New Quote
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
A) logical test

Cite this Microsoft Offie Excel Units A,B,C,D & E

Microsoft Offie Excel Units A,B,C,D & E. (2018, Jan 15). Retrieved from https://graduateway.com/microsoft-offie-excel-units-abcd-e-essay/

Show less
  • Use multiple resourses when assembling your essay
  • Get help form professional writers when not sure you can do it yourself
  • Use Plagiarism Checker to double check your essay
  • Do not copy and paste free to download essays
Get plagiarism free essay

Search for essay samples now

Haven't found the Essay You Want?

Get my paper now

For Only $13.90/page