MS - Excel Exam

To hold row and column titles in places so that they do not scroll when you scroll a worksheet, click the

1 Mark(s)

Unfreeze panes command on the window menu
Freeze panes command on the window menu
Hold titles command on the edit menu
Split command on the window menu

Microsoft Excel is a powerful _________.

1 Mark(s)

Word processing package
Spreadsheet package
Communication S/W Package
DBMS package

Which of the following is not a basic step in creating a worksheet?

1 Mark(s)

Save workbook
Modifiy the worksheet
Enter text and data
Copy the worksheet

How do you select an entire column?

1 Mark(s)

Select Edit > Select > Column from the menu
Click the column heading letter
Hold down the shift key as you click anywhere in the column.
Hold down the Ctrl key as you click anywhere in the column

In order to perform a calculation in a spreadsheet, you need to use a:

1 Mark(s)

Table
Formula
Field
Variable

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

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

What will be the result if you type =A1=B1 in cell C1?

1 Mark(s)

Yes or No
True or False
Value of A1
Value of B1

Status indicators are located on the

1 Mark(s)

Vertical scroll bar
Horizontal scroll bar
Formula bar
Standard toolbar

241. The Delete key of keyboard is assigned to which command in Excel?

1 Mark(s)

Edit >> Clear >> Contents
Edit >> Clear >> All
Edit >> Delete
All of above

Which one is the last column header in Excel 2007?

1 Mark(s)

XFD
XFX
XFL
XFT

The autofill feature

1 Mark(s)

Extends a sequential series of data
Automatically adds a range of cell values
Applies a boarder around selected cells
None of above

Which symbol must all formula begin with?

1 Mark(s)

(Equal)
(Plus)
(Braket)
At the rate

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.

To protect a worksheet, you can choose Protection and the Protect Sheet from the ________ Menu.

1 Mark(s)

Edit
Format
Tools
Data

MS-EXCEL can be used to automate

1 Mark(s)

Financial statements, Business forecasting
Transaction registers, inventory control
Accounts receivable, accounts payable
Any of the above

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

Which of the following series type is not valid for Fill Series dialog box?

1 Mark(s)

Linear
Growth
Autofill
Time

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)

Which of the following format you can decide to apply or not in Auto Format dialog box?

1 Mark(s)

Number format
Border format
Font format
All of above

You can edit a cell by

1 Mark(s)

Clicking the formula button
Double clicking the cell to edit it in-place
Selecting Edit>Edit Cell from the menu
None of above

Which of the following is not a worksheet design criterion?

1 Mark(s)

Efficiency
Auditability
Description
Clarity

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

What Pivot Table toolbar button updates the data in a Pivot Table or Pivot Chart report if the source data chas changed

1 Mark(s)

Format Report
Pivot Table
Refresh Data
Show Detail

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

You can edit existing Excel data by pressing the

1 Mark(s)

F1 key
F2 key
F3 key
F4 key

What is the shortcut key to insert current date in a cell?

1 Mark(s)

CTRL + D
CTRL + T
CTRL + ;
CTRL + /

Comments can be added to cells using

1 Mark(s)

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

Which of the following is the latest version of Excel

1 Mark(s)

Excel 2000
Excel 2002
Excel ME
Excel XP

NOT, AND, OR and XOR are

1 Mark(s)

Logical Operators
Arithmetic operators
Relational operators
None of the 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.

You are editing an worksheet that you had previously saveIf you want to save the edited sheet without losing the original one, which command should you use?

1 Mark(s)

New
Save As
Edit
Save

In Excel, the Fill Color button on the Formatting toolbar is used for what?

1 Mark(s)

To insert a background.
To add borders.
To select a distribution of figures.
To add shading or color to a cell range.

What is an expression that tells how the numbers in a determined set of cells are to be calculated?

1 Mark(s)

Formula
Field
Data
Query Correct Answer:

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

Files created with Lotus 1-2-3 have an extension

1 Mark(s)

DOC
XLS
123
WK1

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

1 Mark(s)

//
FR
Zero
Zero Space

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 set Page Border in Excel from

1 Mark(s)

From Border tab in Format Cells dialog box
From Border tool in Formatting toolbar
From Line Style tool in Drawing toolbar
You can not set page border in Excel

MS - Excel Exam : Question 1 of 40