Computer Awareness MS Excel MCQ, Computer Awareness Questions

To drag a selected range of data to another worksheet in the same workbook, use the?

Protection and the Protect Sheet options can be selected from?

To drag a selected range of data to another worksheet in the same workbook, use the?

You can check the conditions against ____ when applying conditional formatting?

Which function calculates your monthly mortgage payment?

VLOOKUP function used to?

You can activate a cell by?

A function inside another function is known as?

When you insert an Excel file into a Word document, the data are

Except for the …… function, a formula with a logical function shows the word “TRUE” or “FALSE” as a result

You can use drag-and-drop to embed excel worksheet data in a word document

What does the VLOOKUP function do?

Which of the following is an absolute cell reference?

What symbol is used before a number to make it a label?

Which of the following formulas is not entered correctly?

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

How many characters can be typed in a single cell in Excel?

Which of the following is not an example of a value?

The chart wizard term data series refers to

Getting data from a cell located in a different sheet is called _____

Tab scrolling button

A numeric value can be treated as a label value if it precedes with

Data can be arranged in a worksheet in a easy to understand manner using

The auto calculate feature

Excel uniquely identifies cells within a worksheet with a cell name

When you want to insert a blank imbedded excel object in a word document you can

When integrating word and excel, word is usually the

When a label is too long to fit within a worksheet cell, you typically must

The name box

Comments put in cells are called