Busy. Please wait.
Log in with Clever
or

show password
Forgot Password?

Don't have an account?  Sign up 
Sign up using Clever
or

Username is available taken
show password

Your email address is only used to allow you to reset your password. See our Privacy Policy and Terms of Service.


Already a StudyStack user? Log In

Reset Password
Enter the associated with your account, and we'll email you a link to reset your password.

Excel Module 2 Study Guide

Quiz yourself by thinking what should be in each of the black spaces below before clicking on it to display the answer.
        Help!  

Question
Answer
One of the benefits of Live Preview is that ____   show
🗑
Typeface is the specific design used for characters and includes ____   show
🗑
A ____ is not a type of font   show
🗑
show non-theme  
🗑
Italic, bold, bold italic, and underline are examples of ____   show
🗑
To change the font size one point at a time, in the Font group on the Home tab, click the ____ button.   show
🗑
show four, six, two  
🗑
show custom  
🗑
To add a ____ to a sheet tab, click the Format button, point to Tab color, and then click a color.   show
🗑
Selecting the Font Color button arrow will display ____ and a _______.   show
🗑
The background image does not affect any cell’s ____ or __________.   show
🗑
show red and green  
🗑
show general number format.  
🗑
show numbers  
🗑
show January 1, 1900 12:00 am  
🗑
In Excel, dates are ____-aligned in the cell by default, regardless of date format.   show
🗑
show center, , left,, right.  
🗑
____ merges each of the rows in the selected range across the columns in the range.   show
🗑
In Excel, to merge cells A1, B1, C1, D1, and E1, ____ is the correct reference for the merged cell.   show
🗑
Options to rotate cells in Excel are available using the ____ button in the Alignment group on the Home tab.   show
🗑
show to enhance readability, to top right or bottom of a cell, specify thickness.  
🗑
In the Format Cells dialog box, the ____ tab allows you to format currency by choosing decimal places, comma separators, and regular number displays.   show
🗑
show color.  
🗑
When using the Format Painter, double-click the Format Painter button to paste the same format multiple times and click the Format Painter again to ____.   show
🗑
show select to rotate selected range 90 degrees, paste only formulas, paste values and formats.  
🗑
You can open the Format Cells dialog box by right-clicking a cell or selected range, and then clicking ____ on the shortcut menu   show
🗑
show Microsoft word, excel and powerPoint.  
🗑
show excel table.  
🗑
show table style.  
🗑
show use a table style  
🗑
A table ____ applies alternating row colors to the entire Excel table and adjusts the banded rows effect as needed if you add or delete rows.   show
🗑
show ability to sort data, external, filter  
🗑
In Excel, the table style ____ inserts a new row at the bottom of the table that adds the column values.   show
🗑
show banded columns.  
🗑
To remove banded rows from an Excel table, first you need to select the ____ tab on the Ribbon.   show
🗑
show printed page.  
🗑
show margin.  
🗑
One way to ensure that you are using consistent formats is to copy and paste your formats using the Format ____.   show
🗑
In conditional formatting, to highlight only cells that contain a specific date, select the rule____.   show
🗑
show theme and non-theme  
🗑
show hide columns that contain information you do not need.  
🗑
show position of the report on the page, orientation, include headers and footers.  
🗑
show print range.  
🗑
show pagebreak.  
🗑
show select first cell below the row where you want to insert a page break.  
🗑
A ____ indicates a manual page break.   show
🗑
Information that prints on each page, like a company name or logo, may be set as a(n) ____.   show
🗑
show &[File].  
🗑
The header and footer sections include ____ , ______ and ______ sections.   show
🗑


   

Review the information in the table. When you are ready to quiz yourself you can hide individual columns or the entire table. Then you can click on the empty cells to reveal the answer. Try to recall what will be displayed before clicking the empty cell.
 
To hide a column, click on the column name.
 
To hide the entire table, click on the "Hide All" button.
 
You may also shuffle the rows of the table by clicking on the "Shuffle" button.
 
Or sort by any of the columns using the down arrow next to any column heading.
If you know all the data on any row, you can temporarily remove it by tapping the trash can to the right of the row.

 
Embed Code - If you would like this activity on your web page, copy the script below and paste it into your web page.

  Normal Size     Small Size show me how
Created by: galvanl
Popular Computers sets