WorksheetsExcel Fundamentals
Total questions: 17
Worksheet time: 9mins
Name
Class
Date
1.
What symbol is used to designate an absolute cell reference?
a)
@
b)
!
c)
#
d)
$
2.
What is the argument in this function? =AVERAGE(F3:F26)
a)
AVERAGE
b)
F3
c)
F26
d)
F3:F26
3.
In Excel, all formulas must begin with what symbol?
a)
#
b)
=
c)
$
d)
!
4.
Which of these formulas uses relative cell references?
a)
=5*10+20
b)
=$A$10/100
c)
=F18+F19/2
5.
What term refers to mathematical equations used in Excel to perform calculations?
a)
Summations
b)
Cell
c)
Format
d)
Formulas
6.
You want to enter a series of dates down a column. What would be the best tool for the job?
a)
Find and Replace
b)
AutoFill
c)
Spelling Checker
d)
Cut and Paste
7.
What function can be used to find the largest number in a range of numbers?
a)
=AVERAGE
b)
=MIN
c)
=MAX
d)
=SUM
8.
Which of these number formats would you want to apply to a cell showing the total sales for the month?
a)
Currency
b)
Percentage
c)
Date
d)
None of the others
9.
You have decided to center the text within a cell. What have you done?
a)
Merged Cells
b)
Wrapped Text
c)
Changed Alignment
d)
Autofit Content
10.
Which of these statements are true?
a)
You can use borders to create a group of cells or make specific cells stand out.
b)
For cells that contain text, it is better to use a pattern rather than a shade.
c)
The more shades you use on a worksheet, the more attractive it will be.
d)
All of the others.
11.
Which of these are NOT number formats in Microsoft Excel?
a)
Roman Numerals
b)
Percentage
c)
Date
d)
Currency
12.
You can use the Formulas Tab to change the Excel View, to hide Heading, Gridlines and the Ruler.
a)
True
b)
False
13.
What does it mean to merge cells?
a)
Combine 2 or more cells into a single cell.
b)
Apply a border around a set of cells.
c)
Split a single cell into 2 or more cells.
d)
Center the contents of the cells.
14.
What happens when you hide a column in Microsoft Excel?
a)
The data in the column is deleted.
b)
The column doesn't appear, but the data is still there.
c)
Formulas referencing cells in the column stop working.
d)
None of the others.
15.
When would you use conditional formatting on a cell?
a)
You want to highlight negative numbers by using red text.
b)
You want to change the font for every cell in the spreadsheet.
c)
You want to hide the contents of a column.
d)
You want to use a formula and function to sum the values in a column.
16.
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.
17.
Microsoft Excel can use Headers & Footers, just like Microsoft Word.
a)
True
b)
False
100 %
