Excel Basic



Excel BasicsFill in the Answers from the Power Point and Invoice DemonstrationThe electronic spreadsheet was essentially invented in _____ by software pioneer Dan Bricklin, who started up Software Arts with?Bob Frankston?and created VisiCalc.It was released in ______ by Microsoft under the name of _________.Excel was the very ______ Microsoft Office Application. The latest version of Excel has _______________ columns and ______________ rows.What is the name of the application offered by Open Office that compares to the MS Excel Application? _________Is Apache OpenOffice free? _______________ is an area at the top of an office program window that contains commands for working with the open file; the commands are organized under tabs.The feature to extend a series of values based on the contents of a single cell is called ______________.The ____________ is the box at the intersection of a row and a column.The ______ ________ is a collection of cells that are related for some reason.The ______ _________ is the letter and number code such as B15, that identifies the row and column intersection of a cell.The visual representation of data contained in a worksheet data is called a __________. A __________ is made up of cells that are on the same vertical line in a worksheet. A __________ is made up of cells that are on the same horizontal line in a worksheet. The ______ ________ is the small square at the bottom right hand corner of a cell that is dragged to indicate other > cells that should hold values in the series defined by the active cell.The __________ is an expression within a cell used to calculate a value. A _____________ is a pre-programmed formula or routine that is built in to Microsoft Excel. The page layout orientation format where the page is wider than it is high. ____________________ The page layout orientation format where the page is higher than it is wide. ____________________The _______ ______ is the indicator for a worksheet, located in the lower left corner of the workbook window. The ____________________ is the basic Microsoft Excel document, consisting of one or more worksheets.The ____________________ is a page in a Microsoft Excel workbook.EXCEL Information and PracticeOpen a blank workbook in Excel 2016Rename it Practice week 6. File, Save As, RenameEnter the numbers 22, 43, 543, 76, 99, 12 into cell range A1:A6In A7 – add a sum formula and range a1:a6 Remember to always start a formula with an = like: =sum(a1:a6)In A8 – add an average formula using the range a1:a6In A9, A10, A11 – add the min, max and count function, respectivelyFormatting CellsInsert a row above row 1Notice the change in sum, average, etc… formulas ranges – The formulas and cell locations all changed to the new rangesIn the new A1 cell add: This is a practice sheetMerge and center the title between a1 and g1, make it bold, font size 16, with a light colored background fill. Add another row below the first row, add your name and formattingAdd another row with columns labeled Sun, Mon, Tues, Wed, Thurs, Fri, Sat (use the fill handle) – watch instruction Fill in the grid with random values (you add the values)Use the fill handle and copy the sum, average, min and max formulas across the rows.Add a border to row 9 and row 13Add a column to the left of the tableLabel and format the rows like below. Save the file and Email it to dsjoberg@ ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download