Excel Quiz

Which of the following is not a term of MS Excel

• Document

• Cell

• Row

• Workbook

Excel files have a default extension of :

• Xlw

• Wk1

• Xlsx

• 123

You are editing a worksheet that you had previously saved. If you want to save the edited sheet without losing the original one, which command should you use?

• Save

• Save as

• Non of the other answer

Excel displays the current cell address in the....

• Status Bar

• Formula bar

• Name box

• None above

In Excel, Rows are labelled as _____

• A1, A2

• $A$1,$A$2

• A,B,C

• 1,2,3

In Excel, Column are labelled as _____

• A1, A2

• $A$1,$A$2

• A,B,C

• 1,2,3

On an Excel spreadsheet the active cell is indicated by

• a dark wide border

• A dotted border

• A blinking border

• Non of the above

It is possible to insert an image from a file into an Excel spreadsheet

• True

• False

When number signs (#####) are displayed in the cell, it means

• The formula in the cell is wrong

• There are too many characters in the cell and cell width should be adjusted to display all the information

• The decimal point placement in the cell is wrong

Which formula is correct for computing the average?

• Average A1..A4

• =avg(A1 B5

• =average(B1 B4

• All the above