MS - Excel Exam

What function displays row data in a column or column data in a row?

1 Mark(s)

Hyperlink
Index
Transpose
Rows

What is the symbol for dividing?

1 Mark(s)

/
%
&
#

Getting data from a cell located in a different sheet is called …

1 Mark(s)

Accessing
Referencing
Updating
Functioning

Tab scrolling button

1 Mark(s)

Allow you to view a different worksheet
Allow you to view additional worksheet rows down
Allow you to view additional worksheet columns to the right
Allow you to view additional sheets tabs

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

241. The Delete key of keyboard is assigned to which command in Excel?

1 Mark(s)

Edit >> Clear >> Contents
Edit >> Clear >> All
Edit >> Delete
All of above

Which of the following options is appropriate to show the numbers 9779851089510 in a cell?

1 Mark(s)

Enclose the number is brackets
Place the character T before the number
Place the character TX before the number
Apply the Text format in the cell and type the numbers

“Qtr 1, Qtr 2, Qtr 3” is an example of a

1 Mark(s)

Formula
Function
Series
Syntax

Except for the …… function, a formula with a logical function shows the word “TRUE” or “FALSE” as a result

1 Mark(s)

IF
AND
OR
NOT

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

Where a row and a column meet, what do you call that?

1 Mark(s)

A cell
A block
A box
None of the above

How many characters can be typed in a single cell in Excel?

1 Mark(s)

256
1024
32000
65535

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

The Software which contains rows and columns is called ______.

1 Mark(s)

Database
Drawing
Spreadsheet
Word processing

What type of chart is useful for comparing values over categories ?

1 Mark(s)

Pie Chart
Column Chart
Line Chart
Dot Graph

This type of software is similar to an accountant’s worksheet

1 Mark(s)

Word processing
Database
Spreadsheets
Graphics

A worksheet can have a maximum of …. Number of rows

1 Mark(s)

256
1024
32000
65535

Which of the following is the latest version of Excel

1 Mark(s)

Excel 2000
Excel 2002
Excel ME
Excel XP

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 not an option of the spelling dialog box?

1 Mark(s)

Ignore
Ignore all
Edit
Change

What Pivot Table toolbar button updates the data in a Pivot Table or Pivot Chart report if the source data chas changed

1 Mark(s)

Format Report
Pivot Table
Refresh Data
Show Detail

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

1 Mark(s)

Linear
Growth
Autofill
Time

If the values in A1 is “MCQ” and B1 is “Questions”, which function will return “MCQ@Questions” in cell C1?

1 Mark(s)

A1 + “@” + B1
A1 # “@” # B1
A1 & “@” & B1
A1 $ “@” $ B1

While Finding and Replacing some data in Excel, which of the following statement is valid?

1 Mark(s)

You can Find and Replace within the sheet or workbook
Excel does not have option to match case for find
Both are valid
None are valid

Which of the following is not a worksheet design criterion?

1 Mark(s)

Efficiency
Auditability
Description
Clarity

Which of the following is not true regarding Conditional Formatting?

1 Mark(s)

You can add more than one condition to check
You can set condition to look for Bold and apply Italics on them.
You can apply Font, border and pattern formats that meets the specified conditions
You can delete any condition from Conditional Formatting dialog box if it is not requried

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

1 Mark(s)

Insert
Format
Tools
Data

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

In a report, you need to show the monthly rainfall in NepaThe best way to do this is to insert a

1 Mark(s)

Calendar
Photograph of rainfall
Chart showing rainfall amounts
Database of rainfall

When creating a vertical page break

1 Mark(s)

The active cell must be A1
The active cell can be anywhere in the worksheet
The active cell must be in row 1
The active cell must be in column A

A worksheet range is a

1 Mark(s)

A command used for data modeling
A range of values such as from 23 to 234
A group of cells
A group of worksheets

Can you set 0.5 inch left indentation for a cell in Excel?

1 Mark(s)

Excel does not have indentation feature
You can specify indentation only if you turn the rulers on
Indentation can be set from Format Cells dialog box
The indentation can be specified only when printing

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

1 Mark(s)

Number
Character
Label
Date/time

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

When you print preview a worksheet

1 Mark(s)

The entire worksheet is displayed
The selected range is displayed
The active portion of the worksheet is displayed
All of these

In Excel _______ may not contain in Formula

1 Mark(s)

Text Constant
Number Constant
Circular Reference
All of them

Which function calculates your monthly mortage payment?

1 Mark(s)

PMT (payments)
NPER (number of periods)
PV (present value)
All of above

Selecting the Column G & H then choose Insert > Column what will happen?

1 Mark(s)

2 Columns will be inserted after Column F
2 Columns will be inserted after Column G
2 Columns will be inserted after Column H
2 Columns will be inserted after Column I

To remove the content of selected cells you must issue ______ command.

1 Mark(s)

Edit >> Delete
Edit >> Clear >> Contents
Edit >> Clear >> All
Data >> Delete

MS - Excel Exam : Question 1 of 40