CIS 150 3
>STUDY
PLAY
attended workouts
to see how they affect the calculated results.
YOU MIGHT ALSO LIKE…
OTHER SETS BY THIS CREATOR
THIS SET IS OFTEN IN FOLDERS WITH…

 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
 Find Study Resources
Find
Study Resourcesby 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 >
 Earn Free Access
Are you an educator?
Log in
Sign up
Yvcc Ged School
IT
IT 221
True 21 the category of excel functions returns true

Yvcc Ged School

IT 221
 Test Prep
cyoni89

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
True
21. The ____ category of Excel functions returns (truefalse) values.
Logical
22. Which of the following is a Statistical function?
AVERAGE
This preview
has intentionally blurred sections.
Sign up to view the full version.
View Full Document
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.
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.
Sign up to view the full version.
View Full Document
Sign up
to access the rest of the document.
 Fall 16

Expression,
Function Library

Share this link with a friend:
Report
View Full Document
Most Popular Documents from Yvcc Ged School
 5 pages
 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
 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
?
Bookmark it to view later.
No bookmarked documents.
Bookmark this doc
Recently Viewed
[ document.course.dept_acro ] [ document.course.course_num ]
[ document.title ]
Study on the go
Download the iOS
Download the Android app
Other Related Materials
 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
 Excel supplies over 300 functions organized into 11 categories Cube Database
 Pace University
 CIS 122
–
Fall 2014
Calculating Data with Formulas and Functions
 Use AutoFill to create a series of numbers dates or text based on a pattern Use
 EmbryRiddle Aeronautical University
 COM BA 230
–
Spring 2016
NPExcel2013_T03_PPT
 Or imagine you have a workbook that tracks project milestone dates for a
 University of South Africa
 INFORMATIO BINF
–
Fall 2013
excel2013formulasandfunctionsstudentfinal
 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
 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 ]