MS - Excel Exam

Which setting you must modify to print a worksheet using letterhead?

1 Mark(s)

Paper
Margin
Layout
Orientation

You can check the conditions against __________ when applying conditional formatting

1 Mark(s)

Cell value
Formula
Both of above
All of above

The spelling tool is placed on ______ toolbar.

1 Mark(s)

Standard
Formatting
Drawing
Reviewing

To record a sequence of keystrokes and mouse actions to play back later we use:

1 Mark(s)

Media player
Sound Recorder
Calculator
Macro Recorder

Which of the following shortcuts can be used to insert a new line in the same cell?

1 Mark(s)

Enter
Alt + Enter
Ctrl + Enter
Shift + Enter

NOT, AND, OR and XOR are

1 Mark(s)

Logical Operators
Arithmetic operators
Relational operators
None of the above

Status indicators are located on the

1 Mark(s)

Vertical scroll bar
Horizontal scroll bar
Formula bar
Standard toolbar

You can use the formula palette to

1 Mark(s)

Format cells containing numbers
Create and edit formulas containing functions
Entered assumptions data
Copy a range of cells

You can select a single range of cells by

1 Mark(s)

Clicking the upper-left cell in a group of cells and then pressing the Shift key while clicking the lower right cell in a group of cells
Pressing the Ctrl key while dragging over the desired cells
Pressing the Shift key and an arrow key
Dragging over the desired cells

What is the short cut key to replace a data with another in sheet?

1 Mark(s)

Ctrl + R
Ctrl + Shift + R
Ctrl + H
Ctrl + F

In Excel _______ may not contain in Formula

1 Mark(s)

Text Constant
Number Constant
Circular Reference
All of them

Formatting a cell in Number format you can’t set

1 Mark(s)

Decimal Places
Use 1000 separator
Negative numbers
Currency Symbol

Excel uniquely identifies cells within a worksheet with a cell name

1 Mark(s)

Cell names
Column numbers and row letters
Column letters and row numbers
Cell locator coordinates

The command Edit >> Fill Across Worksheet is active only when

1 Mark(s)

One sheet is selected
When many sheets are selected
When no sheet is selected
None of above

Which elements of worksheet can be protected from accidental modification

1 Mark(s)

Contents
Objects
Scenarios
All of above

Which is not the function of “Edit, Clear” command?

1 Mark(s)

Delete contents
Delete notes
Delete cells
Delete formats

If the values in A1 is “MCQ” and B1 is “Questions”, which function will return “MCQ@Questions” in cell C1?

1 Mark(s)

A1 + “@” + B1
A1 # “@” # B1
A1 & “@” & B1
A1 $ “@” $ B1

Can you set 0.5 inch left indentation for a cell in Excel?

1 Mark(s)

Excel does not have indentation feature
You can specify indentation only if you turn the rulers on
Indentation can be set from Format Cells dialog box
The indentation can be specified only when printing

Which of the following formulas will Excel Not be able to calculate?

1 Mark(s)

SUM(Sales)-A3
SUM(A1:A5)*.5
SUM(A1:A5)/(10-10)
SUM(A1:A5)-10

To view a cell comment

1 Mark(s)

Click the edit comment command on the insert menu
Click the display comment command on the window menu
Position the mouse pointer over the cell
Click the comment command on the view menu

Multiple calculations can be made in a single formula using ________.

1 Mark(s)

Standard Formulas
Array Formula
Complex Formulas
Smart Formula

Where can you set the shedding color for a range of cells in Excel?

1 Mark(s)

Choose required color form Patterns tab of Format Cells dialog box
Choose required color on Fill Color tool in Formatting toolbar
Choose required color on Fill Color tool in Drawing toolbar
All of above

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)

What should be add before a fraction to avoid entering it as a date?

1 Mark(s)

//
FR
Zero
Zero Space

Text formulas:

1 Mark(s)

Replace cell references
Return ASCII values of characters
Concatenate and manipulate text
Show formula error value

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 automatically adjust the size of text in a cell if they do not fit in width by

1 Mark(s)

Double clicking on the right border of column header
From Format choose Columns and then Autofit Selection
From Format Cells dialog box mark Shrink to fit check box
All of above

In the formula, which symbol specifies the fixed columns or rows?

1 Mark(s)

$
*
%
&

Comments can be added to cells using

1 Mark(s)

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

MS Excel provides the default value for step in Fill Series dialog box

1 Mark(s)

0
1
5
10

The box on the chart that contains the name of each individual record is called the ________.

1 Mark(s)

Cell
Title
Axis
Legend

232. When a row of data is to be converted into columns

1 Mark(s)

Copy the cells in row, select the same number of cells in row and paste
Copy the cells in column then choose Edit >> Paste Special, then click Transpose and OK
Copy the cells then go to Format >> Cells then on Alignment tab click Transpose check box and click OK
Select the cells then place the cell pointer on new cell and choose Edit >> Paste Special, mark Transpose check box and click OK.

When you link data maintained in an excel workbook to a word document

1 Mark(s)

The word document cannot be edit
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

If you press ________, the cell accepts your typing as its contents.

1 Mark(s)

Enter
Ctrl + Enter
Tab
Insert

Worksheet can be renamed by

1 Mark(s)

Adding ? symbol at the end of filename while saving workbook
Click on Worksheet tab by Holding CTRL Key and type new name
Double Click on the Worksheet tab and type new name
Worksheet cannot renamed

A worksheet can have a maximum of …. Number of rows

1 Mark(s)

256
1024
32000
65535

Which of the following is correct?

1 Mark(s)

POWER(2^3)
POWER(2,3)
POWER(2#3)
POWER(2*3)

How to restrict the values of a cell so that only whole numbers between 9 and 99 can be entered in a cell.

1 Mark(s)

The Settings tab under the menu Format > Cells
The Settings tab under the menu Data > Validation
The Settings tab under the menu Data > Filter > Advanced Filter
The Settings tab under the menu Format > Conditional Formatting

When you use the fill effects in the format data series dialog box, you can not

1 Mark(s)

Rotate text on the chart
Select a fore ground color
Select a pattern
Select a background color

Which of the following option is not available in Paste Special dialog box?

1 Mark(s)

Add
Subtract
Divide
SQRT

MS - Excel Exam : Question 1 of 40