Question
click below
click below
Question
Normal Size Small Size show me how
Excels Lessons 2 & 3
Question | Answer |
---|---|
What is the process of using the mouse to move or copy cells called? | Drag and Drop |
Alicia needs to delete the data in cell B5. which command would she select? | Clear |
Jon wants to print only the Inventory worksheet that he is currently working on in his workbook. Which option should he choose? | Print Active Sheet |
Which Microsoft excel feature automatically inserts data into a cell that begins with the same character as a previous entry? | Auto complete |
Jennifer needs to identify the values in column B fora a sales report. Which type of entry should she us in the column header? | Labels |
What is the name of the list of frequently used excel commands available when a user right-clicks an item in a worksheet? | Shortcut menu |
Sharon's spreadsheet contains information about the number of music downloads in F1:F25. F1:F25 represents a: | range |
which term refers to a group of cells that may be formatted, moved, copied, or deleted as a group? | range |
When entering data into a cell, which keyboard key is used to remove characters to the left of the insertion point? | Backspace key |
Which command on the Fill options dialog box is the default option if you enter a month or day? | Fill series |
Alicia need to move the data in cell B5 to cell E5. Which command would she select? | Cut |
David wants to key the numbers 1 to 1,000 in column A of his spreadsheet. What command should he use to complete this task? | autofill |
In an Microsoft Excel worksheet, how you change the width of a column so that the widest entry will fit? | Autofit |
To help organize and identify Microsoft files by providing details about the files, which of the following would you use? | Document properties |
In Microsoft excel worksheet, which feature makes an exact replica of the cell data and format while keeping the original cell intact? | copy |
Joan is creating a table that will include demographic information about her employees. Which header in her table considered? | Label |
Joyce has updated the data in an existing spreadsheet. Which command would she select to preserve data for future use? | save |
Jennifer needs to identify the values in column B for a statistics report. Which type of entry should she use in the column header? | Labels |
Which command on the home ribbon allows data to be moved from one worksheet location to another? | Cut |
What is the name of the small black square in the lower right corner of the heavy border of an active cell that repeats a cell's value in the adjacent cells? | Fill handle |
Ji would like to print only the worksheet he is currently working on. what print option should he choose? | print active sheet |
which command enables a user to save an existing worksheet with a new name or save the worksheet in a new location? | save as |
John's workbooks includes 3 worksheets. Which option should he choose to print them? | Print entire workbook |
Which is a special workbook a user and the use as a pattern to create new similar workbooks or worksheets? | template |
What are contains the command used to customize the print options in Microsoft excel? | file tab |