Question 1

If you do not need a row or column any more it is best to hide it instead of deleting it in case you change your mind.

Accepted Answer

A) True 
 B)False

Question 2

Which keyboard shortcut puts the user in cell edit mode?

Accepted Answer

A) F2 
B) Shift F2 
C) F3 
D) Shift F3 
A) F2 
B) Shift F2 
C) F3 
D) Shift F3

Question 3

Match between columns
                        Premises: Flash Fill
Accounting number format
Paste Special,Add
Currency number format
Transpose

Accepted Answer

The Answer of Puts the $ next to the leftmost is...

Question 4

What should you do if there are columns you need,but do not want to display?

Accepted Answer

A) Delete the columns you do not want to display then undo your action when finished. 
B) Move the columns you want to see so that they are together then move them back to their original locations with finished. 
C) Cut and paste the columns you do not want to display to another area of the worksheet. 
D) Hide the columns you do not want to display,then unhide them when finished. 
A) Delete the columns you do not want to display then undo your action when finished. 
B) Move the columns you want to see so that they are together then move them back to their original locations with finished. 
C) Cut and paste the columns you do not want to display to another area of the worksheet. 
D) Hide the columns you do not want to display,then unhide them when finished.

Question 5

The ________ area contains the formulas which are dependent on values found elsewhere in the sheet.

Accepted Answer

The answer of The ________ area contains the formulas which...

Question 6

________ a carefully formatted worksheet can save you a lot of time when you need that formatting on another sheet.

Accepted Answer

The answer of ________ a carefully formatted worksheet can save...

Question 7

Match between columns
                        Premises: Order of operations
Name Box
Pointing
Formula
Fill handle

Accepted Answer

The Answer of Displays the address of the active cell is...

Question 8

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

Accepted Answer

A) True 
 B)False

Question 9

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 10

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

New workbooks typically contain how many worksheets?

Accepted Answer

A) 0 
B) 1 
C) 2 
D) 3 
A) 0 
B) 1 
C) 2 
D) 3

Question 13

Besides the Page Setup dialog box,where else can you create headers or footers?

Accepted Answer

A) Page Layout tab,Text group,Header & Footer 
B) Insert tab,Text group,Header & Footer 
C) Home tab,Text group,Header & Footer 
D) View tab,Text group,Header & Footer 
A) Page Layout tab,Text group,Header & Footer 
B) Insert tab,Text group,Header & Footer 
C) Home tab,Text group,Header & Footer 
D) View tab,Text group,Header & Footer

Question 14

When you copy and paste a range the relative references do not change.

Accepted Answer

A) True 
 B)False

Question 15

Which of the following is not considered an Excel element?

Accepted Answer

A) Formula Bar 
B) Name Box 
C) Active cell 
D) Print Preview 
A) Formula Bar 
B) Name Box 
C) Active cell 
D) Print Preview

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

You can move a range by using the cut and paste commands.

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

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 20

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

If you do not need a row or column any more it is best to hide it instead of deleting it in case you change your mind.

Which keyboard shortcut puts the user in cell edit mode?

What should you do if there are columns you need,but do not want to display?

The ________ area contains the formulas which are dependent on values found elsewhere in the sheet.

________ a carefully formatted worksheet can save you a lot of time when you need that formatting on another sheet.

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

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

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

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

New workbooks typically contain how many worksheets?

Besides the Page Setup dialog box,where else can you create headers or footers?

When you copy and paste a range the relative references do not change.

Which of the following is not considered an Excel element?

Which of the following is not a valid Cell Style?

You can move a range by using the cut and paste commands.

Which is not a valid range?

Which of the following is not a valid number format?

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

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

If you do not need a row or column any more it is best to hide it instead of deleting it in case you change your mind.

Which keyboard shortcut puts the user in cell edit mode?

What should you do if there are columns you need,but do not want to display?

The ________ area contains the formulas which are dependent on values found elsewhere in the sheet.

________ a carefully formatted worksheet can save you a lot of time when you need that formatting on another sheet.

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

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

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

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

New workbooks typically contain how many worksheets?

Besides the Page Setup dialog box,where else can you create headers or footers?

When you copy and paste a range the relative references do not change.

Which of the following is not considered an Excel element?

Which of the following is not a valid Cell Style?

You can move a range by using the cut and paste commands.

Which is not a valid range?

Which of the following is not a valid number format?

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

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