Brainscape's Knowledge GenomeTM

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


See full index

Excel > 4-6 > Flashcards

4-6 Flashcards

1
Q

What type of formula cell reference instructs Microsoft excel to keep the cell reference constant in the formula as it copies it to the destination area?

A

absolute

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

what method is the most efficient way to copy five separate formulas to adjacent cells simultaneously?

A

copy by using the fill handle

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

Jennifer is calculating her GPA. if she uses “=(A1+A2+A3+A4)/4”, this is an example of which type of entry?

A

formulas

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

how is a cell reference in a formula and its corresponding location in a worksheet identified?

A

cell reference and cell location are outlined in matching colors

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

tyler created a monthly sales workbook that contains the formula =(January!B3). “January” is an example of an

A

External Reference

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

when copying values in Microsoft Excel, which features automatically adjusts cell references for the new copy location?

A

relative reference

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

tyler created a monthly sales workbook that contains the formula =SUM(Sales). “Sales” is an example of a

A

named range

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

Gabriel needs to create a formula that does not change when it is copied to cell B2. Which formula should he create?

A

$B$1+25

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

what do you call it when you reference cells in other sheets in a workbook formula using the sheet name as the reference rather than the cell address?

A

worksheet reference

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

Sandra is creating a formula to subtract the values in cell B4 and C4. which formula should she use?

A

=B4-C4

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

snadra is creating a formula to multiply the values in cell B4 and C4. which formula should she use?

A

=B4*C4

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

Joshua created a budget workbook that contains the formulas =(Summary!B3). “Summary” is an example of an

A

external reference

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

which group on the formulas ribbon enables a user to specify when a formula is completed

A

calculation

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

what is a prewritten formula that is built into the Microsoft Excel called

A

function

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

Larkeysha has created a spreadsheet containing students grades. which function would she use to return the current date in cell A1

A

TODAY

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

what function adds all of the numbers in a range of cells

A

SUM

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

Amanda has created a spreadsheet containing test grades for the first nine weeks. which function would she use to find the highest test grade

A

MAX

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

which command on the home tab displays the total of the selected cells directly after the selected cells

A

AutoSum

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

Amanda has created a spreadsheet containing test grades for the first nine weeks. which function would she use to estimate the grade on her next test

A

AVERAGE

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

which group on the formulas ribbon contains the command that checks for common errors found in a formula?

A

formula auditing

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

where can you find the insert function button in Microsoft Excel

A

formula bar

22
Q

angie is calculating her average sales for the past four months. if she uses “=AVERAGE(B1:B4)”, this is an example of which type of entry

A

function

23
Q

Gabriel needs to create a shortcut formula in cell B40 to calculate total sales located in cells B1 through B39. which function should he create?

A

=SUM(B1:B39)

24
Q

which group on formulas ribbon contains a command that allows a user to create names for cells to use in a formula

A

defined names

25
Q

which of the following are valid Microsoft Excel functions

A

AVERAGE, MAX, MIN

26
Q

which function do you use to interest today’s date un a worksheet so that it automatically updates each time the worksheet is opened?

A

Today

27
Q

which function would she use to return the current date and time in cell A1

A

NOW

28
Q

which dialog box contains the commands to specify an exact date and time format to use for a selected cell in a worksheet

A

Format cells

29
Q

on the home ribbon, what di you use to change the font size of the characters in a cell

A

font size drop down list

30
Q

trey would like to outline the cell range A1:F20. which formatting style should he select

A

borders

31
Q

where can you fine the command to apply a fill color to a cell or range of cells in a worksheet

A

home ribbon

32
Q

K would like to apply the Title format to the data in row 1 of a spreadsheet. which formatting style should he select

A

cell style

33
Q

which command do you use to format a cell or selected cells quickly by choosing from a defined list of styles

A

cell style

34
Q

carl notices the last two lines of text in cell B4 are not showing up in his worksheet. How could carl format the cell to correct this problem

A

Autofit

35
Q

needs the title in cell A1 to align horizontally across cells A1 through D1. Which alignment option should she select

A

Merge and Center

36
Q

which command on the home ribbon do you use to rotate text to a vertical or diagonal angle in a worksheet

A

orientation

37
Q

what defines the color of the characters in a Mircorsoft Excel worksheet

A

font color

38
Q

which dialog box in Microsoft Excel do you use to set the rotation of text in a cell to a specific degree

A

format cells

39
Q

K needs the text in cell A1 to bee angled at 90 degrees. Which alignment option should she select

A

orientation

40
Q

On the home ribbon, what do you use to change the text color of characters in a cell

A

font color drop down list

41
Q

which command on the insert ribbon creates a link to a web page, picture, email address, or program in a worksheet

A

hyperlink

42
Q

what type of formatting appears only when the value in a cell meets conditions specified by a user

A

conditional

43
Q

which command on the home ribbon joins selected cells into one and centers the content into a larger single cell?

A

merge and center

44
Q

trey would like to apply a rule to the date in cell range A1:F20 that will highlight number greater than 50,000 with a yellow fill color and dark yellow text. which formatting style should he select

A

conditional formatting

45
Q

what command do you use to apply a background color to cells in a worksheet

A

fill color

46
Q

which quick-number style button formats number to display as currency in the worksheet

A

accounting

47
Q

column D in a spreadsheet contains information about regional sales. which formatting would be most appropriate for the date in column D

A

Currency

48
Q

column D in a spreadsheet contains employee ID Number. which formatting would be most appropriate for the data in column D

A

Text

49
Q

Carl notices that the date in cell E4 reads #####. what command could carl choose to correct this problem

A

autofit

50
Q

which command do you use to reduce the margin between the borders and the text in an indented Cell

A

decrease indent

51
Q

which defines the appearance and shape of the letters, numbers, and special characters in Microsoft Excel

A

Font

Excel (5 decks)

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