LinkedIn

Lakukan tugas rumah & ujian kamu dengan baik sekarang menggunakan Quizwiz!

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


Set pelajaran terkait

Part ll: Body Tissues and Section 3.4 Epithelial Tissue

View Set

US History Regents Vocab: Buying on Margin - Civilian Conservation Corps

View Set

Fl Insurance Agent Licensing Exam

View Set

PC Exam 5 NCLEX-RN & Success Questions

View Set

Culture and Diversity Psy Quiz 4

View Set