CISC 1050 chapter 9

If you use the comma button in the "Numbers" group of the ribbon, you can quickly apply the __________________ comma style. Currency Comma [0] 1000 Separator

1000 Separator

Matt opens Microsoft Excel and sees the "backstage view." What should he click on to create a new Excel workbook? Welcome to Excel Calendar insights Blank workbook

Blank workbook

The ________________ group of the ribbon has a simple dropdown for changing the format of cells. Cells Styles Comma

Cells

What is NOT a way to rename a worksheet in Excel? Double click the sheet tab and type the new name. Then, click enter to apply the name change. Right-click the sheet tab and select 'Rename'. Type the new name. Then, click enter to apply the name change. Ensure the sheet whose name you wish to change is currently open. On the Home tab, click on 'Format' and choose 'Rename Sheet' and then rename the sheet. Click the File tab, then click on 'Save As,' then type the new worksheet name, and lastly click 'Save' to rename the worksheet.

Click the File tab, then click on 'Save As,' then type the new worksheet name, and lastly click 'Save' to rename the worksheet.

Liam is entering data into a four-column table in Excel. He realizes he needs to insert a new column in between the current column 3 and 4. Which column should he click on to insert a new blank column in the correct location? Column 3 Any column Column 4

Column 4

___________________ is the keyboard shortcut to create a new workbook in Excel. Windows + N Alt + N Ctrl + N

Ctrl + N

Which tab that exists in Excel does not exist in Word? Page Layout Data Review Help

Data

Sarah has entered data into five different columns in an Excel spreadsheet, but realizes she cannot read all the information in the third column. What should she do to automatically resize this column only? Click on the right boundary of the third cell and drag it to a set pixel size Select all the columns and use the "Format" button in the "Cell" group of the ribbon Double click on the right boundary of the third cell

Double click on the right boundary of the third cell

Sally has a list of numbers she needs to organize in a table in a column. After she types her first number into cell A1, what button should she hit to proceed to the next cell in the column? Enter Backspace Tab

Enter

When entering data in a column, you should use the _________________button to proceed to the next cell Shift Enter Tab

Enter

Clicking which button will let you move from the current cell down to the cell below it? Alt Tab Backspace Enter/Return

Enter/Return

Sara has Microsoft Excel open and is looking over a table of data for her Computer Apps course. She wants to create a new workbook to begin her homework assignment. How can she do this? Insert>New Page File>Open File>New

File>New

Marissa has to enter date information into Excel and wants the full date, including day of the week, to display. As she types she notices that only the numerical month/day/year is showing. What does she need to do? Apply a cell style Change the comma style Format the cells

Format the cells

Sally is entering fraction data into an Excel worksheet. What should she do before she begins typing her data into the worksheet? Change the comma style Apply a cell style Format the cells

Format the cells

Sally has transferred a hand-written mailing list into Excel to be formatted as a table. She has already labeled the first cell of her three columns "Last Name," "First Name," and "Address." When she formats her cells into a table, what will these labels represent? Cell style Header Table style

Header

The __________________ button in the "Cells" group of the ribbon has a simple dropdown for adding a blank row into an existing table in a worksheet. Insert Format Delete

Insert

Mike is entering data into a four-column table in Excel. After he enters all the data, he realizes he wants to move column 2 to be the rightmost column. What should he do? Copy column 2, paste it in the new position, and then delete the original column 2. Delete column 2 and retype the data into a new column. Move column 2

Move column 2

Which group of the ribbon has a simple dropdown for changing the format of cells? Comma Styles Numbers

Numbers

The "Row Height" option in the "Format Cells" menu will allow you: autofit the height of a row to the text in the cells apply the default height to Excel rows specify a standard pixel height for multiple rows at once

specify a standard pixel height for multiple rows at once

The _______________ shortcut to add a new worksheet can be found at the bottom of the active workbook. "+" "Insert" Menu > "Sheet" "Insert" tab

"+"

Matt opens an Excel workbook and wants to add an additional worksheet. Which method below will add a new blank worksheet with the fewest number of clicks? "Insert" button> "Insert Sheet" option "+" Add Worksheet shortcut "Insert" tab, "Add worksheet"

"+" Add Worksheet shortcut

Sara has moved her Excel workbook partially out of the view of her computer screen and cannot see the bottom of the workbook now. If she wishes to add another worksheet to the current workbook without moving the file, what should she select? "Insert" button> "Insert Sheet" option "+" Add Worksheet shortcut "Insert" tab, "Add worksheet"

"Insert" button> "Insert Sheet" option

Cell A1 in an Excel worksheet contains 1000000. Which one of the following cell formats should we apply to cell A1 to make it look like $ 1,000,000.00? Accounting format Date format Percentage format Text format

Accounting format

Mike has entered inventory data into Excel, but he is not sure that it is all up to date. If he wishes to quickly note which cells need to be verified, what is the easiest way to do this? Format the information as a table Apply headers to the table Apply a cell style

Apply a cell style

Michelle is entering data into Excel and she wants a comma to appear any time her number is at least four digits long, but she does not want any decimal points. Which comma style should she use? The 'Currency' comma style Apply the 'Comma [0]' comma style Apply the 'Comma' comma style

Apply the 'Comma [0]' comma style

Teresa has entered the dollar values of recent large sales into Excel. She wants to make all the cells include a dollar sign and two decimal points. What should she do? Apply the 'Comma [0]' comma style Apply the 'Comma' comma style Apply the 'Currency' comma style

Apply the 'Currency' comma style

Rachel has entered data into five different columns in an Excel spreadsheet, but realizes she cannot read all the information in the third column. She wants her columns to have a uniform appearance. What should she do? Double click on the right boundary of the third cell Click on the right boundary of the third cell and drag it to a set pixel size Select all the columns and use the "Format" button in the "Cell" group of the ribbon

Select all the columns and use the "Format" button in the "Cell" group of the ribbon

In order to format a series of rows and columns as a table, you should use the "Format as a Table" button in the ___________________ group of the ribbon. Table Styles Cells

Styles

In order to quickly indicate some cells are "good", you should use the Cell Styles button in the ______________ group of the ribbon. Styles Table Cells

Styles

Mike has a list of data he needs to place into a row in an Excel worksheet. After entering information into cell A1, what button will move his cursor into cell B1? Backspace Enter Tab

Tab

If you wish to quickly apply a color scheme to an entire set of rows and columns in Excel, you should apply a _______________ style Table Cell Comma

Table

Sarah wishes to give an Excel table a professional look and feel. The easiest way to do this is to apply what? Cell style Header Table style

Table style

Richard is reviewing an Excel table of sales data and notices that a few cells are shaded a grey color. What does this likely indicate? These cells are important and should be discussed in his next staff meeting. These cells have the highest sales data in them. The information in these cells needs to be verified.

The information in these cells needs to be verified.

What is the main purpose of using Excel? To create flyers, papers, and letters To create presentations and slide shows To create spreadsheets and charts To store, manipulate, and display data

To create spreadsheets and charts