MS - Excel Exam

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

1 Mark(s)

Number
Character
Label
Date/time

What feature enables you to adjust or back solve the value in a cell to reach a desired outcome in a formula?

1 Mark(s)

Goal Seek
Scenario Summary report
Forecasting
Trend line

Which is used to perform what if analysis?

1 Mark(s)

Solver
Goal seek
Scenario Manager
All of above

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

1 Mark(s)

Pie Chart
Column Chart
Line Chart
Dot Graph

If 4/6 entered in a cell without applying any formats, Excel will treat this as

1 Mark(s)

Fraction
Number
Text
Date

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

1 Mark(s)

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

Paper spreadsheets can have all the same advantages as an electronic spreadsheet except which of the following?

1 Mark(s)

Rows and columns
Headings
Speed
None of these

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

Which of the following action removes a sheet from workbook?

1 Mark(s)

Select the sheet, then choose Edit > Delete Sheet
Select the sheet then choose Format > Sheet > Hide
Both of above
None of above

When a range is selected, how can you activate the previous cell?

1 Mark(s)

Press the Alt key
Press Tab
Press Enter
None of above

Which of the cell pointer indicate that you can move the content to other cell?

1 Mark(s)

Doctor’s symbol (Big Plus)
Small thin plus icon
Mouse Pointer with anchor at the tip
None of above

Which of the following methods cannot be used to enter data in a cell?

1 Mark(s)

Pressing an arrow key
Pressing the Tab key
Pressing the Esc key
Clicking on the formula bar

All worksheet formula

1 Mark(s)

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

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

In Excel _______ may not contain in Formula

1 Mark(s)

Text Constant
Number Constant
Circular Reference
All of them

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

Text formulas:

1 Mark(s)

Replace cell references
Return ASCII values of characters
Concatenate and manipulate text
Show formula error value

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

1 Mark(s)

Insert
Format
Tools
Data

You can use the formula palette to

1 Mark(s)

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

Which of the following is correct?

1 Mark(s)

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

In order to perform a calculation in a spreadsheet, you need to use a:

1 Mark(s)

Table
Formula
Field
Variable

You can print only an embedded chart by

1 Mark(s)

Moving the chart to a chart sheet before you print.
Formatting the chart before you print
Selecting the chart before you print
Both (A) and (C)

MS Excel provides the default value for step in Fill Series dialog box

1 Mark(s)

0
1
5
10

Which symbol must all formula begin with?

1 Mark(s)

(Equal)
(Plus)
(Braket)
At the rate

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

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

The autofill feature

1 Mark(s)

Extends a sequential series of data
Automatically adds a range of cell values
Applies a boarder around selected cells
None of above

Which of the following option is not available in Paste Special dialog box?

1 Mark(s)

Add
Subtract
Divide
SQRT

To delete an embedded objects, first

1 Mark(s)

Double click the object
Select the object by clicking it
Press the Shift + Delete keys
Select it and then press the delete key

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 methods can not be used to edit the contents of a cell?

1 Mark(s)

Press the Alt key
Clicking the formula bar
Pressing the F2 key
Double clicking the cell

Which of the following will not set text in selected cells to italics?

1 Mark(s)

Pressing Ctrl + I on the keyboard
Using the Tools – Wizard – Web Form menu item
Using the Format – Cells – Font menu item
None of the above

How do you display current date only in MS Excel?

1 Mark(s)

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

How are data organized in a spreadsheet?

1 Mark(s)

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

The name box

1 Mark(s)

Shows the location of the previously active cell
Appears to the left of the formula bar
Appears below the status bar
Appears below the menu bar

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

In maximum, how many sheets can be set as default while creating new workbook?

1 Mark(s)

254
255
256
No Limit

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

To insert three columns between columns D and E you would

1 Mark(s)

Select column D
Select column E
Select columns E, F and G
Select columns D, E, and F.

To return the remainder after a number is divided by a divisor in EXCEL we use the function?

1 Mark(s)

ROUND ( )
FACT ( )
MOD ( )
DIV ( )

MS - Excel Exam : Question 1 of 40