NEW
Font size
S
M
L
XL
WorksheetsExcel fundamentals
Total questions: 20
Worksheet time: 10mins
Name
Class
Date
1.
You have decided to center the text within a cell. What have you done?
a)
Merge cells
b)
Wrapped text
c)
Changed alignment
d)
Auto-fit content
2.
You can use the Formulas Tab to change the Excel View, to hide Heading, Gridlines and the Ruler.
a)
True
b)
False
3.
In Excel, all formulas must begin with what symbol?
a)
!
b)
=
c)
@
d)
#
4.
What terms refers to mathematical equations used in Excel to perform calculations?
a)
Format
b)
Summations
c)
Cell
d)
Formulas
5.
Which of these number formats would you want to apply to a cell showing the total sales for the month?
a)
Date
b)
Currency
c)
Percentage
6.
What does it mean to merge cells?
a)
Apply a border around a set of cells.
b)
Combine 2 or more cells into a single cell.
c)
Center the contents of the cells.
d)
Split a single cell into 2 or more cells.
7.
Microsoft Excel can use Headers and Footers, just like Microsoft Word.
a)
True
b)
False
8.
What function should be entered to calculate the total budget?
a)
=SUM(B3:B6)
b)
CALCULAT(B3:B6
c)
=SUM(B3 to B6)
d)
=AVERAGE(B3:B6)
9.
Which letter on the image is a Row?
a)
A
b)
B
c)
C
d)
D
10.
Why would you want to change the column width?
a)
To draw attention to the data in those cells.
b)
To make sure the column headings are always visible when scrolling.
c)
To make sure all of the information in the column is visible.
11.
What symbol is used to designate an absolute cell reference?
a)
!
b)
$
c)
@
d)
#
12.
You want to enter a series of dates down a column. What would be the best tool for the job?
a)
Find & Replace
b)
Auto fill
c)
Spelling Checker
d)
Cut & Paste
13.
Which of these formulas uses relative cell references?
a)
=5*10+20
b)
=$A$10/100
c)
F18+F19/2
14.
Which letter on the image is a Name Box?
a)
A
b)
B
c)
C
d)
D
15.
Which letter on the image is a column?
a)
A
b)
B
c)
C
d)
D
16.
What is the address of the currently selected cell?
a)
B4
b)
4B
c)
C4
d)
B5
17.
Which letter on the image is a cell?
a)
A.
b)
B.
c)
C.
d)
D.
18.
What formula should be entered to calculate the total budget?
a)
=B3+B4+B5+B6
b)
=CALCULATE
c)
=3b+4B+5B+6B
d)
=B3+B5
19.
Which of these are NOT number formats in Microsoft Excel?
a)
Currency
b)
Percentage
c)
Roman Numerals
d)
Date
20.
What happens when you hide a column in Microsoft Excel?
a)
The column doesn't appear, but the data is still there.
b)
The data in the column is deleted.
c)
Formulas referencing cells in the column stop working.
Reset
