Microsoft Excel

Description: A Microsoft Excel Test to check the basic knowledge in excel concepts
Number of Questions: 25
Created by:
Tags: Spreadsheet Cell Pivot Tables Functions Formulas Charts Operators Conditional Logic Goal Seek Input Forms Data Validations Web Integration Computer Basics Microsoft Excel
Attempted 0/25 Correct 0 Score 0

By default, a value in excel sheet is

  1. left aligned in a cell

  2. right aligned in a cell

  3. centre aligned in a cell

  4. None of these


Correct Option: B

How are columns identified in an excel worksheet?

  1. Numbers

  2. Letters

  3. Roman numbers

  4. Bullets


Correct Option: B

In Microsoft Excel, how many sheets are there per file by default?

  1. 1

  2. 3

  3. 2

  4. 4


Correct Option: B

How many columns are there in an Excel worksheet?

  1. 256

  2. 255

  3. 254

  4. 1024


Correct Option: A

In an Excel worksheet, the default label is

  1. left aligned in a cell

  2. right aligned in a cell

  3. centre aligned in a cell

  4. None of these


Correct Option: A

Which of the following features has not changed from Excel 2003 to Excel 2007?

  1. Office button

  2. Zoom bar

  3. Ribbon

  4. Formula bar


Correct Option: D

In excel, which symbol is used to multiply numbers?

  1. /

  2. &

  3. ^

  4. *


Correct Option: D
Explanation:

Option 4 is the correct answer.

In Excel, rows are identified by

  1. numbers

  2. letters

  3. Roman numbers

  4. bullets


Correct Option: A

A spreadsheet is a piece of software for

  1. manipulating images

  2. handling and manipulating photos

  3. handling and manipulating numbers

  4. handling and manipulating text


Correct Option: C

Where can you see zoom bar in an excel 2007 worksheet?

  1. At the top left corner

  2. At the bottom right corner

  3. Next to name box

  4. Under the ribbon


Correct Option: B

In excel, where can you find the chart option?

  1. Insert menu

  2. Review menu

  3. Edit menu

  4. Format menu


Correct Option: A

Which of the following shortcuts is used to format the diagonal box?

  1. Ctrl + F

  2. Ctrl + 1

  3. Ctrl + 2

  4. Ctrl + F1


Correct Option: B

Where can you enter data in a cell?

  1. In the address bar

  2. In the name box

  3. In the insert box

  4. In the formula bar


Correct Option: B

How many rows are there in an Excel worksheet?

  1. 65,534

  2. 65,535

  3. 65,536

  4. 65,537

  5. 66,400


Correct Option: C
Explanation:

In an MS Excel worksheet, the total number of rows is 65,536.

When you know what answer you want, but don’t know the exact input for that answer, which excel tool could you use to do the same?

  1. The goal tool

  2. Goal scenario

  3. Goal formatting

  4. Goal seek


Correct Option: D

Which of the following can be entered in the excel formula bar to add up?

  1. C4+C5+C6+C7

  2. = C4+C5+C6+C7

    • C4+C5+C6+C7
  3. TOTAL: C4+C5+C6+C7


Correct Option: B

In Excel, the sort option is in _______ menu.

  1. Insert

  2. Format

  3. Data

  4. Tools


Correct Option: C

The PMT () formula can be used to calculate the

  1. time difference between 2 times

  2. date difference between 2 dates

  3. monthly payment amount on a loan

  4. straight loan payment based on constant payments and constant interest rate


Correct Option: D

Where can you find Office button in Excel 2007?

  1. At the top left corner

  2. At the bottom right corner

  3. Next to the name box

  4. Under the ribbon


Correct Option: A

Where can you edit the data in a cell?

  1. In the address bar

  2. In the name box

  3. In the insert box

  4. In the formula bar


Correct Option: D

Which option has been replaced by Excel 2007 by menu and tool bars found in earlier version of Excel?

  1. Name box

  2. Ribbon

  3. Formula bar

  4. None of these


Correct Option: B
Explanation:

Option (2) is correct.

Which of the following is the correct date function?

  1. =DATE(2008:12:25)

  2. =DATE(2008,12,25)

  3. =DATE(25,12,2008)

  4. DATE(2008:12:25)


Correct Option: B

Which of the following is the extension of a Microsoft Excel file?

  1. file.exe

  2. file.doc

  3. file.xlf

  4. file.xls


Correct Option: D

Which of the following can be used to put the current date and time in an excel sheet?

  1. TIME()

  2. =NOW()

  3. =DATE_TIME()

  4. =DATE_NOW()


Correct Option: B

Which of the following is not a chart type in the Excel Chart Wizard?

  1. Radar

  2. Pie

  3. Bubble

  4. Point


Correct Option: D
- Hide questions