MS Excel MCQs

Question 1

Which of the following is not information you can specify using the solver?

Accepted Answer

Input cells

Answer

Constraints

Answer

Target cell

Answer

Changing cells

Question 2

Each excel file is called a workbook because

Accepted Answer

It can contain many sheets including worksheets and chart sheets

Answer

It can contain text and data

Answer

It can be modified

Answer

You have to work hard to create it

Question 3

Excel probably considers the cell entry January 1, 2020 to be a

Accepted Answer

Value

Answer

Label

Answer

Formula

Answer

Text string

Question 4

You can enter which types of data into worksheet cells?

Accepted Answer

Labels, values, and formulas

Answer

Labels and values but not formulas

Answer

Values and formulas but not labels

Answer

Formulas only

Question 5

All worksheet formula

Accepted Answer

Return a formula result

Answer

Manipulate values

Answer

Manipulate labels

Answer

Use the addition operator

Question 6

Which of the following is a correct order of precedence in formula calculation?

Accepted Answer

None of above

Answer

Multiplication and division exponentiation positive and negative values

Answer

Multiplication and division, positive and negative values, addition and subtraction

Answer

Addition and subtraction, positive and negative values, exponentiation

Question 7

The Paste Special command lets you copy and paste:

Accepted Answer

The resulting values of a formula instead of the actual formula

Answer

Multiply the selection by a copied value

Answer

Cell comments

Answer

Formatting options

Question 8

The numbers in our worksheet look like this 1000: You want them to look like this: $1,000.How can you accomplish this?

Accepted Answer

Click the Currency Style button on the formatting toolbar

Answer

You have to retype everything and manually add the dollar signs, commas, and decimals

Answer

Select Format > Money from the menu

Answer

None of these

Question 9

Excel worksheet cells work very similarly to what common element of the windows graphical user interface

Accepted Answer

Text boxes

Answer

Option buttons

Answer

List boxes

Answer

Combo boxes