Question 1

To select nonadjacent cells or ranges on a worksheet,you can press and hold _____ while selecting each one.

Accepted Answer

A)  CTRL 
B)  ALT 
C)  SHIFT 
D)  ESC 
A)  CTRL 
B)  ALT 
C)  SHIFT 
D)  ESC

Question 2

Boris wants to remove a workbook window from his workplace.What series of clicks can he use to hide it?

Accepted Answer

A)  View tab > Window group > Hide 
B)  View tab > Window group > Split 
C)  View tab > Window group > View Side by Side 
D)  View tab > Window group > Switch Windows > Select a file 
A)  View tab > Window group > Hide 
B)  View tab > Window group > Split 
C)  View tab > Window group > View Side by Side 
D)  View tab > Window group > Switch Windows > Select a file

Question 3

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 4

To preserve the original version of a workbook so you can make changes to a copy of it,which of the following would you do?

Accepted Answer

A)  Leave the workbook closed. 
B)  Open the workbook,change the first worksheet,and save it using the Save command. 
C)  Open the workbook,make changes,and then save it using the same name. 
D)  Open the workbook,make changes,and then save it using a different name. 
A)  Leave the workbook closed. 
B)  Open the workbook,change the first worksheet,and save it using the Save command. 
C)  Open the workbook,make changes,and then save it using the same name. 
D)  Open the workbook,make changes,and then save it using a different name.

Question 5

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 6

Which of the following is true about changing worksheet column width?

Accepted Answer

A)  In Normal view,the Column Width dialog box lets you set column width to an exact value in inches. 
B)  In Normal view,the Column Width dialog box lets you set the exact number of characters that will fit in the column. 
C)  When you drag the right column border in Normal view,a ScreenTip displays the exact width in inches. 
D)  When you drag the right column border in Page Layout view,a ScreenTip displays the exact width in pixels. 
A)  In Normal view,the Column Width dialog box lets you set column width to an exact value in inches. 
B)  In Normal view,the Column Width dialog box lets you set the exact number of characters that will fit in the column. 
C)  When you drag the right column border in Normal view,a ScreenTip displays the exact width in inches. 
D)  When you drag the right column border in Page Layout view,a ScreenTip displays the exact width in pixels.

Question 7

Which of the following appears in Page Layout view?

Accepted Answer

A)  Text box containing the header 
B)  Margins 
C)  Page number indicator 
D)  Blue dotted lines indicating page breaks 
A)  Text box containing the header 
B)  Margins 
C)  Page number indicator 
D)  Blue dotted lines indicating page breaks

Question 8

Which of the following helps you move around a worksheet that is too large to fit on the screen at once?

Accepted Answer

A)  sheet tabs 
B)  arguments 
C)  scroll bars 
D)  operators 
A)  sheet tabs 
B)  arguments 
C)  scroll bars 
D)  operators

Question 9

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 10

To select a single worksheet cell so you can work with it,which of the following would you do?

Accepted Answer

A)  Click the cell. 
B)  Move the cell pointer over the cell. 
C)  Click the status bar. 
D)  Click the Name box. 
A)  Click the cell. 
B)  Move the cell pointer over the cell. 
C)  Click the status bar. 
D)  Click the Name box.

Question 11

Rukha has created two custom views of a worksheet.In one view,all rows and columns can be seen whereas in the other,specific rows and columns are hidden.What can she do to be able to see the view that she needs to at a given point in time?

Accepted Answer

A)  Click Custom Views and double-click on the display settings she wants to see. 
B)  Under Windows group on the View tab,click on View Side by Side. 
C)  Under Windows group on the View tab,click on Switch Windows and select the View she wants. 
D)  Click Custom View and check the box beside Hidden rows,column and filter settings to see Custom view of all rows and columns shown while uncheck the box to see the Custom view of specific rows and columns hidden. 
A)  Click Custom Views and double-click on the display settings she wants to see. 
B)  Under Windows group on the View tab,click on View Side by Side. 
C)  Under Windows group on the View tab,click on Switch Windows and select the View she wants. 
D)  Click Custom View and check the box beside Hidden rows,column and filter settings to see Custom view of all rows and columns shown while uncheck the box to see the Custom view of specific rows and columns hidden.

Question 12

Myra wants to hide a worksheet to remove it from view.Which of these series of clicks will help her do so?

Accepted Answer

