Question 1

Which of the following is the temporary Windows storage area that holds selections you copy or cut?

Accepted Answer

A)  Clipboard 
B)  Backstage 
C)  Name box 
D)  Worksheet window 
A)  Clipboard 
B)  Backstage 
C)  Name box 
D)  Worksheet window

Question 2

Which of the following methods copies an existing worksheet within the same workbook?

Accepted Answer

A)  Drag its sheet tab to a new location. 
B)  Press and hold CTRL and drag its sheet tab to a new location. 
C)  Press and hold SHIFT and drag its sheet tab to a new location. 
D)  Press and hold ALT and drag its sheet tab to a new location. 
A)  Drag its sheet tab to a new location. 
B)  Press and hold CTRL and drag its sheet tab to a new location. 
C)  Press and hold SHIFT and drag its sheet tab to a new location. 
D)  Press and hold ALT and drag its sheet tab to a new location.

Question 3

To open a workbook after you start Excel, you can use the Open Other Workbooks command on the Navigation bar.

Accepted Answer

A) True 
 B)False

Question 4

Which of the following lets you edit the contents of a cell?

Accepted Answer

A)  Click the cell, click the status bar, and press Enter. 
B)  Click the cell and click in the status bar. 
C)  Double-click the cell, click in the status bar, or just start typing. 
D)  Double-click the cell or click in the formula bar. 
A)  Click the cell, click the status bar, and press Enter. 
B)  Click the cell and click in the status bar. 
C)  Double-click the cell, click in the status bar, or just start typing. 
D)  Double-click the cell or click in the formula bar.

Question 5

To print worksheet contents across the length of a page, you can use portrait orientation.

Accepted Answer

A) True 
 B)False

Question 6

You need to add another product to your inventory worksheet, which shows product names in row A. Which of the following should you add?

Accepted Answer

A)  a row 
B)  a column 
C)  a button 
D)  conditional formatting 
A)  a row 
B)  a column 
C)  a button 
D)  conditional formatting

Question 7

You receive a worksheet in which the rows are numbered 1, 2, 3, 5,6. This means that row 4 is _____.

Accepted Answer

A)  deleted 
B)  hidden 
C)  cut 
D)  conditionally formatted 
A)  deleted 
B)  hidden 
C)  cut 
D)  conditionally formatted

Question 8

Why is it necessary to use care when inserting worksheet cells?

Accepted Answer

A)  It might automatically change the functions you are using. 
B)  It can change relative references to absolute references in formulas. 
C)  You will have to manually correct cell references in formulas. 
D)  It may disturb row or column alignment, which can affect worksheet accuracy. 
A)  It might automatically change the functions you are using. 
B)  It can change relative references to absolute references in formulas. 
C)  You will have to manually correct cell references in formulas. 
D)  It may disturb row or column alignment, which can affect worksheet accuracy.

Question 9

To enter a range of text based on examples that are already in your worksheet, which of the following can you use?

Accepted Answer

A)  Business Intelligence 
B)  Flash fill 
C)  Quick Analysis tools 
D)  What-if analysis 
A)  Business Intelligence 
B)  Flash fill 
C)  Quick Analysis tools 
D)  What-if analysis

Question 10

Where do you rename a workbook and adjust its save location?

Accepted Answer

A)  Save As dialog box 
B)  Home tab 
C)  Name box 
D)  Active cell 
A)  Save As dialog box 
B)  Home tab 
C)  Name box 
D)  Active cell

Question 11

In formulas, calculations in square brackets are calculated first.

Accepted Answer

A) True 
 B)False

Question 12

Your worksheet is too wide to fit on one portrait page. What is the best way to fix this problem?

Accepted Answer

A)  Hide the column headings. 
B)  Insert a function. 
C)  Copy columns to the next page. 
D)  Change the page orientation to landscape. 
A)  Hide the column headings. 
B)  Insert a function. 
C)  Copy columns to the next page. 
D)  Change the page orientation to landscape.

