NEW
Font size
S
M
L
XL
WorksheetsMicrosoft Excel 2013 Survey (Basic)
Total questions: 20
Worksheet time: 9mins
Name
Class
Date
1.
Which one of the following is a spreadsheet application?
a)
Microsoft Word
b)
Microsoft Powerpoint
c)
Microsoft Excel
d)
Microsoft Outlook
2.
How do you change column width to fit the contents?
a)
Single-click the boundary to the left of the column heading
b)
Double-click the boundary to the right of the column heading
c)
Press ALT and single-click anywhere in the column
3.
Which button allows you to copy cell formats from one cell to another?
a)
Enter
b)
Autofit
c)
Format Painter
d)
Esc
4.
True or False. If you choose a larger font size, the height of the row is automatically made taller.
a)
True
b)
False
5.
An example of a range address.
a)
A1:B3
b)
A1;B3
c)
A1-B3
d)
A1=B3
6.
A formula in the spreadsheet should always start with
a)
a plus sign
b)
an asterisk
c)
an equals sign
d)
a capital letter
7.
Which filename extension is used for Excel workbooks?
a)
.com
b)
.xls
c)
.htm
d)
.doc
8.
In a spreadsheet formula which symbol is used to multiply?
a)
+
b)
-
c)
*
d)
x
9.
What is the name given to the intersection of a row and a column in a spreadsheet?
a)
cell
b)
block
c)
cube
d)
square
10.
Which direction do rows run in a spreadsheet?
a)
vertical
b)
clockwise
c)
horizontal
d)
diagonal
11.
How are columns designated?
a)
Circles
b)
Letters
c)
Numbers
d)
Stars
12.
How are rows designated?
a)
Circles
b)
Letters
c)
Numbers
d)
Stars
13.
Which of these would add up the numbers from A3 to A6
a)
+(A3:A6)
b)
=(A3:A6)
c)
=(Ave(a3:a6))
d)
=Sum(A3:A6)
14.
Which direction do columns run in a spreadsheet?
a)
Vertical
b)
Counter-Clockwise
c)
Diagonal
d)
Horizontal
15.
Pressing ENTER moves the selection one cell to the right by default.
a)
True
b)
False
16.
When a worksheet is printed, the grid lines that surround the cells are printable by default.
a)
True
b)
False
17.
The active cell is what is currently selected, where data is entered when you begin typing.
a)
True
b)
False
18.
The active cell is bounded by a heavy border.
a)
True
b)
False
19.
What are lines that can be applied around worksheet cells or objects?
a)
Gridlines
b)
Borders
c)
Underlines
d)
Boundaries
20.
It is possible to type numbers and letters (words) into a cell.
a)
True
b)
False
Reset
