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