Upgrade to remove ads
Excel Lesson 1 & 2
Terms in this set (40)
What occurs when the cursor is moved over a cell and a user clicks?
A. the row is selected
B. the cell is selected
C. The column is selected
D. the worksheet is selected
The cell is selected
Which view is the default view used in Microsoft Excel?
A. Page Layout
John wants to be able to view multiple areas of his spreadsheet at the same time. What would be his best option?
A. Freeze Panes
Which of the following notebook-like features organizes the sheets for use in Excel?
Which ribbon option opens a related dialog box?
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?
A. Magnify area
B. enlarge selected area
C. amplify range
d. zoom to selection
Zoom to Selection
Joan has a table that includes demographic information about her employees. What does all the information about one employee represent?
Joyce needs to access an spreadsheet she saved yesterday. Which command would she select?
D. Save as
Which group on the view ribbon enables a user to show or hide the ruler, gridlines, formula bar or headings?
A. Workbook Views
Which Microsoft Office object would you use for quick, convenient, one-click access to frequently used Excel commands?
A. Quick ACcess Toolbar
B. Title bar
C. status bar
D. formula bar
Quick access toolbar
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?
C. ctrl+up arrow
D. Ctrl+ 1
Which tab do you use to display the area that contains the print command?
B. Page layout
Which area, on the left of the formula bar, can you look at to determine the cell address of a selected cell?
A. Cell box
B. Address box
C. Name box
D. Formula box
What command will arrange microsoft excel windows so that they appear side by side on the screen?
A. zoom to selection
B. new window
C. arrange all
d. freeze panes
Which of the following would you use to enter, calculate, manipulate, and analyze data such as numbers and text in excel?
Which view enables a user to create or modify a worksheet while seeing how it will look in printed format?
A. Page layout
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?
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 keys?
A. Quick access toolbar
B. hot keys
C. mini toolbar
Sharon's spreadsheet contains information about the number of music downloads in F25. "25" identifies the:
Which of the follwing software programs is a powerful spreadsheet program that allows users to organize data, complete calculations and graph data?
Which command do you use to close an open file and completely exit the Microsoft excel program?
b. save as
David wants to key the numbers 1-1000 in Column A of his spreadsheet. What command should he use to complete this task?
C. FInd and replace
Jennifer needs to identify the values in column B for a statistics report. Which type of entry should she use in the column header?
Joan is creating a table that will include demographic information about her employees. What is each header in her table considered?
What is the process of using the mouse to move or copy cells called?
a. click and paste
b. drag and move
d. drag and drop
drag and drop
In a Microsoft Excel worksheet, how do you change the width of a column so that the widest entry will fit?
A. Smart fit
C. Best fit
D. true fit
John wants to print only the Inventory worksheet that he is currently working on in his workbook. which option should he choose?
A. Print selectoin
B. print active sheet
C. Print entire workbook
D. Fit Sheet on one page
B. Print active sheet
Which microsoft excel feature automatically inserts data into a cell that begins with the same characters as a previous entry?
To help organize and identify Microsoft Excel files by providing details about the files, which of the following would you use?
a. file details
b. document properties
c. file facts
d. document options
alicia needs to move the data in cell b5 to cell e5. which command would she select?
d. format printer
Alicia needs to delete the data in cell b5. WHich command would she select?
D. format painter
When entering data into a cell, which keyboard key is used to remove characters from the left of the insertion point?
A. delete key
C. left arrow key
D. enter key
In Microsoft Excel, which feature makes an exact replica of the cell data and format while keeping the original cell intact?
Sharon's spreadsheet contains information about the number of music downloads in F1:F25. F1:F25 represents a:
What is the name of the list of frequently used excel commands available when a user right-clicks an item in the worksheet?
A. mini toolbar
B. QUick access toolbar
C. SHortcut menu
D. shortcut toolbar
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?
A. Fill handle
C. copy handle
D. copy box
Joyce has updated the data in an existing spreadsheet. WHich command would she select to preserve the data for future use?
d. save as
Which command on the fill options dialog box is the default option if you enter a month or day?
a. copy cells
b. fill formatting only
c. fill without formatting
d fill series
Which command on the "home ribbon" allows data to be moved from one worksheet location to another?
Wich term refers to a group of selected cells that may be formatted, moved, copied or deleted as a group?
This set is often in folders with...
Excel Lesson 1 Part 2
Excel Lesson 1
Excel Lesson 1
Lesson 1 Excel and Access
You might also like...
Excel Unit 1-2 Test Practice Qs
Microsoft Excel Unit 1-3
Excel Lesson 2 & 3
Other sets by this creator
Mi novio ideal 2
Other Quizlet sets
PSYC 101: Chapter 1- History
Brainstem pathways and lesions--Baugh
Bio 220 - CH 4 - Connective Tissue (Unit 1)
PSC CHAPTERS 1/2 EXAM STUDY