Brainscape's Knowledge GenomeTM

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


See full index

CSC Exam III > Exam III review > Flashcards

Exam III review Flashcards

1
Q

Which function should you use to count the number of cells in a range that contain numbers?

A

count

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

What feature should you use to find the right input when you know the result you want?

A

Goal Seeking

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

Which function calculates the payment of a loan based on constant payments and a constant rate?

A

pmt

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

Which function should you use to find the mean of a list of values?

A

average

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

Which function should you use to find the middle value in a list of values?

A

median

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

Which function should you use to count the non-empty cells?

A

counta

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

Which function should you use to change the contents of a cell based on a condition or criteria?

A

if

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

Which function should you use to find the most frequently occurring number in a list (or range) of numbers?

A

mode

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

Which function should you use to have information returned from a table?

A

vlookup

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

What feature should you use to change the appearance of a cell based on a criteria?

A

conditional formatting

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

Which function should you use to eliminate the decimal portion of a number?

A

trunc

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

Which function should you use to display the date and time?

A

now

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

Which function should you use to find the lowest number in a range?

A

min

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

Which function should you use to find the highest number in a range?

A

max

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

Which function should you use to display the date?

A

today

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

Which function should you use to count cells based on a criteria?

A

countif

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

Which function should you use to return the sum of the products of corresponding ranges or arrays?

A

sumproduct

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

Which function should you use to join several text strings into one text string?

A

concatenate

19
Q

A cell’s unique address is its ________.

A

cell reference

20
Q

The default view in Excel.

A

Normal View

21
Q

by default Text is ____ aligned.

A

left

22
Q

by default Numbers are _____ aligned.

A

right

23
Q

Which feature would you use to join several selected cells into one cell?

A

merge

24
Q

A prewritten formula that is built into Excel is a _______.

A

function

25
Q

Which feature would you use to check which cells are references in the formula assigned to the active cell?

A

range finder

26
Q

______ allows you to select cells for use in a formula by using a mouse.

A

point mode

27
Q

Which format would you use to have a fixed dollar sign?

A

accounting

28
Q

Which format would you use to have a floating dollar sign?

A

currency

29
Q

Which view allows you to create or modify a worksheet while viewing how it will look in printed format?

A

page layout view

30
Q

How do you display the formulas version?

A

[ctrl]+[accent mark]

31
Q

The data is cleared and the format is reset to the default when you _______ a cell.

A

move

32
Q

The data and format remain intact when you _____ a cell.

A

copy

33
Q

A row is inserted ______.

A

above

34
Q

A column is inserted _________.

A

to the left

35
Q

Which feature would you use to keep the titles on the screen no matter how far you scroll down or to the right?

A

Freeze Titles

Freeze Panes

36
Q

A date is just a _____ since 1/1/1900

A

number

37
Q

Which addressing mode would you use to keep the column and row the same as you copy the formula?

A

absolute

38
Q

Which address mode would you use to keep the column the same as you copy the formula

A

mixed

39
Q

Which addressing mode would you use to adjust the column and row as you copy the formula?

A

relative

40
Q

Which feature would you use to scrutinize the impact of changing values in cells that are referenced by a formula in another cell?

A

what if analysis

41
Q

What is the small black square located in the lower-right corner of an active cell?

A

fill handle

42
Q

the values that you use with a function

A

arguments

43
Q

the width of the column will be increased or decreased so that the widest entry will fit the column

A

best fit

CSC Exam III (1 decks)

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