# Excel Flashcards by Sam Tancharoensuksavai

Search

Create

We use cookies to simplify and improve your experience on our website. By using our website, you are agreeing to our cookie and privacy policies.

52 terms

# CIS 150 3

###### PLAY

Cube
The ____ category of Excel functions retrieves data from multidimensional databases involving online analytical processing
logical
The ____ category of Excel functions returns (true-false) values
average
Which of the following is a Statistical function?
INT
Which of the following is a Math & Trig function? ____
Nested
=ROUND(AVERAGE(A1:A100),2) is an example of a(n) ____ function
Go
After you describe a function in the Search for a function box in the Insert Function dialog box, click ____.
arguments
The numbers, text, or cell references used by the function to return a value are called ____.
fill handle
Referring to the figure above, the last entry shown in Column K is 644.7953813. There is a black "plus sign" on the lower right edge of the cell that is the
auto fill options button
Referring to the figure above, the last entry shown in Column K is 644.7953813. There is an icon in the cell underneath the 644.7953813 which is the ____.
two
Referring to the figure above, which number represents the COUNT function?
four
Referring to the figure above, which number refers difference between the scheduled and
attended workouts
<<
Which of the following is not a comparison operator? __
the formula returns the text "restart"
In the following formula: =IF(A1="YES", "DONE", "RESTART"), what happens if A1= "NO"?
AND
Which of the following is not a date function? __
MAX
The ____ function returns the maximum value in the range
relative
One of the great advantages of ____ references is that you can quickly generate row and column totals without having to worry about revising the formulas as you copy them to new locations.
\$
Absolute references are marked with a ____.
does not change
When you copy a formula that contains an absolute reference to a new location, the reference ____.
absolute
Use ____ references when you want different formulas to refer to the same cell.
median
Another name for the middle value is the ____ value.
optional
____ arguments may provide more control over the returned value.
the general syntax of all functions
FUNCTION(argument1, argument2, …) is ___
default
If an optional argument is not included, Excel assumes a(n) ____ value for it.
12
Excel functions are organized into ____ categories.
algebra
Which of the following is not an Excel function category? ___
COUNT
Which function counts how many cells in a range contain numbers, where value1, value2, and so forth are text, numbers, or cell references?
cell references
In "SUM(number1 [, number2, number3, …])", number 1, number 2, and number 3 may be numbers or ____.
information
Which category of Excel functions returns information about the format, location, or contents of worksheet cells? ____
the average of the values A1:A100 is calculated
In the formula =INT(AVERAGE(A1:A100)), which would occur first? ___
the same number of left and right parentheses
When you nest functions, you should have ____
function library
The Insert Function button is in the ____ group.
search
The Insert Function dialog box has a(n) ____ option.
content in formats
The fill handle copies ____
content
Using the AutoFill Options button, the Fill Without Formatting option copies the ____ but not the formatting.
february, march, april
Using AutoFill, what would be the extended series of the initial entry Jan?
true or false
A logical function is a function that works with values that are either ____.
A does not equal B
In the formula =IF(A1=B1, C1, C2), the result will be C2 if ____.
mixed
____ references are seldom used other than when creating tables of calculated values such as a multiplication table in which the values of the formula or function can be found in the initial rows and columns of the table.
a blank cell
=IF(G22= "x ", SUM(H22:J22), " ") with display ______ if G22 is not equal to "x".
look up
______ functions find values in tables of data and insert them in another location in the worksheet such as cells or in formulas.
#n/a
If the VLOOKUP function cannot find the lookup value, the _________ error value is displayed in the cell.
what if analysis
One way to perform a _________ is by changing one or more of the input values
to see how they affect the calculated results.
type january in cell A1 and then drag the fill handle
Ellen opens Excel 2013 and enters her monthly income for one year beginning with January. To create a series of months, she can ____.
absolute reference
Ellen has entered all of her monthly expenses. She needs to create a formula that will deduct her monthly expenses from her monthly income. Since her monthly income is the same amount each month, she uses a(n)____ to identify the cell containing the income value.
math and trig button in the function library group
Ellen’s spending varies from month to month. She wants to calculate the total expenses for each month. She wants to see all of the arguments associated with the SUM function so she clicks the ____ then clicks SUM to open the Function Arguments dialog box.
select the range A10:L10, click the quick analysis button, click TOTALS, then click median
Ellen wants to find out what her median monthly spending is. The monthly totals for her spending appear in the range A10:L10. Which of the following is NOT a way to enter the MEDIAN function into her database?
F4
Ellen is expecting to get a 3% raise next year. She enters .03 in cell D2 so that she can predict her monthly income for the next year. What function key will make D2 an absolute reference?
look up function
Susan designs a worksheet with the inventory number, description, quantity, unit cost, reorder point and value. To find values in tables of data, and insert them in another location in the worksheet such as cells or in formulas, she will use ________.
false
Susan needs to use a lookup function to find an exact match of an inventory item, so she will set the range_lookup value to _______ .
#N/A
Susan uses VLOOKUP to retrieve the return value from a vertical lookup table. When she enters the VLOOKUP function, specifying the lookup value and other criteria, the lookup value cannot be found. It displays ______ error value in the cell
what if analysis
Susan wants to make some changes to the worksheet to explore the impact that changing input values has on the calculated values in the worksheet. She can use ______.
goal seek
Susan wants to automate the trial-and-error process by allowing her to specify a value for a calculated item, which Excel uses to determine the input value needed to reach that goal. She can use ______.
##### YOU MIGHT ALSO LIKE…
42 terms
CIS 150 3
42 terms
Excel Tutorial 3: Calculating Data with Formulas and Functions
37 terms
Excel Module 3
50 terms
Excel
7 terms
BSL 333 Final
38 terms
MGT 304
22 terms
MCY 124
52 terms
CIS 150 5
##### THIS SET IS OFTEN IN FOLDERS WITH…
52 terms
CIS 150 4
52 terms
bus 150-2
52 terms
BUS 150
108 terms
Excel Test

