WorksheetsMicrosoft Excel 2010
Total questions: 15
Worksheet time: 30mins
The Intersection of rows and columns is known as ______.
Cell
Grid lines
Header
Footer
In MS Excel, Rows are labeled as_______.
A,B, C etc.
1,2,3 etc.
A1,A2,etc.
$A$1, $A$2 etc.
The ________ feature of MS Excel quickly completes a series of data.
AutoFill
Fill Handle
Auto Complete
Sorting
When you enter text in a cell in MS Excel. It is also appears in the
Status Bar
Row Heading
Name Box
Formula Bar
In a worksheet, there are ________ columns.
16,384
16,385
16,390
16,382
In Excel, which one denoted a range from B1 through E5
B1-E5
B1:E5
B1 to E5
B1 $ E5
Which of the following is not a term pertaining to spreadsheet?
Cell
Formula Bar
Browser
Rows
Select the correct example of a cell address:
3611
901
98A
A25
Formulas in Excel start with:
%
+
=
-
In excel, by default there are ______ number of worksheets.
1
2
3
4
The Name Box:
Shows the location of the previously active cell.
Appears to the left of the formula bar.
Appears below the starts bar.
Appears above the menu bar.
Excel displays the current cell address in the ______.
Formula bar
Menu bar
Name box
Title bar
Status bar shows the name of the currently selected command or current activity.
True
False
Pressing the ______ key opens the Save As dialog box.
F3
F7
F10
F12
By default, the number is _____aligned in a cell.
Left
Center
Right
