MS EXCEL QUIZ | EXAMIANS

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

WK1

Doc

123

XLS

TRUE ANSWER : ?
YOUR ANSWER : ?

Excel worksheet cells work very similarly to what common element of the windows graphical user interface

Text boxes

Option buttons

Combo boxes

List boxes

TRUE ANSWER : ?
YOUR ANSWER : ?

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

F8

F9

F11

F10

TRUE ANSWER : ?
YOUR ANSWER : ?

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

=SUM(Sales)-A3

=SUM(A1:A5)/(10-10)

=SUM(A1:A5)*0.5

=SUM(A1:A5)-10

TRUE ANSWER : ?
YOUR ANSWER : ?

You want to set such that when you type Baishakh and drag the fill handle, Excel should produce Jestha, Aashadh and so on. What will you set to effect that?

Fill series

Auto fill options

Custom List

Fill across worksheet

TRUE ANSWER : ?
YOUR ANSWER : ?

You want to track the progress of the stock market on a daily basis. Which type of chart should you use?

Column chart

Row chart

Line chart

Pie chart

TRUE ANSWER : ?
YOUR ANSWER : ?

Which setting you must modify to print a worksheet using letterhead?

Layout

Paper

Margin

Orientation

TRUE ANSWER : ?
YOUR ANSWER : ?

The Name box on to the left of formula bar

Shows the name of worksheet currently working on

Shows the name of workbook currently working on

None of the listed here

Shows the name of cell or range currently working on

TRUE ANSWER : ?
YOUR ANSWER : ?

How can you show or hide the gridlines in Excel Worksheet

Click Gridline tool on Forms toolbar

None

Go to Tools > Options > View tab and mark or remove the check box named Gridline

Both

TRUE ANSWER : ?
YOUR ANSWER : ?

You can copy data or formulas

With commands on the shortcut menu

With the copy, paste and cut commands on the edit menu

With buttons on the standard toolbars

All of these

TRUE ANSWER : ?
YOUR ANSWER : ?