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

Question 2

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 3

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

Accepted Answer

A) True 
 B)False

Question 4

Match the following navigation shortcuts with their actions:
i. Right arrow
II. Page Down
III. Home
IV. End
v. Ctrl + Home

Accepted Answer

A)  Moves active cell down one screen 
B)  This does nothing by itself 
C)  Moves active cell to column A, row 1 
D)  Moves active cell to column A in that row 
E)  Moves right one cell in the same row 
A)  Moves active cell down one screen 
B)  This does nothing by itself 
C)  Moves active cell to column A, row 1 
D)  Moves active cell to column A in that row 
E)  Moves right one cell in the same row

Question 5

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 6

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 Formatting Only 
A)  Formatting 
B)  Keep Source Formatting 
C)  Paste 
D)  Keep Formatting Only

Question 7

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

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

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 10

How is text aligned by default?

Accepted Answer

A)  Left 
B)  Center 
C)  Right 
D)  Decimal 
A)  Left 
B)  Center 
C)  Right 
D)  Decimal

Question 11

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

Accepted Answer

A) True 
 B)False

Question 12

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

Accepted Answer

A) True 
 B)False

Question 13

Match the following terms with their description:
i. Normal view
II. Page Layout view
III. Page Break Preview
IV. View controls
v. Sheet tab navigation

Accepted Answer

A)  Displays data and page breaks 
B)  Allows you to go to the first, previous, next, or last sheet in a workbook 
C)  Does not display margins or page breaks 
D)  Icons that let you change views 
E)  Displays data and margins 
A)  Displays data and page breaks 
B)  Allows you to go to the first, previous, next, or last sheet in a workbook 
C)  Does not display margins or page breaks 
D)  Icons that let you change views 
E)  Displays data and margins

Question 14

Number ________ controls how a value appears in a cell.

Accepted Answer

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

Question 15

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

Accepted Answer

A) True 
 B)False

Question 16

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

Match the following terms with their description:
i. Zoom control
II. Workbook
III. Worksheet
IV. Sheet tab
v. Cell

Accepted Answer

A)  Makes the text on the screen smaller or larger 
B)  Contain labels, values and formulas 
C)  The intersection of a column and a row 
D)  Shows the name of the worksheet 
E)  The same as a spreadsheet 
A)  Makes the text on the screen smaller or larger 
B)  Contain labels, values and formulas 
C)  The intersection of a column and a row 
D)  Shows the name of the worksheet 
E)  The same as a spreadsheet

Question 18

You can hide or delete multiple rows or columns by using the Ctrl or Shift key and then selecting the rows or columns you want to hide or delete.

Accepted Answer

A) True 
 B)False

Question 19

Match the following terms with their description:
i. AutoComplete
II. Auto Fill
III. Column heading
IV. Row heading
v. Alignment

Accepted Answer

A)  The letter in the cell reference "F4" 
B)  Helps complete a logical sequence 
C)  The number in the cell reference "F4" 
D)  Refers to how data are positioned in the boundaries of a cell. 
E)  Matches the letters you type to another value in the column if the letters match 
A)  The letter in the cell reference "F4" 
B)  Helps complete a logical sequence 
C)  The number in the cell reference "F4" 
D)  Refers to how data are positioned in the boundaries of a cell. 
E)  Matches the letters you type to another value in the column if the letters match

Question 20

Match the following terms with their description:
i. Name Box
II. Order of operations
III. Formula
IV. Fill handle
v. Pointing

Accepted Answer

A)  Always begins with an equals sign (=) 
B)  Small green square used to perform various actions 
C)  Displays the address of the active cell 
D)  Also known as semi-selection 
E)  PEMDAS 
A)  Always begins with an equals sign (=) 
B)  Small green square used to perform various actions 
C)  Displays the address of the active cell 
D)  Also known as semi-selection 
E)  PEMDAS

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

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

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

Match the following navigation shortcuts with their actions: i. Right arrow II. Page Down III. Home IV. End v. Ctrl + Home

New workbooks typically contain how many worksheets?

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

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

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

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

How is text aligned by default?

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

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

Match the following terms with their description: i. Normal view II. Page Layout view III. Page Break Preview IV. View controls v. Sheet tab navigation

Number ________ controls how a value appears in a cell.

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

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

Match the following terms with their description: i. Zoom control II. Workbook III. Worksheet IV. Sheet tab v. Cell

You can hide or delete multiple rows or columns by using the Ctrl or Shift key and then selecting the rows or columns you want to hide or delete.

Match the following terms with their description: i. AutoComplete II. Auto Fill III. Column heading IV. Row heading v. Alignment

Match the following terms with their description: i. Name Box II. Order of operations III. Formula IV. Fill handle v. Pointing

Common Features

Access: Introduction to Powerpoint

Access: Tables and Queries in Relational Databases

Access: Query Calculations and Expressions

Access: Basic Forms and Reports

Excell: Formulas and Functions

Excell: Charts

Excell: Datasets and Tables

Powerpoint: Introduction to Powerpoint

Powerpoint: Effective Presentation Development

Powerpoint: Presentation Enhancement

Powerpoint: Presentation Refinement

Word: Introduction to Word

Word: Document Presentation

Word: Document Productivity

Word: Research and Collaboration

Filters

Exam 6: Excell: Introduction to Excel

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

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

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

Match the following navigation shortcuts with their actions: i. Right arrow II. Page Down III. Home IV. End v. Ctrl + Home

New workbooks typically contain how many worksheets?

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

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

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

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

How is text aligned by default?

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

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

Match the following terms with their description: i. Normal view II. Page Layout view III. Page Break Preview IV. View controls v. Sheet tab navigation

Number ________ controls how a value appears in a cell.

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

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

Match the following terms with their description: i. Zoom control II. Workbook III. Worksheet IV. Sheet tab v. Cell

You can hide or delete multiple rows or columns by using the Ctrl or Shift key and then selecting the rows or columns you want to hide or delete.

Match the following terms with their description: i. AutoComplete II. Auto Fill III. Column heading IV. Row heading v. Alignment

Match the following terms with their description: i. Name Box II. Order of operations III. Formula IV. Fill handle v. Pointing

Common Features

Access: Introduction to Powerpoint

Access: Tables and Queries in Relational Databases

Access: Query Calculations and Expressions

Access: Basic Forms and Reports

Excell: Formulas and Functions

Excell: Charts

Excell: Datasets and Tables

Powerpoint: Introduction to Powerpoint

Powerpoint: Effective Presentation Development

Powerpoint: Presentation Enhancement

Powerpoint: Presentation Refinement

Word: Introduction to Word

Word: Document Presentation

Word: Document Productivity

Word: Research and Collaboration

Filters