Microsoft Excel Basic MCQs (Long Quiz) (Part 2)
This is the quiz about basics of Microsoft Office Excel. Students and new learner's can test their knowledge.
Question 1 / 26
Which of the following methods cannot be used to enter data in a cell
Pressing the Esc key
Clicking on the formula bar
Question 2 / 26
Which of the following will not cut information?
Pressing Ctrl + C
Pressing Ctrl+X
Question 3 / 26
Which of the following is not a way to complete a cell entry?
Clicking the Enter button on the Formula bar
Pressing spacebar
Question 4 / 26
Text formulas:
Concatenate and manipulate text
Show formula error value
Question 5 / 26
Which of the following is not a basic step in creating a worksheet?
Copy the worksheet
Modifiy the worksheet
Question 6 / 26
How do you select an entire column?
Select Edit > Select > Column from the menu
Click the column heading letter
Question 7 / 26
How can you print three copies of a workbook?
Select File>Properties form the menu and type 3 in the Copies to print text box.
Select File >Print from the menu and type 3 in the Number of copies text box.
Question 8 / 26
To create a formula, you first:
Select the cell you want to place the formula into
Type the equals sign (=) to tell Excel that you’re about to enter a formula
Question 9 / 26
To center worksheet titles across a range of cells, you must
Select the cells containing the title text plus the range over which the title text is to be centered
Widen the columns
Question 10 / 26
How do you delete a column?
Select Insert > Find from the menu
Select Data > Form from the menu to open the Data Form dialog box and click the Criteria button
Question 11 / 26
When integrating word and excel, word is usually the
Destination & Client
Server
Question 12 / 26
When a label is too long to fit within a worksheet cell, you typically must
Increase the column width
Decrease the column width
Question 13 / 26
The name box
Shows the location of the previously active cell
Appears to the left of the formula bar
Question 14 / 26
Comments put in cells are called
Smart tip
Cell tip
Question 15 / 26
You can use the horizontal and vertical scroll bars to
Split a worksheet into two panes
View different rows and columns edit the contents of a cell
Question 16 / 26
Multiple calculations can be made in a single formula using
array formula
complex formulas
Question 17 / 26
Which button do you click to add up a series of numbers?
The autosum button
The Formula button
Question 18 / 26
To copy formatting from one area in a worksheet and apply it to another area you would use:
There is no way to copy and apply formatting in Excel – You have to do it manually
The Format Painter button on the standard toolbar
Question 19 / 26
In a worksheet you can select
Rows
Columns
Question 20 / 26
When you link data maintained in an excel workbook to a word document
The word document cannot be edit
The word document contains a reference to the original source application
Question 21 / 26
Which area in an excel window allows entering values and formulas
Menu bar
Formula bar
Question 22 / 26
To hold row and column titles in place so that they do not scroll when you scroll a worksheet click the
Unfreeze panes command on the window menu
Freeze panes command on the window menu
Question 23 / 26
To edit in an embedded excel worksheet object in a word document
Use the excel menu bar and toolbars inside the word application
Edit the hyperlink
Question 24 / 26
To create a formula, you can use:
Values or cell references although not both at the same time
Value and cell references
Question 25 / 26
Status indicators are located on the
Horizontal scroll bar
Formula bar
Question 26 / 26
Which of the following is the oldest spreadsheet package?
VisiCalc
Lotus 1-2-3
What's Your Reaction?
Like
0
Dislike
0
Love
0
Funny
0
Wow
0
Sad
0
Angry
0
Comments (0)