MS - Excel Exam

What is the short cut key to highlight the entire column?

1 Mark(s)

Ctrl+C
Ctrl+Enter
Ctrl+Page Up
Ctrl+Space Bar

Tab scroll buttons are place on Excel screen

1 Mark(s)

Towards the bottom right corner
Towards the bottom left corner
Towards the top right corner
Towards the top left corner

To edit data in an embedded Excel worksheet object in a Word document

1 Mark(s)

Use the Excel menu bar and toolbars inside the word application
Edit the hyperlink
Edit the data in a Excel source application
Use the Word menu bar and toolbars

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

How can you remove borders applied in cells?

1 Mark(s)

Choose None on Border tab of Format cells
Open the list on Border tool in Formatting toolbar then choose first tool (no border)
Both of above
None of above

Which of the following is correct?

1 Mark(s)

AVERAGE(4, 5, 6, 7)
AVERAGE(A1, B1, C1)
AVERAGE(A1:A9, B1:B9)
All of the above

To copy cell contents using drag and drop press the

1 Mark(s)

End key
Shift key
Ctrl key
Esc key

To edit in an embedded excel worksheet object in a word document

1 Mark(s)

Use the excel menu bar and toolbars inside the word application
Edit the hyperlink
Edit the data in a excel source application
Use the word menu bar and toolbars

You can quickly change the appearance of your work by choosing Auto Format from the ________ Menu.

1 Mark(s)

Edit
View
Format
Tools

Which area in an Excel window allows entering values and formulas?

1 Mark(s)

Title Bar
Menu Bar
Formula Bar
Standard Tool Bar

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

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

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

An excel workbook is a collection of

1 Mark(s)

Workbooks
Worksheets
Charts
Worksheets and charts

To create an interactive Pivot Table for the web, you use a Microsoft Office Web component called

1 Mark(s)

HTML
Pivot Table Field List
Pivot Table List
Pivot Table Report

Clear the contents by pressing “DELETE” key from a keyboard will clear

1 Mark(s)

Text Only
Format Only
Contents Only
Both Contents and Format

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

When you see a cell with a red triangle in the top right corner, what does this signify?

1 Mark(s)

There is an error in the cell
There is a comment associated with the cell
The font color for text in the cell is red
A formula cannot be entered into the cell

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

1 Mark(s)

Linear
Growth
Autofill
Time

You can move a sheet from one workbook into new book by

1 Mark(s)

From Edit menu choose Move or Copy sheet, mark the Create a ccopy and Click OK
From Edit menu choose Move of Copy then choose (Move to end) and click OK
From Edit menu choose Move or Copy then select (new book) from To Book list and click OK
None of above

You can use the formula pallette to

1 Mark(s)

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

Which of the following is not an underline option in the format cells dialog box?

1 Mark(s)

Double
Single Accounting
Double Accounting
Single Engineering

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

1 Mark(s)

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

Which function will calculate the number of workdays between 6/9/2004 and 8/12/2004?

1 Mark(s)

Workday
Date
Networkdays
All of the above

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

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

Formulas in Excel start with

1 Mark(s)

Percentage
Equal
Plus
Subtraction

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.

Microsoft Excel is a powerful _________.

1 Mark(s)

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

All worksheet formula

1 Mark(s)

Manipulate values
Manipulate labels
Return a formula result
Use the addition operator

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

A function inside another function is called _______

1 Mark(s)

Nested function
Round function
Sum function
Text function

When you insert an Excel file into a Word document, the data are

1 Mark(s)

Hyperlinked
Placed in a word table
Linked
Embedded

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

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

Rounding errors can occur

1 Mark(s)

When you use multiplication, division, or exponentiation in a formula
When you use addition and subtraction in a formula
Because excel uses hidden decimal places in computation
When you show the results of formulas with different decimal places that the calculated results

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

What’s a quick way to extend these numbers to a longer sequence, for instance 1 through 20?

1 Mark(s)

Select both cells, and then drag the fill handle over the range you want, for instance 18 more rows
Select the range you want, include both cells, point to fill on the Edit menu, and then click down.
Copy the second cell, click in the cell below it, on the standard toolbar click the down arrow on the Paste button, and then click Paste Special
All of above

Long text can be broken down into many lines within a cell. You can do this through

1 Mark(s)

Wrap Text in Format > Cells
Justify in Edit > Cells
Text Wraping in Format > Cells, Layout tab
All of above

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

1 Mark(s)

View
Format
Tools
Data

MS - Excel Exam : Question 1 of 40