Shared Flashcard Set

Details

Advanced Excel Chapter 2
Test Questions
7
Computer Science
Undergraduate 3
09/26/2013

Additional Computer Science Flashcards

 


 

Cards

Term
____is the arithmetic value that occurs in the middle of a data set when organized from lowest to highest, where half the values are less than and half the values are greater than the median value.
Definition
Median
Term
2/2
Microsoft Excel provides a variety of predefined functions, including statistical functions, that you can use to determine such values as the arithmetic mean, median, mode, and standard deviation of a set of data.
Definition
True
Term
Format Painter can be used to copy a format into multiple noncontiguous cells.
Definition
True
Term
2/2
The formula =ROUNDUP(3.432,1) rounds the value 3.432 up to the next highest tenth, or 3.5.
Definition
True
Term
The standard deviation tells you how closely together values are distributed
Definition
True
Term
The Paste Special dialog box offers Operation options, which allow you to paste values using only three arithmetic operations—Add, Subtract, and Multiply.
Definition
False
Term
Microsoft Excel allows you to use ____, such as LARGE, SMALL, and RANK.EQ, that help you to structure and analyze data in meaningful ways.
Definition
functions
Supporting users have an ad free experience!