Study your flashcards anywhere!

Download the official Cram app for free >

  • Shuffle
    Toggle On
    Toggle Off
  • Alphabetize
    Toggle On
    Toggle Off
  • Front First
    Toggle On
    Toggle Off
  • Both Sides
    Toggle On
    Toggle Off
  • Read
    Toggle On
    Toggle Off
Reading...
Front

How to study your flashcards.

Right/Left arrow keys: Navigate between flashcards.right arrow keyleft arrow key

Up/Down arrow keys: Flip the card between the front and back.down keyup key

H key: Show hint (3rd side).h key

A key: Read text to speech.a key

image

Play button

image

Play button

image

Progress

1/26

Click to flip

26 Cards in this Set

  • Front
  • Back
the default setting is for a new excel workbook to contain ___ worksheets
a. none
b. four
c. three
d. two
C
new rows are inserted ___ the selected row and existing rows shift accordingly.
a. above
b. below
c. to the left of
d. to the right of
A
a useful tool in locating a match and replacing it with a replacement value of your choice is called
a. find and replace
b. value search
c. data sort
d. data analysis
A
to simultaneously close your workbook and the excel program click___ from the office menu
a. exit excel
b. minimize
c. close
d. end
A
the___ are the values that an excel function uses to perform calculations or operations
a. formulas
b. arguments
c. criteria
d. numbers
B
the intersection of a column and row is called
a. grid
b. field
c. box
d. cell
D
in a line chart, ___ is (are) displayed along the bottom axis
a. data point values
b. the legend
c. time
d. distance
C
the keyboard shortcut for the autosum feature is
a. [tab] +[=]
b. [ctrl]+ [=]
c. [alt] +[=]
d. [shift] +[=]
C
A___will display to indicate a cell contains an error message.
a. moving border around cell
b. blue outline around cell
c. green triangle in upper left corner of cell
d. red square in lower right corner of cell
C
A____ surrounds the selected range to be copied
a. solid border
b.red border
c. blue border
d. moving border
D
you can remove the contents of a cell by clicking the 'clear' button and choosing ___ from the editing group on the ribbon.
a. filter
b. clear contents
c. delete
d. fill
B
excel's prewritten formulas are called
a. functions
b. commands
c. calculations
d. summations
A
the keyboard shortcut to view print preview
a. [f2]
b. [ctrl]+[f1]
c. [ ctrl] +[f2]
d. [f1]
C
the___feature can generate a series of values into adjacent cells based on the value of other cells
a. autoformat
b. autocorrect
c. autocomplete
d. autofill
D
the___is the target destination for data that has been cut or copied using the office clipboard
a. add content area
b. paste area
c. insert field area
d. copy ares
B
to reopen a workbook once excel is opened, you can check the___ from the office menu to see if the file is there and click on it
a. recent documents
b. work history
c. former spreadsheets
d. track previous
A
___is the process of changing the appearance of cells and the overall layout of the worksheet.
a.formatting
b. editing
c. justifying
d. printing
A
you can use the auto fill feature to continue a series for any pattern that is established with___ cells.
a. 6 or more
b. 5 or more
c. 1 or more
d. 2 or more
D
___ is used to copy the formatting of one cell to other cells
a. fill color
b. autofit
c. format painter
d. format theme
C
use the___ command to display text on two lines within a cell.
a. insert row
b. align text
c. merge and center
d. wrap text
D
pressing___ pastes the text and removes it from the office clipboard
a. enter
b. copy button
c. tab
d. paste button
A
in performing calculations, ___ are processed first
a. expressions within parentheses
b. multiplication and division
c. comparison operators
d. addition and subtraction
A
___ refers to a cell maintaining the formatting of the number typed in the cell even when you delete the number and replace it with another number
a. direct formatting
b. format recognition
c. auto format
d. format as you type
D
to specify ranges of cells that are nonadjacent, separate the ranges with a
a. colon
b. semi-colon
c. comma
d. bracket
C
to create a pie chart, you must select ___ range(s) of data
a. one
b. four
c. three
d. two
D
the format cells dialog box is displayed by
a. double-clicking over selected cells and selecting format cells from the shortcut menu
b. clicking on the format cells button on the ribbon
c. right clicking over the selected cells and selecting format cells from the shortcut menu
d. clicking on the format cells button in the format group
C