Question 1

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 2

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

Accepted Answer

A) True 
 B)False

Question 3

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. 
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.

Question 4

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^2 
A) 5/6 
B) 1+ 
C) (2-3) 
D) 6^2

Question 5

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*2 
A) Phone number (111.111.1111) 
B) Social Security number (111-11-1111) 
C) Part number (PT111) 
D) =2*2

Question 6

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

Accepted Answer

A) True 
 B)False

Question 7

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

Accepted Answer

A) True 
 B)False

Question 8

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 handle 
A) Sizing handle 
B) Fill handle 
C) Copy/Paste handle 
D) Move Cell handle

Question 9

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

Accepted Answer

A) True 
 B)False

Question 10

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 need 
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 need

Question 11

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

Accepted Answer

semi-selec

Question 12

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

Accepted Answer

A) True 
 B)False

Question 13

Number ________ controls how a value appears in a cell.

Accepted Answer

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

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

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

Accepted Answer

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

Question 16

Which of the following is not a valid Cell Style?

Accepted Answer

A) Heading 5 
B) Accent 3 
C) Input 
D) Calculation 
A) Heading 5 
B) Accent 3 
C) Input 
D) Calculation

Question 17

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

Accepted Answer

A) True 
 B)False

Question 18

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

Accepted Answer

A) True 
 B)False

Question 19

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

Accepted Answer

A) True 
 B)False

Question 20

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# 
A) =D3 
B) =2*2 
C) =sum(1,2,3,4,5) 
D) =#12/31/2014#-#12/31/2015#

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

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

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

Which of the following would not be considered text?

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

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

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

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

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

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

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

Number ________ controls how a value appears in a cell.

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

Which of the following is not a valid Cell Style?

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

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

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

Which of the following is not a valid formula?

Formulas and Functions

Charts

Datasets and Tables

Subtotals, Pivottables, and Pivotcharts

What-If Analysis

Specialized Functions

Statistical Functions

Multiple-Sheet Workbook Management

Imports, Xml, and Power Add-Ins

Collaboration and Workbook Distribution

Templates, Styles, and Macros

Appendix: Exploring Microsoft Office Excel 2016 Comprehensive Poatsygrauer

Filters

Exam 1: Introduction to Excel

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

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

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

Which of the following would not be considered text?

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

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

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

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

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

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

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

Number ________ controls how a value appears in a cell.

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

Which of the following is not a valid Cell Style?

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

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

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

Which of the following is not a valid formula?

Formulas and Functions

Charts

Datasets and Tables

Subtotals, Pivottables, and Pivotcharts

What-If Analysis

Specialized Functions

Statistical Functions

Multiple-Sheet Workbook Management

Imports, Xml, and Power Add-Ins

Collaboration and Workbook Distribution

Templates, Styles, and Macros

Appendix: Exploring Microsoft Office Excel 2016 Comprehensive Poatsygrauer

Filters