Question 1

What is the best way to make sure your worksheet prints on only one page?

Accepted Answer

A) Limit the amount of data you put on each worksheet 
B) Make the font sizes smaller 
C) Make the margins as small as possible 
D) Use the Fit to option 
A) Limit the amount of data you put on each worksheet 
B) Make the font sizes smaller 
C) Make the margins as small as possible 
D) Use the Fit to option D

Question 2

Adding color to cells is not considered a professional design strategy.

Accepted Answer

A) True 
 B)False  False

Question 3

________ can be used in calculations,whereas text cannot.

Accepted Answer

Values

Question 4

Where is the Show Formulas command found?

Accepted Answer

A) Formula Auditing group on the Formulas tab 
B) Formula Auditing group on the Data tab 
C) Formula Auditing group on the Review tab 
D) Formula Auditing group on the Developer tab 
A) Formula Auditing group on the Formulas tab 
B) Formula Auditing group on the Data tab 
C) Formula Auditing group on the Review tab 
D) Formula Auditing group on the Developer tab

Question 5

What Paste option would you choose if you wanted to maintain the formatting of the copied cell,but not its contents?

Accepted Answer

A) Formatting 
B) Keep Source Formatting 
C) Paste 
D) Keep Formating Only 
A) Formatting 
B) Keep Source Formatting 
C) Paste 
D) Keep Formating Only

Question 6

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 7

What is the best practice to switch the columns and rows in a range?

Accepted Answer

A) Cut the range,then use the Paste Special option called Values 
B) Cut the range,then use the Paste Special option called Transpose 
C) Cut the range,then use the Paste Special option called Switch 
D) Cut the range,paste it into a blank area,then cut and paste each cell where you want it 
A) Cut the range,then use the Paste Special option called Values 
B) Cut the range,then use the Paste Special option called Transpose 
C) Cut the range,then use the Paste Special option called Switch 
D) Cut the range,paste it into a blank area,then cut and paste each cell where you want it

Question 8

When you do not need the data on a worksheet you should ________ it to make the file smaller.

Accepted Answer

The answer of When you do not need the data...

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

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 11

Match between columns
                        Premises: View controls
Page Layout view
Normal view
Sheet tab navigation
Page Break Preview

Accepted Answer

The Answer of Icons that let you change views and is...

Question 12

You should use ________ in formulas whenever possible instead of static numbers.

Accepted Answer

The answer of You should use ________ in formulas whenever...

Question 13

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 14

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

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 15

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

Accepted Answer

semi-selec

Question 16

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

Accepted Answer

The Answer of The number in the cell reference "F4" is...

Question 17

What is the best practice for centering a title over multiple columns?

Accepted Answer

A) Enter the title in the center column of the range 
B) Use the Merge Title feature 
C) Use the Merge and Center alignment 
D) Use the Combine and Center alignment 
A) Enter the title in the center column of the range 
B) Use the Merge Title feature 
C) Use the Merge and Center alignment 
D) Use the Combine and Center alignment

Question 18

You can add ________ color to a cell or range of cells for emphasis.

Accepted Answer

The answer of You can add ________ color to a...

Question 19

Which Paste option would you choose if you wanted to flip the rows and columns?

Accepted Answer

A) Transpose 
B) Rotate 
C) Flip 
D) Formulas 
A) Transpose 
B) Rotate 
C) Flip 
D) Formulas

Question 20

The current cell is also known as the ________ cell.

Accepted Answer

The answer of The current cell is also known as...

What is the best way to make sure your worksheet prints on only one page?

Adding color to cells is not considered a professional design strategy.

________ can be used in calculations,whereas text cannot.

Where is the Show Formulas command found?

What Paste option would you choose if you wanted to maintain the formatting of the copied cell,but not its contents?

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

What is the best practice to switch the columns and rows in a range?

When you do not need the data on a worksheet you should ________ it to make the file smaller.

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

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

You should use ________ in formulas whenever possible instead of static numbers.

Which of the following would not be considered text?

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

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

What is the best practice for centering a title over multiple columns?

You can add ________ color to a cell or range of cells for emphasis.

Which Paste option would you choose if you wanted to flip the rows and columns?

The current cell is also known as the ________ cell.

Formulas and Functions

Charts

Datasets and Tables

Subtotals, Pivot-tables, and Pivot-charts

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

Office 2016 Common Features

Filters

Exam 1: Introduction to Excel

What is the best way to make sure your worksheet prints on only one page?

Adding color to cells is not considered a professional design strategy.

________ can be used in calculations,whereas text cannot.

Where is the Show Formulas command found?

What Paste option would you choose if you wanted to maintain the formatting of the copied cell,but not its contents?

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

What is the best practice to switch the columns and rows in a range?

When you do not need the data on a worksheet you should ________ it to make the file smaller.

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

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

You should use ________ in formulas whenever possible instead of static numbers.

Which of the following would not be considered text?

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

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

What is the best practice for centering a title over multiple columns?

You can add ________ color to a cell or range of cells for emphasis.

Which Paste option would you choose if you wanted to flip the rows and columns?

The current cell is also known as the ________ cell.

Formulas and Functions

Charts

Datasets and Tables

Subtotals, Pivot-tables, and Pivot-charts

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

Office 2016 Common Features

Filters