• Find Study Resources

• by School
• by Subject

Course Study Guides
• by Book

Literature Study Guides
Infographics

Get Instant Tutoring Help
Earn by Contributing

• Earn Free Access
• Become a Tutor
• Scholarships
• For Educators

• Find
Study Resources

• by School

• by Subject

• Course Study Guides

• by Book

• Literature Study Guides

• Infographics

• Get Instant
Tutoring Help

• Earn by
Contributing

• Earn Free Access

• Earn Money

• Become a Tutor

• Scholarships

• Are you an educator?

Yvcc Ged School

IT

IT 221

excel module 3.docx

# True 21 the category of excel functions returns true

• Yvcc Ged School

• IT 221

• Test Prep

• 4

• 100%
(2)
2 out of 2 people found this document helpful

This preview shows pages 1–4. Sign up to view the full content.

View Full Document

item, which Excel uses to determine the input value needed to reach that goal.
True
21. The ____ category of Excel functions returns (true-false) values.
Logical
22. Which of the following is a Statistical function?
AVERAGE

This preview
has intentionally blurred sections.

View Full Document

23. Which of the following is a Math & Trig function?
INT
24. =ROUND(AVERAGE(A1:A100),2) is an example of a(n) ____ function.
nested
25. After you describe a function in the Search for a function box in the Insert Function dialog box, click
____.
Go
26. The numbers, text, or cell references used by the function to return a value are called ____.
arguments
27. Which of the following is not a comparison operator? ____
<<
28. In the following formula: =IF(A1=”YES”, “DONE”, “RESTART”), what happens if A1= “NO”?
The
formula returns the text “RESTART”.
29. Which of the following is not a date function?
AND
30. The ____ function returns the maximum value in the range.
MAX
31. One of the great advantages of ____ references is that you can quickly generate row and column totals
without having to worry about revising the formulas as you copy them to new locations.
Relative
32. Absolute references are marked with a ____.
\$
33. When you copy a formula that contains an absolute reference to a new location, the reference ____.
does not change
34. Use ____ references when you want different formulas to refer to the same cell.
absolute
35. Another name for the middle value is the ____ value.
median
36. ____ arguments may provide more control over the returned value.
Optional
37. FUNCTION(argument1, argument2, …) is ____.
the general syntax of all functions
38. If an optional argument is not included, Excel assumes a(n) ____ value for it.
default
39. Excel functions are organized into ____ categories.
13
40. Which of the following is not an Excel function category?
Algebra
41. Which function counts how many cells in a range contain numbers, where value1, value2, and so forth
are text, numbers, or cell references?
COUNT
42. In “SUM(number1 [, number2, number3, …])”, number 1, number 2, and number 3 may be numbers
or ____.
cell references
43. Which category of Excel functions returns information about the format, location, or contents of
worksheet cells?
Information
44. In the formula =INT(AVERAGE(A1:A100)), which would occur first?
The average of the values in
the range A1:A100 is calculated.
45. When you nest functions, you should have _
the same number of left and right parentheses
46. The Insert Function button is in the ____ group.
Function Library
47. The Insert Function dialog box has a(n) ____ option.
search b.
48. The fill handle copies ____.
content and formats
49. Using the AutoFill Options button, the Fill Without Formatting option copies the ____ but not the

