MS - Excel Exam

You can use the formula pallette to

1 Mark(s)

Format cells containing numbers
Create and edit formula containing functions
Enter assumptions data
Copy a range of cells

The spelling dialog box can be involved by choosing spelling from ________ menu.

1 Mark(s)

Insert
File
Tools
View

Which of the cell pointer indicates you that you can make selection?

1 Mark(s)

Doctor’s symbol (Big Plus)
Small thin plus icon
Mouse Pointer with anchor at the tip
None of above

You can activate a cell by

1 Mark(s)

Pressing the Tab key
Clicking the cell
Pressing an arrow key
All of the above

You can activate a cell by

1 Mark(s)

Pressing the Tab key
Clicking the cell
Pressing an arrow key
All of above

How many worksheets can a workbook have?

1 Mark(s)

3
8
255
None of above

You can not link Excel worksheet data to a Word document

1 Mark(s)

With the right drag method
With a hyperlink
With the copy and paste special commands
With the copy and paste buttons on the standard toolbar

Weight refers to

1 Mark(s)

The print density of characters
The height of the printed character
Upright or slanted shape
The design and appearance of characters

Which of the following is a popular DOS based spreadsheet package?

1 Mark(s)

Word
Smart cell
Excel
Lotus 1-2-3

The short cut key Ctrl + R is used in Excel to

1 Mark(s)

Right align the content of cell
Remove the cell contents of selected cells
Fill the selection with active cells to the right
None of above

Documentation should include

1 Mark(s)

Destination and users of the output data
Source of input data
Information on the purpose of the workbook
All of the above

When all the numbers between 0 and 100 in a range should be displayed in Red Color, apply

1 Mark(s)

Use = if() function to format the required numbers red
Apply Conditional Formatting command on Format menu
Select the cells that contain number between 0 and 100 then click Red color on Text Color tool
All of above

Which tool you will use to join some cells and place the content at the middle of joined cell?

1 Mark(s)

From Format Cells dialog box click on Merge Cells check box
From Format Cells dialog box select the Centered alignment
From Format Cells dialog box choose Merge and Center check box
Click on Merge and Center tool on formatting toolbar

Which of the following is a correct order of precedence in formula calculation?

1 Mark(s)

Exponentiation, Multiplication and division, positive and negative values
Multiplication and division, positive and negative values, addition and subtraction
Addition and subtraction, positive and negative values, exponentiation
All of above

You cannot link excel worksheet data to a word document

1 Mark(s)

With the right drag method
With a hyperlink
With the copy and paste special commands
With the copy and paste buttons on the standard toolbar.

What happens when you press Ctrl + X after selecting some cells in Excel?

1 Mark(s)

The cell content of selected cells disappear from cell and stored in clipboard
The cells selected are marked for cutting
The selected cells are deleted and the cells are shifted left
The selected cells are deleted and cells are shifted up

Which of these is a quick way to copy formatting from a selected cell to two other cells on the same worksheet?

1 Mark(s)

Use Ctrl to select all three cells, then click the paste button on the standard toolbar
Copy the selected cell, then select the other two cells, click style on the Format menu, then click Modify
Click format painter on the Formatting toolbar twice then click in each cell you want to copy the formatting to
All of above

You want to set such that when you type Baishakh and drag the fill handle, Excel should produce Jestha, Aashadh and so on. What will you set to effect that?

1 Mark(s)

Custom List
Auto Fill Options
Fill Across Worksheet
Fill Series

Which function will you use to enter current time in a woksheet cell?

1 Mark(s)

Today()
Now()
Time()
CurrentTime()

When you link data maintained in Excel workbook to a Word document

1 Mark(s)

The Word document cannot be edited
The Word document contains a reference to the original source application
The word document must contain a hyperlink
The word document contains a copy of the actual data

When you want to insert a blank imbedded excel object in a word document you can

1 Mark(s)

Click the object command on the insert menu
Click the office links button on the standard toolbar
Click the create worksheet button on the formatting toolbar
Click the import excel command on the file menu

How do you tell one cell from another?

1 Mark(s)

By numbers
By letters
By its address
By color

What does COUNTA () function do?

1 Mark(s)

Counts cells having alphabets
Counts empty cells
Counts cells having number
Counts non-empty cells

Comments can be added to cells using

1 Mark(s)

Edit > Comments
Insert > Comments
File > Comments
View > Comments

Tab scrolling button

1 Mark(s)

Allow you to view a different worksheet
Allow you to view additional worksheet rows down
Allow you to view additional worksheet columns to the right
Allow you to view additional sheets tabs

What happens when dollar signs ($) are entered in a cell address? (e$B$2:$B$10)

1 Mark(s)

An absolute cell address is created.
Cell address will change when it is copied to another cell.
The sheet tab is changed.
The status bar does not display the cell address.

What function displays row data in a column or column data in a row?

1 Mark(s)

Hyperlink
Index
Transpose
Rows

Which of the following is not true regarding Conditional Formatting?

1 Mark(s)

You can add more than one condition to check
You can set condition to look for Bold and apply Italics on them.
You can apply Font, border and pattern formats that meets the specified conditions
You can delete any condition from Conditional Formatting dialog box if it is not requried

How to specify cell range from A9 to A99 in Excel?

1 Mark(s)

(A9, A99)
(A9 to A99)
(A9 : A99)
(A9 – A99)

An excel workbook is a collection of

1 Mark(s)

Workbooks
Worksheets
Charts
Worksheets and charts

You can use the format painter multiple times before you turn it off by

1 Mark(s)

You can use the format painter button only one time when you click it
Double clicking the format painter button
Pressing the Ctrl key and clicking the format painter button
Pressing Alt key and clicking the format painter button

Which of the following methods cannot be used to enter data in a cell?

1 Mark(s)

Pressing an arrow key
Pressing the Tab key
Pressing the Esc key
Clicking on the formula bar

You accidentally erased a record in the shee what command can be used to restore it immediately?

1 Mark(s)

Insert
Copy
Undo
Replace

In Excel, a Data Series is defined as what?

1 Mark(s)

A type of chart
A cell reference
A collection of related data
A division of results

Which option allows you to Bold all the negative values within the selected cell range:

1 Mark(s)

Zero Formatting
Conditional Formatting
Compare Formatting
Negative Formatting

You can print only an embedded chart by

1 Mark(s)

Moving the chart to a chart sheet before you print.
Formatting the chart before you print
Selecting the chart before you print
Both (A) and (C)

Each excel file is a workbook that contains different sheets. Which of the following can not be a sheet in workbook?

1 Mark(s)

Work sheet
Chart sheet
Module sheet
Data sheet

Which types of charts can excel produce?

1 Mark(s)

Line graphs and pie charts only
Only line graphs
Bar charts, line graphs and pie charts
Bar charts and line graphs only

The name box

1 Mark(s)

Shows the location of the previously active cell
Appears to the left of the formula bar
Appears below the status bar
Appears below the menu bar

What will be the output if you format the cell containing 5436.8 as ‘#,##0.00′?

1 Mark(s)

5430
5436.8
5436.8
6.8

MS - Excel Exam : Question 1 of 40