NEW
Font size
S
M
L
XL
WorksheetsExcel Review #1
Total questions: 57
Worksheet time: 1hrs 6mins
Name
Class
Date
1.
Which of the following is a mixed cell reference with a fixed column address?
a)
G$9
b)
$K356
c)
$F$8
2.
The cell range that starts in cell A1 and goes over to column J and down to row 15 is _____
a)
A1-J15
b)
A1;J15
c)
A1:J15
3.
What symbol prepares a cell for the entry of a formula?
a)
+
b)
-
c)
/
d)
=
4.
The 4 arguments used in the VLookUp function are: look up value, _________, column number, range lookup
a)
table array containing data
b)
Price of the item being looked for
5.
The LookUp function has 3 arguments. First ___________ then table array and finally, results column
a)
Value to Look Up
b)
Value to Calculate
6.
What tab would you find a list of functions and formulas on in Excel?
a)
Home
b)
Insert
c)
Page Layout
d)
Formulas
7.
Is the information below in the right order for an IF statement?
Cell to look for, True, False
Cell to look for, True, False
a)
Yes
b)
No
8.
Jane 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 he use?
a)
SUMIF
b)
AVERAGEIF
c)
TOTALIF
d)
COUNTIF
9.
A graphical representation of data is a
a)
Chart
b)
column
c)
cell
d)
X-axis
10.
James has created a spreadsheet containing student grades. Which function would he use to return the current date in cell A1?
a)
COUNT
b)
IF
c)
NOW
d)
TODAY
11.
Hal has used two different colors in his column chart to show the revenue and expenses for the year. What will Hal use to explain the different column colors?
a)
X axis
b)
Y axis
c)
Legend
d)
Chart Title
12.
Type of graph that shows parts of a whole; the proportional relationship of one set of values.
a)
line graph
b)
bar and column graph
c)
table
d)
pie graph
13.
Type of graph that shows changes in quantities over time and distance.
a)
line graph
b)
pie graph
c)
table
d)
bar and column graph
14.
Type of graph that compares item quantities.
a)
pie graph
b)
table
c)
bar and column graph
d)
line graph
15.
Larkeysha has created a spreadsheet containing student grades. Which function would she use to return the current date and time in cell A1?
a)
NOW
b)
TODAY
16.
What function should a sales manager use to indicate whether a salesperson met the goal of $6,000 sales this month?
a)
Count
b)
CountA
c)
Fill Series
d)
If
17.
Purchase discounts are awarded as follows: 3% for sales of $300, 5% for sales of $500, and 9% for sales of $900 or more. What function is used to determine which discount is allowed based on the purchase price?
a)
Count
b)
Days360
c)
List
d)
Lookup
18.
The number of hours worked is recorded in Cell D7. Hourly rate is recorded in Cell E7. Overtime hours occur anytime the number of hours worked is greater than 40. Which formula correctly determines how many (if any) overtime hours have occurred?
a)
=IF(D7<40),1.5*E7
b)
=IF(D7>40,D7-40)
c)
=MAX(D1:D7)*1.5
d)
=OVERTIME(D7*E7)
19.
What function will produce results that indicate whether a student has passed or failed a course by entering the text "Pass" or "Fail"?
a)
Count
b)
CountA
c)
If
d)
Sum
20.
This function find information in a LARGE table (more than one column) and returns a value.
a)
LookUp
b)
Now
c)
VLoookUp
21.
Which function automatically counts cells that meet a specific condition?
a)
COUNTIF
b)
COUNT
c)
COUNTIFS
d)
SUMIFS
22.
In the picture, why is D2 through D5 placed in paranthesis?
a)
So Excel knows to total the cells before performing the next operation.
b)
So the total of the cells can be multiplied rather than added.
23.
If the parenthesis is removed, what will 9.5% be multiplied by?
a)
D2 +D3+D4+D5
b)
D5
c)
D2
d)
None
24.
Cell value references should always be used when possible to avoid having to make multiple updates when one key value changes.
a)
True
b)
False
25.
Excel follows the ___________________ and first adds the values inside the parentheses.
a)
Order of Operations
b)
Formula Guidelines
26.
___________ are often the best way to define which calculations will be performed first in Excel.
a)
Parentheses
b)
Forumlas
27.
By default, all cell references are _________ references.
a)
Absolute
b)
Relative
28.
Unlike _________ references, _________ references do not change when copied or filled.
a)
Absolute, Relative
b)
Relative, Absolute
29.
An absolute reference is designated in a formula by the addition of a _______ sign.
a)
%
b)
$
c)
&
d)
#
30.
In order to create a single formula to copy to the other rows, use ______ references so the formula calculates the total for each item correctly.
a)
relative
b)
relational
31.
If you don't want a cell reference to change when copied to other cells, use _________ references
a)
Absolute
b)
relative
32.
If you want a cell reference to change when copied to other cells, use _________ references
a)
Absolute
b)
Relative
33.
The four arguments used in the VLookUp function are: Name of Item, _________, column index number, look for approximate match.
a)
range containing data
b)
Price of the item being looked for
34.
When using VLookUp, use _______________ if you want to look for approximate matches rather than an exact match.
a)
True
b)
False
35.
Where can you see formulas?
a)
The formula bar
b)
The cell that contains the answer to the formula if you double click on it.
c)
Both A and B
36.
You can name a cell or a cell range by
a)
Selecting the cell(s) to be named, click in the name box, type the name in and press enter
b)
Click on Define Name on the Formulas tab
c)
Select text to be named and click on Create from Selection
d)
All of the above
37.
=(January!B3) is a reference of
a)
a named range
b)
an external reference (a different worksheet)
c)
the name manager
38.
A group of cells is called a
a)
range
b)
named group
c)
formula
d)
component
39.
What method is the most efficient way to copy five separate formulas to adjacent cells at the same time?
a)
Copy method from shortcut menu
b)
copy using the fill handle
c)
copy from the home tab
40.
Per the order of operations, which of the following is calculated first?
a)
Addition
b)
Exponents
c)
Division
d)
Subtraction
41.
Which of the following is an example of a mixed reference?
a)
A9
b)
$A$9
c)
A$9
d)
A9:E9
42.
How do you insert a new row?
a)
Right-click the row heading where you want to insert the new row and select Insert from the shortcut menu
b)
Select the row heading where you want to insert the new row and select Edit >Row from the menu
c)
Select the row heading where you want to insert the new row and click the Insert Row button on the standard toolbar
d)
All of the above
43.
How do you select an entire column?
a)
Select Edit > Select > Column from the menu
b)
Click the column heading letter
c)
Hold down the shift key as you click anywhere in the column.
d)
Hold down the Ctrl key as you click anywhere in the column
44.
How can you find specific information in a list?
a)
Select Tools > Finder from the menu
b)
Click the Find button on the standard toolbar
c)
Select Insert > Find from the menu
d)
Select Data > Form from the menu to open the Data Form dialog box and click the Criteria button
45.
What would be a correct formula for SUM in excel?
a)
=SUM(B3:B9)
b)
=SUMB3+B9
c)
SUM(B3:B9)
d)
=ADD(B3:B9)
46.
Which button can you click to add up a series of numbers?
a)
The autosum button
b)
The Formula button
c)
The quicktotal button
d)
The total button
47.
To copy formatting from one area in a worksheet and apply it to another area you would use:
a)
The Edit>Copy Format and Edit>Paste Format commands form the menu.
b)
The Copy and Apply Formatting dialog box, located under the Format>Copy and Apply menu.
c)
There is no way to copy and apply formatting in Excel � You have to do it manually
d)
The Format Painter button on the standard toolbar
48.
If the cell contains hashtags (#), what do you need to do?
a)
Expand the column
b)
Expand the row
c)
Change the formula
49.
Each Excel file is called a workbook because
a)
It can contain text and data
b)
It can be modified
c)
It can contain many sheets including worksheets and chart sheets
d)
You have to work hard to create it
50.
You can edit a cell by...
a)
Clicking the formula button
b)
Double clicking the cell
c)
Selecting Edit>Edit Cell from the menu
d)
None of above
51.
Which formula gets the biggest value of a range of cells?
a)
MAX
b)
MIN
c)
LARGE
d)
SUM
52.
Which formula gets the smallest value of a range of cells?
a)
MAX
b)
MIN
c)
SMALL
d)
SUM
53.
Columns go...
a)
Across
b)
Down
54.
Rows go...
a)
Across
b)
Down
55.
In a cell reference, for example A1, what does the letter refer to?
a)
The column
b)
The cell
c)
The row
56.
When entering text in Excel, it is automatically (by default):
a)
Left Justified
b)
Right Justified
c)
Center Justified
d)
Full Justified
57.
When entering numbers in Excel, they are automatically (by default):
a)
Left Justified
b)
Right Justified
c)
Center Justified
d)
Full Justified
Reset