A)  Sheet tab > Window group > Hide 
B)  Sheet tab > Window group > Freeze Panes > Hide 
C)  Sheet tab > Home tab > Cells group > Format > Visibility > Hide & Unhide > Hide Sheet 
D)  Sheet tab > Home tab > Cells group > Format > Visibility > Hide & Unhide > Hide Rows 
A)  Sheet tab > Window group > Hide 
B)  Sheet tab > Window group > Freeze Panes > Hide 
C)  Sheet tab > Home tab > Cells group > Format > Visibility > Hide & Unhide > Hide Sheet 
D)  Sheet tab > Home tab > Cells group > Format > Visibility > Hide & Unhide > Hide Rows

Question 13

In formulas,calculations in square brackets are calculated first.

Accepted Answer

A) True 
 B)False

Question 14

Which of the following inserts a function into a cell?

Accepted Answer

A)  mode indicator 
B)  AutoSum button 
C)  argument 
D)  formula prefix 
A)  mode indicator 
B)  AutoSum button 
C)  argument 
D)  formula prefix

Question 15

In a complex formula,how does Excel determine which calculation to perform first?

Accepted Answer

A)  It calculates the leftmost formulas first. 
B)  It calculates operations outside parentheses first. 
C)  It follows the order of operations. 
D)  It calculates functions first. 
A)  It calculates the leftmost formulas first. 
B)  It calculates operations outside parentheses first. 
C)  It follows the order of operations. 
D)  It calculates functions first.

Question 16

Which of the following options will you select to restrict access to a shared workbook to only co-workers in your company who are logged into Microsoft Office?

Accepted Answer

A) The Specific People B) The People with Existing Access C) The Co-workers in . D) The People in . A) The Specific People B) The People with Existing Access C) The Co-workers in . D) The People in .

Question 17

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 18

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 19

To change the size of text to a particular percentage of the original text size in a Power View report,click on Power View tab > Themes group > Text Size.

Accepted Answer

A) True 
 B)False

Question 20

You can use the I-beam pointer to copy cell contents into adjacent cells.

Accepted Answer

A) True 
 B)False

To select nonadjacent cells or ranges on a worksheet,you can press and hold _____ while selecting each one.

Boris wants to remove a workbook window from his workplace.What series of clicks can he use to hide it?

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

To preserve the original version of a workbook so you can make changes to a copy of it,which of the following would you do?

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

Which of the following is true about changing worksheet column width?

Which of the following appears in Page Layout view?

Which of the following helps you move around a worksheet that is too large to fit on the screen at once?

When should you use relative cell references?

To select a single worksheet cell so you can work with it,which of the following would you do?

Rukha has created two custom views of a worksheet.In one view,all rows and columns can be seen whereas in the other,specific rows and columns are hidden.What can she do to be able to see the view that she needs to at a given point in time?

Myra wants to hide a worksheet to remove it from view.Which of these series of clicks will help her do so?

In formulas,calculations in square brackets are calculated first.

Which of the following inserts a function into a cell?

In a complex formula,how does Excel determine which calculation to perform first?

Which of the following options will you select to restrict access to a shared workbook to only co-workers in your company who are logged into Microsoft Office?

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

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

To change the size of text to a particular percentage of the original text size in a Power View report,click on Power View tab > Themes group > Text Size.

You can use the I-beam pointer to copy cell contents into adjacent cells.

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.(Digital Only).

Introducing Power BI (Digital Only).

Collaborating with Your Team.(Digital Only).

Filters

Exam 1: Getting Started With Excel

To select nonadjacent cells or ranges on a worksheet,you can press and hold _____ while selecting each one.

Boris wants to remove a workbook window from his workplace.What series of clicks can he use to hide it?

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

To preserve the original version of a workbook so you can make changes to a copy of it,which of the following would you do?

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

Which of the following is true about changing worksheet column width?

Which of the following appears in Page Layout view?

Which of the following helps you move around a worksheet that is too large to fit on the screen at once?

When should you use relative cell references?

To select a single worksheet cell so you can work with it,which of the following would you do?

Rukha has created two custom views of a worksheet.In one view,all rows and columns can be seen whereas in the other,specific rows and columns are hidden.What can she do to be able to see the view that she needs to at a given point in time?

Myra wants to hide a worksheet to remove it from view.Which of these series of clicks will help her do so?

In formulas,calculations in square brackets are calculated first.

Which of the following inserts a function into a cell?

In a complex formula,how does Excel determine which calculation to perform first?

Which of the following options will you select to restrict access to a shared workbook to only co-workers in your company who are logged into Microsoft Office?

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

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

To change the size of text to a particular percentage of the original text size in a Power View report,click on Power View tab > Themes group > Text Size.

You can use the I-beam pointer to copy cell contents into adjacent cells.

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.(Digital Only).

Introducing Power BI (Digital Only).

Collaborating with Your Team.(Digital Only).

Filters