WorksheetsExcel 2016
Total questions: 20
Worksheet time: 10mins
Which of the following is considered a range in Excel?
9B:30C
A1:B8
A1, C22, D14
They are all ranges
Which of the following is a row?
A
B
C
D
Which of the following is the Name Box?
A
B
C
D
What is the address of this cell?
B3
3B
AB3
None of them is correct
This mouse pointer allows you to _____.
Change the height of an entire row
Delete an entire row
Select an entire column
Select an entire row
What can a cell contain?
A column
A number, text, formula or function
A row
The cell address
What is a workbook?
Excel file
Excel spreadsheet page.
A number, text, formula or function
Which keyboard shortcut bolds text in a cell?
“Ctrl+B”
“Ctrl+I”
“Ctrl+U”
“Ctrl+X”
Which of the following is NOT a way to change the column width in Excel?
Right-click the column header and then click Column Width.
Click and drag the column's boundary line to the desired width.
Double-click the column header and then click Delete.
Double-click the column's boundary line.
Which of the following methods cannot be used to enter data in a cell
a. Pressing an arrow key
b. Pressing the Tab key
c. Pressing the Esc key
d. Clicking on the formula bar
Which of the following will not cut information?
a. Pressing Ctrl + C
b. Selecting Edit>Cut from the menu
c. Clicking the Cut button on the standard
d. Pressing Ctrl+X
You accidentally erased a record in the sheet. What command can be used to restore it immediately?
A. Insert
B. Copy
C. Undo
D. Replace
What is the shortcut key to highlight the entire column?
A. Ctrl+C
B. Ctrl+Enter
C. Ctrl+Page Up
D. Ctrl+Space Bar
Which of the following is not a term of MS-Excel?
A. Cells
B. Rows
C. Columns
D. Document
The basic unit of a worksheet into which you enter data in Excel is called a
A.cell
B.table
C.box
D.column
The advantage of using a spreadsheet is:
A. calculations can be done automatically.
B. changing data automatically updates calculations
C. more flexibility
D. All of the above
The options available in Backstage view are________
New
Save/Save as
Open
All of these
The Extend selection mode can be enabled using the __________key
F5
F2
F8
F12
The ________displays the address of the selected cell
Formula bar
Name box
Title Bar
None of the above
A______is a rectangular block of contiguous cells
Address
Range
Cell
Formula
