Question 1

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

Accepted Answer

A) True 
 B)False  False

Question 2

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  False

Question 3

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

Accepted Answer

A) True 
 B)False  True

Question 4

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 5

Match the following terms with their description:
I. AutoComplete
II. Auto Fill
III. Column heading
IV. Row heading
V. Enter icon
A. The letter in the cell reference "F4"
B. Helps complete a logical sequence
C. The number in the cell reference "F4"
D. Looks like a check mark next to the formula bar
E. Matches the letters you type to another value in the column if the letters match

Accepted Answer

The answer of Match the following terms with their description:
I....

Question 6

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 7

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 8

Match the following navigation shortcuts with their actions:
I. Right arrow
II. Page Down
III. Home
IV. End
V. Ctrl + Home
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

Accepted Answer

The answer of Match the following navigation shortcuts with their...

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

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 11

Match the following terms with their description:
I. Paste Special, Add
II. Transpose
III. Flash Fill
IV. Accounting number format
V. Currency number format
A. Sums the values of the pasted cells to the cells already there
B. Puts the $ at the left margin of the cell
C. Flips rows and columns when pasted
D. Puts the $ next to the leftmost number
E. Fills in data based on previous column's data

Accepted Answer

The answer of Match the following terms with their description:
I....

Question 12

You can select a range by using the Name Box.

Accepted Answer

A) True 
 B)False

Question 13

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 14

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 15

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 16

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 17

The best way to apply Page Setup options to multiple worksheets is to ________.

Accepted Answer

A) group the worksheets 
B) use the Format Painter 
C) copy and Paste the formatting codes from one sheet to another 
D) use the Apply to Selected Sheets formatting command 
A) group the worksheets 
B) use the Format Painter 
C) copy and Paste the formatting codes from one sheet to another 
D) use the Apply to Selected Sheets formatting command

Question 18

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 19

Which of the following is not a way to widen a column?

Accepted Answer

A) Drag the line between the column headings to the desired size 
B) In the Page Layout tab, Scale to Fit group, select Automatic in the Width drop-down box 
C) Double-click the line between the column headings 
D) Right-click a column heading and select Column Width 
A) Drag the line between the column headings to the desired size 
B) In the Page Layout tab, Scale to Fit group, select Automatic in the Width drop-down box 
C) Double-click the line between the column headings 
D) Right-click a column heading and select Column Width

Question 20

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

Accepted Answer

semi-selec

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

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.

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

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.

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

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

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

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

You can select a range by using the Name Box.

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

Which of the following is not a valid formula?

Which keyboard shortcut puts the user in cell edit mode?

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

The best way to apply Page Setup options to multiple worksheets is to ________.

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

Which of the following is not a way to widen a column?

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

Access: Introduction to Access

Access: Tables and Queries in Relational Databases

Access: Using Queries to Make Decisions

Access: Creating and Using Professional Forms and Reports

Excel : Formulas and Functions

Excel : Charts

Excel : Datasets and Tables

Power Point: Creating a Basic Presentation

Power Point: Presentation Development

Power Point: Presentation Design

Power Point: Enhancing With Multimedia

Word: Introduction to Word

Word: Document Presentation

Word: Document Productivity

Word: Collaboration and Research

Office 2016 Common Features

Working With an Operating System

Filters

Exam 5: Excel : Introduction to Excel

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

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.

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

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.

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

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

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

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

You can select a range by using the Name Box.

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

Which of the following is not a valid formula?

Which keyboard shortcut puts the user in cell edit mode?

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

The best way to apply Page Setup options to multiple worksheets is to ________.

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

Which of the following is not a way to widen a column?

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

Access: Introduction to Access

Access: Tables and Queries in Relational Databases

Access: Using Queries to Make Decisions

Access: Creating and Using Professional Forms and Reports

Excel : Formulas and Functions

Excel : Charts

Excel : Datasets and Tables

Power Point: Creating a Basic Presentation

Power Point: Presentation Development

Power Point: Presentation Design

Power Point: Enhancing With Multimedia

Word: Introduction to Word

Word: Document Presentation

Word: Document Productivity

Word: Collaboration and Research

Office 2016 Common Features

Working With an Operating System

Filters