MS - Excel Exam

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

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)

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

What does COUNTA () function do?

1 Mark(s)

Counts cells having alphabets
Counts empty cells
Counts cells having number
Counts non-empty cells

Which language is used to create macros in Excel?

1 Mark(s)

Visual Basic
C
Visual C++
Java

Which types of charts can excel produce?

1 Mark(s)

Line graphs and pie charts only
Only line graphs
Bar charts, line graphs and pie charts
Bar charts and line graphs only

You can open the consolidate dialog box byt choosing Consolidate from the ….. menu.

1 Mark(s)

Insert
Format
Tools
Data

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

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

1 Mark(s)

Number
Character
Label
Date/time

How many worksheets can a workbook have?

1 Mark(s)

3
8
255
None of above

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

If the cell B1 contains the formula = $A$1, which of the following statements is true

1 Mark(s)

There is a relative reference to cell A1
There is an absolute reference to cell A1
Further changes in value of A1 will not affect the value of B1
Further changes in value of B1 will affect the value of A1

You can use the horizontal and vertical scroll bars to

1 Mark(s)

Split a worksheet into two panes
View different rows and columns
Edit the contents of a cell
View different worksheets

You can use the format painter multiple times before you turn it off by

1 Mark(s)

You can use the format painter button only one time when you click it
Double clicking the format painter button
Pressing the Ctrl key and clicking the format painter button
Pressing Alt key and clicking the format painter button

Which of the following is an absolute cell reference?

1 Mark(s)

!A!1
$A$1
#a#1
A1

How can you update the values of formula cells if Auto Calculate mode of Excel is disabled?

1 Mark(s)

F8
F9
F10
F11

Which is an example of a function?

1 Mark(s)

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

Worksheet can be renamed by

1 Mark(s)

Adding ? symbol at the end of filename while saving workbook
Click on Worksheet tab by Holding CTRL Key and type new name
Double Click on the Worksheet tab and type new name
Worksheet cannot renamed

Right clicking something in Excel:

1 Mark(s)

Deletes the object
Nothing the right mouse button is there for left handed people
Opens a shortcut menu listing everything you can do to the object
Selects the object

When a label is too long to fit within a worksheet cell, you typically must

1 Mark(s)

Shorten the label
Increase the column width
Decrease the column width
Adjust the row height

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

What is the correct way to refer the cell A10 on sheet3 from sheet1?

1 Mark(s)

Sheet3!A10
Sheet1!A10
Sheet3.A10
A10

The Software which contains rows and columns is called ______.

1 Mark(s)

Database
Drawing
Spreadsheet
Word processing

In Excel _______ may not contain in Formula

1 Mark(s)

Text Constant
Number Constant
Circular Reference
All of them

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)

How to fit long texts in a single cell with multiple lines?

1 Mark(s)

Start typing in the cell and press the Enter key to start another line
Use the Wrap Text option in the Format -> Alignment menu
Use the Shrink to Fit option in the Format -> Cells -> Alignment menu
All of above

Which of the following describes how to select all the cells in a single column?

1 Mark(s)

Right click on column and select Pick from list
Use data – text to columns menu item
Left click on the gray column title button
Pressing Ctrl + A on the keyboard

Concatenation of text can be done using

1 Mark(s)

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

A function inside another function is called a ….. function.

1 Mark(s)

Nested
Round
Sum
Text

Which of the following function will return a value of 8?

1 Mark(s)

ROUNDUP(8.4999, 0)
ROUNDDOWN(8.4999, 0)
ROUND(8.4999, 0)
Only B and C

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

You can use the drag and drop method to

1 Mark(s)

Copy cell contents
Move cell contents
Add cell contents
Both (A) and (B)

Which of the following is correct?

1 Mark(s)

POWER(2^3)
POWER(2,3)
POWER(2#3)
POWER(2*3)

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

What term describes a background that appears as a grainy, non smooth surface

1 Mark(s)

Gradient
Pattern
Solid
Texture

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

Excel displays the current cell address in the ____________.

1 Mark(s)

Formula bar
Status Bar
Name Box
Title Bar

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

1 Mark(s)

DOC
XLS
123
WK1

MS - Excel Exam : Question 1 of 40