Excel

Question 1

in a column chart, you can ___

Answer 1

All of the above

Question 2

what chart type would you suggest to anya?

Answer 2

pie

Question 3

you sould tell anya its especially important to ___ 3d charts

Answer 3

include data labels

Question 4

anya needs to call attention to one category above all others. for this purpose, she should use a(n) ___

Answer 4

exploded pie chart

Question 5

in the Paste Special dialog box, you can

Answer 5

all of the above

Question 6

excel function are organized into ___ categories

Answer 6

11

Question 7

the expression used to calculate values displayed in a worksheet is called a (n)___

Answer 7

formula

Question 8

the ___ category of excel functions retrieves data from multidimensional databases involving online analytical processing

Answer 8

CUBE

Question 9

in conditional formatting, to highlight only cells that contain a specific date, select the rule ___

Answer 9

a date occurring

Question 10

in the format cells dialog box, ___ tab allows you to format currency by choosing decimal places, comma separators, and regular number displays

Answer 10

number

Question 11

the most efficient way to format an entire table is to __

Answer 11

use a table style

Question 12

draw attention to 75% approval rating. to highlight these numbers, ajeesh could apply ___

Answer 12

the Greater Than rule with Conditional formatting

Question 13

which of the following can you format using the Number group in excels home tab?

Answer 13

All of the above

Question 14

a ___ is not a type of font

Answer 14

true type

Question 15

according to the order of precedence in excel :

Answer 15

exponentiation, multiplication, division, addition, subtraction

Question 16

the ___ dialog box provides options for moving charts between worksheets and chart sheets

Answer 16

move chart

Question 17

one of the benefits of Live Preview is that ___

Answer 17

it lets you see and evaluate different formats as you develop your workbook

Question 18

___ merges each of the rows in the selected range across the columns in the range

Answer 18

merge across

Question 19

pamela needs to borrow 30,000 as a down payment for her condominium. this amount will be the ___

Answer 19

principal

Question 20

pamela has been told by one bank that if approved, she will have to pay a compound interest. this means that ___

Answer 20

interest paid is calculated on the principal and any previous interest payments that have been added to that principal

Question 21

pamela is trying to figure out what her monthly loan payment will be. She uses the PMT function in the ___ category

Answer 21

Math & Trig

Question 22

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

Answer 22

fv

Question 23

in ___ orientation, a page is taller than it is wide

Answer 23

portrait

Question 24

its difficult to read the exact scale on some of andys data. adding ___ would make it easier to read

Answer 24

major tick marks

Question 25

it is recommended to set your column widths based on the maximum number of characters you wish to display, rather than ___

Answer 25

pixels

Question 26

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

Answer 26

divided by

Question 27

excel is an electronic version of a(n) ___

Answer 27

spreadsheet

Question 28

depending on the pie chart layout you choose, you can ___

Answer 28

all of the above

Question 29

edward tufte said that ___ ink is any part of the chart that does not convey information about the data

Answer 29

non-data

Question 30

to change the font size one point at a time, in the Font group on the Home tab, click the ___ button

Answer 30

either a or b

Question 31

options to rotate cells in excel are available using the ___ button in the alignment group on the home tab

Answer 31

orientation

Question 32

the ___ function category retrieves data from multidimensional databases involving online analytical processing or OLAP

Answer 32

Cube

Question 33

>= is a(n) ___ operator

Answer 33

comparison

Question 34

which of the following represents the pointer when it is over a blank spot in the chart legend?

Answer 34

cross arrows

Question 35

italic, bold, bold italic, and underline are examples of ___

Answer 35

font styles

Question 36

to complete a cell entry, press the ___ key

Answer 36

enter

Question 37

excel makes reading formulas simpler by ___ each cell reference in the formula and its corresponding cell in the worksheet

Answer 37

color coding

Question 38

after you describe a function in the Insert Function dialog box, click ___

Answer 38

Go

Question 39

on a 3d chart, the ___ represents the object's depth

Answer 39

z-axis

Question 40

the ___ function returns the maximum value in the range

Answer 40

MAX

Question 41

to fill a column with a blend of colors in a column, you would choose ___ from the Fill options

Answer 41

gradient fill

Question 42

with ___ interest, the borrower always pays more money to the lender the following year

Answer 42

compound

Question 43

you can treat a range of data as a distinct object in a worksheet known as a(n) ___

Answer 43

excel table

Question 44

to move or a resize an embedded chart ___

Answer 44

both a and b

Question 45

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 ___

Answer 45

turn it off

Question 46

the ____ is the only one of the following charts to compare relative values from different categories to the whole

Answer 46

pie

Question 47

you can also move to the previous or next sheet by pressing the ___ key

Answer 47

ctrl+page up or ctrl+page down

Question 48

when you copy a formula that contains an absolute reference to a new location, the reference ___

Answer 48

does not change

Question 49

a ___ sheet is a worksheet that provides information about the content and purpose of the workbook

Answer 49

planning analysis

Question 50

an excel worksheet can have a maximum of ___ columns in a wokrsheet

Answer 50

16,385