In excel, what do most formulas begin with?
A. : B. * C. = - ANSWER D. (
In this worksheet, cell E5 contains the formula =$A$5. If you drag cell E5 down to E6, what appears in cell E6?
A. A6 B. 9. -ANSWER C. $A$5 D. =A5
Which chart type provides the best visual display of relationship between two numerical variables?
A. Box and whisker chart B. Radar chart C. Combo chart D. XY SCATTER CHART
You want to be able to restrict values in allowed in a cell and need to create a drop-down list of values from which users can choose. Which feature should you use?
A. Conditional Formating B. Protect worksheet C. Allow users to edit ranges D. DATA VALIDATION
You select cell A1, hover the pointer over the cell border to reveal the move icon, then drag the cell to a new location. Which ribbon commands achieve the same result?
A. Copy and transpose B. Cut and fill C. Copy and paste D. CUT AND PASTE
Which excel feature allows you to hide rows or columns with an easily visible expand / collapse?
A. Cut and paste B. GROUPING C. Filtering D. Hiding
The file extension of .xlsm indicate what type of workbook?
A. Excel 2003 workbook B. XML - standard workbook C. MACRO-EMABLED WORKBOOK D. Workbook where macros are not allowed
What excel feature can you use to automatically format cells that are greater than a specified value with designated fill and text colors?
A. Flash fill B. Theme colors C. Format as table D. CONDITONAL FORMATING
To insert a new column to the left of a specific column, right click on the header containing the column's letter and select___
A. INSERT B. Insert Column C. Paste Special D. Insert Column Left
You want to restrict the values entered in a cell to a specific set, such as hop, skip, jump. Which type of data validation should you use?
A. LIST B. Data base C. Custom D. Input range
Column A contains a list of book titles. To insure that no book title appears more than once, first you select column A. What should you do next?
A. On data ribbon, click data validation B. On home ribbon, click clear > duplicates C. Right click column head and select unique D. ON DATA RIBBON, CLICK REMOVE DUPLICATES
A colleague shared an excel file with you, and you want to display a worksheet that is hidden in it. How do you do that?
A. On home tab, click unhide B. On review tab, click unhide sheet C. On view tab, click new window D. RIGHT CLICK ANY WORKSHEET TAB AND SELECT UNHIDE
Given the image below, what happens if you type "P" in the cell A6
A. The word "Perez" appears and immediately active cell moves down B. A pop-up list appears with the previous four names C. The letter "P" appears D. THE WORD "Perez" APPEARS AND THE ACTIVE CELL REMAINS IN THE EDIT MODE
What is the default horizontal alignment of text in a cell?
A. Top B. LEFT C. Right D. Bottom
Which chart type can display two different data series as different series types within the same chart?
A. XY chart B. Clustered column C. COMBO CHART D. Bubble chart
