Study sets, textbooks, questions
Upgrade to remove ads
Terms in this set (106)
Lisa has added WordArt to her spreadsheet Which tab is now available for her to edit the WordArt?
Which command on the Insert Ribbon enables a user to insert a picture of a part of a screen Into a worksheet?
Ken has inserted a picture Into his spreadsheet that was taken with a low-quality camera. Which tool would allow him to sharpen the image?
Which notebook like feature organizes the sheets for use in excel?
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?
Joanne has entered her name in the first name field in Selby two of her table. What is her first name represent in the table?
What command will arrange Microsoft excel windows so that they appear side-by-side on the screen?
Joyce needs to access the spreadsheet she saved yesterday, which command which is select?
Which area on the left side of the formula bar indicates the cell address of a selected cell?
Joan wants to add a new entry at the bottom of her spreadsheet. What is the shortcut I will take her to the last record on her spreadsheet?
Control + end
Which group on the view ribbon and able to use her to show or hide the ruler, grid lines, formula bar, or headings?
which tab is used to display the area that contains the print command?
which view enables a user to create or modify a worksheet was seeing how it will look in printed format?
what occurs when the cursor is moved over a cell and a user clicks?
The cell is selected
What command do you use to increase or decrease the view of a selected sell or range of cells to fill the Excel window area for better visibility?
zoom to selection
which view is the default view used in Microsoft excel?
Which view is the default view use in Microsoft excel?
Sharon's spreadsheet contains information about the number of music downloads in F 25. In this address, 25 identifies the
John wants to be able to view multiple areas of his spreadsheet at the same time. What would be his best option?
which software program is a powerful spreadsheet program that allows users to organize data, complete calculations, and graph data?
which of the following would you use to enter, calculate, manipulate, and analyze data such as numbers and text in Excel?
which command among the window control buttons is used to close and open file and completely exit the Microsoft excel program?
Which ribbon option open the related dialog box?
Which Microsoft office object would you use for Quik, convenient, one quick access to frequently used Excel commands?
quick access toolbar
Joanne has a table that includes demographic information about her employees. If the demographic information is listed across the top and employee names down the left side of the table, what does all the information about one employee represent?
What is the name of the list of frequently used Excel commands available when a user right clicks an item in the worksheet?
Joyce has updated the data in an existing spreadsheet. Which command would you still like to preserve the data for future use?
In Microsoft Excel, which feature makes an exact replica of the cell data and format while keeping the original cell intact?
David wants to keep the numbers 1 to 1000 in column A of his spreadsheet. What command would he use to complete this task?
Which command on the home ribbon allows data to be moved from one worksheet location to another?
Alicia needs to delete the data and sell B5. Which command would she select?
What is the name of the small black square in the lower right corner of the heavy border of an active so that repeats a sales value in adjacent cells?
John 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 term refers to a group of selected cells that may be formatted, moved, copied or deleted as a group?
In a Microsoft XL worksheet, how do you change the width of a column so that the
when entering data into a cell, which keyboard key is used to remove characters to the left of the insertion point?
Sharon spread sheet contains information about the number of music downloads in F1 through F 25. F1 through F 25 represents a
Which command on the Phil options dialog box is the default option if a month or day is entered?
Jennifer needs to identify the values in column B for a statistics report. Which type of entry should she use in the column header?
Joanne is creating a table that will include demographic information about her employees. What is each had her in her table considered?
Which would be used to help organize and identify Microsoft excel files by providing details about the files
What is the process of using the mouse to move or copy cells called?
drag and drop
Which Microsoft excel feature automatically inserts data into a cell that begins with the same characters as a previous injury?
Alicia needs to move the data in cell B five to sell the five. Which command what she select?
What area contains the command used to customize the print options in Microsoft excel?
which command enables the user to save an existing worksheet with a new name or save the worksheet in a new location?
What is a special workbook our user can create and then use as a pattern to create new, similar workbooks or worksheets?
Jim would like to print only the cell range a one through 520. What page set up options should he change
steve would like to print only the worksheet he is currently working on. what print option should he choose?
johns workbook includes 3 worksheets. which option should he choose to print them?
print entire workbook
tyler created a monthly sales workbook that contains the formula =(January!B3). January is an example of a
What type of formula cell reference instructs Microsoft excel to keep the cell reference constant in the formula as it copies it to the destination area?
Carl notices the last two lines of text in cell before or not showing up in his spreadsheet. How could Carl form out the cell to correct this problem?
which command on the home ribbon is used to format row height in column with, organize sheets, and protect or hide cells in a worksheet?
Which set of formatting choices includes a set of colors, fonts, and affects that you can apply to a worksheet to enhance its appearance?
Jack would like to force the data into a spreadsheet to fit on one page one printed. Which option should he select?
which term describes the blank portions of a page that fall outside the main body of the print a document?
Jonah showing her spreadsheet to a customer and does not want the customer to be able to see the wholesale prices column. What option should she choose?
John notices that column D is not showing on his spreadsheet. What action does he need to take to view column D?
John spreadsheet includes multiple pages of records. If John wants to view his headings while scrolling through spreadsheet what should he do
which ribbon contains the command to apply theme to a worksheet in Microsoft excel?
which command group on the page layout ribbon controls the presence of gridlines and headings on a worksheet?
In Microsoft Excel, what is used to emphasize certain injuries and make the worksheet easier to read and understand?
Which command on the page layout ribbon enables the user to mark where a new page will begin on the printed copy?
Jim would like the data in row one of his spreadsheet to repeat on every page of his print out. What page set up option should he change?
what command is used to insert information into a worksheet that will display at the top and bottom edges of the printed page?
header and footer
Which command is used to remove manual page breaks from a worksheet area
select remove page break from the brakes drop down area
Which command on the home ribbon is used to remove cells, Rose, or columns from a worksheet or table?
Jack would like the data in row 10 not to display on his spreadsheet. Which option should he select?
What is a single character, word, or phrase in a cell on a worksheet that is typically used in searches?
John would like to remove a worksheet from his workbook. Which option would he choose?
David wants to change all occurrences of North Carolina to NC in his spreadsheet. What command should he use to complete this task?
Jack would like the data in row one to remain stationary on the screen while he scrolls. Which option should he select?
How would she tabs be moved to a new position in the workbook?
click and drag the sheet tab to the new location
Which command on the home ribbon do you use to replace information in a selected sell. With the new information or new formatting?
find and select
Joanne wants to be able to view row one as well as calm as I was scrolling through her worksheet. Which option should she choose?
How was an exact copy of the worksheet created within the same workbook?
Right click the sheet tab, then choose move or copy from the shortcut menu
Virginia wants to emphasize the sheet tabs in his workbook. Which command should he choose?
Virgil wants to customize the sheet tabs and his workbook with the names June, July, and August. Which command should he choose?
what feature of Microsoft excel keeps a portion of a worksheet visible well the other portions scrolls?
John would like to change the order of the worksheets and his workbook. Which option would you choose?
Virgil needs to transfer a worksheet in the current workbook to a different workbook. Which command should he choose?
Which is a way to qualify data by specifying a matching condition or asking a question of the data?
David only wants to view the employees in the marketing department who earn a salary of more than $25,000. What command should he use to complete this task
Which command on the home ribbon do you use to temporarily hide specific values on a worksheet based on the criteria on?
sort and filter
David wants to arrange the employee salaries in column A of his spreadsheet from lowest to highest. What command should he use to complete this task?
Which ribbon includes the commands to apply a quick table style to a range of cells?
How can a table style be quickly modified to meet user preferences?
right click on style and choose duplicate
Dylan is creating an Excel spreadsheet of student schedules for all FB LA members. He would like to show a summary view of all of the first. Classes. Which teacher would allow him to do this?
Canyon would like to convert the cell range a one through F 22 a medium 19 style. Which formatting style should he still liked?
format as table
Joanne wants to see her sales representatives in numerical order with the sales person who sold the least at the top. Which sorting option should she choose
What is the process of bringing data containing text field separated by commas into Excel called?
juan Has created a spreadsheet that displays sales of her employees. She would like to view any of those employees which sales above $25,000 who are from region three. What option would allow her to do that?
Dylan is creating an Excel spreadsheet of student schedules for all FB LA members. He would like to know how many members are in the same first period class. Which feature would allow him to do this?
Which command on the home ribbon do you use to organize data in ascending or descending order?
sort and filter
What home Ruben group contains the command to use for quickly converting selected cells to a table by choosing a table style?
Cooper is creating a spreadsheet for FB LA and wants to be able to put the spreadsheet in alphabetical order by last name. What should Cooper applied to the spreadsheet?
Jill wants to search her spreadsheet for a value in the first column of her table. What function should she use?
If, and, or and not are all part of which category of functions?
Tom wants to convert all text to lowercase. Which function should he use?
How was the cell reference in a formula in its corresponding location in a worksheet identified?
Cell reference and set location or outlined in matching colors
jennifer is calulating her gpa. if she uses =(a1+a2+a3+a4)/4 This is an example of which type of entry?
what term is used when referencing cells and other sheets in a workbook formula using the sheet name as the reference rather than the cell address?
Gabriel needs to create a formula that does not change when it is copied to cell b two. Which formula should he create?
When copying values in Microsoft excel, which feature automatically adjust so references for the new copy location?
Sandra creating a formula to subtract the values in cells before and C4. Which formula should she use?
Sets with similar terms
Microsoft Excel Unit 1-3
Excel Study Quizlet
Excel Unit 1-2 Test Practice Qs
Other sets by this creator
Other Quizlet sets
LECTURE 14 - BASAL GANGLIA DISORDERS
Careers: Workplace Types and the Economy