Question 1

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

Accepted Answer

A) True 
 B)False

Question 2

A(n)________ is a type of file that organizes data in rows and columns.

Accepted Answer

The answer of A(n)________ is a type of file that...

Question 3

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 4

What can you not do from the Page Setup, Sheet tab?

Accepted Answer

A) Set margins 
B) Set a print area 
C) Print gridlines 
D) Change the page order 
A) Set margins 
B) Set a print area 
C) Print gridlines 
D) Change the page order

Question 5

Which Paste option would you choose if you wanted only the computed values to be pasted, but with all formatting intact?

Accepted Answer

A) Paste 
B) Values 
C) Values & Number Formatting 
D) Values & Source Formatting 
A) Paste 
B) Values 
C) Values & Number Formatting 
D) Values & Source Formatting

Question 6

Which of the following is not a valid number format?

Accepted Answer

A) $1,000.00 
B) $ 1,000.000 
C) (1,000.00) 
D) $ -1,000.00 
A) $1,000.00 
B) $ 1,000.000 
C) (1,000.00) 
D) $ -1,000.00

Question 7

Which of the following is not a valid keystroke for navigating around a worksheet?

Accepted Answer

A) Ctrl + Home 
B) Ctrl + End 
C) Alt + Up arrow 
D) Page Down 
A) Ctrl + Home 
B) Ctrl + End 
C) Alt + Up arrow 
D) Page Down

Question 8

What does pressing the Enter key while in a cell, do?

Accepted Answer

A) The value is set, and the active cell remains the active cell 
B) The value is set, and the cell to the right becomes the active cell 
C) The value is set, and the cell below becomes the active cell 
D) The value is set, and the action is the same as pressing the Tab key 
A) The value is set, and the active cell remains the active cell 
B) The value is set, and the cell to the right becomes the active cell 
C) The value is set, and the cell below becomes the active cell 
D) The value is set, and the action is the same as pressing the Tab key

Question 9

You can select a range by using the Name Box.

Accepted Answer

A) True 
 B)False

Question 10

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 11

Which of the following names of worksheet tabs would be best?

Accepted Answer

A) Sheet 1 
B) Jan 
C) January Payroll Information 
D) JPAE 
A) Sheet 1 
B) Jan 
C) January Payroll Information 
D) JPAE

Question 12

The ________ feature can pull only part of a cell's value and place it into another cell.

Accepted Answer

Flash Fill

Question 13

The current cell is also known as the ________ cell.

Accepted Answer

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

Question 14

Match between columns
                        Premises: File
View
Home
Insert
Data

Accepted Answer

The Answer of Alt + H and Alt + A is...

Question 15

Cell ________ refers to how data are located within the boundaries of the cell.

Accepted Answer

The answer of Cell ________ refers to how data are...

Question 16

For the fill handle to work you need to have two cells selected.

Accepted Answer

A) True 
 B)False

Question 17

Bottom Align is the default vertical alignment.

Accepted Answer

A) True 
 B)False

Question 18

Which is not a valid range?

Accepted Answer

A) A1:A3, B1:B3 
B) A1:A9 
C) A1:F1 
D) A1:F9 
A) A1:A3, B1:B3 
B) A1:A9 
C) A1:F1 
D) A1:F9

Question 19

Match between columns
                        Premises: Home
End
Page Down
Ctrl + Home
Right arrow

Accepted Answer

The Answer of Moves active cell to column A , is...

Question 20

If you want to unmerge cells you click the Unmerge alignment option.

Accepted Answer

A) True 
 B)False

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

A(n)________ is a type of file that organizes data in rows and columns.

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

What can you not do from the Page Setup, Sheet tab?

Which Paste option would you choose if you wanted only the computed values to be pasted, but with all formatting intact?

Which of the following is not a valid number format?

Which of the following is not a valid keystroke for navigating around a worksheet?

What does pressing the Enter key while in a cell, do?

You can select a range by using the Name Box.

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

Which of the following names of worksheet tabs would be best?

The ________ feature can pull only part of a cell's value and place it into another cell.

The current cell is also known as the ________ cell.

Cell ________ refers to how data are located within the boundaries of the cell.

For the fill handle to work you need to have two cells selected.

Bottom Align is the default vertical alignment.

Which is not a valid range?

If you want to unmerge cells you click the Unmerge alignment option.

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

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

A(n)________ is a type of file that organizes data in rows and columns.

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

What can you not do from the Page Setup, Sheet tab?

Which Paste option would you choose if you wanted only the computed values to be pasted, but with all formatting intact?

Which of the following is not a valid number format?

Which of the following is not a valid keystroke for navigating around a worksheet?

What does pressing the Enter key while in a cell, do?

You can select a range by using the Name Box.

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

Which of the following names of worksheet tabs would be best?

The ________ feature can pull only part of a cell's value and place it into another cell.

The current cell is also known as the ________ cell.

Cell ________ refers to how data are located within the boundaries of the cell.

For the fill handle to work you need to have two cells selected.

Bottom Align is the default vertical alignment.

Which is not a valid range?

If you want to unmerge cells you click the Unmerge alignment option.

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