Computer quiz 4th quarter

• Microsoft excel is a spreadsheet program that allows you to store, organize, and analyze information
• Spreadsheet is an interactive file which consists of vertical and horizontal lines that form rows and columns
• Cell is the intersection of a row and a column
• Cell address is the location of the cell
• group of cells is known as a cell range
• merged cell is a single cell that is created by combining two or more cells
• Arrow is used for menus or for moving a selection

  
• Thick cross is the general pointer for selecting single cells or a group of cells

  
• I-Beam or insertion point indicates the cursor position when editing a cell entry

  
• Fill handle is used for copying a formula or extending data series

  
• Double arrow appears at the borders of column headings and is used to widen a column

  
• Row pointer is used to select a whole row when positioned on the row number

  
• column pointer is used to select a whole column when positioned on the column letter

  
• template is a predesigned spreadsheet that you can use to create a new workbook quickly
• Excel files are called workbooks
• save command is used to save and make permanent the changes you have made in the document
• Save as command is used to create a copy of your original workbook and assign a new file name and the same or a different location for the copied version
• fill handle feature allow you to copy and paste content quickly to adjacent cells in the same row or column
• flash fill is a feature in excel that can be used to enter data automatically into your worksheet, saving you time and effort
• data can be text or number and can be classified into three types: label, value, and formula
• label is any type of data not used in calculations
• value is data that can be used for calculations
• formula is an expression that calculates the value in a cell
• formula is an expression which calculates the value of a cell in excel
• cell reference refers to a cell or cell range that can be used to solve a formula in a spreadsheet program
• two types of cell references: relative reference, absolute reference
• relative reference change when a formula is copied to another cell
• absolute references remain constant no matter where they are copied
• autosum allows you to add quickly a range of cells together
• functions are ready-made formulas that perform a series of operations on a specified range of values
• the count function is generally used to count a range of cells containing numbers or dates excluding blanks and texts
• counta function counts everything–numbers, dates, texts, or a range containing a mixture of these items—but does not count blank cells
• text functions allow you to modify and format texts
• if function checks whether a condition is met and returns one value if true and another value if false
• countif is a function used to count cells that meet a single criterion