Wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

ms excel by shees & Faisal

Total questions: 51

Worksheet time: 28mins

Name
Class
Date
1.

A combination of numbers and symbols used to express a calculation.

a)

Active Cell

b)

Label

c)

Formula Bar

d)

Formula

2.

The cell in your worksheet that has been selected. It will have bolder gridlines around it.

a)

Active Cell

b)

Formula

c)

Cell

d)

Cell address

3.

The name of the cell is determined by the name of the row and the column intersecting, such as A8.

a)

Formula

b)

Formula Bar

c)

Cell Address

d)

Cell Grid

4.
By default, Microsoft Excel automatically saves a copy of your spreadsheet every 10 minutes.
a)
True
b)
False
5.
The Subtotals command adds numbers in a designated column.
a)
True
b)
False
6.
Which one of the following is a spreadsheet application? 
a)
Microsoft Word
b)
Microsoft Powerpoint
c)
Microsoft Excel
d)
Microsoft Outlook
7.
How do you change column width to fit the contents?
a)
Single-click the boundary to the left of the column heading
b)
Double-click the boundary to the right of the column heading
c)
Press ALT and single-click anywhere in the column
8.
Which button allows you to copy cell formats from one cell to another?
a)
Enter
b)
Autofit
c)
Format Painter
d)
Esc
9.
The fill handle only allows you to copy formulas to several different cells.
a)
True
b)
False
10.

What is the "Active Cell" in Excel?

a)

The Bottom cell in a worksheet. It is indicated by a dark border onscreen.

b)

The current cell in a worksheet. It is indicated by a dark border onscreen.

c)

The top cell in a worksheet. It is indicated by a dark border onscreen.

d)

The past cell in a worksheet. It is indicated by a dark border onscreen.

11.

Define Cell?

a)

The dark bordered box in excel.

b)

A box in Excel that has formulas.

c)

The intersection of a column or row in a worksheet or table.

d)

Fx Bar where you input data.

12.

Define Formula Bar?

a)

I don't know

b)

I don't care

c)

Don't miss this one!

d)

An element in Excel that appears below the Ribbon and to the right of the Insert command that shows the contents of the active cell so that you edit the text, value, date, formula, or function.

13.
If you see a series of "######" in a cell, that means the following:
a)
You keyed in an incorrect number
b)
The row height is too high
c)
The text is incorrectly spelled
d)
The column width is not wide enough
14.
When entering text in Excel, it is automatically (by default):
a)
Left Justified
b)
Right Justified
c)
Center Justified
d)
Full Justified
15.
You can only work in one cell at a time. The actual cell that you are working in is called what?
a)
Column
b)
Name Box
c)
Active Cell
d)
Row
16.
What kind of software is Excel?
a)
Spreadsheet software
b)
Word Processing
c)
Drawing
17.
Excel is part of?
a)
Power Point
b)
Microsoft Office Suite
c)
Access
d)
Google
18.
What do you call the rectangles on a spreadsheet?
a)
Cell
b)
Button
c)
Sentence
19.

A program using a table comprising of rows, columns and cells.

a)

MS Word

b)

MS PowerPoint

c)

MS Outlook

d)

MS Excel

20.

The intersection of a row and a column is called this.

a)

Active Cell

b)

Chart

c)

Column

d)

Row

21.

This symbol must be typed first to use a formula.

a)

Plus Sign

b)

Equal Sign

c)

FX

d)

Function

22.

How is the COLUMN in a MS Excel Spreadsheet named?

a)

Numbers

b)

Letters

c)

Cells

d)

Columns

23.

How are ROWS in MS EXCEL spreadsheet named?

a)

numbers

b)

letters

c)

cells

d)

columns

24.

What is a rectangular box in a MS EXCEL Spreadsheet called?

a)

row

b)

column

c)

cell

25.

What does every formula in MS EXCEL start with?

a)

+

b)

-

c)

=

d)

*

26.

Excel allows you to work with?

a)

Sentences

b)

Paragraphs

c)

data

27.
Blank are vertical
a)
Columns
b)
Rows
28.
The Quick Access Toolbar is:
a)
customizable
b)
found at the bottom of the screen
c)
found on the right side of the screen
d)
none of the above
29.
Located on the left side or the entry bar, displays the active cell reference:
a)
entry bar
b)
cell reference
c)
name box
d)
none of the above
30.
This is the:
a)
entry bar
b)
group
c)
name box
d)
none of the above
31.
Which tab in Excel has charts and tables?
a)
review
b)
home
c)
file
d)
insert
32.
What is the name of this cell?
a)
B10
b)
5B
c)
B5
d)
A5
33.
How do you make a cell the active cell?
a)
Click the ACTIVE button
b)
Click INSERT CELL
c)
Click on the cell
d)
Cells are always active
34.

You can use the auto-sum key to subtract numbers.

a)

True

b)

False

35.

Excel would be the ideal program to type a book report?

a)

False

b)

True

36.

What button will add up a group of numbers?

a)

Equals button

b)

Auto sum button

c)

Plus symbol button

37.
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
38.
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
39.
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
40.
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)
41.
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
42.
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
43.
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
44.
If the cell contains hashtags (#), what do you need to do?
a)
Expand the column
b)
Expand the row
c)
Change the formula
45.
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
46.
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
47.
Which formula gets the biggest value of a range of cells?
a)
MAX
b)
MIN
c)
LARGE
d)
SUM
48.
Which formula gets the smallest value of a range of cells?
a)
MAX
b)
MIN
c)
SMALL
d)
SUM
49.
Which symbol must all formula begin with?
a)
=
b)
+
c)
(
d)
@
50.
Which of the following formulas is not entered correctly?
a)
=10+50
b)
=B7+B8
c)
=B7+14
d)
10+50
51.
In a cell reference, for example A1, what does the letter refer to?
a)
The column
b)
The cell
c)
The row

Similar Resources on Wayground

BEDIR GRADE 1 & 2 ICT TERM 3

50 questions

BEDIR GRADE 1 & 2 ICT TERM 3

quiz

Worksheet

•

1st - 2nd Grade

SQL_29/11

47 questions

SQL_29/11

quiz

Worksheet

•

1st Grade - University

Practice Quiz-2(IT)

50 questions

Practice Quiz-2(IT)

quiz

Worksheet

•

KG - 10th Grade

Databases

50 questions

Databases

quiz

Worksheet

•

KG - 12th Grade

T. I. C.

46 questions

T. I. C.

quiz

Worksheet

•

1st - 9th Grade

minion rush

50 questions

minion rush

quiz

Worksheet

•

1st - 5th Grade

abood

49 questions

abood

quiz

Worksheet

•

1st - 9th Grade

Ms. Excel

50 questions

Ms. Excel

quiz

Worksheet

•

1st - 3rd Grade