MS Excel MCQs

Which is the shortcut key to display active cells in Excell?

1. Shift+Backspace
2. Crtl+Backspace
3. Alt+Backspace
4. none

Ms Excel is a

1. Spreadsheet program
2. Multimedia software
3. Entertainment software
4. None

Ms Excel displays the current cell address in the ____

1. Name box
2. Cell tip
3. Both
4. None

—–is used for arranging data in ascending/descending order in MS Excel

1. Data, order
2. Data, sort
3. Data, all
4. None of these

What term refers to a specific set of values saved with the workbook?

1. Range
2. Trend line
3. Scenario
4. What-if analysis

The horizontal and vertical lines on a spreadsheet are called:

1. Grid-lines
2. Block lines
3. Sheets
4. Cells

Which type of chart use in time changing project?

1. Bar
2. Histo
3. line
4. none of these

Which of the following is correct syntax in Excel?

1. =IF(LogicalTest, TrueResult, FalseResult)
2. =IF(LogicalTest, (TrueResult, FalseResult)
3. =IF(LogicalTest, TrueResult) (LogicalTest, FalseResult)
4. =IF(LogicalTest, TrueResult), IF(LogicalTest, FalseResult)

Which sign is used to create an absolute cell reference in MS Excel?

1. @
2. =
3. $
4. %

What will be the result of formula '=16/2^3' in a cell in MS Excel?

1. 512
2. 124
3. 2
4. 124