MS Excel mcq Questions and Answer | Microsoft Excel-5

1 min read

MS Excel mcq Questions and Answer | Microsoft Excel-5

Excell- 5

Question 1
Without using the mouse or the arrow keys, what is the fastest way of getting to cell Al in a spreadsheet?
A
Press Ctrl +Home
B
Press Home
C
Press Shift + Home
D
Press Alt + Home
Question 2
Which of the following methods can not be used to edit the contents of a cell?
A
Press the Alt key
B
Clicking the formula bar
C
Pressing the F2 key
D
Double clicking the cell
Question 3
If you begin typing an entry into a cell and then realize that you don't want your entry placed into a cell, you
A
Press the Erase key
B
Press Esc
C
Press the Enter button
D
Press the Edit Formula button
Question 4
Which of the following methods can not 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
Question 5
Which of the following will not cut information?
A
Pressing Ctrl + C
B
Selecting Edit >Cut from the menu
C
Clicking the Cut button on the standard
D
Pressing Ctrl + X
Question 6
Which of the following is not a way to complete a cell entry?
A
Pressing enter
B
Pressing any arrow key on the keyboard
C
Clicking the Enter button on the Formula bar
D
Pressing spacebar
Question 7
You can activate a cell by
A
Pressing the Tab key
B
Clicking the cell
C
Pressing an arrow key
D
All of the above
Question 8
Text formulas:
A
Replace cell references
B
Return ASCII values of characters
C
Concatenate and manipulate text
D
Show formula error value
Question 9
How do you insert a 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
Question 10
Which of the following is not a basic step in creating a worksheet?
A
Save workbook
B
Modifiy the worksheet
C
Enter text and data
D
Copy the worksheet
Question 11
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
Question 12
How can you print three copies of a workbook?
A
Select File>Properties form the menu and type 3 in the Copies to print text box.
B
Select File >Print from the menu and type 3 in the Number of copies text box.
C
Click the Print button on the standard toolbar to print the document then take it to Kinko's and have 2 more copies made
D
Press Ctri+P+3
Question 13
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
Question 14
To center 'worksheet titles across a range of cells, you must
A
Select the cells containing the title text plus the range over which the title text is to be centered
B
Widen the columns
C
Select the cells containing the title text plus the range over which the title text is to be enfettered
D
Format the cells with the comma style
Question 15
How do you delete a column?
A
Select the column heading you want to delete and select the Delete Row button on the standard toolbar
B
Select the column heading you want to delete and select Insert Delete from the menu
C
Select the row heading you want to delete "and select Edit>Delete from the menu
D
Right click the column heading you want to delet and select delete from .the shortcut menu
Question 16
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
Question 17
When integrating word and excel, word is usually the
A
Server
B
Destination
C
Client
D
Both b and c
Question 18
When a label is too long to fit within a worksheet cell, you typically must
A
Shorten the label
B
Increase the column width
C
Decrease the column width
D
Adjust the row height
Question 19
The name box
A
Shows the location of the previously active cell
B
Appears to the left of the formula bar
C
Appears below the status bar
D
Appears below the menu bar
Question 20
Comments put in cells are called
A
Smart tip
B
Cell tip
C
Web tip
D
Soft tip
Question 21
Which is used to perform what if analysis?
A
Solver
B
Goal seek
C
Scenario Manager
D
All of above
Question 22
You can use the horizontal and vertical scroll bars to
A
Split a, worksheet into two panes
B
View different rows and columns edit the contents of a cell
C
Edit the contents of a cell
D
view different worksheets
Question 23
Hyperlinks can be
A
Text
B
Drawing objects
C
Pictures
D
All of above
Question 24
To activate the previous cell in a pre-selected range, press
A
The Alt key
B
The Tab key
C
The Enter key
D
All of the above
E
None of these
Question 25
Which button do 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
Question 26
When the formula bar is active, you can see
A
The edit formula button
B
The cancel button
C
The enter button
D
All of the above
Question 27
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
Question 28
In a worksheet you can select
A
The entire worksheet
B
Rows
C
Columns
D
All of the above
Question 29
When you link data maintained in an excel workbook to a word document
A
The word document can not be edit
B
The word document contains a reference to the original source application
C
The word document must contain a hyperlink
D
The word document contains a copy of the actual data
Question 30
Which area in an excel window allows entering values and formulas
A
Title bar
B
Menu bar
C
Formula bar
D
Standard toolbar
Question 31
To hold row and column titles in place so that they do not scroll when you scroll a worksheet click the
A
Unfreeze panes command on the window menu
B
Freeze panes command on the window menu
C
Hold titles command on the edit menu
D
Split command on the window menu
Question 32
To edit in an embedded excel worksheet object in a word document
A
Use the excel menu bar and toolbars inside the word application
B
Edit the hyperlink
C
Edit the data in a excel source application
D
Use the word menu bar and toolbars
Question 33
To create a formula, you can use:
A
Values but not cell references
B
Cell references but not values
C
Values or cell references although not both at the same time
D
Value and cell references
Question 34
Status indicators are located on the
A
Vertical scroll bar
B
Horizontal scroll bar
C
Formula bar
D
Standard toolbar
Question 35
Which of the following is the oldest spreadsheet package?
A
VisiCalc
B
Lotus 1-2-3
C
Excel
D
StarCalc
Question 36
Pounding errors can occur
A
When you use multiplication, division, or exponentiation in a formula
B
When you use addition and subtraction in a formula
C
Because excel uses hidden decimal places in computation
D
When you show the results of formulas with different decimal places that the calculated results
Question 37
You can copy data or formulas
A
With the copy, paste and cut commands on the edit menu
B
With commands on the shortcut menu
C
With buttons on the standard toolbars
D
All of the above
Question 38
You can not link excel worksheet data to a word document
A
With the right drag method
B
With a hyperlink
C
With the copy and paste special commands
D
With the copy and paste buttons on the standard toolbar.
Question 39
Which of the following is a popular DOS based spreadsheet package?
A
Word
B
Smart cell
C
Excel
D
Lotus 1-2-3
Question 40
An excel workbook is a collection of
A
Workbooks
B
Worksheets
C
Charts
D
Worksheets and charts
There are 40 questions to complete.

 

Leave a Reply

Your email address will not be published.

Previous Story

MS Excel mcq Questions and Answer | Microsoft Excel-4

Next Story

MS Excel mcq Questions and Answer | Microsoft Excel-6

Latest from Blog

error: Content is protected !!