The automation functionality provided by vba has

Info icon This preview shows pages 3–5. Sign up to view the full content.

View Full Document Right Arrow Icon
The automation functionality provided by VBA has caused Excel to become a target for macro viruses. This was a serious problem in the corporate world until antivirus products began to detect these viruses. Microsoft belatedly took steps to prevent the misuse by adding the ability to disable macros completely, to enable macros when opening a workbook or to trust all macros signed using a trusted certificate. Ms Excel Versions Versions for Microsoft Windows include: 1987 Excel 2.0 for Windows 1990 Excel 3.0 1992 Excel 4.0 1993 Excel 5.0 1995 Excel 7.0 (Office '95) 1997 Excel 8.0 (Office 1 97) 1999 Excel 9.0 (Office 2000) 2001 Excel 10.0 (Office XP) 2003 Excel 11.0 (Office 2003) 2007 Excel 12.0 (Office 2007) Versions for the Apple Macintosh include: 1985 Excel 1.0 1988 Excel 1.5
Image of page 3

Info icon This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
1989 Excel 2.2 1990 Excel 3.0 1992 Excel 4.0 1993 Excel 5.0 1998 Excel 8.0 (Office '98) 2000 Excel 9.0 (Office 2001) 2001 Excel 10.0 (Office v. X) 2004 Excel 11.0 (Office 2004) Versions for OS/2 include: 1989 Excel 2.2 1991 Excel 3.0 [Haredoftware; Software-Matters/Software Solutions; Ankit (2017); ] Getting started in excel i. Invoking excel and Navigating/ viewing excel ii. Commands, buttons contained in the ribbon iii. Arranging windows (maximize, minimize, restore) iv. Resizing and moving windows v. Creating a workbook vi. Moving around a work book (Using a mouse and a keyboard) vii. Saving a workbook viii. Renaming worksheets ix. Opening an existing workbook Making excel entries i. A label, Value, Formula The term label has a number of meanings in spreadsheet programs such as Microsoft Excel and Google Sheets. A label most often refers to a text entry such as a heading used to identify a column of data. The term is also used to refer to the headings and titles in charts such as the horizontal and vertical axes titles. Entering data into a spreadsheet is just like typing in a word processing program, but you have to first click the cell in which you want the data to be placed before typing the data. All words describing the values (numbers) are called labels. The numbers, which can later be used in formulas, are called values. Notice also that the labels (composed of letters) are all left justified and the values (composed of numbers) are all right justified in their cells.
Image of page 4
Image of page 5
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern