Get help now

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

dovnload

Download

  • Pages 7
  • Words 1652
  • Views 132
  • Can’t find relevant credible information

    Let our experts help you

    Get help now
    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

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

    Hi, my name is Amy 👋

    In case you can't find a relevant example, our professional writers are ready to help you write a unique paper. Just talk to our smart assistant Amy and she'll connect you with the best match.

    Get help with your paper