MS EXCEL QUIZ

What do you call the chart that shows the proportions of how one or more data elements relate to another data element?

Line Chart

XY Chart

Pie Chart

Column Chart

TRUE ANSWER : ?
YOUR ANSWER : ?

Which button do you click to add up a series of numbers?

The Formula button

The total button

The autosum button

The quicktotal button

TRUE ANSWER : ?
YOUR ANSWER : ?

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

Label

Character

Number

Date/Time

TRUE ANSWER : ?
YOUR ANSWER : ?

You can use the formula palette to

Copy a range of cells

Create and edit formula containing functions

Format cells containing numbers

Enter assumptions data

TRUE ANSWER : ?
YOUR ANSWER : ?

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

F10

F11

F9

F8

TRUE ANSWER : ?
YOUR ANSWER : ?

Which function is used to calculate depreciation, rates of return, future values and loan payment amounts?

Financial

Logical

Math & Trigonometry

Statistical

TRUE ANSWER : ?
YOUR ANSWER : ?

The Name box on to the left of formula bar

Shows the name of workbook currently working on

Shows the name of cell or range currently working on

Shows the name of worksheet currently working on

None of the listed here

TRUE ANSWER : ?
YOUR ANSWER : ?

Each excel file is called a workbook because

You have to work hard to create it

It can be modified

It can contain many sheets including worksheets and chart sheets

It can contain text and data

TRUE ANSWER : ?
YOUR ANSWER : ?

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

Sheet1!A10

Sheet3!A10

Sheet3.A10

A10

TRUE ANSWER : ?
YOUR ANSWER : ?

Excel files have a default extension of in Excel-2003

Xlw

Wk1

Xls

123

TRUE ANSWER : ?
YOUR ANSWER : ?

↑