MS - Excel Exam

You can automatically adjust the size of text in a cell if they do not fit in width by

1 Mark(s)

Double clicking on the right border of column header
From Format choose Columns and then Autofit Selection
From Format Cells dialog box mark Shrink to fit check box
All of above

Which one is the last column header in Excel 2007?

1 Mark(s)

XFD
XFX
XFL
XFT

When you group worksheets

1 Mark(s)

You can enter variable data on multiple worksheets at one time
You can print more than one worksheet at a time
You can enter common data, formats, and formulas on multiple worksheets at one time
Both (B) and (C)

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

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

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

Excel uniquely identifies cells within a worksheet with a cell name

1 Mark(s)

Cell names
Column numbers and row letters
Column letters and row numbers
Cell locator coordinates

How to restrict the values of a cell so that only whole numbers between 9 and 99 can be entered in a cell.

1 Mark(s)

The Settings tab under the menu Format > Cells
The Settings tab under the menu Data > Validation
The Settings tab under the menu Data > Filter > Advanced Filter
The Settings tab under the menu Format > Conditional Formatting

What is the keyboard shortcut (button or buttons to be pressed) for creating a chart from the selected cells?

1 Mark(s)

F3
F5
F7
F11

Which of the following is not information you can specify using the solver?

1 Mark(s)

Input cells
Constraints
Target cell
Changing cells

Which of the following is not a valid data type in Excel?

1 Mark(s)

Number
Character
Label
Date/Time

Which menu option can be sued to split windows into two

1 Mark(s)

Format > window
View > window > split
Window > split
View > split

Which of the following is invalid statement?

1 Mark(s)

Sheet tabs can be colored
Some picture can be applied as a background of a sheet
You can set the column width automatically fit the amount of text
The width of a row and be specified manually or fit automatically

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.

How many worksheets can a workbook have?

1 Mark(s)

3
8
255
None of above

Which key do you press to check spelling?

1 Mark(s)

F3
F5
F7
F9

Hyperlinks cannot be

1 Mark(s)

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

You can merge the main document with data source in Excel. In mail merge operation, Word is usually

1 Mark(s)

Server
Source
Client
None

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 methods will not enter data in a cell?

1 Mark(s)

Pressing the Esc key
Pressing an arrow key
Pressing the tab key
Clicking the enter button to the formula bar

Formatting a cell in Number format you can’t set

1 Mark(s)

Decimal Places
Use 1000 separator
Negative numbers
Currency Symbol

What is the symbol for dividing?

1 Mark(s)

/
%
&
#

In Excel _______ may not contain in Formula

1 Mark(s)

Text Constant
Number Constant
Circular Reference
All of them

How do you rearrange the data in ascending or descending order?

1 Mark(s)

Data, Sort
Data, Form
Data, Table
Data Subtotals

Which is an example of a formula?

1 Mark(s)

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

Got functions? No You need the insert function dialog box. How do you get it?

1 Mark(s)

Right click a cell and then click insert
Click the insert menu and then click function
Type = in a cell
All of the above

Concatenation of text can be done using

1 Mark(s)

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

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

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

1 Mark(s)

Hyperlinked
Placed in a word table
Linked
Embedded

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

Which of following is Not one of Excel’s what-if function?

1 Mark(s)

Goal seek
Solver
Scenario manager
Auto Outline

How do you display current date and time in MS Excel?

1 Mark(s)

Date ()
Today ()
Now ()
Time ()

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

1 Mark(s)

View
Format
Tools
Data

Macros are “run” or executed from the ….. menu.

1 Mark(s)

Insert
Format
Tools
Data

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)

What term refers to a specific set of values saved with the workbook?

1 Mark(s)

Range
Scenario
Trend line
What-if analysis

The first cell in EXCEL worksheet is labeled as

1 Mark(s)

AA
A1
Aa
A0

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

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

You can copy data or formulas

1 Mark(s)

With the copy, paste and cut commands on the edit menu
With commands on a shortcut menu
With buttons on the standard toolbar
All of the above

MS - Excel Exam : Question 1 of 40