WorksheetsMicrosoft Excel
Total questions: 30
Worksheet time: 10mins
An application that organizes data into cells, rows and columns is classified as a
Database
Spreadsheet
Word Processor
Text Editor
The first electronic spreadsheet that was made for the Macintosh PC was
Corel Quattro Pro
Lotus 1-2-3
OpenOffice.org Calc
VisiCalc
The spreadsheet program included in MS Office Productivity Suite is
Access
Excel
PowerPoint
Word
Lotus 1-2-3 was invented by
Bill Gates
Bob Frankston
Dan Bricklin
Mitchell Kapor
The person considered as the “Father of the Spreadsheet” is
Bob Frankston
Dan Bricklin
Steve Jobs
Thomas Watson
A file containing one or more worksheets is called
Document
Text file
Workpad
Workbook
An on-screen spreadsheet that contains various cells in columns and rows is known as
Blank Page
Spread
Tab
Worksheet
The intersection of a row and column is called
Cell
Coordinate
Grid
Space
A currently selected cell is called
Active Cell
Blank Cell
Cell A1
First Cell
The part of the Excel window that displays the cell reference of the active cell is the
Formula Bar
Formula Box
Name Box
Status Bar
There are 1,048,576
Column Headers
Column Markers
Row Headers
Row Markers
The letters A to XFD above the worksheet are called
Column Headers
Column Markers
Row Headers
Row Markers
The coordinate of the intersecting row and column is called
Cell Reference
Cell Grid
Cell Name
Cell Marker
The faint lines around the cells that distinguishes cells on the worksheet are called
Gridlines
Margins
Guidelines
Guides
The total number of cells in Excel 2016 spreadsheet is
65,536
1,048,576
16,777,216
17,179,869,184
To edit the contents of a cell press
F2
F3
F4
F5
To close the current workbook, press
Ctrl+W
Ctrl+X
Ctrl+Y
Ctrl+Z
The part of the worksheet that runs horizontally and are identified by numbers are called
Cell
Column
Gridline
Row
The part of the worksheet that runs vertically and are identified by letters are called
Cell
Column
Gridline
Row
The total number of columns in Excel is
16,384
1,048,576
16,777,216
17,179,869,184
Pressing Shift+Tab key moves the cell pointer one cell to the left.
True
False
The cell pointer will move one cell up when you press Shift+Enter.
True
False
Pressing the Tab key moves the cell pointer one screen to the right.
True
False
The End key is used to move the cell pointer to the last cell on the column.
True
False
Ctrl+PgDn goes down one screen.
True
False
Press F6 to enter a specific cell address that you want to go to.
True
False
The Home key is used to move the cell pointer to the first cell on the row.
True
False
Several rows will be selected if you click and drag across the row headers.
True
False
To resize a column, point on the grid line between the cells, then click and drag.
True
False
AutoFit automatically fits the cell on the exact length of text only but not its size.
True
False
