NEW
Font size
S
M
L
XL
WorksheetsExcel Skills - 2
Total questions: 25
Worksheet time: 13mins
Name
Class
Date
1.
Dan only wants to view the employees in the Marketing department who earn a salary of more than £30,000. What command should he use to complete this task?
a)
Sort
b)
Filter
c)
Find & Replace
d)
AutoFill
2.
William wants to arrange the employee salaries in Column A of his spreadsheet from lowest to highest. What command should he use to complete this task?
a)
Sort
b)
Filter
c)
AutoFill
d)
Find & Replace
3.
Mary wants to count the number of cells in a range in her spreadsheet. She would like to count only the cells in that range that contain 100. What function should she use?
a)
COUNTIF
b)
AVERAGEIF
c)
SUMIF
d)
TOTALIF
4.
Which command on the Home Ribbon do you use to temporarily hide specific values on a worksheet based on a criterion?
a)
Find & Select
b)
Sort & Filter
c)
Organize
d)
Format Cell
5.
Cooper is creating a spreadsheet for the school and wants to be able to put the spreadsheet in alphabetical order by last name. What should Cooper apply to the spreadsheet?
a)
Outline
b)
Collapse
c)
Sort
d)
Subtotal
6.
All forumulas in Excel begin with the following symbol
a)
+
b)
=
c)
%
d)
/
7.
Solid lines that mark off the rows and columns in a worksheet.
a)
Bold
b)
Merge
c)
Gridlines
d)
Underline
8.
The column letter and row number that identify a cell, such as B3.
a)
Cell
b)
Active Cell
c)
Cell Reference
d)
Row
9.
How do you select a cell range?
a)
Click
b)
Hold
c)
Drag
d)
All of the above
10.
Joan wants to see her sales representatives in numerical order with the sales person who sold the least at the top. Which sorting option should she choose?
a)
Ascending
b)
Descending
c)
Primary Sort
d)
Customer Filter
11.
When you want a formula to multiply for you, you use....
a)
X
b)
>
c)
*
d)
++
12.
What command is used to insert information into a worksheet that will display at the top and bottom edges of the printed page
a)
Margins
b)
Print titles
c)
Header & Footer
d)
Page Setup
13.
In Microsoft Excel, what is used to emphasize certain entries and make the worksheet easier to read and understand?
a)
Formatting
b)
Printing
c)
Arranging
d)
Configuring
14.
If a cell shows ####### , it means that
a)
Your formula has a syntax error
b)
The row is too short to show the number a the current font size
c)
The column is too narrow to show all the digits of the number
d)
None of the above
15.
This is a:
a)
Row
b)
Column
c)
Cell
d)
None of the above
16.
To arrange information by kinds or classes, or in a particular order:
a)
Enter
b)
Tab
c)
Sort
d)
None of the above
17.
This is a tool that lets you pick what specific data you want to display.
a)
1 - Filter
b)
2 - Sort
c)
3 - Wrap
d)
4 - Merge
18.
This is a tool that puts your data in alphabetical or numerical order.
a)
1 - Filter
b)
2 - Sort
c)
3 - Wrap
d)
4 - Merge
19.
What formula function will determine the smallest value in a range?
a)
=min(range),
b)
=max(range),
c)
=average(range),
d)
=smallest(range)
20.
Which of the following has a cell reference?
a)
5%
b)
=4*3.7
c)
=G4/E3
d)
sub-total
21.
This operation is used to print a portion of a spreadsheet.
a)
Print preview
b)
Print selection
c)
Sort
d)
Freeze panes
22.
Which is the correct formula to add cells A1 to A5?
a)
=SUM(A2+A5)
b)
=SUM(A1:A5)
c)
=A1+A2+A3
d)
=SUM(A1:A4)
23.
Amanda has created a spreadsheet containing test grades for the first nine weeks. Which function would she use to estimate the grade on her next text?
a)
Average
b)
Max
c)
Min
d)
Sum
24.
Formatting worksheet data by changing the look of the cells that meet specified conditions
a)
Conditional Formatting
b)
Sorting
c)
Filtering
d)
Scrubbing
25.
Displaying a subset of data that meets certain criteria and temporarily hides other data
a)
Filtering
b)
Sorting
c)
Conditional Formatting
d)
Erasing
Reset
