Excel Flashcards
in a column chart, you can ___
All of the above
what chart type would you suggest to anya?
pie
you sould tell anya its especially important to ___ 3d charts
include data labels
anya needs to call attention to one category above all others. for this purpose, she should use a(n) ___
exploded pie chart
in the Paste Special dialog box, you can
all of the above
excel function are organized into ___ categories
11
the expression used to calculate values displayed in a worksheet is called a (n)___
formula
the ___ category of excel functions retrieves data from multidimensional databases involving online analytical processing
CUBE
in conditional formatting, to highlight only cells that contain a specific date, select the rule ___
a date occurring
in the format cells dialog box, ___ tab allows you to format currency by choosing decimal places, comma separators, and regular number displays
number
the most efficient way to format an entire table is to __
use a table style
draw attention to 75% approval rating. to highlight these numbers, ajeesh could apply ___
the Greater Than rule with Conditional formatting
which of the following can you format using the Number group in excels home tab?
All of the above
a ___ is not a type of font
true type
according to the order of precedence in excel :
exponentiation, multiplication, division, addition, subtraction
the ___ dialog box provides options for moving charts between worksheets and chart sheets
move chart
one of the benefits of Live Preview is that ___
it lets you see and evaluate different formats as you develop your workbook
___ merges each of the rows in the selected range across the columns in the range
merge across
pamela needs to borrow 30,000 as a down payment for her condominium. this amount will be the ___
principal
pamela has been told by one bank that if approved, she will have to pay a compound interest. this means that ___
interest paid is calculated on the principal and any previous interest payments that have been added to that principal
pamela is trying to figure out what her monthly loan payment will be. She uses the PMT function in the ___ category
Math & Trig
assuming pamela is faithful to her monthly payments and her interest rate does not change, she could be able to calculate the ____ of the loan
fv
in ___ orientation, a page is taller than it is wide
portrait
its difficult to read the exact scale on some of andys data. adding ___ would make it easier to read
major tick marks
it is recommended to set your column widths based on the maximum number of characters you wish to display, rather than ___
pixels
for most loan and investment calculations, you need to enter the annual interest rate ___ the number of times the interest is compound during the year
divided by
excel is an electronic version of a(n) ___
spreadsheet
depending on the pie chart layout you choose, you can ___
all of the above
edward tufte said that ___ ink is any part of the chart that does not convey information about the data
non-data
to change the font size one point at a time, in the Font group on the Home tab, click the ___ button
either a or b
options to rotate cells in excel are available using the ___ button in the alignment group on the home tab
orientation
the ___ function category retrieves data from multidimensional databases involving online analytical processing or OLAP
Cube
> = is a(n) ___ operator
comparison
which of the following represents the pointer when it is over a blank spot in the chart legend?
cross arrows
italic, bold, bold italic, and underline are examples of ___
font styles
to complete a cell entry, press the ___ key
enter
excel makes reading formulas simpler by ___ each cell reference in the formula and its corresponding cell in the worksheet
color coding
after you describe a function in the Insert Function dialog box, click ___
Go
on a 3d chart, the ___ represents the object’s depth
z-axis
the ___ function returns the maximum value in the range
MAX
to fill a column with a blend of colors in a column, you would choose ___ from the Fill options
gradient fill
with ___ interest, the borrower always pays more money to the lender the following year
compound
you can treat a range of data as a distinct object in a worksheet known as a(n) ___
excel table
to move or a resize an embedded chart ___
both a and b
when using the format painter, double click the format painter button to paste the same format multiple times and click the format painter again to ___
turn it off
the ____ is the only one of the following charts to compare relative values from different categories to the whole
pie
you can also move to the previous or next sheet by pressing the ___ key
ctrl+page up or ctrl+page down
when you copy a formula that contains an absolute reference to a new location, the reference ___
does not change
a ___ sheet is a worksheet that provides information about the content and purpose of the workbook
planning analysis
an excel worksheet can have a maximum of ___ columns in a wokrsheet
16,385
