MS - Excel Exam

What do you mean by a Workspace?

1 Mark(s)

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

A data map is helpful

1 Mark(s)

When you have too much data to chart
To show a geographic distribution of data
To compare data points
To show changes in data over time

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

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

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

You can auto fit the width of column by

1 Mark(s)

Double clicking on the column name on column header
Double click on the cell pointer in worksheet
Double clicking on column right border on column header
Double clicking on the column left border of column header

If you need a text to show vertically in a cell. How will you achieve this?

1 Mark(s)

Choose Vertical on Text alignment in Format Cells dialog box
Choose 90 Degrees in Orientation of Format Cells dialog box
Choose Distributed from the Vertical drop down list of Format Cells dialog box
Choose Center Across Selection from Horizontal combo box in Format Cells dialog box

How do you wrap the text in a cell?

1 Mark(s)

Format, cells, font
Format, cells, protection
Format, cells, number
Format, cells, alignment

Microsoft Excel is a powerful _________.

1 Mark(s)

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

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

Which of the following is not a valid data type in excel

1 Mark(s)

Number
Character
Label
Date/time

It is acceptable to let long text flow into adjacent cells on a worksheet when

1 Mark(s)

Data will be entered in the adjacent cells
No data will be entered in the adjacent cells
There is no suitable abbreviation of the text
There is not time to format the next

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

Which is an example of a function?

1 Mark(s)

Add(A1:A2)
A1+A2
SUM(A1:A2)
A1+A2

An Excel Workbook is a collection of ________.

1 Mark(s)

Workbooks
Worksheets
Charts
Worksheets and Charts

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

Text formulas:

1 Mark(s)

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

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

An excel workbook is a collection of

1 Mark(s)

Workbooks
Worksheets
Charts
Worksheets and charts

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

What do we call a computer program that organizes data in rows and columns of cells? You might use this type of program to keep a record of the money you earned moving lawns over the summer.

1 Mark(s)

Spreadsheet program
Database program
Word processor program
Desktop publisher program

Selecting the Rows 5 & 6 then choose Insert > Ro What will happen?

1 Mark(s)

2 Rows will be inserted after Row 4
2 Rows will be inserted after Row 5
2 Rows will be inserted after Row 6
2 Rows will be inserted after Row 7

Gridlines

1 Mark(s)

May be turned off for display but turned on for printing
May be turned on or off for printing
The be turned off for display and printing
All of these

The Paste Special command lets you copy and paste:

1 Mark(s)

Multiply the selection by a copied value
Cell comments
Formatting options
The resulting values of a formula instead of the actual formula

Which function is not available in the Consolidate dialog box?

1 Mark(s)

Pmt
Average
Max
Sum

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

In Excel _______ may not contain in Formula

1 Mark(s)

Text Constant
Number Constant
Circular Reference
All of them

The Chart wizard term data categories refers to;

1 Mark(s)

A chart plot area
A horizontal axis
The organization of individual values with a chart’s data series
The data range that supply chart data

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

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

You can group noncontiguous worksheets with

1 Mark(s)

The group button on the standard toolbar
The shift key and the mouse
The ctrl key and mouse
The alt+enter key

Your German supplier still invoices for parts in Deutsche marks. How can you have Excel convert those sums to Euros?

1 Mark(s)

On the Insert menu, click Symbol and from the currency symbols subset, select the Euro sign.
On the tools menu, click Add-Ins, and select the Euro Currency Tools check box
Apply a selected background color
All of above

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

Which of the following methods cannot be used to edit the content of cell?

1 Mark(s)

Pressing the Alt key
Clicking the formula bar
Pressing F2
Double clicking the cell

Paste Special allows some operation while you paste to new cell. Which of the following operation is valid?

1 Mark(s)

Square
Percentage
Goal Seek
Divide

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

1 Mark(s)

Table
Formula
Field
Variable

How can you find specific information in a list?

1 Mark(s)

Select Tools > Finder from the menu
Click the Find button on the standard toolbar
Select Insert > Find from the menu
Select Data > Form from the menu to open the Data Form dialog box and click the Criteria button

To delete an embedded objects, first

1 Mark(s)

Double click the object
Select the object by clicking it
Press the Shift + Delete keys
Select it and then press the delete key

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)

MS - Excel Exam : Question 1 of 40