Microsoft Excel | Unit 1-2 Test Study Guide

¡Supera tus tareas y exámenes ahora con Quizwiz!

Clear

Alicia needs to delete the data in cell B5. Which command would she select?

Cut

Alicia needs to move the data in cell B5 to cell E5. Which command would she select?

AutoFill

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?

Copy

In Microsoft Excel, which feature makes an exact replica of the cell data and format while keeping the original cell intact?

Auto Fit

In an Microsoft Excel worksheet, how do you change the width of a column so that the widest entry will fit?

Labels

Jennifer needs to identify the values in column B for a sales report. Which type of entry should she use in the column header?

Labels

Jennifer needs to identify the values in column B for a statistics report. Which type of entry should she use in the column header?

Row

Joan has a table that includes demographic information about her employees. What does all the information about one employee represent?

Entry

Joan has entered her name in the First Name field in cell B2 of her table. What does her First Name represent in the table?

Label

Joan is creating a table that will include demographic information about her employees. What is each header in her table considered?

Ctrl + End

Joan wants to add a new entry at the bottom of her spreadsheet. What is the shortcut that will take her to the last record on her spreadsheet?

Split

John wants to be able to view multiple areas of his spreadsheet at the same time. What would be his best option?

Print Active Sheet

John wants to print only the Inventory worksheet that he is currently working on in his workbook. Which option should he choose?

Save

Joyce has updated the data in an existing spreadsheet. Which command would she select to preserve the data for future use?

Open

Joyce needs to access a spreadsheet she saved yesterday. Which command would she select?

Range

Sharon's spreadsheet contains information about the number of music downloads in F1:F25. F1:F25 represents a...

Row

Sharon's spreadsheet contains information about the number of music downloads in F25. "25" identifies the:

Document properties

To help organize and identify Microsoft Excel files by providing details about the files, which of the following would you use?

Zoom to Selection

What command do you use to increase or decrease the view of a selected cell or range of cells to fill the Excel Window area for better visibility?

Arrange All

What command will arrange Microsoft Excel windows so that they appear side by side on the screen?

Key Tips

What feature was created for users who prefer to use the keyboard rather than the mouse, and provides keyboard code icons that may be used in conjunction with the ALT key?

Shortcut Menu

What is the name of the list of frequently used Excel commands available when a user right-clicks an item in the worksheet?

Fill handle

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 adjacent cells?

Drag and drop

What is the process of using the mouse to move or copy cells called?

The cell is selected

What occurs when the cursor is moved over a cell and a user clicks?

Backspace key

When entering data into a cell, which keyboard key is used to remove characters to the left of the insertion point?

AutoComplete

Which Microsoft Excel feature automatically inserts data into a cell that begins with the same characters as a previous entry?

Quick Access Toolbar

Which Microsoft Office object would you use for quick, convenient, one-click access to frequently used Excel commands?

Name box

Which area, on the left side of the formula bar, can you look at to determine the cell address of a selected cell?

Exit

Which command do you use to close an open file and completely exit the Microsoft Excel program?

Fill Series

Which command on the Fill options dialog box is the default option if you enter a month or day?

Cut

Which command on the Home ribbon allows data to be moved from one worksheet location to another?

Show

Which group on the View Ribbon enables a user to show or hide the ruler, gridlines, Formula Bar, or headings?

Workbook

Which of the following notebook- like features organizes the sheets for use in Excel?

Excel 2010

Which of the following software programs is a powerful spreadsheet program that allows users to organize data, complete calculations, and graph data?

Worksheet

Which of the following would you use to enter, calculate, manipulate, and analyze data such as numbers and text in Excel?

Launcher

Which ribbon option opens a related dialog box?

File

Which tab do you use to display the area that contains the print command?

Range

Which term refers to a group of selected cells that may be formatted, moved, copied or deleted as a group?

Page Layout

Which view enables a user to create or modify a worksheet while seeing how it will look in printed format?

Normal

Which view is the default view used in Microsoft Excel?


Conjuntos de estudio relacionados

EXERCISE 17.2: Relative Ages in Cross-Cutting Situations

View Set

Art Appreciation Chapter 13: Architecture

View Set

US History Civil Rights Movement Quiz

View Set

Chapter 28 Questions - Child, Older Adult, and Intimate Partner Violence

View Set

Reading Development: Comprehension

View Set

Ch. 5 Short Term & Working Memory

View Set