Question 1

Which of the following tabs lets you see exactly how your worksheet looks before printing?

Accepted Answer

A)  Insert 
B)  View 
C)  Formulas 
D)  File 
A)  Insert 
B)  View 
C)  Formulas 
D)  File

Question 2

For which of the following would you use the Paste list arrow on the Ribbon when pasting a copied cell?

Accepted Answer

A)  To erase the cell value from the clipboard. 
B)  To paste the value's number formatting only. 
C)  To paste all items on the clipboard. 
D)  To compute the results of a function. 
A)  To erase the cell value from the clipboard. 
B)  To paste the value's number formatting only. 
C)  To paste all items on the clipboard. 
D)  To compute the results of a function.

Question 3

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 4

Changing a worksheet window to Normal view changes the contents of the worksheet.

Accepted Answer

A) True 
 B)False

Question 5

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 6

Which of the following is not a way to move cell contents?

Accepted Answer

A)  the Cut and Paste buttons on the Home tab 
B)  the fill handle in the lower-right corner of an active cell or range 
C)  the CTRL key + the Move pointer 
D)  drag-and-drop 
A)  the Cut and Paste buttons on the Home tab 
B)  the fill handle in the lower-right corner of an active cell or range 
C)  the CTRL key + the Move pointer 
D)  drag-and-drop

Question 7

Which of the following is true about moving cell contents?

Accepted Answer

A)  You can move cells using the Copy command. 
B)  You cannot move cells from one worksheet to another. 
C)  When you move cell contents,they remain in their original location. 
D)  You can move cells using the drag-and-drop feature. 
A)  You can move cells using the Copy command. 
B)  You cannot move cells from one worksheet to another. 
C)  When you move cell contents,they remain in their original location. 
D)  You can move cells using the drag-and-drop feature.

Question 8

Which of the following would you use to create a duplicate of the selected cell when the CTRL key is pressed?

Accepted Answer

A)  Normal pointer 
B)  I-beam pointer 
C)  Move pointer 
D)  Copy pointer 
A)  Normal pointer 
B)  I-beam pointer 
C)  Move pointer 
D)  Copy pointer

Question 9

To save a workbook for the first time,you use the Save As dialog box.

Accepted Answer

A) True 
 B)False

Question 10

Sam wants to count the number of cells between B1 and B20 that contain numbers in them.Which of the following formula should he use to do so?

Accepted Answer

A)  =COUNT(B1:B20) 
B)  =COUNTIF(B1:B20) 
C)  =SUM(B1:B20) 
D)  =CALCULATE(B1:B20) 
A)  =COUNT(B1:B20) 
B)  =COUNTIF(B1:B20) 
C)  =SUM(B1:B20) 
D)  =CALCULATE(B1:B20)

Question 11

Luis wants to unhide and view all rows and columns in a worksheet.Which of the following series of clicks/entries/selections can he use to create a custom view of the worksheet?

Accepted Answer

A)  Worksheet > View tab > Workbook Views group > Custom Views > Close 
B)  Worksheet > View tab > Workbook Views group > Custom Views > Add > Name box (Type a name )> OK 
C)  Worksheet > View tab > Workbook Views group > Custom Views > Add > Name box (Type a name )> Include in view (Tick check box- Hidden rows,columns and filter settings )> OK 
D)  Worksheet > View tab > Workbook Views group > Custom Views > Add > Name box (Type a name )> Include in view (select check box- Print settings )> OK 
A)  Worksheet > View tab > Workbook Views group > Custom Views > Close 
B)  Worksheet > View tab > Workbook Views group > Custom Views > Add > Name box (Type a name )> OK 
C)  Worksheet > View tab > Workbook Views group > Custom Views > Add > Name box (Type a name )> Include in view (Tick check box- Hidden rows,columns and filter settings )> OK 
D)  Worksheet > View tab > Workbook Views group > Custom Views > Add > Name box (Type a name )> Include in view (select check box- Print settings )> OK

Question 12

The default worksheet text is _____-point Calibri.

Accepted Answer

A)  10 
B)  11 
C)  12 
D)  14 
A)  10 
B)  11 
C)  12 
D)  14

Question 13

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)

Which of the following tabs lets you see exactly how your worksheet looks before printing?

For which of the following would you use the Paste list arrow on the Ribbon when pasting a copied cell?

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

Changing a worksheet window to Normal view changes the contents of the worksheet.

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

Which of the following is not a way to move cell contents?

Which of the following is true about moving cell contents?

Which of the following would you use to create a duplicate of the selected cell when the CTRL key is pressed?

To save a workbook for the first time,you use the Save As dialog box.

Sam wants to count the number of cells between B1 and B20 that contain numbers in them.Which of the following formula should he use to do so?

Luis wants to unhide and view all rows and columns in a worksheet.Which of the following series of clicks/entries/selections can he use to create a custom view of the worksheet?

The default worksheet text is _____-point Calibri.

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?

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

Which of the following tabs lets you see exactly how your worksheet looks before printing?

For which of the following would you use the Paste list arrow on the Ribbon when pasting a copied cell?

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

Changing a worksheet window to Normal view changes the contents of the worksheet.

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

Which of the following is not a way to move cell contents?

Which of the following is true about moving cell contents?

Which of the following would you use to create a duplicate of the selected cell when the CTRL key is pressed?

To save a workbook for the first time,you use the Save As dialog box.

Sam wants to count the number of cells between B1 and B20 that contain numbers in them.Which of the following formula should he use to do so?

Luis wants to unhide and view all rows and columns in a worksheet.Which of the following series of clicks/entries/selections can he use to create a custom view of the worksheet?

The default worksheet text is _____-point Calibri.

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?

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