Keiser Introduction to Computers CGS1000CG1 Week 2 MC Review Test

Test       Week 2 MC Review Test – Microsoft Excel

•             Question 1          Which of the following highlights and color-codes each cell as you type its address?                                        

                1. Formula Auditing

                2. Range Finder

                3. Evaluate Formula

                4. Select Method

•             Question 2          Which of the following words best describes a Z to A sort?                                          

1. Ascending

                2. Rising

                3. Descending

                4. Sliding

                Question 3          Which of the following commands should you use to lock rows or columns in view so you can position data for easy review?                                  

                1. Zoom options

                2. Merge & Center command

                3. Status bar view buttons

                4. Freeze Panes command

•             Question 4          Which of the following is a single value from within a data series?                            

                1. Gridline

                2. Tick mark

                3. Trendline

                4. Data point

•             Question 5          How should you save a file if you want it to be compatible with older versions of Microsoft Excel?                                               

1. Excel Macro-Enabled Workbook

                2. Excel 97-2003 Workbook

                3. Excel Template

                4. Excel Macro-Enabled Template

•             Question 6          Which of the following is the name used to describe a rectangular group of cells?                                            

1. Columns

                2. Rows

                3. Range

                4. None of the above

•             Question 7          Which of the following displays the contents of a selected cell?                                

                1. Gridlines

                2. Formula bar

                3. Name box

                4. Cell reference

•             Question 8          In Workbook views, which of the following is used to switch workbook views?  

                1. Ribbon

                2. Menu bar

                3. Status bar

                4. Shortcut menu

•             Question 9          Which of the following is a preset combination of colors and effects for a chart, its background, and its elements?                                    

                1. Chart layout

                2. Chart style

                3. Quick Layout

                4. None of the above

•             Question 10        Which of the following is a set of formatting elements that include font style, size, color, alignment, borders, and fill, as well as number formats?                                     

                1. Cell style

                2. Range style

                3. Worksheet style

                4. Format Painter

•             Question 11        Which of the following functions adds cell values together and divides the result by the number of values?                                

                1. MIN

                2. COUNT

                3. MAX

                4. AVERAGE

•             Question 12        In an Excel table, which of the following contains descriptive titles or labels?      

                1. Header row

                2. Record

                3. Field

                4. Table

•             Question 13        Which of the following has a mathematical answer of 11?                                            

1. 2+4*3

                2. (2+4)*3

                3. 3+2*4

                4. (2+3)*4

•             Question 14        Which of the following is selected when you point to and click a column heading?                                            

                1. The entire column

                2. The entire row

                3. The entire worksheet

                4. The 20 cells adjacent to the top of the column

•             Question 15        Which of the following terms refers to the cells that contain values and labels to be graphed in a chart?                                  

                1. Data series

                2. Data point

                3. Source data

                4. Category label

•             Question 16        Which of the following characters precedes Excel functions?                                      

                1.  +

                2.  =

                3.  (

                4.  –

•             Question 17        Once you have saved a workbook for the first time, which of the following keyboard shortcuts can you use to save it again?                                              

                1. Ctrl+F

                2. Ctrl+K

                3. Ctrl+R

                4. Ctrl+S

•             Question 18        Which of the following can be created from a PivotTable?                                           

                1. PivotFormats

                2. PivotFills

                3. PivotFilters

                4. PivotCharts

•             Question 19        Which of the following simplifies the process of entering the months of the year in a worksheet?                                               

1. Fill Handle tool

                2. AutoSum button

                3. Headings option

                4. Freeze Panes option

•             Question 20        Which of the following statements is False about hiding rows?                                  

                1. Hiding a row deletes the data from the row.

                2. Hiding a row does not delete the data from the column.

                3. Hiding a row does not affect the results of calculations.

                4. After hiding a row, you can unhide it.