MS - Excel Exam

Which of the following options is not located in the Page Setup dialog box?

1 Mark(s)

Page Break Preview.
Page Orientation
Margins
Headers and Footers

What is the symbol for dividing?

1 Mark(s)

/
%
&
#

Which of the cell pointer indicates that you can fill series?

1 Mark(s)

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

In EXCEL, you can sum a large range of data by simply selecting a tool button called _________?

1 Mark(s)

AutoFill
Auto correct
Auto sum
Auto format

To return the remainder after a number is divided by a divisor in EXCEL we use the function?

1 Mark(s)

ROUND ( )
FACT ( )
MOD ( )
DIV ( )

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

1 Mark(s)

Add
Subtract
Divide
SQRT

You can enter which types of data into worksheet cells?

1 Mark(s)

Labels, values, and formulas
Labe3ls and values but not formulas
Values and formulas but not labels
Formulas only

You can use the formula palette to

1 Mark(s)

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

When the formula bar is activated, you can see

1 Mark(s)

The Edit Formula button
The Cancel button
The Enter button
All of above

Hyperlinks can be

1 Mark(s)

Text
Drawing objects
Pictures
All of above

To insert three columns between columns D and E you would

1 Mark(s)

Select column D
Select column E
Select columns E, F and G
Select columns D, E, and F.

Getting data from a cell located in a different sheet is called ________.

1 Mark(s)

Accessing
Referencing
Updating
Functioning

A smart tag will be removed from a cell when

1 Mark(s)

The cell is moved
The cell is hidden
The data in the cell is changed or deleted
The formatting of the cell is changed

Text formulas:

1 Mark(s)

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

Which of the following is correct?

1 Mark(s)

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

MS-EXCEL is based on __________?

1 Mark(s)

WINDOWS
DOS
UNIX
OS/2

Status indicators are located on the

1 Mark(s)

Vertical scroll bar
Horizontal scroll bar
Formula bar
Standard toolbar

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 maximum, how many sheets can be set as default while creating new workbook?

1 Mark(s)

254
255
256
No Limit

“Qtr 1, Qtr 2, Qtr 3” is an example of a

1 Mark(s)

Formula
Function
Series
Syntax

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

To show/hide the grid lines in Microsoft Excel 2007

1 Mark(s)

Page Layout > Grid lines > View
Insert > Grid lines > View
View > Grid lines > View
Edit > Grid lines > View

You can add an image to a template by clicking the Insert Picture From File button on the …. Toolbar.

1 Mark(s)

Standard
Formatting
Drawing
Picture

What does the NOW() function return?

1 Mark(s)

It returns the serial number of the current date and time
It returns the serial number of the current date
It returns the serial number of the current time
None of the above

What is the keyboard shortcut for creating a chart from the selected cell range?

1 Mark(s)

F2
F4
F8
F11

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

1 Mark(s)

Delete contents
Delete notes
Delete cells
Delete formats

The Name box on to the left of formula bar

1 Mark(s)

Shows the name of workbook currently working on
Shows the name of worksheet currently working on
Shows the name of cell or range currently working on
None of above

Which of the following is correct syntax in Excel?

1 Mark(s)

IF(LogicalTest, TrueResult, FalseResult)
IF(LogicalTest, (TrueResult, FalseResult))
IF(LogicalTest, TrueResult) (LogicalTest, FalseResult)
IF(LogicalTest, TrueResult), IF(LogicalTest, FalseResult)

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.

Which function calculates your monthly mortage payment?

1 Mark(s)

PMT (payments)
NPER (number of periods)
PV (present value)
All of above

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

When integrating Ms-Word and Excel, Word is usually the

1 Mark(s)

Server
Source
Client
None

The numbers in our worksheet look like this: You want them to look like this: $1,000.How can you accomplish this?

1 Mark(s)

None of these
Select Format > Money from the menu
Click the Currency Style button on the formatting toolbar
You have to retype everything and manually add the dollar signs, commas, and decimals

Comments can be added to cells using ________.

1 Mark(s)

Edit -> Comments
Insert -> Comment
File -> Comments
View –> Comments

What term refers to a specific set of values saved with the workbook?

1 Mark(s)

Range
Scenario
Trend line
What-if analysis

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

When creating a vertical page break

1 Mark(s)

The active cell must be A1
The active cell can be anywhere in the worksheet
The active cell must be in row 1
The active cell must be in column A

Which of the following Excel screen components can NOT be turned on or off?

1 Mark(s)

Formula Bar
Status Bar
Tool Bar
None of above

Formulas in Excel start with

1 Mark(s)

Percentage
Equal
Plus
Subtraction

Which of the following is not true about Find and Replace in Excel

1 Mark(s)

You can search for bold and replace with italics
You can decide whether to look for the whole word or not
You can search in formula too
You can search by rows or columns or sheets

MS - Excel Exam : Question 1 of 40