MS - Excel Exam

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 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

Which of the following describes how to select all the cells in a single column?

1 Mark(s)

Right click on column and select Pick from list
Use data – text to columns menu item
Left click on the gray column title button
Pressing Ctrl + A on the keyboard

Which of the following is the latest version of Excel

1 Mark(s)

Excel 2000
Excel 2002
Excel ME
Excel XP

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

Hyperlinks cannot be

1 Mark(s)

Special shapes like stars and banners
Drawing objects like rectangles ovals
Pictures
All can be hyperlinks

How can you show or hide the gridlines in Excel Worksheet?

1 Mark(s)

Go to Tools > Options > View tab and mark or remove the check box named Gridline
Click Gridline tool on Forms toolbar
Both of above
None of above

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

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

A user wishes to remove a spreadsheet from a workbook. Which is the correct sequence of events that will do this?

1 Mark(s)

Go to File-Save As – Save As Type – Excel worksheet
Right click on the spreadsheet tab and select DELETE
Right click on the spreadsheet and select Insert – Entire Column
None of above

Data can be arranged in a worksheet in a easy to understand manner using

1 Mark(s)

Auto formatting
Applying styles
Changing fonts
All of above

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

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

Formatting a cell in Currency, you can specify

1 Mark(s)

Decimal Places
Currency Symbol
Both of above
None of above

What value will display if the formula = “$55.00″+5 is entered into a cell?

1 Mark(s)

60
60
“$55.00″+5
60

Where a row and a column meet, what do you call that?

1 Mark(s)

A cell
A block
A box
None of the above

Which of the following formulas is not entered correctly?

1 Mark(s)

10 + 50
B7*B1
B7 + 14
10 + 50

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

1 Mark(s)

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

The cell reference for cell range of G2 to M12 is _______.

1 Mark(s)

G2.M12
G2;M12
G2:M12
G2-M12

What do you mean by a Workspace?

1 Mark(s)

Group of Columns
Group of Worksheets
Group of Rows
Group of Workbooks

You can open the Sort dialog box by choosing Sort from the ….. menu

1 Mark(s)

View
Format
Tools
Data

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

Data marker on a chart are linked to data points in a worksheet, therefore,

1 Mark(s)

You can automatically apply formatting to a data series
You can change the position of a data marker and automatically change the data point value in the worksheet
You can change a data print value and automatically are draw the chart
Both (A) and (B)

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

A circular reference is

1 Mark(s)

Geometric modeling tool
A cell that points to a drawing object
A formula that either directly or indirectly depends on itself
Always erroneous

What is the shortcut key to hide entire column?

1 Mark(s)

CTRL + −
CTRL + 0
CTRL + H
CTRL + C

Which function calculates your monthly mortage payment?

1 Mark(s)

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

What is entered by the function =today()

1 Mark(s)

The date value for the day according to system clock
The time value according to system clock
Today’s date as Text format
All of above

To activate the previous cell in a pre-selected range, press

1 Mark(s)

The Alt key
The Tab key
The Enter key
None of above

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.

When you work with large worksheets, you may need to

1 Mark(s)

Size the worksheet to fit on the specific number of pages
Add and remove page breaks
Specify only certain print areas
All of these

What symbol is used before a number to make it a label?

1 Mark(s)

(Quote)
(Equal)
(Underscore)
(Apostrophe)

To drag a selected range of data to another worksheet in the same workbook, use the

1 Mark(s)

Tab key
Alt key
Shift key
Ctrl key

Which function is not available in the Consolidate dialog box?

1 Mark(s)

Pmt
Average
Max
Sum

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

You can convert existing excel worksheet data an charts to an HTML document by using

1 Mark(s)

FTP wizard
Internet assistant wizard
Intranet wizard
Import wizard

Excel probably considers the cell entry January 1, 2000 to be a

1 Mark(s)

Label
Value
Formula
Text string

Which of the following is not a way to complete a cell entry?

1 Mark(s)

Pressing enter
Pressing any arrow key on the keyboard
Clicking the Enter button on the Formula bar
Pressing spacebar

To activate the previous cell in a pre-selected range, press

1 Mark(s)

The Alt key
The Tab key
The Enter key
None of the above

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

MS - Excel Exam : Question 1 of 40