NEW
Font size
WorksheetsExcel
Total questions: 15
Worksheet time: 7mins
What is the intersection of a column and a row on a worksheet called ?
Column
Value
Address
Cell
Functions in MS Excel must begin with ___
An () sign
An Equal Sign
A Plus Sign
A > Sign
In Excel, Columns are labelled as ___
A, B, C, etc
1,2,3 etc
A1, A2, etc.
$A$1, $A$2, etc.
The Greater Than sign (>) is an example of _____ operator.
Arithmatic
Logical
Conditional
Greater
The ____ feature of MS Excel quickly completes a series of data
Auto Complete
Auto Fill
Fill Handle
In Excel, Rows are labelled as ______
A, B, C, etc
1,2,3 etc
A1, A2, etc.
D.$A$1, $A$2, etc.
The basic unit of a worksheet into which you enter data in Excel is called a
cell
table
box
D.column
How many sheets are there, by default, when we create a new Excel file ?
1
3
5
10
In Excel, which one denoted a range from B1 through E5
B1 - E5
B1:E5
B1 to E5
B1$E5
An Excel file is generally called a / an
Spreadsheet
Worksheet
Workbook
Sheet
It is a collection of data that is stored electronically as a series of records in a table.
spreadsheet
presentation
database
MS Word
A fast way to add up this column of numbers is to click on the cell below the numbers and then:
Click Subtotals on the Data menu.
Click the AutoSum button on the Standard toolbar, then press ENTER
View the sum in the formula bar.
How do you change the column width to fit the contents?
Single-click the boundary to the left of the column heading.
Double-click the boundary to the right of the column heading
Press ALT and single-click anywhere in the column.
###### means:
You've entered a number wrong.
You've misspelled something.
The cell is not wide enough.
To add a new row, click a cell in the row immediately above where you want the new row.
True
False