Question 13

Which of the following can you use to insert a formula using a function?

Accepted Answer

A)  Insert Function dialog box 
B)  AutoSum button on the Ribbon 
C)  AutoSum list arrow on the Ribbon 
D)  Copy and paste a cell containing a function 
A)  Insert Function dialog box 
B)  AutoSum button on the Ribbon 
C)  AutoSum list arrow on the Ribbon 
D)  Copy and paste a cell containing a function

Question 14

To format text so that it automatically appears in multiple lines within a cell, you can transpose it.

Accepted Answer

False - wr

Question 15

Miley wants to perform calculations on four worksheets with identical structures at the same time. So, in order to group them and perform the task faster, she can press the Ctrl + Alt key and click the worksheet tabs she wants to group and then modify either of the worksheets for automatic change in the other one.

Accepted Answer

A) True 
 B)False

Question 16

When should you use relative cell references?

Accepted Answer

A)  When you want to preserve the exact cell address in a formula. 
B)  When you want to preserve the relationship to the formula location. 
C)  When you want to insert a function. 
D)  When you want to enter sequential values in a range of cells. 
A)  When you want to preserve the exact cell address in a formula. 
B)  When you want to preserve the relationship to the formula location. 
C)  When you want to insert a function. 
D)  When you want to enter sequential values in a range of cells.

Question 17

Which of the following will you select as X in the following series of clicks to copy a chart from Excel to Word so that it is no longer linked to Excel: In Excel: Chart > Home tab > Clipboard group > Copy button > In Word: location to paste chart > Home tab > Clipboard

Accepted Answer

A)  Link 
B)  Embed 
C)  Source formatting 
D)  Destination theme 
A)  Link 
B)  Embed 
C)  Source formatting 
D)  Destination theme

Question 18

Carol wants to unhide a workbook window she had hidden earlier. Which of these series of clicks can she press to do so?

Accepted Answer

A)  View tab > Window group > Unhide 
B)  View tab > Window group > Uncheck box beside Hide > Check box beside Unhide 
C)  File > Options > Display > Check Show all windows in the Taskbar box 
D)  Home > Format > Visibility > Hide & Unhide > Hide Sheet 
A)  View tab > Window group > Unhide 
B)  View tab > Window group > Uncheck box beside Hide > Check box beside Unhide 
C)  File > Options > Display > Check Show all windows in the Taskbar box 
D)  Home > Format > Visibility > Hide & Unhide > Hide Sheet

Question 19

A student is given the task of counting the number of nonblank cells in the range of cells B1 to B20. Which of the following formulas should he use to do so?

Accepted Answer

A)  =COUNT(B1:B20) 
B)  =COUNTIF(B1:B20) 
C)  =COUNTA(B1:B20) 
D)  =DCOUNTA(B1:B20) 
A)  =COUNT(B1:B20) 
B)  =COUNTIF(B1:B20) 
C)  =COUNTA(B1:B20) 
D)  =DCOUNTA(B1:B20)

Question 20

Which of the following formulas totals the cells B6, B7, B8, B9, and B10 most efficiently?

Accepted Answer

A)  The formula =B6+B7+B8+B9+B10. 
B)  The formula =TOTAL(B6-B10) 
C)  The formula =SUM(B6:B10) 
D)  The formula +SUM(B6-B10) 
A)  The formula =B6+B7+B8+B9+B10. 
B)  The formula =TOTAL(B6-B10) 
C)  The formula =SUM(B6:B10) 
D)  The formula +SUM(B6-B10)

Which of the following is the temporary Windows storage area that holds selections you copy or cut?

Which of the following methods copies an existing worksheet within the same workbook?

To open a workbook after you start Excel, you can use the Open Other Workbooks command on the Navigation bar.

Which of the following lets you edit the contents of a cell?

To print worksheet contents across the length of a page, you can use portrait orientation.

