# Shared Flashcard Set

## Details

Data Analysis CGS 2518 by Jill Weiss
CGS 2518 by Jill Weiss Exam 1
98
Computer Science
02/04/2014

Term
 Move up one row.
Definition
 Shift+Enter
Term
 Move one column to the left.
Definition
 Shift+Tab
Term
 Move to previous or next sheet in current workbook.
Definition
 Ctrl+Page Up& Ctrl+Page Down
Term
 Returns to the first cell in the worksheet.
Definition
 Ctrl + Home
Term
 Go-To Dialog Box:
Definition
 Ctrl+G or the button on the editing group.
Term
 Excel allows a maximum of _______ columns in a worksheet.
Definition
 16,385
Term
 By default, text is ___-aligned in cells whereas numbers, dates, and times are ___-aligned.
Definition
 Left, Right
Term
Definition
 A collection of text ad numbers laid out in a rectangular grid.
Term
 What is a chart sheet?
Definition
 Contains an excel chart that provides a visual representation of worksheet data.
Term
 What is a cell reference?
Definition
 A number and letter that indicate the row and column location.
Term
 What is text data?
Definition
 Any combination of letters, numbers, and symbols that form words and sentences.
Term
 What is number data?
Definition
 Any numerical value that can be used in a mathematical calculation.
Term
 Truncated?
Definition
 When the rest fo an entry is hidden from view.
Term
 What is Autocomplete?
Definition
 Excel tries to anticipate what you may be tryping to amke repetitive typing easier.
Term
 What does Wrap Text do?
Definition
 Forces tect that extends beyond the border to fit within a cell.
Term
 If a number exceeds it cell size you see?
Definition
 #####
Term
 Difference between clearing and deleting.
Definition
 Clearing only removes data, deleting removes the cells as well.
Term
 insert a row.
Definition
 Home Tab - Insert button
Term
 How large is a point?
Definition
Term
 What are  the two types of sheets in a workbook?
Definition
 Worksheets and chartsheets.
Term
 A group of cells is called a?
Definition
 Cell range or range.
Term
 A _____ is an expression that returns a value.
Definition
 Formula
Term
 Binoculars.
Definition
 Find + Select
Term
 A group fo cells in a single rectangular block of cells.
Definition
Term
 Select all?
Definition
 Ctrl + A
Term
 Hold this down to select cells in different areas of the worksheet.
Definition
 Ctrl
Term
 A formula is written using _________that combine different values resulting in a single value that si displayed in the cell.
Definition
 operators
Term
Definition
 =
Term
 Where is the page break preview button?
Definition
 On the status bar.
Term
 To toggle between formula view and normal view.
