Question 1

Which of the following is not a valid Cell Style?

Accepted Answer

A)  Heading 5
B)  Accent 3
C)  Input
D)  CalculationE) A) and B)
F) B) and C)

Question 2

Make sure to enter all cell reference in upper case when putting them in formulas.

Accepted Answer

A) True 
 B)False

Question 3

Which of the following would not be considered text?

Accepted Answer

A)  Phone number (111.111.1111) 
B)  Social Security number (111-11-1111) 
C)  Part number (PT111) 
D)  =2*2E) A) and D)
F) None of the above

Question 4

The contents of a cell can be seen in the naming box.

Accepted Answer

A) True 
 B)False

Question 5

Use the Find command to jump to a cell that is not currently visible.

Accepted Answer

A) True 
 B)False

Question 6

Match between columns
                        Premises: XFD
Text
Semi-selection
Range
Value

Accepted Answer

The Answer of A combination of letters not used in is...

Question 7

The fill handle allows you to copy and paste formulas to adjacent cells.

Accepted Answer

A) True 
 B)False

Question 8

What does it mean when you see ####### in a cell?

Accepted Answer

A)  Your formula is incorrect.
B)  At least one of the cell references in your formula is pointing to an empty cell.
C)  Your column is not wide enough.
D)  Your row is not tall enough.E) C) and D)
F) A) and C)

Question 9

Match between columns
                        Premises: Enter icon
Row heading
AutoComplete
Auto Fill
Column heading

Accepted Answer

The Answer of Matches the letters you type to another is...

Question 10

When cells are merged, the merged cell's address becomes the address of the range.

Accepted Answer

A) True 
 B)False

Question 11

What is the small green square in the bottom right of a cell called?

Accepted Answer

A)  Sizing handle
B)  Fill handle
C)  Copy/Paste handle
D)  Move Cell handleE) A) and B)
F) None of the above

Question 12

It is always a good practice to test each formula you enter for accuracy.

Accepted Answer

A) True 
 B)False

Question 13

Using ________ often decreases the amount of time it takes to enter cell references in formulas.

Accepted Answer

semi-selec...

Question 14

A(n)________ is a line you can put around a cell or range of cells for emphasis.

Accepted Answer

The answer of A(n)________ is a line you can put...

Question 15

Excel stores dates as numbers with 0 being 0 CE according to the Gregorian calendar.

Accepted Answer

A) True 
 B)False

Question 16

In the formula, =1+(2-3) +5/6-6^2, what will Excel evaluate first?

Accepted Answer

A)  5/6
B)  1+
C)  (2-3) 
D)  6^2E) All of the above
F) A) and C)

Question 17

Number ________ controls how a value appears in a cell.

Accepted Answer

The answer of Number ________ controls how a value appears...

Question 18

Displaying cell formulas can help find errors in formulas more easily.

Accepted Answer

A) True 
 B)False

Question 19

Which of the following is not a valid formula?

Accepted Answer

A)  =D3
B)  =2*2
C)  =sum(1,2,3,4,5) 
D)  =#12/31/2014#-#12/31/2015#E) B) and C)
F) B) and D)

Question 20

Which of the following is not one of the recommendations when first designing a spreadsheet?

Accepted Answer

A)  Decide what your purpose is
B)  Decide what inputs you will need
C)  Estimate the amount of time required to complete the spreadsheet
D)  Decide what outputs you will needE) All of the above
F) A) and B)

Exam 1: Introduction to Excel

Match the following terms with their description:

It is always a good practice to test each formula you enter for accuracy.

Correct Answer
verified

What is the small green square in the bottom right of a cell called?

Correct Answer
verified

Match the following terms with their description:

In the formula, =1+(2-3) +5/6-6^2, what will Excel evaluate first?

Correct Answer
verified

What does it mean when you see ####### in a cell?

Correct Answer
verified

Number ________ controls how a value appears in a cell.

Correct Answer
verified

Make sure to enter all cell reference in upper case when putting them in formulas.

Correct Answer
verified

Use the Find command to jump to a cell that is not currently visible.

Correct Answer
verified

Which of the following is not a valid formula?

Correct Answer
verified

A(n)________ is a line you can put around a cell or range of cells for emphasis.

Correct Answer
verified

Which of the following is not one of the recommendations when first designing a spreadsheet?

Correct Answer
verified

Displaying cell formulas can help find errors in formulas more easily.

Correct Answer
verified

When cells are merged, the merged cell's address becomes the address of the range.

Correct Answer
verified

Which of the following is not a valid Cell Style?

Correct Answer
verified

Which of the following would not be considered text?

Correct Answer
verified

The contents of a cell can be seen in the naming box.

Correct Answer
verified

Using ________ often decreases the amount of time it takes to enter cell references in formulas.

Correct Answer
verified
semi-selec...
View Answer

The fill handle allows you to copy and paste formulas to adjacent cells.

Correct Answer
verified

Excel stores dates as numbers with 0 being 0 CE according to the Gregorian calendar.

Correct Answer
verified

Exam 1: Introduction to Excel

Match the following terms with their description:

It is always a good practice to test each formula you enter for accuracy.

Correct AnswerverifiedShow Answer

What is the small green square in the bottom right of a cell called?

Correct AnswerverifiedShow Answer

Match the following terms with their description:

In the formula, =1+(2-3) +5/6-6^2, what will Excel evaluate first?

Correct AnswerverifiedShow Answer

What does it mean when you see ####### in a cell?

Correct AnswerverifiedShow Answer

Number ________ controls how a value appears in a cell.

Correct AnswerverifiedShow Answer

Make sure to enter all cell reference in upper case when putting them in formulas.

Correct AnswerverifiedShow Answer

Use the Find command to jump to a cell that is not currently visible.

Correct AnswerverifiedShow Answer

Which of the following is not a valid formula?

Correct AnswerverifiedShow Answer

A(n)________ is a line you can put around a cell or range of cells for emphasis.

Correct AnswerverifiedShow Answer

Which of the following is not one of the recommendations when first designing a spreadsheet?

Correct AnswerverifiedShow Answer

Displaying cell formulas can help find errors in formulas more easily.

Correct AnswerverifiedShow Answer

When cells are merged, the merged cell's address becomes the address of the range.

Correct AnswerverifiedShow Answer

Which of the following is not a valid Cell Style?

Correct AnswerverifiedShow Answer

Which of the following would not be considered text?

Correct AnswerverifiedShow Answer

The contents of a cell can be seen in the naming box.

Correct AnswerverifiedShow Answer

Using ________ often decreases the amount of time it takes to enter cell references in formulas.

Correct Answerverifiedsemi-selec...View AnswerShow Answer

The fill handle allows you to copy and paste formulas to adjacent cells.

Correct AnswerverifiedShow Answer

Excel stores dates as numbers with 0 being 0 CE according to the Gregorian calendar.

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
semi-selec...
View Answer

Correct Answer
verified

Correct Answer
verified