NEW
Font size
S
M
L
XL
WorksheetsMS EXCEL
Total questions: 36
Worksheet time: 33mins
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.
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
7.
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
8.
Which formula gets the biggest value of a range of cells?
a)
MAX
b)
MIN
c)
LARGE
d)
SUM
9.
Which formula gets the smallest value of a range of cells?
a)
MAX
b)
MIN
c)
SMALL
d)
SUM
10.
Which symbol must all formula begin with?
a)
=
b)
+
c)
(
d)
@
11.
Columns go...
a)
Across
b)
Down
12.
Rows go...
a)
Across
b)
Down
13.
In a cell reference, for example A1, what does the letter refer to?
a)
The column
b)
The cell
c)
The row
14.
Which of these symbols is used for divide on a computer?
a)
\
b)
*
c)
/
d)
|
15.
A cell name contains
a)
Cell name
b)
Column numbers and row letters
c)
Column letters and row numbers
d)
Cell locator coordinates
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.
In Excel rows are labeled by
a)
letters
b)
numbers
c)
rows and numbers
18.
What kind of software is Excel?
a)
Word processing software
b)
Spreadsheet Software
c)
Data Base Software
19.
In excel, columns are labeled by
a)
Letters
b)
Numbers
c)
Letters and numbers
20.
What button will add up a group of numbers
a)
Equals button
b)
Plus symbol button
c)
Auto-sum button
21.
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
22.
Excel refers to files as
a)
Documents
b)
Workbooks
c)
data bases
23.
What setting do you use to format numbers as dollar amounts
a)
Accounting
b)
Currency
c)
Accounting and Currency
24.
Where rows and columns meet are referred to as
a)
Blocks
b)
Cells
c)
Boxes
25.
What kind of chart should you use to show the pieces (percentages) of a whole
a)
Bar Chart
b)
Column Chart
c)
Pie Chart
26.
Can you format text with Excel
a)
Yes
b)
No
27.
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
28.
Excel is part of
a)
Access
b)
Microsoft Office
c)
PowerPoint
29.
If your document will not fit on one page, you can always print it in
a)
Portrait
b)
Landscape
30.
Excel would be the ideal program to type out a book report.
a)
True
b)
False
31.
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
32.
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
33.
You can do other functions (besides addition) with the auto sum button ∑ such as average, max, min
a)
True
b)
False
34.
You can use the Auto Sum Key ∑ to subtract numbers.
a)
True
b)
False
35.
Which of the following is a selected cell?
a)
current command
b)
default option
c)
active cell
d)
default cell
36.
To visually compare number across different categories, use a
a)
Bar chart
b)
Column chart
c)
Bar or Column Chart
Reset