This preview
has intentionally blurred sections.

View Full Document

This is the end of the preview.

to access the rest of the document.

• Fall 16

• Expression,
Function Library

Copied!

Report

View Full Document

#### Most Popular Documents from Yvcc Ged School

• Prev
• Next

• 5 pages

• Yvcc Ged School
• IT 221

Fall 2016

module 4.docx

• 25 pages

• NP_EX16_6b_1.xlsx
• Yvcc Ged School
• IT 221

Fall 2016

NP_EX16_6b_1.xlsx

• 11 pages

• galaxies have a great many short spiral segments branching from the spiral arms
• Yvcc Ged School
• ASTR 100

Fall 2016

tb_chapter12

• 3 pages

• HW#4_Ch6&7GIST
• Yvcc Ged School
• GEOLOGY 101

Fall 2016

HW#4_Ch6&7GIST

• 5 pages

• Carbohydrate digestion begins in the mouth because saliva contains amylase What
• Yvcc Ged School
• NUTRITION 101

Fall 2016

Module 5 assignment.docx

• 4 pages

• ME323_Notes_Week2_A.pdf
• Yvcc Ged School
• MATH calculus

Spring 2014

ME323_Notes_Week2_A.pdf

View
more

• Bookmarked

[ document.course.dept_acro ] [ document.course.course_num ]

[ document.title ]

[ document.bookmarkTime ]

IT 221

excel module 3.docx

Viewing now

Interested in excel module 3.docx

?

Bookmark it to view later.

Bookmark excel module 3.docx.

Bookmarked!

No bookmarked documents.

Bookmark this doc

#### Recently Viewed

[ document.course.dept_acro ] [ document.course.course_num ]

[ document.title ]

#### Other Related Materials

13 pages

• ANS mixed PTS 1 REF EX 154 8 Not all functions have arguments and some
• American University of Sharjah
• BIS 101

Fall 2012

NPExcel2013_T03

8 pages

• Excel supplies over 300 functions organized into 11 categories Cube Database
• Pace University
• CIS 122

Fall 2014

Calculating Data with Formulas and Functions

47 pages

• Use AutoFill to create a series of numbers dates or text based on a pattern Use
• Embry-Riddle Aeronautical University
• COM BA 230

Spring 2016

NPExcel2013_T03_PPT

76 pages

• Or imagine you have a workbook that tracks project milestone dates for a
• University of South Africa
• INFORMATIO BINF

Fall 2013

excel-2013-formulas-and-functions-student-final

23 pages

• Selected Answer c does not change Answers a becomes bold b has a dotted outline
• Gaston College
• ACCOUNTING 101

Fall 2016

8 pages

• Answers a nested OR conditions b Lookup Analysis c IF conditions d What If
• Central New Mexico Community College
• 1173 EXCEL 1173

Fall 2014

Tutorial 3

[ snackBarMessage ]

2/3

PREVIEWS LEFT

### What students are saying

• As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

Kiran
Temple University Fox School of Business ‘17, Course Hero Intern

• I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

Dana
University of Pennsylvania ‘17, Course Hero Intern

• The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

Jill
Tulane University ‘16, Course Hero Intern