Font size
WorksheetsMICROSOFT EXCEL
Total questions: 40
Worksheet time: 24mins
(a) is a spreadsheet program that allows you to store, organize, and analyze information
__________ was the first computer spreadsheet program. It was released to the public in 1978, running on Apple II program
Microsoft Excel 2.0
Excel 3.0 with tools bars and 3D charts
VISICALC
Lotus 123
__________ is a spreadsheet program designed for IBM-compatible personal computers by lotus corporation in 1983
VISICALC
Lotus 123
Microsoft Excel 2.0
Excel 3.0 with tools bars and 3D charts
The first Windows version was labeled "2" to correspond to the Mac version. This included a run-time version of Windows
Microsoft Excel 2.0
Excel 3.0 with tools bars and 3D charts
Excel 4.0 for Windows 3.1
Excel 95
Included toolbars, drawing capabilities, outlining, add-in support, 3D charts, and many more new features
Microsoft Excel 2.0
Excel 3.0 with tools bars and 3D charts
Excel 4.0 for Windows 3.1
Excel 95
The first popular version included lots of usability features
Excel 3.0 with tools bars and 3D charts
Excel 95
Excel 4.0 for Windows 3.1
Excel 97
The first major 32 bit version of excel feature wise it's very similar to excel 5
Excel 4.0 for Windows 3.1
Excel 95
Excel 97
Microsoft Excel 2003
A new interface for VBA developers, userForms, data validation, and lots more
Excel 95
Excel 2000
Microsoft Excel 2003
Excel 97
Can use HTML as a native file format, "self-repair" capability, enhanced clipboard, pivot charts, modeless user forms
Excel 95
Excel 97
Microsoft Excel 2003
Excel 2000
Finally some major changes in Excel. For some the changes may actually be too major
Excel 2000
Microsoft Excel 2003
Microsoft Excel 2007
Excel 2010
New features include sparkling graphics, pivot table slicers, an updated solver, and a 64-bit version
Excel 2010
Microsoft Excel 2007
Microsoft Excel 2003
Excel 2000
What are the 4 new features in Microsoft Office Excel 2003 version?
(a)
VISICALC
1978
1983
1987
1990
Lotus 123
1978
1987
1983
1990
Microsoft Excel 2.0
1978
1987
1990
1983
Excel 3.0 with tools bars and 3D charts
1987
1990
1992
1995
Excel 4.0 for Windows 3.1
1987
1990
1992
1995
Excel 95
1992
1997
1999
1995
Excel 97
1992
1995
1997
1999
Excel 2000
2010
2007
2003
1999
Microsoft Excel 2003
2010
2007
2003
1999
Microsoft Excel 2007
2010
2007
2003
1999
Excel 2010
2010
2007
2003
1999
Each workbook contains how many worksheets?
(a)
What are the 10 parts of the excel workbook?
(a)
The ___________ lets you access common commands no matter which tab you are on
quick access toolbar
ribbon
name box
formula bar
The ___________ contains all the commands you will need in order to do common tasks
quick access toolbar
name box
ribbon
formula bar
The __________ tells you the location or the name of the selected cell
quick access toolbar
ribbon
name box
formula bar
In the ___________ you can enter or edit data. A formula or function that will appear cell
ribbon
formula bar
name box
column
A __________ is a group of cells that runs from the left or the page to the right
formula bar
column
row
worksheets
Each workbook holds one more _________ also known as spreadsheets
worksheets
horizontal scroll bar
page view
zoom control
Excel files are called (a)
_________ lets you scroll and slide to the left or right depending on what part of the page
zoom control
page view
horizontal scroll bar
worksheets
What are the 3 ways to view a spreadsheet?
(a)
____________ is selected by default, and shows you an unlimited number of cells and columns. It is highlighted in the image at the right
normal view
page layout view
page break view
divides your spreadsheet into pages
normal view
page layout view
page break view
Lets you see an overview of your spreadsheet, which is helpful when you are page breaks
page break view
page layout view
normal view
This is where you can slide or drag to see the zoom percentage that is on the lest of the slide bar
zoom control
page view
horizontal scroll bar
worksheets
What certain program may install additional tools to the ribbon?
(a)
The tabs are called (a)
