Excel Flashcards by Sam Tancharoensuksavai

 
Search

Create
Log in Sign up

Log in Sign up
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

mmmachado3

CIS 150 3

>STUDY

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
OTHER SETS BY THIS CREATOR
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

Course Hero Logo
Course Hero Symbol

    • Find Study Resources

      • Main Menu
      • by School
      • by Subject

        Course Study Guides
      • by Book

        Literature Study Guides
        Infographics

      Get Instant Tutoring Help
      Earn by Contributing

      • Main Menu
      • Earn Free Access
      • Upload Documents
      • Refer Your Friends
      • Become a Tutor
      • Scholarships
    • For Educators

      Log in

      Sign up

    • app store button

      google play button



  • 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

      Learn More >

    • Upload Documents

    • Refer Your Friends

    • Earn Money

    • Become a Tutor

    • Scholarships

      Learn More >

  • Are you an educator?

  • Log in

  • Sign up

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
Image of page 1

Info icon
This preview
has intentionally blurred sections.
Sign up to view the full version.



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.
Image of page 2
48. The fill handle copies ____.
content and formats
49. Using the AutoFill Options button, the Fill Without Formatting option copies the ____ but not the
Image of page 3

Info icon
This preview
has intentionally blurred sections.
Sign up to view the full version.



View Full Document

Image of page 4
This is the end of the preview.

Sign up

to access the rest of the document.

  • Fall 16


  • Expression,
    Function Library
  • Twitter Icon
  • Email Icon
  • URL Icon
    Share this link with a friend:


    Copied!


Report



View Full Document

Most Popular Documents from Yvcc Ged School

  • Prev
  • Next

  • 5 pages
    module 4.docx

    • Filter 58 Mya has asked for your advice A colleague told her to remove the
    • Yvcc Ged School
    • IT 221

      Fall 2016

    module 4.docx

  • 25 pages
    NP_EX16_6b_1.xlsx

    • NP_EX16_6b_1.xlsx
    • Yvcc Ged School
    • IT 221

      Fall 2016

    NP_EX16_6b_1.xlsx

  • 11 pages
    tb_chapter12

    • 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

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

      Fall 2016

    HW#4_Ch6&7GIST

  • 5 pages
    Module 5 assignment.docx

    • 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

    • ME323_Notes_Week2_A.pdf
    • Yvcc Ged School
    • MATH calculus

      Spring 2014

    ME323_Notes_Week2_A.pdf

View
more

  • Bookmarked
    excel module 3.docx

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

    [ document.title ]

    [ document.bookmarkTime ]

excel module 3.docx

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

excel module 3.docx

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

[ document.title ]

satisfaction guaranteed seal

Study on the go

  • Download the iOS

  • Download the Android app

Other Related Materials

13 pages
NPExcel2013_T03

  • 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
Calculating Data with Formulas and Functions

  • 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
NPExcel2013_T03_PPT

  • 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
excel-2013-formulas-and-functions-student-final

  • 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
TEST 3 answers.docx

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

    Fall 2016

TEST 3 answers.docx

8 pages
Tutorial 3

  • 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

Sign up to access 24/7 study resources for your classes
Sign Up
Log in

What students are saying

  • Left Quote Icon

    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.

    Student Picture

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

  • Left Quote Icon

    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.

    Student Picture

    Dana
    University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    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.

    Student Picture

    Jill
    Tulane University ‘16, Course Hero Intern