MS - Excel Exam

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

1 Mark(s)

Hyperlinked
Placed in a word table
Linked
Embedded

If you want to have a blank line after the title in a worksheet, what is the best thing for you to do?

1 Mark(s)

Re-format the spreadsheet
Insert a row
Increase the column width
Use the spacebar

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

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

How do you change column width to fit the contents?

1 Mark(s)

Single-click the boundary to the left to the column heading
Double click the boundary to the right of the column heading
Press Alt and single click anywhere in the column
All of these

Which elements of a worksheet can be protected from accidental modification?

1 Mark(s)

Contents
Objects
Scenarios
All of the above

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

Which key do you press to check spelling?

1 Mark(s)

F3
F5
F7
F9

What does the VLOOKUP function do?

1 Mark(s)

Looks up text that contain ‘v’
Checks whether text is the same in one cell as in the next
Finds related records
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

Which button do you click to add up a series of numbers?

1 Mark(s)

The autosum button
The Formula button
The quicktotal button
The total button

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

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

1 Mark(s)

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

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

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:

Charts tips can

1 Mark(s)

Show the formatting of a data label
Show the name of a data series
Show the value of data point
Both (B) and (C)

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

To center worksheet titles across a range of cells, you must

1 Mark(s)

Select the cells containing the title text plus the range over which the title text is to be centered
Widen the columns
Select the cells containing the title text plus the range over which the title text is to be enfettered
Format the cells with the comma style

You can activate a cell by

1 Mark(s)

Pressing the Tab key
Clicking the cell
Pressing an arrow key
All of the above

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

“New Comment” option can be found under _________ tab

1 Mark(s)

Insert
Data
Review
View

How can you print three copies of a workbook?

1 Mark(s)

Select File>Properties form the menu and type 3 in the Copies to print text box.
Select File >Print from the menu and type 3 in the Number of copies text box.
Click the Print button on the standard toolbar to print the document then take it to Kinko’s and have 2 more copies made
Press Ctrl+P+3

A numeric value can be treated as a label value if it precedes with

1 Mark(s)

Apostrophe (&lsquo)
Exclamation (!)
Hash (#)
Ampersand (&)

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

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

Which is an example of a formula?

1 Mark(s)

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

How are data organized in a spreadsheet?

1 Mark(s)

Lines and spaces
Layers and planes
Rows and columns
Height and width

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

The Software which contains rows and columns is called ______.

1 Mark(s)

Database
Drawing
Spreadsheet
Word processing

The first cell in EXCEL worksheet is labeled as

1 Mark(s)

AA
A1
Aa
A0

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

1 Mark(s)

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

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)

If you press ________, the cell accepts your typing as its contents.

1 Mark(s)

Enter
Ctrl + Enter
Tab
Insert

Which of the following formulas will Excel Not be able to calculate?

1 Mark(s)

SUM(Sales)-A3
SUM(A1:A5)*.5
SUM(A1:A5)/(10-10)
SUM(A1:A5)-10

To create a formula, you can use:

1 Mark(s)

Values but not cell references
Cell references but not values
Values or cell references although not both at the same time
Value and cell references

Which option allows you to Bold all the negative values within the selected cell range:

1 Mark(s)

Zero Formatting
Conditional Formatting
Compare Formatting
Negative Formatting

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

The Cancel and Enter buttons appear in the:

1 Mark(s)

Title bar
Formula bar
Menu bar
Sheet tabs

Edit > Delete command

1 Mark(s)

Deletes the content of a cell
Deletes Formats of cell
Deletes the comment of cell
Deletes selected cells

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.

MS - Excel Exam : Question 1 of 40