Question 1

What would not be a typical item to have in a header or footer?

Accepted Answer

A) The spreadsheet designer's name 
B) The filename or file path 
C) The file size 
D) The page number 
A) The spreadsheet designer's name 
B) The filename or file path 
C) The file size 
D) The page number

Question 2

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 3

What is not one of the tabs in Excel?

Accepted Answer

A) Formulas 
B) Page Layout 
C) File 
D) Mailings 
A) Formulas 
B) Page Layout 
C) File 
D) Mailings

Question 4

A(n)________ range contains several ranges.

Accepted Answer

The answer of A(n)________ range contains several ranges....

Question 5

You cannot hide column A or row 1 because they cannot be unhidden.

Accepted Answer

A) True 
 B)False

Question 6

What can you not do directly from the Backstage,Print screen view?

Accepted Answer

A) Switch to formula view and print formulas 
B) Select which printer you want to use 
C) Select how much of the worksheet will be printed 
D) Set the page orientation 
A) Switch to formula view and print formulas 
B) Select which printer you want to use 
C) Select how much of the worksheet will be printed 
D) Set the page orientation

Question 7

It is relatively easy to copy Excel cells into other Office programs.

Accepted Answer

A) True 
 B)False

Question 8

What can you not do within the worksheet tabs shortcut menu?

Accepted Answer

A) Format the worksheet 
B) Add color to the tab 
C) Insert a worksheet 
D) Delete a worksheet 
A) Format the worksheet 
B) Add color to the tab 
C) Insert a worksheet 
D) Delete a worksheet

Question 9

You can select a range by using the Name Box.

Accepted Answer

A) True 
 B)False

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

Bottom Align is the default vertical alignment.

Accepted Answer

A) True 
 B)False

Question 12

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

Accepted Answer

A) True 
 B)False

Question 13

The cell at row 4 and column B,would be identified as 4B.

Accepted Answer

A) True 
 B)False

Question 14

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

Accepted Answer

A) True 
 B)False

Question 15

You can ________ a cell's contents to the right or left to help it stand out from the row above or below.

Accepted Answer

The answer of You can ________ a cell's contents to...

Question 16

Match between columns
                        Premises: Zoom control
Cell
Sheet tab
Workbook
Worksheet

Accepted Answer

The Answer of The intersection of a column and a is...

Question 17

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

Accepted Answer

A) True 
 B)False

Question 18

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

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

Question 20

Right-clicking a column heading,then selecting Insert,will add a new column to the left of the current column.

Accepted Answer

A) True 
 B)False

What would not be a typical item to have in a header or footer?

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

What is not one of the tabs in Excel?

A(n)________ range contains several ranges.

You cannot hide column A or row 1 because they cannot be unhidden.

What can you not do directly from the Backstage,Print screen view?

It is relatively easy to copy Excel cells into other Office programs.

What can you not do within the worksheet tabs shortcut menu?

You can select a range by using the Name Box.

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

Bottom Align is the default vertical alignment.

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

The cell at row 4 and column B,would be identified as 4B.

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

You can ________ a cell's contents to the right or left to help it stand out from the row above or below.

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

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

Which of the following is not a valid formula?

Right-clicking a column heading,then selecting Insert,will add a new column to the left of the current column.

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 would not be a typical item to have in a header or footer?

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

What is not one of the tabs in Excel?

A(n)________ range contains several ranges.

You cannot hide column A or row 1 because they cannot be unhidden.

What can you not do directly from the Backstage,Print screen view?

It is relatively easy to copy Excel cells into other Office programs.

What can you not do within the worksheet tabs shortcut menu?

You can select a range by using the Name Box.

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

Bottom Align is the default vertical alignment.

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

The cell at row 4 and column B,would be identified as 4B.

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

You can ________ a cell's contents to the right or left to help it stand out from the row above or below.

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

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

Which of the following is not a valid formula?

Right-clicking a column heading,then selecting Insert,will add a new column to the left of the current column.

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