You need to add another product to your inventory worksheet, which shows product names in row A. Which of the following should you add?

You receive a worksheet in which the rows are numbered 1, 2, 3, 5,6. This means that row 4 is _____.

Why is it necessary to use care when inserting worksheet cells?

To enter a range of text based on examples that are already in your worksheet, which of the following can you use?

Where do you rename a workbook and adjust its save location?

In formulas, calculations in square brackets are calculated first.

Your worksheet is too wide to fit on one portrait page. What is the best way to fix this problem?

Which of the following can you use to insert a formula using a function?

To format text so that it automatically appears in multiple lines within a cell, you can transpose it.

When should you use relative cell references?

Which of the following will you select as X in the following series of clicks to copy a chart from Excel to Word so that it is no longer linked to Excel: In Excel: Chart > Home tab > Clipboard group > Copy button > In Word: location to paste chart > Home tab > Clipboard

Carol wants to unhide a workbook window she had hidden earlier. Which of these series of clicks can she press to do so?

A student is given the task of counting the number of nonblank cells in the range of cells B1 to B20. Which of the following formulas should he use to do so?

Which of the following formulas totals the cells B6, B7, B8, B9, and B10 most efficiently?

Formatting Workbook Text and Data

Performing Calculations With Formulas and Functions

Analyzing and Charting Financial Data

Generating Reports From Multiple Worksheets and Workbooks

Managing Data With Data Tools

Summarizing Data With Pivottables

Performing What-If Analyses

Exploring Financial Tools and Functions

Analyzing Data With Business Intelligence Tools

Exploring Pivottable Design

Developing an Excel Application

Customizing Your Workspace Text and Graphics

Customizing Your Workspace Text and Graphics

Customizing Your Workspace Text and Graphics

Filters

Exam 1: Getting Started With Excel

Which of the following is the temporary Windows storage area that holds selections you copy or cut?

Which of the following methods copies an existing worksheet within the same workbook?

To open a workbook after you start Excel, you can use the Open Other Workbooks command on the Navigation bar.

Which of the following lets you edit the contents of a cell?

To print worksheet contents across the length of a page, you can use portrait orientation.

You need to add another product to your inventory worksheet, which shows product names in row A. Which of the following should you add?

You receive a worksheet in which the rows are numbered 1, 2, 3, 5,6. This means that row 4 is _____.

Why is it necessary to use care when inserting worksheet cells?

To enter a range of text based on examples that are already in your worksheet, which of the following can you use?

Where do you rename a workbook and adjust its save location?

In formulas, calculations in square brackets are calculated first.

Your worksheet is too wide to fit on one portrait page. What is the best way to fix this problem?

Which of the following can you use to insert a formula using a function?

To format text so that it automatically appears in multiple lines within a cell, you can transpose it.

When should you use relative cell references?

Which of the following will you select as X in the following series of clicks to copy a chart from Excel to Word so that it is no longer linked to Excel: In Excel: Chart > Home tab > Clipboard group > Copy button > In Word: location to paste chart > Home tab > Clipboard

Carol wants to unhide a workbook window she had hidden earlier. Which of these series of clicks can she press to do so?

A student is given the task of counting the number of nonblank cells in the range of cells B1 to B20. Which of the following formulas should he use to do so?

Which of the following formulas totals the cells B6, B7, B8, B9, and B10 most efficiently?

Formatting Workbook Text and Data

Performing Calculations With Formulas and Functions

Analyzing and Charting Financial Data

Generating Reports From Multiple Worksheets and Workbooks

Managing Data With Data Tools

Summarizing Data With Pivottables

Performing What-If Analyses

Exploring Financial Tools and Functions

Analyzing Data With Business Intelligence Tools

Exploring Pivottable Design

Developing an Excel Application

Customizing Your Workspace Text and Graphics

Customizing Your Workspace Text and Graphics

Customizing Your Workspace Text and Graphics

Filters