Definition
 Ctrl + `
Term
 What are the two types of ranges in excel?
Definition
Term
 How do you rename a worksheet?
Definition
 Double click the sheet tab and type the new name.
Term
 How are page-breaks indicated in page break preview?
Definition
 A dotted blue border sepearates one page from another.
Term
 What is the typeface?
Definition
 The specific design of a set of characters, including letters, numbers, punctuation marks, and symbols.
Term
 What is a theme?
Definition
 A collection of of formats for text, colors, images, and graphical effects applied throughout a workbook.
Term
 Formatting?
Definition
 The process of changing a workbook's appearance by defining the fonts, styles, colors, and decorative features.
Term
 How many standard colors are there?
Definition
 10
Term
 What is the difference between the serif and the sans serif fonts?
Definition
 Serif includes delicate strokes, whereas sans serif does not include them.
Term
 ______ colors are the  ___ colors that belong to a workbook's ______.
Definition
 Theme, 12, Theme
Term
 Why are dates right aligned in a worksheet by default?
Definition
 Excel treats dates and time as numbers.
Term
 What is the general number format?
Definition
 Displays values exactly as they are typed by the user.
Term
 What three tools can you use to copy formats?
Definition
 Format painter, paste special and the paste options buttons.
Term
 What is a conditional format?
Definition
Term
 What are print titles?
Definition
Term
 Six table style options you can turn on and off?
Definition
Term
 Difference between an cell style and a table style?
Definition
Term
 Two methods of applying the same format t different ranges.
Definition
Term
 Where can you define the page margins?
Definition
 GO to the page layout tab and then press the margns button.
Term
 veA
Definition
Term
 A/an ______ reference is interpreted in relation to the location of the cell containing the formula.
Definition
 Relative
Term
 A/an absolute reference fixed when the cell formula is copied to a new location and has an \$ in front of the column letter and the row number.
Definition
 Absolute
Term
 ______________ argumentsfs (in bold)are needed to return a value.
Definition
 Required
Term
 The _______ function return s the sum of the values in the range.
Definition
 Sum
Term
 The _______ function returns the minimum value in the range.
Definition
 MIN
Term
 The _______ function returns the average value of the range.
Definition
 AVERAGE
Term
 The _______ function returns the maximum value in the range.
Definition
 MAX
Term
 The __________ are not required for the function to return a value.
Definition
 optional arguments
Term
 Each chart has a ____ ____, which is the range that contain the data to display in the chart.
Definition
 data source
Term
 What does the TODAY function do?
Definition
Term
 An ______ is a logical function that tests a condition and then returns one value if the condition is true and another value if the condition is false.
Definition
 IF function
Term
 What does the fill handle do?
Definition
 Copies the formating and content into another selected range.
Term
 A ____ function inserts or calculates dates and times.
Definition
 Date
Term
 An Excel ________ is a spreadsheet written or tailored to meet specific needs.
Definition
 Application
Term
 Defined names can include as many as ____ characters
Definition
 255
Term
 A ______ _______ indicates that the cell contains a comment.
Definition
 Red triangle
Term
 The Defined Names group can be found in the _______ tab
Definition
 formulas
Term
 The data validation button can be found in the _____ tab
Definition
 Data
Term
 To protect a worksheet, go to the _____ group of the _______ tab
Definition
 changes, review
Term
 (Keyboard short cut)Current Date
Definition
 CTRL + ;
Term
 Row 1 is also known as:
Definition
Term
Definition
 Field Names
Term
 Values within () are called ________
Definition
 Arguments
Term
 (Keyboard short cut)Undo
Definition
 Alt + Backspace
Term
 (Keyboard short cut)Auto fill selected cells
Definition
 CTRL + Enter
Term
 The fields that you use to order data are called ______ fields
Definition
 Sort Fields
Term
 Each row represents a _______
Definition
 Record of data entered by the user.
Term
 + button is called
Definition
 The expand button.
Term
 - button is called
Definition
 The collapse button
Term
 A quicker and easier way to filter a PivotTable or PivotChart is by using a
Definition
 Slicer
Term
 Freeze Pane is located in the _____ tab
Definition
 View
Term
 _______ and left click to select a range of worksheets.
Definition
 Shift
Term
 ______ click the fill handle to auto fill
Definition
 Double
Term
 When you select any cell, it becomes the
Definition
 Active Cell
Term
 The split button is in the _____ tab
Definition
 View
Term
 To rename a table, go to table name located in the ________ group of the Design tab
Definition
 Properties
Term
 A worksheet _____ is a collection of two or more selected worksheets
Definition
 Group
Term
 What is the PMT function used for?
Definition
 Calculates the payment for a loan based on constant payments and a constant interest rate.
Term
 True or False?Subtotals can be done in a table?
Definition
 False
Term
 An _____________ is an object in a worksheet.
Definition
 embedded chart
Term
 A data source is a collection of ____ _____which is a range of values that is plotted as a single unit on a chart.
Definition
 data series
Term
 A _________________ is a rectangular area that indicates the data and markers associated with the data series.
Definition
 Legend
Term
 _____ marks identify the units t regular intervals on the chart axis.
Definition
 Tick
Term
 The _____ area contains the chart and all other chart elements inside of it.
Definition
 chart
Term
 Every function has to follow a set of rules or _____ in order to function and return a value.
Definition
 syntax
Supporting users have an ad free experience!