Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

ITSC 1301 Excel > Excel > Flashcards

Excel Flashcards

1
Q

in a column chart, you can ___

A

All of the above

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

what chart type would you suggest to anya?

A

pie

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

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

A

include data labels

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

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

A

exploded pie chart

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

in the Paste Special dialog box, you can

A

all of the above

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

excel function are organized into ___ categories

A

11

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

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

A

formula

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

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

A

CUBE

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

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

A

a date occurring

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

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

A

number

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

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

A

use a table style

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

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

A

the Greater Than rule with Conditional formatting

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

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

A

All of the above

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

a ___ is not a type of font

A

true type

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

according to the order of precedence in excel :

A

exponentiation, multiplication, division, addition, subtraction

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

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

A

move chart

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

one of the benefits of Live Preview is that ___

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
18
Q

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

A

merge across

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
19
Q

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

A

principal

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
20
Q

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

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
21
Q

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

A

Math & Trig

22
Q

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

A

fv

23
Q

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

A

portrait

24
Q

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

A

major tick marks

25
Q

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

A

pixels

26
Q

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

A

divided by

27
Q

excel is an electronic version of a(n) ___

A

spreadsheet

28
Q

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

A

all of the above

29
Q

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

A

non-data

30
Q

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

A

either a or b

31
Q

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

A

orientation

32
Q

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

A

Cube

33
Q

> = is a(n) ___ operator

A

comparison

34
Q

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

A

cross arrows

35
Q

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

A

font styles

36
Q

to complete a cell entry, press the ___ key

A

enter

37
Q

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

A

color coding

38
Q

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

A

Go

39
Q

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

A

z-axis

40
Q

the ___ function returns the maximum value in the range

A

MAX

41
Q

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

A

gradient fill

42
Q

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

A

compound

43
Q

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

A

excel table

44
Q

to move or a resize an embedded chart ___

A

both a and b

45
Q

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 ___

A

turn it off

46
Q

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

A

pie

47
Q

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

A

ctrl+page up or ctrl+page down

48
Q

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

A

does not change

49
Q

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

A

planning analysis

50
Q

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

A

16,385

ITSC 1301 Excel (1 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2024 Bold Learning Solutions. Terms and Conditions