WorksheetsMicrosoft Excel 2010 - 1
Total questions: 22
Worksheet time: 11mins
Which of the following methods cannot be used to enter data in a cell
a. Pressing an arrow key
b. Pressing the Tab key
c. Pressing the Esc key
d. Clicking on the formula bar
In MS-Excel you can use the drag and drop method to
A.Copy cell contents
B.Move cell contents
C.Add cell contents
D.(A) and (B)
You accidentally erased a record in the sheet. What command can be used to restore it immediately?
A. Insert
B. Copy
C. Undo
D. Replace
When you are typing data that is in a series, such as days of the week, you can use this tool to complete the series.
A) AutoSum
B) Custom Fill
C)Fill Handle
D)Ctrl+C
Which of the following is not a term of MS-Excel?
A. Cells
B. Rows
C. Columns
D. Document
The basic unit of a worksheet into which you enter data in Excel is called a
A.cell
B.table
C.box
D.column
The advantage of using a spreadsheet is:
A. calculations can be done automatically.
B. changing data automatically updates calculations
C. more flexibility
D. All of the above
There are three types of data found in a spreadsheet.
A. data, words, numbers
B. equations, data, numbers
C. words, numbers, labels
D. numbers formulas, labels
Microsoft Excel is what kind of software?
Word Processing Software
Spreadsheet Software
Database Software
Presentation Software
The letters in Excel represent the...
Rows
Columns
Cells
Data
The numbers in Excel represent the...
Rows
Columns
Cells
Data
Using the keyboard, you could navigate from one cell to another cell by using the ____ ____.
Enter Keys
Arrow Keys
Piano Keys
Tab Key
The cell address of the highlighted cell is
C
4
A4
C4
What does the indicated icon in the red box do?
Change number of active cells
Change font colour
Change font size
Change the number of calculations
What does the indicated icon do in the red box?
Apply underline
Apply italic
Make text bigger
Apply bold
Which of these would multiply the numbers from A3 to A6
*(A3:A6)
=Multiplay(A3:A6)
=A3*A4*A5*A6
=Sum(a3*a6)
A ____ is another name for an equation used in Excel.
Calculation
Template
sheet
Formula
Did u like this Quiz?
Yes
NO
How often you want to Play such types of Quizzes.
Once Every Week
Daily
Sometimes
Not at all
