Which Chart Tools Ribbon tab allows a user to select from a gallery of chart styles?
What is Design?
100
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?
What is Ctrl + End?
100
Which ribbon contains the command to apply a theme to a worksheet in Microsoft Excel? (NCCTE.9_12.BE.BM20.1.01)
What is Page Layout?
100
What area contains the command used to print a worksheet in Microsoft Excel? (NCCTE.9_12.BE.BM20.1.01)
What is File Tab
100
Jennifer needs to identify the values in column B for a sales report. Which type of entry should she use in the column header? (NCCTE.9_12.BE.BM20.1.02)
What is Labels?
200
Which of the following software programs is a powerful spreadsheet program that allows users to organize data, complete calculations, and graph data?
What is Excel 2010?
200
How is a cell reference in a formula and its corresponding location in a worksheet identified? (NCCTE.9_12.BE.BM20.1.01)
What is Cell reference and cell location are outlined in matching colors?
200
Which is a special workbook a user can create and then use as a pattern to create new, similar workbooks or worksheets? (NCCTE.9_12.BE.BM20.1.01)
What is Template?
200
Joan is creating a table that will include demographic information about her employees. What is each header in her table considered? (NCCTE.9_12.BE.BM20.1.02)
What is label
300
Which tab in the PivotChart Tools Ribbon allows a user to apply a chart style to the PivotChart?
What is Design?
300
Which of the following would you use to enter, calculate, manipulate, and analyze data such as numbers and text in Excel?
What is Worksheet?
300
John has highlighted the data he would like to print. Which print option should he choose? (NCCTE.9_12.BE.BM20.1.01)
What is Print Selection?
300
What command do you use to insert information into a worksheet that will display at the top and bottom edges of the printed page? (NCCTE.9_12.BE.BM20.1.01)
What is Header And Footer?
300
Joan has a table that includes demographic information about her employees. What does all the information about one employee represent? (NCCTE.9_12.BE.BM20.1.02)
What is Row?
400
Which tab in the PivotChart Tools Ribbon allows a user to apply chart titles to the PivotChart?
What is Layout?
400
Which Microsoft Office object would you use for quick, convenient, one-click access to frequently used Excel commands?
What is Quick Access Toolbar?
400
John's workbooks includes 3 worksheets. Which option should he choose to print them? (NCCTE.9_12.BE.BM20.1.01)
What is Print Entire Workbook
400
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? (NCCTE.9_12.BE.BM20.1.02)
What is AutoFill?
400
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? (NCCTE.9_12.BE.BM20.1.02)
What is Entry?
500
Joyce needs to access a spreadsheet she saved yesterday. Which command would she select?
What is Open?
500
What occurs when the cursor is moved over a cell and a user clicks?
What is The cell is selected?
500
Which command enables a user to save an existing worksheet with a new name or save the worksheet in a new location? (NCCTE.9_12.BE.BM20.1.01)
What is Save As?
500
Jennifer needs to identify the values in column B for a statistics report. Which type of entry should she use in the column header? (NCCTE.9_12.BE.BM20.1.02)
What is Labels?
500
In Microsoft Excel, which feature makes an exact replica of the cell data and format while keeping the original cell intact? (NCCTE.9_12.BE.BM20.1.02)