NEW
Font size
S
M
L
XL
WorksheetsMicrosoft Excel
Total questions: 50
Worksheet time: 40mins
Name
Class
Date
1.
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
2.
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
3.
To create a formula, you first:
a)
Select the cell you want to place the formula into
b)
Type the equals sign (=) to tell Excel that you're about to enter a formula
c)
Enter the formula using any input values and the appropriate mathematical operators that make up your formula
d)
Choose the new command from the file menu
4.
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)
5.
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
6.
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
7.
If the cell contains hashtags (#), what do you need to do?
a)
Expand the column
b)
Expand the row
c)
Change the formula
8.
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
9.
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
10.
Which formula gets the biggest value of a range of cells?
a)
MAX
b)
MIN
c)
LARGE
d)
SUM
11.
Which formula gets the smallest value of a range of cells?
a)
MAX
b)
MIN
c)
SMALL
d)
SUM
12.
Which symbol must all formula begin with?
a)
=
b)
+
c)
(
d)
@
13.
Which of the following formulas will Excel not be able to calculate?
a)
=SUM(Sales)-A3
b)
=SUM(A1:A5)*0.5
c)
=SUM(A1:A5)/(10-10)
d)
=SUM(A1:A5)-10
14.
In a cell reference, for example A1, what does the letter refer to?
a)
The column
b)
The cell
c)
The row
15.
Which of these symbols is used for divide on a computer?
a)
\
b)
*
c)
/
d)
|
16.
Which of these formulas will find the correct average of the cells?
a)
=AVERAGE(A1:A10)
b)
=MEAN(A1:A10)
c)
AVERAGE(A1:A10)
d)
=(A1+A2+A3+A4+A5+A6+A7+A8+A9+A10)/10
17.
There is an IF function in D2. What is the correct formula?
a)
=IF(C2=75,”Pass”,”Fail”)
b)
=IF(C2>=75,”Pass”,”Fail”)
c)
=IF(C2>75,”Pass”,”Fail”)
18.
What symbol represents less than?
a)
>
b)
<
c)
<=
d)
>=
19.
What symbol separates the 3 things in the brackets of an IF function?
a)
=
b)
,
c)
"
d)
>
20.
What symbol represents greater than or equal to?
a)
<=
b)
>=
c)
==
d)
=
21.
Which has the deliberate mistake:
a)
=IF(B2=”11A”,”Mrs Green” , , ”Mr Jones”)
b)
=IF(B2=”11A”,”Mrs Green” , ”Mr Jones”)
22.
To put names into alphabetical order use ...
a)
Filter
b)
Format
c)
Define
d)
Sort
23.
Combining two cells together is called:
a)
Filtering
b)
Merging
c)
Wrapping
d)
Filling
24.
The IF function on excel . . .
a)
returns one value if a condition is true and another value if it's false
b)
calculates the average of some data
c)
Searches the worksheet for a name
d)
Identifies and mistakes in formula
25.
What kind of software is Excel?
a)
Word processing software
b)
Spreadsheet Software
c)
Data Base Software
26.
What can you do with the mouse to rename a sheet?
a)
Double Click on worksheet tab
b)
Right Click on worksheet tab
c)
Both double click and right click tab
27.
What setting do you use to format numbers as dollar amounts
a)
Accounting
b)
Currency
c)
Accounting and Currency
28.
What kind of chart should you use to show the pieces (percentages) of a whole
a)
Bar Chart
b)
Column Chart
c)
Pie Chart
29.
Can you format text with Excel
a)
Yes
b)
No
30.
To see what math formulas are used in a cell, click on the
a)
Show formulas button
b)
Show the math button
c)
the auto sum button
31.
If your document will not fit on one page, you can always print it in
a)
Portrait
b)
Landscape
32.
What key should you use to take you to the cell to the right
a)
Tab key
b)
Right arrow key
c)
just click in it
33.
To allow you to evenly distribute a title over a table of numbers, use the
a)
Center button
b)
Merge and Center button
c)
Merge cells only button
34.
Prewritten formulas available in Microsoft Excel that perform calculations on values in your worksheet.
a)
Formulas
b)
Functions
c)
Absolute reference
d)
Name box
35.
Displays the lowest value in a range.
a)
IF Function
b)
MAX Function
c)
MIN Function
d)
SUM Function
36.
Stored in the individual cells of a worksheet.
a)
Labels
b)
Stuff
c)
Values
d)
Data
37.
Used to specify an absolute reference in a formula.
a)
$
b)
?
c)
%
d)
!
38.
Done to emphasize certain entries and make the worksheet easier to read and look more professional.
a)
Formatting
b)
Accounting style
c)
Currency style
d)
Conditional styles
39.
What are horizontal and vertical lines in a spreadsheet called?
a)
graph
b)
grid lines
40.
a group of cells
a)
spreadsheet
b)
range
41.
text used in a spreadsheet and usually creates titles
a)
label
b)
value
42.
What is the area of Excel that is circled in the picture?
a)
Formula Bar
b)
Name Box
c)
Workbook
d)
Active Sheet
43.
What area of Excel is circled in this picture?
a)
Sheet Tab
b)
Name Box
c)
Formula Bar
d)
Active Cell
44.
The ________ can be used to copy contents of one cell to another.
a)
Fill Handle
b)
Name Box
c)
Formula Bar
d)
F2
45.
What does this tool do?
a)
makes a decimal
b)
makes a percent
c)
makes a dollar amount
d)
changes the places behind the decimal
46.
By default, Excel 2013 files are saved this extension.
a)
.xls
b)
.xlsx
c)
.csv
d)
.xbk
e)
.ods
47.
Which function key allows you to apply an absolute cell reference to and cell address?
a)
F1
b)
F2
c)
F3
d)
F4
48.
The black plus sign shown in picture is called?
a)
Fill handle
b)
Autofit
c)
Formula
49.
Where is the formula bar located?
a)
Top of screen
b)
Bottom of screen
c)
There is a formula bar?
d)
Cyberspace
50.
What is the location where you can get rid of the gridlines?
a)
Page Setup
b)
Borders and Shading
c)
Alignment and Spacing
d)
Font
Reset
